> Connection conn = DriverManager.getConnection("jdbc:mysql:TestDB");
That's not what a valid JDBC URL looks like for MySQL. The official spec
is:
jdbc:mysql://[hostname][:port]/dbname[?param1=value1][¶m2=value2]...
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?