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
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext 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)

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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.