jdbc connection

From: <tejasvi.patil_at_gmail.com>
Date: 5 May 2006 03:50:12 -0700
Message-ID: <1146826212.663148.150090@j73g2000cwa.googlegroups.com>

Hello,
I have installed java 2 SDK 1.4 on my windows XP machine. I want to connect to oracle database server (machine name - myserver) where Oracle 9i is installed.
I am running following java code....

import java.sql.*;
import sun.jdbc.odbc.*;
class dba {
  public static void main (String args []) throws SQLException   {

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

                 System.out.println("driver is loaded dynamically");
        	//Class.forName ("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
              e.printStackTrace();
        }

        Connection conn = DriverManager.getConnection
        ("jdbc:oracle:thin:@myserver:1521:sdms60", "sys","password");
        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select * from
NGSDMS60.NGTAGS");
        while (rset.next())
              System.out.println (rset.getString(1));   // Print col 1
        stmt.close();

  }
}
But it gives runtime error as follows:
driver is loaded dynamically
Exception in thread "main" java.sql.SQLException: No suitable driver

        at java.sql.DriverManager.getConnection(DriverManager.java:532)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at dba.main(dba.java:15)

Can anyone please help in this???
Do i need to insatll or need to do some settings through control panel on server / client machine??

Thanks in advance!!!

regards,
Tejasvi Patil Received on Fri May 05 2006 - 05:50:12 CDT