Yes. For security reasons we cannot use TCP connection.
>>> Tim Funk <[EMAIL PROTECTED]> 07/11/02 09:45AM >>>
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" <[EMAIL PROTECTED]>
> 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: <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]>
