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 » Stylus Studio Technical Forum » mySQL DB Connection
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + element type must not contain ... (3)
-> + XML to .txt file (7)
-> + Modifying a XSL-FO report (5)
-> + Retrievning multiple values...... (2)
-> + does Stylus Enterprise work wi... (2)
-> + MSSQL to 837P conversion (4)
-> + Generating XML files accesing ... (6)
-> + How to bold text using XSL (6)
-> + Different heading based on pag... (3)
-> + Code folding (2)
-> + Bad param=value pair on comman... (2)
-> + Saving an XML file (2)
-> + stylus adding random non print... (2)
-> + Displaying Base64Binary as Ima... (6)
-> - probleme de representation d'i... (1)
-> + SS 2008 error message not disp... (8)
-> + XQuery external variable conve... (4)
-> + encodings available (3)
-> + stand-alone application file n... (4)
-> + Windows Installer Dialog Box a... (4)
-> + Block search and replace (2)
-> + Problem with validation (3)
-> + ISA12 vs GS08 (5)
-> + Web Service Call failure... an... (11)
-> + Quotes in xpath query (3)
-> + Java Built-in processor no lon... (6)
-> + Dynamic input and output names (8)
-> + Java built-in parser (3)
-> + Contains an invalid path (2)
-> + Wizard XML Schema to XML (2)
-> + XML to EDI (14)
-> + Computer with original install... (2)
-> + using Custom Tool - passing ar... (3)
-> + Non-printable special characte... (3)
-> + Transfer Options (Settings, Pr... (2)
-> + Enterprise Edition, Rel. 3, Bu... (9)
-> + Need help with xsl file and xm... (2)
-> + Upgrading and retaining settin... (4)
-> + saxon9.dll etc. missing (2)
-> - Error on using XQuery File in ... (1)
-> - Strange Dialog Box (1)
-> + Studio Crashes in schema edito... (3)
-> + Xml to XMl Conversion (2)
-> + Unable to create a complex typ... (2)
-> + Error message wen trying run j... (2)
-> - XSLT Mapper question... (1)
-> + Dcument Wizard XSLT Editor Tab... (2)
-> + Beginner Question - XPath with... (2)
-> + Trying to generate .net code w... (2)
-> + duplicate values in variable w... (5)
-> + Java Runtime Environment libra... (4)
-> + programmatically generate XML ... (4)
-> + Help Loading Oracle BI Publish... (4)
-> + [French] xsl <=> report (3)
-> + XML Diff (3)
-> + StylusStudio 2008, saxon saxon... (6)
-> + Msql Table err:FODC0004 Table ... (2)
-> + The evaluation period for Data... (2)
-> + Mysql to XML (2)
-> + Is there a Collapse All nodes ... (2)
-> + flat file conversion with CDAT... (4)
-> + Struzzo.exe eats up %40 CPU ba... (2)
-> + schematron support? (11)
-> + XML Generator did not generate... (2)
-> + Nesting XML files (2)
-> + Web Service Call fails - targe... (5)
-> + getting not valid for content ... (2)
-> - element modem was referenced i... (1)
-> + xerces-c++ xml parser (2)
-> + movie.dtd (2)
-> + HELP! Stylus Studio 2008 Enter... (3)
-> + Xalan problem with xsl:attribu... (2)
-> + Breakpoints being ignored (12)
-> + Need a new key for Stylus Stud... (2)
-> + Global parameters are not reco... (4)
-> + mySQL DB Connection 2 (10)
-> + Using Data Direct xQuery to ag... (4)
-> + stylusXslt command line -- XSL... (15)
-> + XSLT processor using EXSLT fun... (2)
-> + Integrating Omni Mark (2)
-> + EDI Standards to gXML (2)
-> + flat file conversion (3)
-> + EDI to XML: Invalid URI error (3)
-> + Validating and XML Schema (6)
-> + XSD to DDL (MS-SQL/2005) (6)
-> + xml converter cant encode 0x19 (4)
-> + XSD Help Needed (2)
-> + How do you delete a field in a... (2)
-> + Disable page breaks (3)
-> + XSD semantic structure compari... (3)
-> + Studio Crashes On File Open (7)
-> + Which parser is used by Stylus... (2)
-> + How to DIFF XML windows with d... (3)
-> + Automation using Visual Studio (7)
-> + CSV to XML conversion help (2)
-> + XML tree help (3)
-> + java.lang.NullPointerException... (2)
-> + Creating schema from xml - how... (3)
-> + Mismatch between intellisense ... (4)
-> + Using FOP 0.94 in XML Pipeline (2)
-- Previous [1081-1100] [1101-1120] [1121-1140] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Michael BenjaminSubject: mySQL DB Connection
Author: Michael Benjamin
Date: 02 Jan 2008 12:30 AM
Hi
On using Enterprise Suite 2008 I get this error:

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:/Styylus

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

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

at com.stylusstudio.DataDirectDDXQStub.connect(DataDirectDDXQStub.java:84)

at com.stylusstudio.DataDirectDDXQStub.getConnection(DataDirectDDXQStub.java:120)
================================================================
I am using mySQL in XAMPP on VISTA in the C: drive
I am using the mySQL Community Edition for database type
The database is called stylustest
What should the Server URL be?

Thanks for your patience
With regards
Michael
Postnext
Minollo I.Subject: mySQL DB Connection
Author: Minollo I.
Date: 02 Jan 2008 09:15 AM
Probably your MySQL driver is not available in the classpath? As explained in http://media.datadirect.com/download/docs/ddxquery/allddxq/reference/conf_sourcefiles7.html#wp209990 when using MySQL Community edition you need to make sure the MySQL JDBC driver is part of your classpath. Working in Stylus Studio, you can change the classpath right clicking on the project node.

Postnext
Ivan PedruzziSubject: mySQL DB Connection
Author: Ivan Pedruzzi
Date: 02 Jan 2008 11:44 AM

Could you also try to restart Stylus Studio?

We have detected situation where after registering the class-path, MySQL CE driver didn't load properly until Stylus Studio restarts.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Postnext
Michael BenjaminSubject: mySQL DB Connection
Author: Michael Benjamin
Date: 03 Jan 2008 09:48 AM
Sorry
No further on
I placed the driver thus:
C:\Program Files\Java\jre1.6.0_03\mysql-connector-java-5.1.5\mysql-connector-java-5.1.5-bin.jar
Which is the CLASSPATH
The database called stylustest is in the mySQL file in XAMP fil;e on the C: drive. The UN is root there is no password
Should I use localhost or 127.0.0.1 ? Do I nominate a port or accept the default one?
Could the port definition be a problem especially as I am using VISTA [it has been a problem with VISTA in other applications]
I would appreciate help as I am seriously stuck
Thanks
Michael
Postnext
Minollo I.Subject: mySQL DB Connection
Author: Minollo I.
Date: 03 Jan 2008 09:57 AM
The error you are receiving is symptom of the driver not being found; so, as long as you are still getting the same error you reported at the beginning of this thread, let's focus on that first.

You are saying that the driver jar is the classpath; but be aware that Stylus Studio ignores the classpath environment variable. To make sure the jar is part of the classpath used by Stylus Studio, you need to right click on the project node root, select "Set Project Classpath..." and add the jar file you mentioned to the list of items in the classpath. Then save the project and restart Stylus Studio.

Do you still get the same error after doing that?
Postnext
Michael BenjaminSubject: mySQL DB Connection
Author: Michael Benjamin
Date: 03 Jan 2008 10:02 AM
I added to the node as you said with to no avail!
What should I do now
Thanks
Michael
Postnext
Michael BenjaminSubject: mySQL DB Connection
Author: Michael Benjamin
Date: 03 Jan 2008 10:07 AM
Great
thanks a million
Michael
Postnext
Minollo I.Subject: mySQL DB Connection
Author: Minollo I.
Date: 03 Jan 2008 10:09 AM
I see two replies from you that seem to contradict each other; should we assume you are all set?
Postnext
Michael BenjaminSubject: mySQL DB Connection
Author: Michael Benjamin
Date: 03 Jan 2008 10:33 AM
Thanks
Yes
I closed the Application and it worked
Really pleased
Thanks
Michael
Postnext
Minollo I.Subject: mySQL DB Connection
Author: Minollo I.
Date: 03 Jan 2008 11:21 AM
BTW, a better way to handle the classpath for the driver is to set it in the connection dialog, not at the project level. When you connect to MySQL Community Server, you have the option in the connection dialog to enter the location of the MySQL JDBC driver; doing that will be enough to make things work properly.
Posttop
Frank MainzerSubject: mySQL DB Connection
Author: Frank Mainzer
Date: 29 Mar 2011 05:53 AM
Hi,

i have the same problem and followed the instructions. I did set the classpath on project and connection level, restarted the app.

Still getting that message:

java.sql.SQLException: No suitable driver found for jdbc:mysql://lec2-50-16-153-176.compute-1.amazonaws.com:3306/warehouse?

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

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

at com.stylusstudio.DataDirectDDXQStub.connect(DataDirectDDXQStub.java:176)

at com.stylusstudio.DataDirectDDXQStub.getConnection(DataDirectDDXQStub.java:212)
   
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.