I still think your jdbc-url is wrong. In my opinion you have to give a tnsname for the oci driver and hostname+port+sid for then thin driver.
Have you tried the examples given in http://otn.oracle.com/tech/java/sqlj_jdbc/pdf/a96654.pdf on Page 52 and 53? For the examples it is enough to have exported LD_LIBRARY_PATH containing $ORACLE_HOME/lib and CLASSPATH containing the classes12.zip from the oracle 9i client-installation ($ORACLE_HOME/jdbc/lib). -- Original Nachricht -- >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]> > > ________________________________________ Online Fotoalben - jetzt kostenlos bei http://www.ePost.de -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
