Hi Artur,
Thanks for the full info view output.
The issue seems to be specific to MS SQL. Could you run basex on command line with the -d flag and share the output with us?
Thanks in advance Christian
On Fri, Aug 27, 2021 at 11:17 AM Artur Moor skynexion@gmail.com wrote:
Dear all,
When executing an SQL query with the SQL module: sql:init("com.microsoft.sqlserver.jdbc.SQLServerDriver"), let $connection := sql:connect("jdbc:sqlserver://SQLHOST:1433;databaseName=DBNAME", "username", "pa$$w0rd") return sql:execute($connection, "SELECT * FROM TABLE")
I get the following error message: Error: Stopped at /Users/sa/staging/file, 3/19: [sql:error] An SQL exception occurred: Das Resultset wurde geschlossen. Compiling:
- inline let $connection_0 := sql:connect("jdbc:sqlserver://SQLHOST:1433;databaseName=DBNAME", "username", "pa$$w0rd")
- simplify FLWOR expression: sql:connect("jdbc:sqlserver://SQLHOST:1433;databaseName=DBNAME", "username", "pa$$w0rd") ! sql:execute(., "SELECT * FROM TABLE")
Optimized Query: (sql:init("com.microsoft.sqlserver.jdbc.SQLServerDriver"), sql:connect("jdbc:sqlserver://SQLHOST:1433;databaseName=DBNAME", "username", "pa$$w0rd") ! sql:execute(., "SELECT * FROM TABLE")) Query: sql:init("com.microsoft.sqlserver.jdbc.SQLServerDriver"), let $connection := sql:connect("jdbc:sqlserver://SQLHOST:1433;databaseName=DBNAME", "username", "pa$$w0rd") return sql:execute($connection, "SELECT * FROM TABLE") Query Plan:
<QueryPlan compiled="true" updating="false"> <List type="item()*"> <SqlInit name="sql:init" type="empty-sequence()" size="0"> <Str type="xs:string" size="1">com.microsoft.sqlserver.jdbc.SQLServerDriver</Str> </SqlInit> <IterMap type="item()*"> <SqlConnect name="sql:connect" type="xs:integer" size="1"> <Str type="xs:string" size="1">jdbc:sqlserver://SQLHOST:1433;databaseName=DBNAME</Str> <Str type="xs:string" size="1">username</Str> <Str type="xs:string" size="1">pa$$w0rd</Str> </SqlConnect> <SqlExecute name="sql:execute" type="item()*"> <ContextValue type="xs:integer" size="1"/> <Str type="xs:string" size="1">SELECT * FROM TABLE</Str> </SqlExecute> </IterMap> </List> </QueryPlan>
Does anyone have an idea what the problem is?
Any hints are welcome!