Another mysql problem

[nschessnerd]

Hey, so I get a Driver error when I try to connect to my local mysql db. My code is in a servlet as follows

Class.forName("com.mysql.jdbc.Driver").newInstance();
            Connection con=null;
            Statement smt=null;
            con=DriverManager.getConnection("jdbc:mysql://localhost:3306/sql?user=webusr&password=pass");

Thanks
M

[peter_budo]

I don't know what is the purpose if that port number over there?
I posted small part of code which I usualy use in other thread http://www.daniweb.com/techtalkforums/post316412-2.html
so you can have look and compare it with your one

[nschessnerd]

I use the port because my server is located on port 3306...

[jwenting]

dump the .newInstance(), it's superfluous.

Without knowing the actual error the cause of the problem will always remain guesswork.
But most likely you either don't have the correct driver or the database doesn't allow you to connect.

[nschessnerd]

Ahh thanks, it was newInstance