java.sql.SQLException: No suitable driver

[laredotornado]

Hi,

I'm using Java 1.5 with Oracle 10g.

I'm getting a java.sql.SQLException: No suitable driver when executing
the "getConnection" line. Any ideas? The db connection string is
"oracle:thinmyinstance:1521rcl", so I assumed that corresponded to
the "oracle.jdbc.driver.OracleDriver" class.

// Load the JDBC Driver
Class.forName("oracle.jdbc.driver.OracleDriver");
java.sql.Connection con = java.sql.DriverManager.getConnection(
getTestProperty("db.url") + ";"
+ "user=" + getTestProperty("db.username") + ";password=" +
getTestProperty("db.password"));

Shouldn't "Class.forName" throw a ClassNotFoundException if it can't
load that class? How do I find out what class the DriverManager is
searching for?

Thanks, - Dave

 

[Arne Vajhøj]

I'm using Java 1.5 with Oracle 10g.

I'm getting a java.sql.SQLException: No suitable driver when executing
the "getConnection" line. Any ideas? The db connection string is
"oracle:thinmyinstance:1521rcl", so I assumed that corresponded to
the "oracle.jdbc.driver.OracleDriver" class.

// Load the JDBC Driver
Class.forName("oracle.jdbc.driver.OracleDriver");
java.sql.Connection con = java.sql.DriverManager.getConnection(
getTestProperty("db.url") + ";"
+ "user=" + getTestProperty("db.username") + ";password=" +
getTestProperty("db.password"));

Shouldn't "Class.forName" throw a ClassNotFoundException if it can't
load that class? How do I find out what class the DriverManager is
searching for?

Try:

Class.forName("oracle.jdbc.OracleDriver");

and connection string:

"jdbcracle:thinmyinstance:1521rcl"

Arne

 

[Roedy Green]

// Load the JDBC Driver
Class.forName("oracle.jdbc.driver.OracleDriver");
java.sql.Connection con = java.sql.DriverManager.getConnection(
getTestProperty("db.url") + ";"
+ "user=" + getTestProperty("db.username") + ";password=" +
getTestProperty("db.password"));

dump out the first parm to getConnection so you can make sure you got
it precisely as you intended.

It might look something like this:

"jdbcracle:thinsome.server.name:someportnumber:somedatabasename",
"myuserid", "mypassword" );