I am trying to use BaseX to enter data from its XML db into an MS SQL server database, according to https://docs.microsoft.com/en-us/sql/connect/jdbc/using-basic-data-types?vie... the MS SQL server column type bigint is mapped to long in Java.
However, when I try
<sql:parameter type="long">{$id}</sql:parameter>
with BaseX and sql:execute-prepared, I get an error saying [sql:error] An SQL exception occurred: unsupported type: long
The BaseX documentation https://docs.basex.org/wiki/SQL_Module#sql:execute-prepared indeed only lists
attribute type { "int" | "string" | "boolean" | "date" | "double" | "float" | "short" | "time" | "timestamp" | "sqlxml" }
as the possible types. Am I out of luck trying to use BaseX that way for that datatype? Using <sql:parameter type="int">{$id}</sql:parameter> the sql doesn't succeed.