...

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



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

Personal Oracle8i Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - 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

LINK2HR2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pria)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = link2hr2))
)




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 !!

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum