Problem while database connection in java

[Jagriti]

I am java user.I am trying the database connection in java , but unfortunately I am unsuccessful in it. I am getting lots of error while compilation.

I used below code to make connection:

Class.forName("sun.jdbc.odbc.JDBCODBCDriver");
Connection con1 = DriverManager.getConnection("jdbc:odbc:dumy1"; "ab", "");
Statement stmt = con1.createStatement();

Can you determine what's wrong with this code? or Can you able to provide me the error-less code??...

[Reegan]

The code which you have used in which it seems that there is incorrect connection string.

Your code is :

Class.forName("sun.jdbc.odbc.JDBCODBCDriver");

Correct code should be:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

[opaper]

The following source of Java establish a JDBC connection to a mSQL database on a server "www.demomyserver.com'"

// Establish a connection to a mSQL database using JDBC.
import java.sql.*;

class JdbcTest1 {

public static void main (String[] args) {
try
{
// Step 1: Load the JDBC driver.
Class.forName("com.imaginary.sql.msql.MsqlDriver");
// Step 2: Establish the connection to the database.
String url = "jdbc:msql://www.demoserver.com:1114/contact_mgr";
Connection conn = DriverManager.getConnection(url,"user1","password");
}
catch (Exception e)
{
System.err.println("Got an exception! ");
System.err.println(e.getMessage());
}
}
}

I hope this program will help you to understand JDBC connection..

[MindSpace]

While making database connection in java please make sure that you are following the below steps:

1. Loading the Driver> 2. Making the Connection> 3. Using the DriverManager Class> 4. Using a DataSource Object for a connection.

For detail information visit the below link:

http://java.sun.com/docs/books/tutor...onnecting.html