How To Connect to Oracle From WO 5.2
How To Connect to Oracle From WO 5.2
- Subject: How To Connect to Oracle From WO 5.2
- From: email@hidden
- Date: Thu, 12 Feb 2004 11:03:12 -0500
- Priority: normal
Morning everyone,
I was trying to connect to an instance of our Oracle DB. We have Windows 2000 advanced server WO 5.2 and Oracle 8i (8.1.7)
Here is the tnsnames.ora entry:
LOGIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbtest2.lhric.org)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl.osdbtest.lhric.org)
)
)
-
It connects to the aforementioned instance via SQLPlus.
Now I am using the jdbc adaptor through the eomodeler but I think the url that I wrote is wrong. I tried jdbc:oracle:email@hidden:1521:orcl.osdbtest.lhric.org
But I got the following error.
JDBC connection failed for driver :'oracle.jdbc.driver.OracleDriver'. Driver not found in Java Runtime! Please verify your CLASSPATH environment variable. The current CLASSPATH for your application is : C:\Apple\Library\Frameworks\JDBCEOAdaptor.framework\Resources\Java\.;/Library/Java;C:/Apple/Local/Library/Java;C:/Apple/Library/Java;C:/Apple/Library/JDK/lib/classes.zip;C:/Apple/Library/Frameworks/JavaVM.framework/Classes/awt.jar;C:/Apple/Library/JDK/lib/swingall.jar
An unexpected error has occurred which may cause EOModeler to malfunction. You may want to save copies of your open documents and quit EOModeler.
Error: JDBCAdaptorException: JDBC connection failed for driver :'oracle.jdbc.driver.OracleDriver'. Driver not found in Java Runtime! Please verify your CLASSPATH environment variable. The current CLASSPATH for your application is : C:\Apple\Library\Frameworks\JDBCEOAdaptor.framework\Resources\Java\.;/Library/Java;C:/Apple/Local/Library/Java;C:/Apple/Library/Java;C:/Apple/Library/JDK/lib/classes.zip;C:/Apple/Library/Frameworks/JavaVM.framework/Classes/awt.jar;C:/Apple/Library/JDK/lib/swingall.jar
Stack Trace:
JDBCAdaptorException: JDBC connection failed for driver :'oracle.jdbc.driver.OracleDriver'. Driver not found in Java Runtime! Please verify your CLASSPATH environment variable. The current CLASSPATH for your application is : C:\Apple\Library\Frameworks\JDBCEOAdaptor.framework\Resources\Java\.;/Library/Java;C:/Apple/Local/Library/Java;C:/Apple/Library/Java;C:/Apple/Library/JDK/lib/classes.zip;C:/Apple/Library/Frameworks/JavaVM.framework/Classes/awt.jar;C:/Apple/Library/JDK/lib/swingall.jar
at JDBCContext.connect(Compiled Code)
at JDBCContext._tryConnect(JDBCContext.java:246)
at JDBCContext._fetchJDBCInfo(Compiled Code)
at JDBCPlugIn.jdbcInfo(JDBCPlugIn.java:848)
at OraclePlugIn.jdbcInfo(OraclePlugIn.java:74)
at JDBCAdaptor.typeInfo(JDBCAdaptor.java:242)
at JDBCAdaptor.hackedAssignExternalTypeForAttribute(Compiled Code)
at EOAdaptorJava._recursivelyConvertEntity(Compiled Code)
at EOAdaptorJava.hackedAssignExternalInfoForEntireModel(Compiled Code)
Any ideas ?
A. Shiraz
44 Executive Boulevard
Elmsford, NY 10523
(914) 592- 4203 x268
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.