Hi,
you are trying to take an thin-jdbc url with the oci-driver.
Try jdbc:oracle:thin:@bioinfo...
or jdbc:oracle:oci8@<sid>
Hth
Felix
On Wed, Aug 14, 2002 at 02:57:01PM -0500, Nagpal, Vikas wrote:
> 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]>
