XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Paul van BavelSubject: 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)

... 7 more

Posttop
Ivan PedruzziSubject: javax.xml.xquery.XQException: [DataDirect][XQuery]Identifier name 'identifier' too long
Author: Ivan Pedruzzi
Date: 09 Nov 2015 03:32 PM
Hi Paul,

I contacted you offline once we know what's happening we will update the thread.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.