On 31 August 2016 at 14:46, Marco Lettere <m.lettere@gmail.com> wrote:
Hi all,
after passing to 8.5.3 we have several points in our current application that stop working.
The first one refers to the use of sql module. The following query worked neatly in previous version 8.5.1 beta ....
let $init := sql:init("com.mysql.jdbc.Driver")
let $connection := sql:connect("jdbc:mysql://localhost:3306/adb?useSSL=false", "user", "pass")
return (sql:execute($connection, "select 1 + 1 from dual"), sql:close($connection))
returns:
<sql:row xmlns:sql="http://basex.org/modules/sql ">
<sql:column name="1 + 1">2</sql:column>
</sql:row>
In 8.5.3 we get the following stacktrace:
Version: BaseX 8.5.3
Java: Oracle Corporation, 1.8.0_91
OS: Windows 7, x86
Stack Trace:
java.lang.RuntimeException: Class org.basex.query.QueryResources can not access a member of class org.basex.query.func.sql.JDBCConnections with modifiers ""
at org.basex.util.Util.notExpected(Util.java:62)
at org.basex.query.QueryResources.index(QueryResources.java: 121)
at org.basex.query.func.sql.SqlFn.jdbc(SqlFn.java:36)
at org.basex.query.func.sql.SqlConnect.item(SqlConnect.java:35)
[….]
We have also an issue with executing xquery:invoke on -xqm files that are stored in subdirectories of the invoking module. But I still have to repdroduce a SSCE first.
Thanks for any support.
Regards,
Marco.