Problems with 8.5.3

On 31 August 2016 at 14:46, Marco Lettere <m.lettere at 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. > >

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