From: Date: February 11 2003 6:03pm
Subject: RE: No suitable driver error
List-Archive: http://lists.mysql.com/java/5027
Message-Id: <006c01c2d1ef$91b9b150$790aa8c0@cotagesoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

> Connection conn =3D DriverManager.getConnection("jdbc:mysql:TestDB");

That's not what a valid JDBC URL looks like for MySQL. The official spec
is:

=20
jdbc:mysql://[hostname][:port]/dbname[?param1=3Dvalue1][&param2=3Dvalue2]=
...

The shortest form of this for you, if the client is on the same host as
the mysql server, is

  jdbc:mysql:///TestDB

It's better form to mention at least the hostname, though, to make this
explicit:

  jdbc:mysql://localhost/TestDB

Unfortunately the only documentation available for Connector/J is on the
sourceforge site for an old version of mm.mysql driver:

  http://mmmysql.sourceforge.net/doc/mm.doc/book1.htm.

Mark: the www.mysql.com site has *no* pointers to this documentation.
Any chance of getting an updated version of this documentation into the
mysql.com site?