Re: JDBC OCI driver + Tomcat 4.04
Subject: Re: JDBC OCI driver + Tomcat 4.04 From: mark [EMAIL PROTECTED] === When using the OCI driver in a windows environment, we have found the following helps :- 1) Add references to classes12.zip and nls_charset12.zip to the classpath (eg in catalina.bat). 2) The reference should be to the installed location (eg c:\oracle\Ora81\jdbc\lib\classes12.zip or wherever the zip files are in your oracle installation is). Do not copy to another location or rename to classes12.zip. 3) Make sure the oracle path has been added to the PATH variable in windows (again you can add it in catalina.bat). The above steps dont seem necessary when using the Oracle thin driver and I'm not sure all of the above is required - it works for us though. Let us know if youre still having problems. HTH Mark James Ward [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... One note I forgot to mention about the OCI driver: You must set your ORACLE_HOME and LD_LIBRARY_PATH vars!!! In my server.sh I have these lines: ORACLE_HOME=/home/oracle/product/817 export ORACLE_HOME LD_LIBRARY_PATH=$ORACLE_HOME/lib export LD_LIBRARY_PATH If you do all that and you can do a tnsping, everything *should* work. -James -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: JDBC OCI driver + Tomcat 4.04
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]
Re: JDBC OCI driver + Tomcat 4.04
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]
Re: JDBC OCI driver + Tomcat 4.04
The OCI driver is *at least* 10X faster than the thin driver. It is worth getting it going. ;-) I do not have my ora docs handy, what is a ORA-12560 error? Any hints there? Send some simple sample code, that will help too. Larry [EMAIL PROTECTED] 07/11/02 07:46 AM 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? -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: JDBC OCI driver + Tomcat 4.04 (ORA-12560)
oerr ORA 12560 12560, 0, TNS:protocol adapter error // *Cause: A generic protocol adapter error occurred. // *Action: Check addresses used for proper protocol specification. Before // reporting this error, look at the error stack and check for lower level // transport errors.For further details, turn on tracing and reexecute the // operation. Turn off tracing when the operation is complete. -Original Message- From: Larry Meadors [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 10:31 AM To: [EMAIL PROTECTED] Subject: Re: JDBC OCI driver + Tomcat 4.04 The OCI driver is *at least* 10X faster than the thin driver. It is worth getting it going. ;-) I do not have my ora docs handy, what is a ORA-12560 error? Any hints there? Send some simple sample code, that will help too. Larry [EMAIL PROTECTED] 07/11/02 07:46 AM 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? -- 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]
RE: JDBC OCI driver + Tomcat 4.04
Do you have to install the oracle tnsclient software or something like that to use OCI? -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 9:31 AM To: [EMAIL PROTECTED] Subject: Re: JDBC OCI driver + Tomcat 4.04 The OCI driver is *at least* 10X faster than the thin driver. It is worth getting it going. ;-) I do not have my ora docs handy, what is a ORA-12560 error? Any hints there? Send some simple sample code, that will help too. Larry [EMAIL PROTECTED] 07/11/02 07:46 AM 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? -- 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]
RE: JDBC OCI driver + Tomcat 4.04
O'Reilly has a good article about the performance differences between the oci and the thin client driver: http://www.oreilly.com/catalog/jorajdbc/chapter/ch19.html In order to use the OCI driver you will have to install the oracle client. Then make sure your tnsnames.ora file is correct. Check it with a tnsping. Personally I am sticking with the thin client driver. -James -Original Message- From: Durham David Cntr 805CSS/SCBE [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 9:10 AM To: Tomcat Users List Subject: RE: JDBC OCI driver + Tomcat 4.04 Do you have to install the oracle tnsclient software or something like that to use OCI? -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 9:31 AM To: [EMAIL PROTECTED] Subject: Re: JDBC OCI driver + Tomcat 4.04 The OCI driver is *at least* 10X faster than the thin driver. It is worth getting it going. ;-) I do not have my ora docs handy, what is a ORA-12560 error? Any hints there? Send some simple sample code, that will help too. Larry [EMAIL PROTECTED] 07/11/02 07:46 AM 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? -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: JDBC OCI driver + Tomcat 4.04
Yep, you need to have the client installed on the tomcat server. It works the same on linux and Windows, and is a free download, so it is not a BIG deal, just an extra step. If you are running tomcat as a service, you also have to tell it where to find the dll (on windows). Not sure about linux setup. The thin driver is sure easier, but you just cannot argue with the performance, I was SHOCKED. Larry [EMAIL PROTECTED] 07/11/02 09:10 AM Do you have to install the oracle tnsclient software or something like that to use OCI? -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: JDBC OCI driver + Tomcat 4.04
Hi, James: thank you for that URL. I recommend everyone read it ;) goes off in search of his db programmers Yoav Shapira Millennium ChemInformatics -Original Message- From: James Ward [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 11:31 AM To: Tomcat Users List Subject: RE: JDBC OCI driver + Tomcat 4.04 O'Reilly has a good article about the performance differences between the oci and the thin client driver: http://www.oreilly.com/catalog/jorajdbc/chapter/ch19.html In order to use the OCI driver you will have to install the oracle client. Then make sure your tnsnames.ora file is correct. Check it with a tnsping. Personally I am sticking with the thin client driver. -James -Original Message- From: Durham David Cntr 805CSS/SCBE [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 9:10 AM To: Tomcat Users List Subject: RE: JDBC OCI driver + Tomcat 4.04 Do you have to install the oracle tnsclient software or something like that to use OCI? -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 9:31 AM To: [EMAIL PROTECTED] Subject: Re: JDBC OCI driver + Tomcat 4.04 The OCI driver is *at least* 10X faster than the thin driver. It is worth getting it going. ;-) I do not have my ora docs handy, what is a ORA-12560 error? Any hints there? Send some simple sample code, that will help too. Larry [EMAIL PROTECTED] 07/11/02 07:46 AM 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? -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: JDBC OCI driver + Tomcat 4.04
One note I forgot to mention about the OCI driver: You must set your ORACLE_HOME and LD_LIBRARY_PATH vars!!! In my server.sh I have these lines: ORACLE_HOME=/home/oracle/product/817 export ORACLE_HOME LD_LIBRARY_PATH=$ORACLE_HOME/lib export LD_LIBRARY_PATH If you do all that and you can do a tnsping, everything *should* work. -James -Original Message- From: Shapira, Yoav [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 9:52 AM To: Tomcat Users List Subject: RE: JDBC OCI driver + Tomcat 4.04 Hi, James: thank you for that URL. I recommend everyone read it ;) goes off in search of his db programmers Yoav Shapira Millennium ChemInformatics -Original Message- From: James Ward [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 11:31 AM To: Tomcat Users List Subject: RE: JDBC OCI driver + Tomcat 4.04 O'Reilly has a good article about the performance differences between the oci and the thin client driver: http://www.oreilly.com/catalog/jorajdbc/chapter/ch19.html In order to use the OCI driver you will have to install the oracle client. Then make sure your tnsnames.ora file is correct. Check it with a tnsping. Personally I am sticking with the thin client driver. -James -Original Message- From: Durham David Cntr 805CSS/SCBE [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 9:10 AM To: Tomcat Users List Subject: RE: JDBC OCI driver + Tomcat 4.04 Do you have to install the oracle tnsclient software or something like that to use OCI? -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 9:31 AM To: [EMAIL PROTECTED] Subject: Re: JDBC OCI driver + Tomcat 4.04 The OCI driver is *at least* 10X faster than the thin driver. It is worth getting it going. ;-) I do not have my ora docs handy, what is a ORA-12560 error? Any hints there? Send some simple sample code, that will help too. Larry [EMAIL PROTECTED] 07/11/02 07:46 AM 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? -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: JDBC OCI driver + Tomcat 4.04
Wow. I do not know how they tested or measured this, but it is WAY, WAY off what I saw in our environment. I wonder if this is on the Oracle server? We literally saw a 10x performance boost going to OCI. Larry [EMAIL PROTECTED] 07/11/02 09:32 AM O'Reilly has a good article about the performance differences between the oci and the thin client... -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: JDBC OCI driver + Tomcat 4.04
Just out of curiosity, what platforms for oracle and tomcat? -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 10:00 AM To: [EMAIL PROTECTED] Subject: RE: JDBC OCI driver + Tomcat 4.04 Wow. I do not know how they tested or measured this, but it is WAY, WAY off what I saw in our environment. I wonder if this is on the Oracle server? We literally saw a 10x performance boost going to OCI. Larry [EMAIL PROTECTED] 07/11/02 09:32 AM O'Reilly has a good article about the performance differences between the oci and the thin client... -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: JDBC OCI driver + Tomcat 4.04 ... problem solved
Good news. Good news. Problem solved. For some reason when I run tomcat as a NT service, I am getting TNS: protocol adaptor error. Just today I started tomcat as a stand alone application, manually bingo! it worked. I went back and started tomcat service as an administrator but still gave the same error. I stopped the service and run the application as stand alone. This time I see no error. I could query the database through my JSPs and JavaBeans. I modified wrapper.properties file to contain correct entries. But still gave me same problem. I do have Oracle client on the workstation. I could able to log on through SQL*Plus client. I was able to run a simple Java application from the command prompt and get connected to the database but some how I was bailing out when I execute the same code through JSP. So, for right now I will run Tomcat as stand alone application and NOT as a NT service. Thank you for all your help. Rao Larry Meadors [EMAIL PROTECTED] 07/11/02 11:31AM Yep, you need to have the client installed on the tomcat server. It works the same on linux and Windows, and is a free download, so it is not a BIG deal, just an extra step. If you are running tomcat as a service, you also have to tell it where to find the dll (on windows). Not sure about linux setup. The thin driver is sure easier, but you just cannot argue with the performance, I was SHOCKED. Larry [EMAIL PROTECTED] 07/11/02 09:10 AM Do you have to install the oracle tnsclient software or something like that to use OCI? -- 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]
RE: JDBC OCI driver + Tomcat 4.04 ... problem solved
If you can run tomcat as a normal user, but not as a service, I can 99% guarantee the problem is with permissions for the local SYSTEM account on the server. The permission level for the local SYSTEM account isn't allowing tomcat to read or access the files it needs to read or access. Search the list archives, this subject came up about a month ago, the poster had the exact same problem and resolved it. John Turner [EMAIL PROTECTED] -Original Message- From: Rao Manekar [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 12:24 PM To: [EMAIL PROTECTED] Subject: RE: JDBC OCI driver + Tomcat 4.04 ... problem solved Good news. Good news. Problem solved. For some reason when I run tomcat as a NT service, I am getting TNS: protocol adaptor error. Just today I started tomcat as a stand alone application, manually bingo! it worked. I went back and started tomcat service as an administrator but still gave the same error. I stopped the service and run the application as stand alone. This time I see no error. I could query the database through my JSPs and JavaBeans. I modified wrapper.properties file to contain correct entries. But still gave me same problem. I do have Oracle client on the workstation. I could able to log on through SQL*Plus client. I was able to run a simple Java application from the command prompt and get connected to the database but some how I was bailing out when I execute the same code through JSP. So, for right now I will run Tomcat as stand alone application and NOT as a NT service. Thank you for all your help. Rao Larry Meadors [EMAIL PROTECTED] 07/11/02 11:31AM Yep, you need to have the client installed on the tomcat server. It works the same on linux and Windows, and is a free download, so it is not a BIG deal, just an extra step. If you are running tomcat as a service, you also have to tell it where to find the dll (on windows). Not sure about linux setup. The thin driver is sure easier, but you just cannot argue with the performance, I was SHOCKED. Larry [EMAIL PROTECTED] 07/11/02 09:10 AM Do you have to install the oracle tnsclient software or something like that to use OCI? -- 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] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: JDBC OCI driver + Tomcat 4.04
Win2K on both. A contractor we are working with is using linux, and he reported similar performance. Larry [EMAIL PROTECTED] 07/11/02 10:03 AM Just out of curiosity, what platforms for oracle and tomcat? -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 10:00 AM To: [EMAIL PROTECTED] Subject: RE: JDBC OCI driver + Tomcat 4.04 Wow. I do not know how they tested or measured this, but it is WAY, WAY off what I saw in our environment. I wonder if this is on the Oracle server? We literally saw a 10x performance boost going to OCI. Larry [EMAIL PROTECTED] 07/11/02 09:32 AM O'Reilly has a good article about the performance differences between the oci and the thin client... -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] -- 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]
