XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XQuery Help and Discussion » XQuery & MySQL
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2017)
-> + Issue with Processing Instruct... (2)
-> + problem converting json to XML... (2)
-> + Problem base64 decoding string... (3)
-> + Problems posting multipart for... (5)
-> + trouble with download of price... (2)
-> + Problem with http-post not bei... (3)
-> + path problem, xps_file:writeAl... (9)
-> + Xquery update support? (2)
-> + problem with Stylus studio try... (5)
-> + adding dtd reference to xml ou... (4)
-> + xquery escaping ambarsand when... (3)
-> + Whitespace problem when return... (5)
-> + Problem with namespace prefix ... (5)
-> - Sending via SFTP returns unexp... (1)
-> + Query and Sftp clent (4)
-> + xquery and try - catch (3)
-> + Query + ddtek:http-post optio... (5)
-> + Example files referenced in do... (3)
-> + Automatic Error Detection and ... (3)
-> + Working with result of ddtek:h... (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Lawrence HarrisSubject: 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)

Thanks
Postnext
Ivan PedruzziSubject: XQuery & MySQL
Author: Ivan Pedruzzi
Date: 08 Nov 2006 10:36 AM
Hi Lawrence,

Did you read the chapter "Creating an ODBC System Data Source" in the online help?
http://www.stylusstudio.com/configure_data_source.html

Did you install Sequelink Socket Server?

Which ODBC driver did you try?

Are you able to test the ODBC connection from the control panel?

Is the Sequelink service running?

Is the Sequelink service installed on the same machine where Stylus Studio is running?


Thank You
Ivan Pedruzzi
Stylus Studio Team
Postnext
Lawrence HarrisSubject: XQuery & MySQL
Author: Lawrence Harris
Date: 08 Nov 2006 10:46 AM
Yes I read the chapter about ODBC and I did install the software, but JDBC doesn't typically use ODBC. Do I need to use the ODBC Server program?

Thanks,
Larry
Posttop
Ivan PedruzziSubject: 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.

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.