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
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?
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
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.
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)
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.