Trying to work with JDBC OCI

["Nagpal, Vikas" <vi...@utmb.edu>]

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:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>