File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 REST with Spring (video course) this week in the Spring 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!