RE: Still have no answer for this!
Is there a reason you must use the jdbc-odbc bridge? Or could you use the classes11 or classes12 jar files to provide jdbc connections? This is the preferred method of connecting for many reasons, and it would be worth trying to see if you can get rid of this error. -Original Message- From: Roland Dong [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 10:59 AM To: Tomcat Users List; Alex Chaffee Subject: Still have no answer for this! I have installed tomacat to set up Oracle JDBC-ODBC driver, data source... but ran into some problmes: The database connection with Oracle only works with .java files but does not work with jsp files. For example: test.java would work but test.jsp would not. This is the error message I got when running with test.jsp: OCI.DLL: One of the library files needed to run this appliction cannot be found. Can anyone tell me what might be the problem? I checked the dll dependency for OCI.DLL, all dll files are there. Please help Roland This is my test.jsp program: %@ page info=database handler% %@ page import=java.io.*% %@ page import=java.util.*% %@ page import=java.sql.*% %@ page import=javax.servlet.*% %@ page import=javax.servlet.http.*% % try { Connection con=null; Statement stmt=null; ResultSet rs=null; String createString=null; Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url=jdbc:odbc:test; con = DriverManager.getConnection(url,scott, tiger); createString=select FIRST_NAME,EMPLOYEE_ID,SALARY from emp; stmt=con.createStatement(); ; rs = stmt.executeQuery(createString); while (rs.next()) { String col1 = rs.getString(1); String col2 = rs.getString(2); out.println(trtd+col1+/tdtd+col2+/td/tr); } out.println(/table); } catch (Exception e) {} % -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Still have no answer for this!
OCI.DLL: One of the library files needed to run this appliction cannot be found. Can anyone tell me what might be the problem? I checked the dll dependency for OCI.DLL, all dll files are there. http://www.orafaq.com/msgboard/java/messages/398.htm OCI is the Oracle Call Interface and is only one of the ways you can call Oracle. Are you *sure* that your connection URIs are identical? One workaround may be to re-install the Oracle drivers, according to one comment I found. Better still, move to a POS (Proper Operating System) instead of the POS (Microsoft product) you are using. Justin. -- You're only jealous cos the little penguins are talking to me. *** For more information on Ordnance Survey products and services, visit our web site at http://www.ordnancesurvey.co.uk *** -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Still have no answer for this!
It is possible that you do not have the PATH sentup properly. Make sure the directory containing the OCI.dll is in the PATH environment variable.. Also sometimes esp., when using OCI drivers , you need to set up ORACLE_HOME environment variable.. Hope this helped... Arvind -Original Message- From: Justin Rowles [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 12:19 PM To: 'Tomcat Users List' Subject: RE: Still have no answer for this! OCI.DLL: One of the library files needed to run this appliction cannot be found. Can anyone tell me what might be the problem? I checked the dll dependency for OCI.DLL, all dll files are there. http://www.orafaq.com/msgboard/java/messages/398.htm OCI is the Oracle Call Interface and is only one of the ways you can call Oracle. Are you *sure* that your connection URIs are identical? One workaround may be to re-install the Oracle drivers, according to one comment I found. Better still, move to a POS (Proper Operating System) instead of the POS (Microsoft product) you are using. Justin. -- You're only jealous cos the little penguins are talking to me. *** For more information on Ordnance Survey products and services, visit our web site at http://www.ordnancesurvey.co.uk *** -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] CONFIDENTIALITY NOTICE: E-mail may contain confidential information that is legally protected. Do not read this e-mail if you are not the intended recipient. This e-mail transmission, and any documents, files or previous e-mail messages attached to it may contain confidential information that is legally protected. If you are not the intended recipient or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, by forwarding this to [EMAIL PROTECTED] or by telephone at (877) PANACYA, and destroy the original transmission and its attachments without reading or saving in any manner. Thank you. For information about PANACYA Inc., please visit our website at http://www.panacya.com.