It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Cannot Load Driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Cannot Load Driver" Watch "Cannot Load Driver" New topic

Cannot Load Driver

wasif akbar

Joined: May 02, 2001
Posts: 11
Below is my code:

package com.teoco.GenSequences;
import java.sql.*;
public class DBConnect
public static void main(String args[])
// Loading a driver
catch(ClassNotFoundException e)
System.err.println("Driver could not be loaded" + e.getMessage());

// Defining a URL
String url = "jdbc racle:thin:@dl20,bt51,bt51";

// Establish a connection and create a statement
//Create a connection object
Connection dbConn = DriverManager.getConnection(url);
//Create a statement object
Statement dbStmt = dbConn.createStatement();
//Execute a query
String queryOne = "Select invoice_seq_id from invoice where rownum < 10";
ResultSet dbRes = dbStmt.executeQuery(queryOne);
String inv = dbRes.getString(0);
catch(SQLException e)
System.err.println("SQLException: " + e.getMessage());

When I execute this file, I keep getting the following error:
Driver could not be loaded oracle.jdbc.odbc.OracleDriver
SQLException: No suitable driver
This error initially led to believe something with my classpath. Here is my classpath and path variable settings:
Path=C:\oracle\ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32
;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Rational\common;C:\Program Fil
es\Rational\Rational Test
I thought I fixed any issues with the classpath, yet I still recieve this error. Any help would be greatly appreciated.

Joined: Aug 01, 2000
Posts: 7
Hi Could you please send me your code in mail to my email address?
Thanks & Regards,

Thanks & Regards,<br />Murthy
venugopal askani

Joined: Aug 20, 2001
Posts: 16
U seem to be using both stuff together.
Either use a JDBC ODBC bridge or use a thin client for JDBC connection. In the driver u are specifying a JDBC-ODBC bridge and then in connection u r using thin connection. Please refer to the following site.
or to the JDBC tutorial site
Surya Bahadur
Ranch Hand

Joined: Sep 28, 2000
Posts: 88
Too Many mistakes
If you want to use thin driver the Jdbc Url should be of the form
jdbc racle:thin:@machineName:1521:sid
In the class.forName statement try putting
oracle.jdbc.odbc.OracleDriver instead of oracle.jdbc.driver.OracleDriver.
As far as possible try using thin drivers instead of the odbc drivers to access oracle.

[This message has been edited by Surya Bahadur (edited August 20, 2001).]
[This message has been edited by Surya Bahadur (edited August 20, 2001).]
[This message has been edited by Surya Bahadur (edited August 20, 2001).]
I agree. Here's the link:
subject: Cannot Load Driver
It's not a secret anymore!