MYSQL connector

try

{

Connection conn =

DriverManager.getConnection

("jdbc:mysql://localhost:3306",

"root","secret");

System.out.println("Got Connection");

Does not get to got connection, it says no suitable driver. I've checked the class path, port number and have been told to read the documentation. Can someone tell me where?

[366 byte] By [burntcandlea] at [2007-11-27 6:22:38]
# 1
How are you loading the driver? I don't see it in the code snippet.
BalusCa at 2007-7-12 17:39:47 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
How do I load it. I put it in the classpath as told to.
burntcandlea at 2007-7-12 17:39:47 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3
Ok, this bitClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");How do i point that at mySQL? Sorry, i don;t understand the underlying architecure here.
burntcandlea at 2007-7-12 17:39:47 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 4
Just read it's documentation. http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-basic.html
BalusCa at 2007-7-12 17:39:47 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 5
Thank you.
burntcandlea at 2007-7-12 17:39:47 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...