This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes OCI help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "OCI help " Watch "OCI help " New topic
Author

OCI help

Asad Tungeker
Greenhorn

Joined: Jul 04, 2002
Posts: 3
I have successfully ran OCI:8 driver test on my local
development environment using 8.1.7 driver to conect to Oracle
9i. However, when I transferred the same configuration to app
server, I get a sql exception to connect using OCI:8 driver.
While debugging the classPath, I noticed
1.
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/oracle/app/oracle/product/8
.1.7/ctx/lib, but the ctx folder does not exist in the path
defined above,
2. PATH=$PATH:$ORACLE_HOME/bin
DO I NEED TO ADD the following: $ORACLE_HOME/ctx/bin in the
path ?
libocijdbc8.so driver exist in,
/opt/oracle/app/oracle/product/8.1.7/lib/libocijdbc8.so , and it
is in the classpath but for some reason the application keeps
looking for ocijdbc9.so files. Do I need to replace the
classes12.zip with an older version ??

Error string
[03.02.04 12:53:33:262 CST] ae8e9b ServletInstan X Uncaught
init() exception thr
own by servlet {0}: {1}
"action"
javax.servlet.ServletException:
no ocijdbc9 in
java.library.path
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at
javax.servlet.ServletException.<init>(ServletException.java:161)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doInit(Servle
tMan
ager.java:635)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._init(Strict
Life
cycleServlet.java:136)


Courage does'nt always roar.Sometimes courage is the little voice at the end of the day that says,"I'll try again tomorrow".
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: OCI help