mokhter
12-21-2002, 07: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 !!
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 !!