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
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Rick ScofieldSubject: XQuery MySQL connector
Author: Rick Scofield
Date: 20 May 2015 08:58 PM
I recently crashed my WIN7 PC running Stylus Studio enterprise edition. I was running a pipeline process with a XQuery connection to MySQL database. I have now installed SS on a new WIN8 X64 PC and trying to run the pipeline again. I must be missing a mysql-connector executable or something because I get the error message

"No suitable driver found for jdbc:mysql://web013.MYURL:3306/MYDB?"

when I run the XQuery:
ddtek:sql-delete(collection("R_TEMP")/R_TEMP),
for $cartEntry in /root/row
return ddtek:sql-insert("R_TEMP", "vendor", 'CAR', "sku", $cartEntry/upc, "inventory", $cartEntry/qtyavail)

I remember installing mysql-connector-java-5.1.29-bin before on old PC, is this still the case?

Please advise, Rick

Postnext
Ivan PedruzziSubject: XQuery MySQL connector
Author: Ivan Pedruzzi
Date: 20 May 2015 09:36 PM

Yep, you need to get MySQL JDBC driver Community Edition from Oracle.

To register the driver in Stylus Studio create a new connection to the database using File Explorer.

In the "Connection Settings" dialog set the "Driver Classpath" field to path of the jar that contains the driver. For example

c:\mysql-connector-java-5.1.29-bin.jar



Ivan Pedruzzi
Stylus Studio Team

Postnext
Rick ScofieldSubject: XQuery MySQL connector
Author: Rick Scofield
Date: 20 May 2015 10:11 PM
Thank you Ivan.
I registered mysql-connector-java-5.1.35 and I now have access to the DB.

My next problem is while running a simple .conv flat-2-xml conversion I get the following error and the conversion only create a small portion of the xml output. Please see attached message.

Thank you as always! -Rick


UnknownCapture(1).PNG
error message

Posttop
Ivan PedruzziSubject: XQuery MySQL connector
Author: Ivan Pedruzzi
Date: 20 May 2015 10:32 PM
We need a test case, i will contact you off-list

Ivan Pedruzzi
Stylus Studio Team

 
Go to previous topicPrev TopicGo to next topicNext Topic
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.