connecting java(j2se) and mysql

[Anand Divakaran]

Hi all,
I'm trying to connect my java application with mysql running on the same machine. I'm also using Connector/j driver.
However its throwing an SQLException i.e the quoted statement seems to be an error

   
 
import java.sql.*;
 
public class Sample
{
    public static void main(String args[])
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = null;
           [I] conn = DriverManager.getConnection("jdbc:mysql://localhost:3036/Anand","Anand","maverick");[/I]            
        }
        catch(ClassNotFoundException ee)
        {
            System.out.println("Class Error");
        }
        catch(SQLException ee)
        {
            System.out.println("Connection Error");
        }
    }
}
 

[Campbell Ritchie]

I presume you have checked in the MySQL documentation? Most of it looks all right just at a quick glance.

Do you need the port number 3036? Try omitting that. If that doesn't work, please post the stack trace.

[Muhammad Saifuddin]

3306 is the default mysql port.
try with this port.

or in case of any error please post the stack trace as Campbell suggested.

[Campbell Ritchie]

Originally posted by Muhammad Saifuddin:
3306 is the default mysql port.

If that's the problem, it goes to show what a tiny error can mess up the whole application.
[ July 18, 2008: Message edited by: Campbell Ritchie ]