JDBC/MySQL problem

[kiwi]

I'm writing some code with deals with databases, the connection to my oracle works okay but when trying to connect to a mysql, I get a strange error:

16:42:30: Creating new connection with url: jdbc:mysql://localhost:3306/db
16:42:32: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1

This is pretty much nigh-on impossible to google so I wonder if anyone has any ideas?

 

[kiwi]

Post the SQL and we might be able to help.

There's no SQL, just a connection.

Have you tried supplying a username and password if the DB has one?

I pass the credentials to the DriverManager itself, which is the same code that works for the Oracle connection. The strange thing is, I /think/ I had it working with the same code.

 

[kiwi]

Your connection code should look something like:

               String userName = "testuser";
               String password = "testpass";
               String url = "jdbc:mysql://localhost/test";
               Class.forName ("com.mysql.jdbc.Driver").newInstance ();
               conn = DriverManager.getConnection (url, userName, password);

Is that what you have?

Yep, that's pretty much it. I guess this is just a weird transient error