View Full Version : Error "Type named oracle.jdbc.driver.OracleDriver is not defined."

12-21-2002, 08:42 PM
I have installed oracle on my pc(win2000 os) with version below:

Personal Oracle8i Release - Production
With the Partitioning option
JServer Release - Production

Here is few lines from file TNSNAMES.ORA

TNSNAMES.ORA Configuration File:E:\oracle\ora81\NETWORK\ADMIN\tnsnames.ora
Generated by Oracle Enterprise Manager V2
Date..........: Sat May 11 17:22:02 CDT 2002

(ADDRESS = (PROTOCOL = TCP)(HOST = pria)(PORT = 1521))

I have installed VisualAge for Java 4.0 with JDK 1.2.2 that is offered for free by IBM.

I did the following sqlj setup in VAJ workbench:

1. workbench--->Tools--->SQLJ--->Properties

Perform online semantics checking is checked
JDBC Driver: oracle.jdbc.driver.OracleDriver
Default URL: jdbc:oracle:thin:@pria:1521:link2hr2

Default URL: jdbc:oracle:thin:@pria:1521:link2hr2
User: hrdb
Password: ????????

2. Window--->Options--->Resources. I have the following in Workspace classpath I typed the following:
"E:\oracle\ora81\jdbc\lib\classes12.zip;" w/o quotes.

3. I have many Projects in my workspace along with "Java class libraries", "SQLJ Runtime Libraries".

My Problem is:

When I try to load and register JDBC driver with statement below:

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

I get compile error saying "Type named oracle.jdbc.driver.OracleDriver is not defined."

My questions are:

Do I need to have any "oracle" Projects in my workspace. If so Where do I get it from??.

I think I am missing some oracle classes.

P L E A S E H E L P !!

12-22-2002, 03:06 PM
Why did you post a poll?