java.sql.SQLException: No suitable driver

[Vaishali Paramane]

Hi
I am trying to do simple jdbc program

    
import java.sql.*;
 
public class JDBCSample {
 
  public static void main(java.lang.String[] args) {
  try {
  Class.forName("com.oracle.jdbc.OracleDriver");
} 
catch (ClassNotFoundException e) { 
  /* Handle Exception */ 
}
  
    try {
      // specifying particular database, username, and password
      Connection con = DriverManager.getConnection("jdbc:odbc:oracle","system","vaishali");
   
      // Create and execute an SQL Statement
      Statement stmt = con.createStatement();
      ResultSet rs = stmt.executeQuery("SELECT name FROM emp");
 
      // Display the SQL Results
      while(rs.next()) {
        System.out.println(rs.getString("name"));
      }
 
      // Make sure our database resources are released
      rs.close();
      stmt.close();
      con.close();
 
    } 
    catch (SQLException se) {
      // Inform user of any SQL errors
      System.out.println("SQL Exception: " + se.getMessage());
      se.printStackTrace(System.out);
    } 
  } 
}
 
its showing following error
 
SQL Exception: 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)
at JDBCSample.main(JDBCSample.java:17)
 

 

can anybody help me to come out?

Thanks

Vaishali

[Jared White]

Is the jar containing your JDBC driver in your classpath?

[Vaishali Paramane]

please can you tell me which jar file is needed in classpath.

I am using oracle 10g.

Thanks

Vaishali

[Jeanne Boyarsky]

It's called classes12.jar or ojdbc-14.jar for Oracle.

[Vaishali Paramane]

yes it has in classpath

"c:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar";
"c:\oracle\product\10.2.0\db_1\jdbc\lib\nls_charset12.jar";
"c:\oracle\product\10.2.0\db_1\jdbc\lib\classes12.jar"

Then also its giving error.


Thanks

Vaishali

[Jesper de Jong]

The error message means that either the JDBC driver is not in your classpath, or that the database URL you are using is wrong. Looking at your code, I see that the database URL you are using is "jdbc:odbc:oracle". Are you trying to use the JDBC-ODBC bridge driver to access Oracle?

See this question in the Oracle JDBC FAQ about what the database URL should look like.

[Vaishali Paramane]

Hi

"c:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar";
"c:\oracle\product\10.2.0\db_1\jdbc\lib\nls_charset12.jar";
"c:\oracle\product\10.2.0\db_1\jdbc\lib\classes12.jar"

This is in my class path and

I created 'oracle' as odbc in administrative tools.

I can't understand how to figerout problem.


Thanks

Vaishali