Subject: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?
Subject: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
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.
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.