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
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Can SS do this? (14)
-> - CargoImp support (1)
-> + No Preview Displayed - File is... (3)
-> - Stylus Studio X16 build 1974l ... (1)
-> + Help! Help!Help! Regading form... (2)
-> + FileNotFoundException generati... (6)
-> + FO External Graphic Producing ... (2)
-> + Use of Java methodes (4)
-> + get generated XQuery output on... (2)
-> - right construct for involving ... (1)
-> + SS JRE Version has "Stylus Stu... (3)
-> + Trying to validate an XSD: co... (3)
-> + Disable "Output" windows (4)
-> + Stylus Studio V16 X64 update d... (2)
-> + Could not load the Java Virtua... (2)
-> + .NET XslCompileTransform strip... (6)
-> + XML Report Preview and Save Ev... (8)
-> + X16 Enterprise 32bit crash on ... (5)
-> - MSXML6.0 SAX Parser, "Index re... (1)
-> + MSXML6.0 DOM Parser stops afte... (4)
-- Previous [61-80] [81-100] [101-120] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2016)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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

   
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.