SSDN - A simple complaint

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Michael Benjamin

Subject: A simple complaint
Author: Michael Benjamin
Date: 09 Jan 2008 08:29 AM

Hi
I bought Suite 2007 and was impressed by the wizards and the ease that I could learn to incorporate data.
I then discovered that mySQL was not included.
So I waited 6 months
Now I find that the 2008 has changed. The simple introductory video is irrelevant to my needs with database as the appropriate text in the file column does not exist.
Taken into account with the nomenclature on XSLT wizard that was present although the wizard had departed is leaving a bad taste. This was corrected seemingly yesterday.
I have had a very frustating and angry week with nothing to show.
I could handle 2007 but it did not suite my data. 2008 suites my data but is beyond me.
With regards
Michael Benjmain

Minollo I.

Subject: A simple complaint
Author: Minollo I.
Date: 09 Jan 2008 09:18 AM

I'm not sure I fully understand your complaint, but let me try.

- You are disappointed about the fact that some piece of Stylus Studio web material still references the HTML-to-XSLT wizard, which has been discontinued in v2007. We will work at fixing that web material; the wizard has been discontinued because it was tied to the XML-to-HTML XSLT WYSIWYG component that has been discontinued as well in v2007. You can still do what the old wizard did by using the HTML-to-XML wizard, and then copy&pasting the XML result into the root template of an XSLT
- "Discovering" that MySQL was not included in v2007 shouldn't have been difficult; it wasn't listed as a supported database in the first place; we did add support for it in v2008, as promised when you contacted us

I'm not sure what your current problem is; I *guess* you would like to use the XSLT WYSIWYG component along with MySQL support and you cannot do that? That WYSIWYG component is indeed no more available; and even if it was available, database connectivity is possible only using XQuery. Have you tried create an XML Report with the publisher component in Stylus Studio, generating XQuery code?

Hope this helps.

Michael Benjamin

Subject: A simple complaint
Author: Michael Benjamin
Date: 09 Jan 2008 12:52 PM

Thanks
In 2007 there is a File==> New==> DB To XML Data Source with a dreop and drag feature which is not in 2008
I appre iate the answwer about XSTL -- can you give me an answer to tho too?
Regards
Michael

Minollo I.

Subject: A simple complaint
Author: Minollo I.
Date: 09 Jan 2008 02:21 PM

The DB to XML data source has been replaced (in v2007 Release 2, actually) by the File Explorer component; you can create connections to your database in File Explorer (Relational DB), and open tables that you navigate in there (double click, or right click > Open), and drag&drop databases or tables to the XQuery data sources panel on the right of the editing area, to make those data sources accessible by your XQuery.

Michael Benjamin

Subject: A simple complaint
Author: Michael Benjamin
Date: 09 Jan 2008 02:36 PM

Thanks again
I tried and got this error==>:
==================================================================
at com.ddtek.xquery3.xqj.DDXQDataSource._getConnection(DDXQDataSource.java:1446)

at com.ddtek.xquery3.xqj.DDXQDataSource.getConnection(DDXQDataSource.java:863)

at com.stylusstudio.DDXQFileSystem$DDXQFile.runQuery(DDXQFileSystem.java:353)

... 1 more

Caused by: com.ddtek.xquery.util.XQueryException: [EX0043][DataDirect][XQuery]Incorrect database name 'stylustest;table=db;user=root;xmlforest=true;urltype=.xml'

at com.ddtek.xquery.extractor.util.SqlUtil.createXQueryException(SqlUtil.java:202)

at com.ddtek.xquery.extractor.ExtractorDataSource.getConnection(ExtractorDataSource.java:257)

at com.ddtek.xquery.mediator.SqlAdapter.connect(SqlAdapter.java:68)

at com.ddtek.xquery.mediator.MediatorConnection.connectAllSqlAdapters(MediatorConnection.java:372)

at com.ddtek.xquery.mediator.MediatorConnection.connect(MediatorConnection.java:102)

at com.ddtek.xquery3.xqj.layer.DDXQConnection.<init>(DDXQConnection.java:80)

... 4 more

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Incorrect database name 'stylustest;table=db;user=root;xmlforest=true;urltype=.xml'

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:406)

at com.mysql.jdbc.Util.getInstance(Util.java:381)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)

at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3808)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

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:406)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at com.ddtek.xquery.extractor.ExtractorDataSource.createJDBCConnection(ExtractorDataSource.java:343)

at com.ddtek.xquery.extractor.ExtractorDataSource.getConnection(ExtractorDataSource.java:206)

... 8 more

Minollo I.

Subject: A simple complaint
Author: Minollo I.
Date: 09 Jan 2008 02:45 PM

You are apparently using a bad URL to connect to the database; can you provide more details about which database you are connecting to (MySQL?) and what argument you provide to the connection dialog? The attached image is what I have on my machine connecting to the MySQL.

conn1.gif

conn2.gif

Michael Benjamin

Subject: A simple complaint
Author: Michael Benjamin
Date: 09 Jan 2008 03:08 PM

Thanks again
I do this

DRIVER CLASS PATH C:\Program Files\Java\jre1.6.0_03\mysql-connector-java-5.1.5\mysql-connector-java-5.1.5-bin.jar

SERVER URL: //localhost:3306/stylustest

UN: beden

PW: lufg1Y

In the file explorer I see the database and the tables

I right click on the table and chose 'open with XQuery'

& see error

java.lang.RuntimeException: com.ddtek.xquery3.XQException: [DataDirect][XQuery]Unknown database 'stylustest;table=t_style;user=beden;password=18273d765102;xmlfor'

at com.stylusstudio.DDXQFileSystem$DDXQFile.runQuery(DDXQFileSystem.java:370)

at com.stylusstudio.DDXQFileSystem$DDXQFile.getInputStream(DDXQFileSystem.java:378)

Caused by: com.ddtek.xquery3.XQException: [DataDirect][XQuery]Unknown database 'stylustest;table=t_style;user=beden;password=18273d765102;xmlfor'

at com.ddtek.xquery3.xqj.Util.createXQException(Util.java:241)

at com.ddtek.xquery3.xqj.layer.DDXQConnection.<init>(DDXQConnection.java:83)

at com.ddtek.xquery3.xqj.DDXQDataSource._getConnection(DDXQDataSource.java:1446)

at com.ddtek.xquery3.xqj.DDXQDataSource.getConnection(DDXQDataSource.java:863)

at com.stylusstudio.DDXQFileSystem$DDXQFile.runQuery(DDXQFileSystem.java:353)

... 1 more

Caused by: com.ddtek.xquery.util.XQueryException: [EX0043][DataDirect][XQuery]Unknown database 'stylustest;table=t_style;user=beden;password=18273d765102;xmlfor'

at com.ddtek.xquery.extractor.util.SqlUtil.createXQueryException(SqlUtil.java:202)

at com.ddtek.xquery.extractor.ExtractorDataSource.getConnection(ExtractorDataSource.java:257)

at com.ddtek.xquery.mediator.SqlAdapter.connect(SqlAdapter.java:68)

at com.ddtek.xquery.mediator.MediatorConnection.connectAllSqlAdapters(MediatorConnection.java:372)

at com.ddtek.xquery.mediator.MediatorConnection.connect(MediatorConnection.java:102)

at com.ddtek.xquery3.xqj.layer.DDXQConnection.<init>(DDXQConnection.java:80)

... 4 more

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'stylustest;table=t_style;user=beden;password=18273d765102;xmlfor'

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:406)

at com.mysql.jdbc.Util.getInstance(Util.java:381)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)

at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3823)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

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:406)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at com.ddtek.xquery.extractor.ExtractorDataSource.createJDBCConnection(ExtractorDataSource.java:343)

at com.ddtek.xquery.extractor.ExtractorDataSource.getConnection(ExtractorDataSource.java:206)

... 8 more

Michael Benjamin

Subject: A simple complaint
Author: Michael Benjamin
Date: 09 Jan 2008 03:11 PM

OOPS
I omitted the '?' on the url
Thanks
Lots of blushes
Michael

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.