Hi Marco.
I hit the SQL issue to see https://github.com/BaseXdb/basex/issues/1341
/Andy
On 31 August 2016 at 14:46, Marco Lettere <m.lett...@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.
>
>
