jdbc connection with phpmyadmin

[anand_fevi]

Hello friends,
i am trying to connect to mysql which available online through java with below code.
I can not find a jar which contains the com.imaginary.sql.msql.MsqlDriver which is used the program.

Can any body help me out how to connect to the database or whats the jar file needed for the below programe or from where to download that jar file(imaginary).

Code for your ref:
import java.sql.*;
class testjdbc {

public static void main (String[] args) {
try
{
// Step 1: Load the JDBC driver.
Class.forName("com.imaginary.sql.msql.MsqlDriver") ;
System.out.println("Driver loaded success");
// Step 2: Establish the connection to the database.
String url = "jdbc:msql://www.abc.com:3306/mysql";
Connection conn = DriverManager.getConnection(url,"username","passwo rd");
System.out.println("test connection success");
}
catch (Exception e)
{
System.err.println("Got an exception! ");
System.err.println(e.getMessage());
e.printStackTrace();
}
}
}


Thanks in advance!
by
Anand

[r035198x]

You are trying to load a driver for mSQL not for MySQL. The two are different.
If you want to connect to MySQL then get the driver from the MySQL driver site.

[anand_fevi]

Thank u senior,
I have tried that also.But i am getting the below error sir,
No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager .java:545)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
Note:i need to connect to the mysql database which is available online(not locally) through java(jdbc).
Kindly help me to come out of this issue.
Thanks for ur kind reply.
Anand.M