Subject:javax.xml.xquery.XQException: [DataDirect][XQuery]Identifier name 'identifier' too long Author:Paul van Bavel Date:08 Nov 2015 03:34 PM
I'm trying to do the tutorial named: "Using XQuery To Generate JSON from Relational Data".
After downloading and installing the Sakila Database in my localhost environment (D:\wamp\www) I tried to drag &drop the "film_list" view into the "Stylus studio X15 release2 XML entrprise Suite" .
In this action I get the following, hard to read, error messages:
javax.xml.xquery.XQException: [DataDirect][XQuery]Identifier name 'sakila;table=film_list;user=root;password=55026175742408425e;xmlforest=true;urltype=.xml' is too long
here follow the detail rules, that are also supplied.
java.lang.RuntimeException: javax.xml.xquery.XQException: [DataDirect][XQuery]Identifier name 'sakila;table=film_list;user=root;password=55026175742408425e;xmlforest=true;urltype=.xml' is too long
at com.stylusstudio.DDXQFileSystem$DDXQFile.runQuery(DDXQFileSystem.java:371)
at com.stylusstudio.DDXQFileSystem$DDXQFile.getInputStream(DDXQFileSystem.java:379)
Caused by: javax.xml.xquery.XQException: [DataDirect][XQuery]Identifier name 'sakila;table=film_list;user=root;password=55026175742408425e;xmlforest=true;urltype=.xml' is too long
at com.ddtek.xquery.xqj.Util.createXQException(Util.java:243)
at com.ddtek.xquery.xqj.DDXQConnection.<init>(DDXQConnection.java:78)
at com.ddtek.xquery.xqj.DDXQDataSource._getConnection(DDXQDataSource.java:1528)
at com.ddtek.xquery.xqj.DDXQDataSource.getConnection(DDXQDataSource.java:883)
at com.stylusstudio.DDXQFileSystem$DDXQFile.runQuery(DDXQFileSystem.java:354)
... 1 more
Caused by: com.ddtek.xquery.util.XQueryException: [EX0043][DataDirect][XQuery]Identifier name 'sakila;table=film_list;user=root;password=55026175742408425e;xmlforest=true;urltype=.xml' is too long
at com.ddtek.xquery.extractor.util.SqlUtil.createXQueryException(SqlUtil.java:216)
at com.ddtek.xquery.extractor.util.SqlUtil.createXQueryException(SqlUtil.java:197)
at com.ddtek.xquery.extractor.ExtractorDataSource.getConnection(ExtractorDataSource.java:171)
at com.ddtek.xquery.mediator.SqlAdapter.connect(SqlAdapter.java:68)
at com.ddtek.xquery.mediator.MediatorConnection.connect(MediatorConnection.java:85)
at com.ddtek.xquery.xqj.DDXQConnection.<init>(DDXQConnection.java:75)
... 4 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Identifier name 'sakila;table=film_list;user=root;password=55026175742408425e;xmlforest=true;urltype=.xml' is too long
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.Util.getInstance(Util.java:387)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1686)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1207)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2254)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2285)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2084)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.ddtek.xquery.extractor.ExtractorDataSource.createJDBCConnection(ExtractorDataSource.java:257)
at com.ddtek.xquery.extractor.ExtractorDataSource.getConnection(ExtractorDataSource.java:120)