Re: [basex-talk] Problems with 8.5.3

Ops! Hi Andy thanks will give it an immediate try! Sorry Guys but had a bit of difficulty keeping at pace with the list in August... Thanks, Marco.

On 31/08/2016 16:15, Andy Bunce wrote:

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.lettere@gmail.com mailto: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
<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.