RE: How To Connect to Oracle From WO 5.2
RE: How To Connect to Oracle From WO 5.2
- Subject: RE: How To Connect to Oracle From WO 5.2
- From: "Ricardo T Saito" <email@hidden>
- Date: Thu, 12 Feb 2004 14:18:12 -0300
Hi,
Looks like there's no CLASSES12.ZIP anywhere in the classpath.
You can try to download it at:
http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/jdbc817.html
----------------------------------------------------
Ricardo T Saito - email@hidden
Computer Engineer
Americanas.com - Sao Paulo - Brazil
-----Original Message-----
From: email@hidden
[mailto:email@hidden]On Behalf Of
email@hidden
Sent: Thursday, February 12, 2004 1:03 PM
To: email@hidden
Cc: email@hidden
Subject: How To Connect to Oracle From WO 5.2
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\.;/Librar
y/Java;C:/Apple/Local/Library/Java;C:/Apple/Library/Java;C:/Apple/Library/JD
K/lib/classes.zip;C:/Apple/Library/Frameworks/JavaVM.framework/Classes/awt.j
ar;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\.;/Librar
y/Java;C:/Apple/Local/Library/Java;C:/Apple/Library/Java;C:/Apple/Library/JD
K/lib/classes.zip;C:/Apple/Library/Frameworks/JavaVM.framework/Classes/awt.j
ar;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\.;/Librar
y/Java;C:/Apple/Local/Library/Java;C:/Apple/Library/Java;C:/Apple/Library/JD
K/lib/classes.zip;C:/Apple/Library/Frameworks/JavaVM.framework/Classes/awt.j
ar;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.
_______________________________________________
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.