Subject:XQuery & MySQL Author:Lawrence Harris Date:08 Nov 2006 10:17 AM
How do I use the DB to XML feature with MySQL or other JDBC databases? I tried SequelLink but I received the following error when I tried to use it:
java.sql.SQLException: [StylusStudio][SequeLink JDBC Driver]Internal network error, session aborted due to session protocol data unit format error, connection closed.
at ZC.jdbc.jxtr.JXTRDriverConfig.translateSQLException(Unknown Source)
at ZC.jdbc.jxtr.JXTRDriverConfig.createSQLException(Unknown Source)
at ZC.jdbc.jxtr.JXTRDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.stylusstudio.DataDirectStub.connect(DataDirectStub.java:773)
at com.stylusstudio.DataDirectStub.getConnection(DataDirectStub.java:1152)
Subject:XQuery & MySQL Author:Ivan Pedruzzi Date:08 Nov 2006 11:51 AM
DB to XML data source does not support plugging third party JDBC drivers.
In order to access MySQL you will need to run Sequelink SocketServer and configure an ODBC System Data Source based on the MySQL ODBC driver as explained in the documentation.
DataDirect Technologies has been working on the JDBC driver for MySQL for quite a while, the driver is ready to go but unfortunately MySQL AB doesn't want to address the legal issues preventing us to bring this great technology into the market place.