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]>
