Réf. : Re: Réf. : No Suitable Driver - jean...@corman.be - com.mysql.lists.java

1 message in com.mysql.lists.javaRéf. : Re: Réf. : No Suitable Driver

From	Sent On	Attachments
jean...@corman.be	01 Jul 2004 06:53

Subject:	Réf. : Re: Réf. : No Suitable Driver
From:	jean...@corman.be (jean...@corman.be)
Date:	07/01/2004 06:53:32 AM
List:	com.mysql.lists.java

See the correction in your code...

Regards,

Jean-Yves.

Sridevi Salagrama <srid...@wayne.edu> 01/07/2004 15:50 Veuillez répondre à Sridevi.Salagrama

Pour : jean...@corman.be cc : ja...@lists.mysql.com Objet : Re: Réf. : No Suitable Driver

Hi, The error is as follows.

java.lang.ClassNotFoundException: com.mysql.jdbc.driver SQLException: No suitable driver SQLState: 08001 VendorError: 0

Class.forName("com.mysql.jdbc.Driver").newInstance(); Class.forName("com.mysql.jdbc.driver").newInstance(); Connection conn = DriverManager.getConnection ("jdbc:mysql://localhost/test? user=<username>&password=<password>");

I have these two lines of code.

Thanks

---- Original message ----

Date: Thu, 1 Jul 2004 15:40:08 +0200 From: jean...@corman.be Subject: Réf. : No Suitable Driver To: srid...@wayne.edu Cc: ja...@lists.mysql.com

Hello,

This is a connection problem, not a classpath problem. If it was a classpath problem the exception would be 'ClassNotFoundException'

To get a connection, proceed like this :

Connection connection = DriverManager.getConnection

("jdbc:mysql://<yourhost>:<your_serveur_port>/<your_base>","y our_username","password"

); Statement stmt = connection.createStatement();

Thats all.

Jean-Yves.

Sridevi Salagrama <srid...@wayne.edu> 01/07/2004 15:11 Veuillez répondre à Sridevi.Salagrama

Pour : ja...@lists.mysql.com cc : Objet : No Suitable Driver

Hi,

I have just down loaded the mysql connector/j version 3.0.14- production. I have set the classpath for the jar file and I am using "com.mysql.jdbc.Driver" as the class that implements java.sql.Driver.

I have not been succesful. I keep getting a No suitable Driver (SQl Exception)

Can any body please tell me what I might be doing wrong.

Thanks