JDBC OCI driver + Tomcat 4.04

[Rao Manekar <ma...@dcor.state.ga.us>]

I am having problem connecting to Oracle 9i database using JDBC OCI driver with Named Pipes through Tomcat 4.04.  Connection works fine if I run the code as a java application at command prompt, but fails when I connect through JSP page.   It gives me "ORA-12560: TNS:protocol adapter error ". 
I am using Tomcat 4.04 and IIS 5.0.

I would appreciate your valuable help.

Thanks

Rao

Re: JDBC OCI driver + Tomcat 4.04

[Tim Funk <fu...@joedog.org>]

I know this doesn't solve your problem, but is there a compelling reason 
to use OCI driver as compared to the type 4 driver?

Rao Manekar wrote:
> I am having problem connecting to Oracle 9i database using JDBC OCI driver with Named Pipes through Tomcat 4.04.  Connection works fine if I run the code as a java application at command prompt, but fails when I connect through JSP page.   It gives me "ORA-12560: TNS:protocol adapter error ". 
> I am using Tomcat 4.04 and IIS 5.0.
> 
> I would appreciate your valuable help.
> 
> Thanks
> 
> Rao
> 
> 
> ------------------------------------------------------------------------
> 
> Subject:
> TNS:protocol adapter error ; ORA-12560 ; sqlState=66000
> From:
> "Rao Manekar" <ma...@dcor.state.ga.us>
> Date:
> Wed, 10 Jul 2002 12:23:10 -0400
> 
> 
> Hi:
> 
> I am using: 
> Windows 2000
> IIS 5.0
> Tomcat 4.04
> JDK 1.4
> Oracle 9i
> Orcale OCI JDBC driver
> ( I am using NMP in place of TCP for connecting db server)
> using JSP/java beans
> 
> I am getting following error when I tried to connect to database.
> 
> ORA-12560: TNS:protocol adapter error 
> sqlState=66000
> 
> I could able to connect to the database through Oracle SQL SqlPlus with the same userid, password and tnsname that I am using in my Java class file.
> 
> I also created a simple Java application and run it through command prompt, it connects to the database with out any problem using following code:
> 
> Connection conn = DriverManager.getConnection
>                         ("jdbc:oracle:oci:@" + TNSNAME, user, password);
> 
> (used example mentioned at end of the webpage:
> http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/getsta.htm
> )
> 
> 
> I tried all the options mentioned below:
> (obtained from 
> http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/basic.htm#1000881
> )
> 
> /*******************************************/
> Connection conn = DriverManager.getConnection 
>                   ("jdbc:oracle:oci:scott/tiger@");
> 
> Connection conn = DriverManager.getConnection 
>                   ("jdbc:oracle:oci:@", "scott", "tiger");
> 
> Connection conn = DriverManager.getConnection
>                   (jdbc:oracle:oci:@MyHostString","scott","tiger");
> used tnsname for MyHostString
> 
> Connection conn = DriverManager.getConnection
>    ("jdbc:oracle:oci:@(description=(address=(host= myhost)
>    (protocol=tcp)(port=1521))(connect_data=(INSTANCE_NAME=orcl)))",
>    "scott", "tiger");
> 
> (modified the above one for named pipes as:
> (description=(address=(protocol=NMP)(server=<servername>)(pipe=ORAPIPE))(connect_data=(SID=<sid>)))
> )
> /*******************************************/
> 
> In all instances I am getting the same error message.
> 
> Can any one help me connecting to the database?  
> 
> Thanks in advance.
> 
> 
> Rao Manekar
> 
>  


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>