----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Hi Dave,
Thank you for the info. The OCI connection works now.
Thanks to all who replied.
Regards
Ranga
----Original Message Follows----
From: "David Molloy" <[EMAIL PROTECTED]>
Reply-To: "Java Apache Users" <[EMAIL PROTECTED]>
To: "Java Apache Users" <[EMAIL PROTECTED]>
Subject: RE: JDBC problem
Date: Wed, 2 Aug 2000 09:34:51 +0100
----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Hi Ranga,
I think almost everyone who attempts to set up their OCI Oracle
connections with JServ get this problem at some time. There are a few
things you need to do:
1. Make sure that the jdbc-oci shared object (libocijdbc8 or
liboci80Xjdbc.so etc.)
and ${ORACLE_HOME}/lib are in your path.
2. Include the following lines in your conf files:
# An environment name with value passed to the JVM
# Syntax: wrapper.env=[name]=[value]
# Default: NONE on Unix Systems
# SystemDrive and SystemRoot with appropriate values on Win32
systems
wrapper.env=LD_LIBRARY_PATH=/oracle_sw/app/oracle/product/8.1.5/lib
wrapper.env=ORACLE_HOME=/oracle_sw/app/oracle/product/8.1.5
wrapper.env=ORACLE_SID=**SID**
Obviously set them to whatever applies for you. SID is your database name.
3. The next problem you *may* but quite likely encounter is this:
java.lang.UnsatisfiedLinkError: make_c_state
at java.lang.Throwable.fillInStackTrace(Native Method)
at
org.apache.jserv.JServConnection.processRequest(JServConnection.java:341)
at org.apache.jserv.JServConnection.run(JServConnection.java:197)
at java.lang.Thread.run(Thread.java:485)
To fix this one make sure that your Oracle classes are consistant with your
JDK classes. This one bugged me for quite a while, until I discovered that
on the system I was using it was attempting to use an old jdk, which
wouldn't
work with classes12.zip for Oracle.
Anyway I hope this helps.
Dave Molloy
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Ranga S
Sent: Tuesday, August 01, 2000 7:12 PM
To: [EMAIL PROTECTED]
Subject: Re: JDBC problem
----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Hi,
Thanks to all who replied.
I did add the "wrapper.classpath" entry to my jserv.properties file. Now
when I try to execute the Servlet, it throws the following exception:
Servlet Error: java.lang.UnsatisfiedLinkError: no ocijdbc8 in
java.library.path:
I have set the LD_LIBRARY_PATH environment variable to point to my
$ORACLE_HOME/lib and $ORACLE_HOME/jdbc/lib directories. Still I get that
exception.
Any pointers? Thanks.
Regards
Ranga
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
