-----Original Message-----
From: Saravanan Bellan
Sent: Wednesday, August 14, 2002 12:16 PM
To: 'Tomcat Users List'
Subject: RE: Trying to work with JDBC OCI
It is most definitely a native library location problem not a CLASSPATH
problem.
>
> 2) I have put LD_LIBRARY_PATH=$ORACLE_HOME/lib.
>
Where have you set this variable. It should be visible to the run.sh script.
Also, make sure that $ORACLE_HOME is also set.
> -----Original Message-----
> From: Nagpal, Vikas [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 14, 2002 11:58 AM
> To: '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> Subject: Trying to work with JDBC OCI
>
>
> Hi Everybody,
>
> I have been trying to work with JDBC OCI Driver.While trying
> to run my code
> i get the following error message:
> 1)javax.servlet.ServletException:no ocijdbc9 in java.library.path .
>
> My jsp code is as follows:
>
> 1)I am importing the following packages
> import="java.sql.*, javax.sql.*, javax.servlet.*,
> javax.servlet.http.*,
> java.util.*, oracle.jdbc.*, java.net.*" %>
>
> 2)My connecion code is as follows:
>
> Class.forName("oracle.jdbc.driver.OracleDriver");
> DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
> Connection myConn =
> DriverManager.getConnection("jdbc:oracle:oci:@bioinfo.utmb.edu
> :1521:PLSExtPr
>
> oc");
> where
> <database>=<host>=bioinfo.utmb.edu:<port>=1521:<sid>=PLSExtProc
>
> Statement stmt = myConn.createStatement();
> ResultSet myResultSet = stmt.executeQuery("select * from
> <table> where
> <field>='117_at'");
>
> if (myResultSet != null)
> {
> while (myResultSet.next()) {
>
> To Resolve this error i am trying out the following things:
>
> 1)I have added classes12.jar, nls-charset12.jar,
> ocijdbc.0.0.jar to my
> $TOMCAT_HOME/common/lib and configured it to my CLASSPATH.
>
> 2) I have put LD_LIBRARY_PATH=$ORACLE_HOME/lib.
>
> 3) i have imported package java.net.* into my code.
>
>
>
> Can anyone help.
>
> Thanks,
> With regards,
> Vikas nagpal.
>
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
