Putting JDBC drivers in common/lib
Is it mandatory to put the JDBC drivers in the common/lib? Or can I put the JDBC drivers in each context's WEB-INF/lib? As long as I can remember I read somewhere that these drivers most be placed in the common/lib directory cause otherwise it introduces class loader problems. But what if I have two different Web applications and each of them use a different version of the JDBC driver for the same RDBMS? Regards, -- Behrang Saeedzadeh http://www.jroller.com/page/behrangsa - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Putting JDBC drivers in common/lib
if you are using jndi, i think they have to be in common/lib. If not, they can go in WEB-INF/lib instead. Larry On Sat, 19 Feb 2005 02:42:35 +0330, Behrang Saeedzadeh [EMAIL PROTECTED] wrote: Is it mandatory to put the JDBC drivers in the common/lib? Or can I put the JDBC drivers in each context's WEB-INF/lib? As long as I can remember I read somewhere that these drivers most be placed in the common/lib directory cause otherwise it introduces class loader problems. But what if I have two different Web applications and each of them use a different version of the JDBC driver for the same RDBMS? Regards, -- Behrang Saeedzadeh http://www.jroller.com/page/behrangsa - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: AW: comparison of Type 4 JDBC drivers
On Thu, 11 Nov 2004 08:52:00 +0100, Michael Sudkamp [EMAIL PROTECTED] wrote: And we switched from FreeTDS (which AFAIK is the predecessor of jTDS) to the MS driver years ago because is had more functionality. We use it with heavy statements and result sets and had never any problem with it ;-) Michael Years in real life does a few thousand years in Internet time. :-) I suggest giving a shot to one of the latest releases of jtds.. It is quite *solid* and *performant*. Btw, we use FreeTDS for a legacy system on UNIX to connect it to an SQL Server and it seems to work nice too. I don't know older releases though.. /tb. -Ursprungliche Nachricht- Von: Tuncay Baskan [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 10. November 2004 00:30 An: Tomcat Users List Betreff: Re: comparison of Type 4 JDBC drivers On Wed, 10 Nov 2004 12:18:20 +1300, Craig Collings [EMAIL PROTECTED] wrote: Interesting. I'm using com.microsoft.jdbc.sqlserver.SQLServerDriver which is a type 4 driver and I am also getting ex VM errors: any ideas? I don't know if it's helps.. We tried to use Microsoft JDBC drivers in our applications but because of its troubles we decided to use jTds, which is a but rock-solid free driver.. You can get it from http://jtds.sourceforge.net/. -- /tb. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- /tb. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: comparison of Type 4 JDBC drivers
I cannot thank you enough Tuncay Baskan. We were about to switch to Tomcat from Jrun4 and found that the MS drivers were noticably slower. Your tip to use jTds probably saved me a few days of testing. We also tried DataDirect, but they will not sell you just a driver unless you have some distribution agreement and a lot of money. Many thanks, Al G - Original Message - From: Tuncay Baskan [EMAIL PROTECTED] Date: Tuesday, November 9, 2004 5:29 pm Subject: Re: comparison of Type 4 JDBC drivers On Wed, 10 Nov 2004 12:18:20 +1300, Craig Collings [EMAIL PROTECTED] wrote: Interesting. I'm using com.microsoft.jdbc.sqlserver.SQLServerDriver which is a type 4 driver and I am also getting ex VM errors: any ideas? I don't know if it's helps.. We tried to use Microsoft JDBC drivers in our applications but because of its troubles we decided to use jTds, which is a but rock-solid free driver.. You can get it from http://jtds.sourceforge.net/. -- /tb. --- -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
AW: comparison of Type 4 JDBC drivers
And we switched from FreeTDS (which AFAIK is the predecessor of jTDS) to the MS driver years ago because is had more functionality. We use it with heavy statements and result sets and had never any problem with it ;-) Michael -Ursprungliche Nachricht- Von: Tuncay Baskan [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 10. November 2004 00:30 An: Tomcat Users List Betreff: Re: comparison of Type 4 JDBC drivers On Wed, 10 Nov 2004 12:18:20 +1300, Craig Collings [EMAIL PROTECTED] wrote: Interesting. I'm using com.microsoft.jdbc.sqlserver.SQLServerDriver which is a type 4 driver and I am also getting ex VM errors: any ideas? I don't know if it's helps.. We tried to use Microsoft JDBC drivers in our applications but because of its troubles we decided to use jTds, which is a but rock-solid free driver.. You can get it from http://jtds.sourceforge.net/. -- /tb. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: comparison of Type 4 JDBC drivers
Interesting. I'm using com.microsoft.jdbc.sqlserver.SQLServerDriver which is a type 4 driver and I am also getting ex VM errors: any ideas? An unexpected exception has been detected in native code outside the VM. Unexpected Signal : EXCEPTION_ACCESS_VIOLATION (0xc005) occurred at PC=0x77F46A07 Function=RtlFreeHeap+0x322 Library=C:\WINDOWS\system32\ntdll.dll Current Java thread: at java.util.zip.ZipFile.getEntry(Native Method) at java.util.zip.ZipFile.getEntry(ZipFile.java:146) - locked 0x10b26c90 (a java.util.jar.JarFile) at java.util.jar.JarFile.getEntry(JarFile.java:194) at java.util.jar.JarFile.getJarEntry(JarFile.java:181) at sun.misc.URLClassPath$JarLoader.getResource(URLClassPath.java:668) at sun.misc.URLClassPath.getResource(URLClassPath.java:157) at java.net.URLClassLoader$1.run(URLClassLoader.java:191) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:187) at java.lang.ClassLoader.loadClass(ClassLoader.java:289) - locked 0x10b322d8 (a sun.misc.Launcher$ExtClassLoader) at java.lang.ClassLoader.loadClass(ClassLoader.java:235) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) - locked 0x10b322d8 (a sun.misc.Launcher$ExtClassLoader) at com.abnamrocraigs.listings.IressNewListingsListener.addListings(IressNewList ingsListener.java:147) at com.abnamrocraigs.listings.IressNewListingsListener.notify(IressNewListingsL istener.java:66) at com.abnamrocraigs.tasks.TaskScheduler.propagate(TaskScheduler.java:68) - locked 0x110be650 (a com.abnamrocraigs.tasks.TaskScheduler) at com.abnamrocraigs.tasks.ScheduledTask.run(ScheduledTask.java:21) at java.util.TimerThread.mainLoop(Timer.java:432) at java.util.TimerThread.run(Timer.java:382) Dynamic libraries: 0x0040 - 0x00406000 C:\WINDOWS\system32\java.exe 0x77F4 - 0x77FFA000 C:\WINDOWS\system32\ntdll.dll 0x77E4 - 0x77F34000 C:\WINDOWS\system32\kernel32.dll 0x77DA - 0x77E3 C:\WINDOWS\system32\ADVAPI32.dll 0x77C5 - 0x77CF5000 C:\WINDOWS\system32\RPCRT4.dll 0x77BA - 0x77BF4000 C:\WINDOWS\system32\MSVCRT.dll 0x0800 - 0x082A7000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\server\jvm.dll 0x77D0 - 0x77D8F000 C:\WINDOWS\system32\USER32.dll 0x77C0 - 0x77C44000 C:\WINDOWS\system32\GDI32.dll 0x76AA - 0x76ACC000 C:\WINDOWS\system32\WINMM.dll 0x1000 - 0x10007000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\hpi.dll 0x0038 - 0x0038E000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\verify.dll 0x003B - 0x003C8000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\java.dll 0x0039 - 0x0039D000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\zip.dll 0x008D - 0x008DF000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\net.dll 0x71C0 - 0x71C18000 C:\WINDOWS\system32\WS2_32.dll 0x71BF - 0x71BF8000 C:\WINDOWS\system32\WS2HELP.dll 0x008E - 0x008E8000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\nio.dll 0x71B2 - 0x71B63000 C:\WINDOWS\System32\mswsock.dll 0x76ED - 0x76EF7000 C:\WINDOWS\system32\DNSAPI.dll 0x76F7 - 0x76F77000 C:\WINDOWS\System32\winrnr.dll 0x76F1 - 0x76F3F000 C:\WINDOWS\system32\WLDAP32.dll 0x76F8 - 0x76F85000 C:\WINDOWS\system32\rasadhlp.dll 0x71AE - 0x71AE8000 C:\WINDOWS\System32\wshtcpip.dll 0x0340 - 0x03406000 C:\jintegra\bin\ntvauth.dll 0x73D2 - 0x73E13000 C:\WINDOWS\system32\MFC42.DLL 0x0341 - 0x03417000 C:\jintegra\bin\International\ntvauthEnglishResourceDll.dll 0x71F6 - 0x71F64000 C:\WINDOWS\system32\SECURITY.dll 0x76F5 - 0x76F63000 C:\WINDOWS\system32\SECUR32.dll 0x76C9 - 0x76CB4000 C:\WINDOWS\system32\msv1_0.dll 0x76C1 - 0x76C38000 C:\WINDOWS\system32\imagehlp.dll 0x6D58 - 0x6D621000 C:\WINDOWS\system32\dbghelp.dll 0x77B9 - 0x77B98000 C:\WINDOWS\system32\VERSION.dll 0x76B7 - 0x76B7B000 C:\WINDOWS\system32\PSAPI.DLL Heap at VM Abort: Heap def new generation total 5184K, used 967K [0x1001, 0x105a, 0x10b2) eden space 4672K, 15% used [0x1001, 0x100c4580, 0x104a) from space 512K, 48% used [0x1052, 0x1055da28, 0x105a) to space 512K, 0% used [0x104a, 0x104a, 0x1052) tenured generation total 44240K, used 27306K [0x10b2, 0x13654000, 0x1641) the space 44240K, 61% used [0x10b2, 0x125ca930, 0x125caa00, 0x13654000) compacting perm gen total 18432K, used 18373K [0x1641, 0x1761, 0x1a41) the space 18432K, 99% used [0x1641, 0x17601738, 0x17601800, 0x1761) Local Time = Wed Nov 10 07:28:56 2004 Elapsed Time = 65227 # # The exception above was detected in native code
RE: comparison of Type 4 JDBC drivers
This is the JVM catching an exception/access violation in the native code outside of the JVM. The problem is probably in native code in the driver or any jni code you may be using. If you are not using any jni to wrap native code that is custom to your site, you should look at how you are calling the JDBC. You may be sending NULL values or incorrect format for what the ODBC driver is expecting and causing the access violation. I had something similar and it was stack corruption in my native code. Robert S. Harper 801.265.8800 ex. 255 -Original Message- From: Craig Collings [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 4:18 PM To: tomcat-user ([EMAIL PROTECTED]) Subject: RE: comparison of Type 4 JDBC drivers Interesting. I'm using com.microsoft.jdbc.sqlserver.SQLServerDriver which is a type 4 driver and I am also getting ex VM errors: any ideas? An unexpected exception has been detected in native code outside the VM. Unexpected Signal : EXCEPTION_ACCESS_VIOLATION (0xc005) occurred at PC=0x77F46A07 Function=RtlFreeHeap+0x322 Library=C:\WINDOWS\system32\ntdll.dll Current Java thread: at java.util.zip.ZipFile.getEntry(Native Method) at java.util.zip.ZipFile.getEntry(ZipFile.java:146) - locked 0x10b26c90 (a java.util.jar.JarFile) at java.util.jar.JarFile.getEntry(JarFile.java:194) at java.util.jar.JarFile.getJarEntry(JarFile.java:181) at sun.misc.URLClassPath$JarLoader.getResource(URLClassPath.java:668) at sun.misc.URLClassPath.getResource(URLClassPath.java:157) at java.net.URLClassLoader$1.run(URLClassLoader.java:191) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:187) at java.lang.ClassLoader.loadClass(ClassLoader.java:289) - locked 0x10b322d8 (a sun.misc.Launcher$ExtClassLoader) at java.lang.ClassLoader.loadClass(ClassLoader.java:235) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) - locked 0x10b322d8 (a sun.misc.Launcher$ExtClassLoader) at com.abnamrocraigs.listings.IressNewListingsListener.addListings(IressNewList ingsListener.java:147) at com.abnamrocraigs.listings.IressNewListingsListener.notify(IressNewListingsL istener.java:66) at com.abnamrocraigs.tasks.TaskScheduler.propagate(TaskScheduler.java:68) - locked 0x110be650 (a com.abnamrocraigs.tasks.TaskScheduler) at com.abnamrocraigs.tasks.ScheduledTask.run(ScheduledTask.java:21) at java.util.TimerThread.mainLoop(Timer.java:432) at java.util.TimerThread.run(Timer.java:382) Dynamic libraries: 0x0040 - 0x00406000 C:\WINDOWS\system32\java.exe 0x77F4 - 0x77FFA000 C:\WINDOWS\system32\ntdll.dll 0x77E4 - 0x77F34000 C:\WINDOWS\system32\kernel32.dll 0x77DA - 0x77E3 C:\WINDOWS\system32\ADVAPI32.dll 0x77C5 - 0x77CF5000 C:\WINDOWS\system32\RPCRT4.dll 0x77BA - 0x77BF4000 C:\WINDOWS\system32\MSVCRT.dll 0x0800 - 0x082A7000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\server\jvm.dll 0x77D0 - 0x77D8F000 C:\WINDOWS\system32\USER32.dll 0x77C0 - 0x77C44000 C:\WINDOWS\system32\GDI32.dll 0x76AA - 0x76ACC000 C:\WINDOWS\system32\WINMM.dll 0x1000 - 0x10007000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\hpi.dll 0x0038 - 0x0038E000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\verify.dll 0x003B - 0x003C8000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\java.dll 0x0039 - 0x0039D000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\zip.dll 0x008D - 0x008DF000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\net.dll 0x71C0 - 0x71C18000 C:\WINDOWS\system32\WS2_32.dll 0x71BF - 0x71BF8000 C:\WINDOWS\system32\WS2HELP.dll 0x008E - 0x008E8000 C:\Program Files\Java\j2sdk1.4.2\jre\bin\nio.dll 0x71B2 - 0x71B63000 C:\WINDOWS\System32\mswsock.dll 0x76ED - 0x76EF7000 C:\WINDOWS\system32\DNSAPI.dll 0x76F7 - 0x76F77000 C:\WINDOWS\System32\winrnr.dll 0x76F1 - 0x76F3F000 C:\WINDOWS\system32\WLDAP32.dll 0x76F8 - 0x76F85000 C:\WINDOWS\system32\rasadhlp.dll 0x71AE - 0x71AE8000 C:\WINDOWS\System32\wshtcpip.dll 0x0340 - 0x03406000 C:\jintegra\bin\ntvauth.dll 0x73D2 - 0x73E13000 C:\WINDOWS\system32\MFC42.DLL 0x0341 - 0x03417000 C:\jintegra\bin\International\ntvauthEnglishResourceDll.dll 0x71F6 - 0x71F64000 C:\WINDOWS\system32\SECURITY.dll 0x76F5 - 0x76F63000 C:\WINDOWS\system32\SECUR32.dll 0x76C9 - 0x76CB4000 C:\WINDOWS\system32\msv1_0.dll 0x76C1 - 0x76C38000 C:\WINDOWS\system32\imagehlp.dll 0x6D58 - 0x6D621000 C:\WINDOWS\system32\dbghelp.dll 0x77B9 - 0x77B98000 C:\WINDOWS\system32\VERSION.dll 0x76B7 - 0x76B7B000 C:\WINDOWS\system32\PSAPI.DLL Heap at VM Abort
Re: comparison of Type 4 JDBC drivers
On Wed, 10 Nov 2004 12:18:20 +1300, Craig Collings [EMAIL PROTECTED] wrote: Interesting. I'm using com.microsoft.jdbc.sqlserver.SQLServerDriver which is a type 4 driver and I am also getting ex VM errors: any ideas? I don't know if it's helps.. We tried to use Microsoft JDBC drivers in our applications but because of its troubles we decided to use jTds, which is a but rock-solid free driver.. You can get it from http://jtds.sourceforge.net/. -- /tb. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: comparison of Type 4 JDBC drivers
cheers guys. To be fair, there is no real indication that it _is_ the jdbc driver. In fact the satck trace seems to indicate an interation between sun's code and ntdll.dll which is rather more scary :) Its only happened once - we'll see. jtds looks good though... /disco : : I don't know if it's helps.. We tried to use Microsoft JDBC : drivers in our applications but because of its troubles we : decided to use jTds, which is a but rock-solid free driver.. : : You can get it from http://jtds.sourceforge.net/. : : -- : /tb. : # Notice of Confidential information The information contained in this electronic mail is CONFIDENTIAL INFORMATION and may be LEGALLY PRIVILEGED, intended only for the individual or entity named above. If you are not the intended recipient, you are hereby notified that the use, dissemination, distribution, or copying of this document is strictly prohibited. If you have received this electronic message in error, please immediately notify us by return or telephone call collect to 07 577 6049) and destroy the original message. Thank you, ABN AMRO Craigs Limited. This e-mail message has been scanned and cleared by MailMarshal www.marshalsoftware.com # - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: comparison of Type 4 JDBC drivers
On Wed, Nov 10, 2004 at 01:29:34AM +0200, Tuncay Baskan wrote: On Wed, 10 Nov 2004 12:18:20 +1300, Craig Collings [EMAIL PROTECTED] wrote: I'm using com.microsoft.jdbc.sqlserver.SQLServerDriver which is a type 4 driver and I am also getting ex VM errors: any ideas? I don't know if it's helps.. We tried to use Microsoft JDBC drivers in our applications but because of its troubles we decided to use jTds, which is a but rock-solid free driver.. You can get it from http://jtds.sourceforge.net/. I don't do SQLServer at all, but a friend who has a J2EE app using SQLServer (JBoss using tomcat, I believe) told me the other day that they're using some third-party JDBC drivers, DataDirect I think. It's apparently pricey as hell (enterprise licensing) but it cut their server load in half. -- Steven J. Owens [EMAIL PROTECTED] I'm going to make broad, sweeping generalizations and strong, declarative statements, because otherwise I'll be here all night and this document will be four times longer and much less fun to read. Take it all with a grain of salt. - http://darksleep.com/notablog - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Mysql JDBC Drivers: Use 2.x or 3.x? (Kinda Long, sry)
When I move my datasource definition to the web.xml file for my webapp, I get nothing. When I use the Tomcat manager app and drill down into Service-Host-Context (testapp1)-Resource-DataSources I see my jdbc/MysqlTest1 datasource defined but all the parameters associated with it are blank. Here is my webapps/testapp1/WEB-INF/web.xml file: ?xml version=1.0 encoding=ISO-8859-1? web-app descriptionTest App 1/description resource-ref descriptionDB Connection/description res-ref-namejdbc/MysqlTest1/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref Resource name=jdbc/MysqlTest1 scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/MysqlTest1 parameter nameurl/name valuejdbc:mysql://localhost:3306/tomcat-test1?autoReconnect=true,maxReconnects=3/value /parameter parameter nameusername/name valuexx/value /parameter parameter namepassword/name valuexx/value /parameter parameter namemaxActive/name value100/value /parameter parameter namemaxWait/name value15000/value /parameter parameter namevalidationQuery/name valueSELECT version()/value /parameter parameter nametestOnBorrow/name valuetrue/value /parameter parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter parameter namemaxIdle/name value100/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter parameter nameremoveAbandonedTimeout/name value60/value /parameter parameter namelogAbandoned/name valuetrue/value /parameter /ResourceParams /web-app I'm sure this is something simple I am missing but the docs are not leading me in the right direction. Thanks for any help, CC --- Robert Bateman [EMAIL PROTECTED] wrote: Chuck, I think you need to move your connection pooling over to your context.xml at the web application level. Here is my pool definition from one of my apps: snip it may not be perfect, but it works on our end. Hope that helps! Bob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Mysql JDBC Drivers: Use 2.x or 3.x? (Kinda Long, sry)
I think I see the problem... Those 2 definitions need to be over in your context.xml. Context.xml is located in META-INF/context.xml It appears you have the definitions in web.xml within WEB-INF/web.xml, which I believe is incorrect. Bob On Wednesday 22 September 2004 02:19 pm, Chuck Carson wrote: When I move my datasource definition to the web.xml file for my webapp, I get nothing. When I use the Tomcat manager app and drill down into Service-Host-Context (testapp1)-Resource-DataSources I see my jdbc/MysqlTest1 datasource defined but all the parameters associated with it are blank. Here is my webapps/testapp1/WEB-INF/web.xml file: ?xml version=1.0 encoding=ISO-8859-1? web-app descriptionTest App 1/description resource-ref descriptionDB Connection/description res-ref-namejdbc/MysqlTest1/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref Resource name=jdbc/MysqlTest1 scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/MysqlTest1 parameter nameurl/name valuejdbc:mysql://localhost:3306/tomcat-test1?autoReconnect=true,maxRecon nects=3/value /parameter parameter nameusername/name valuexx/value /parameter parameter namepassword/name valuexx/value /parameter parameter namemaxActive/name value100/value /parameter parameter namemaxWait/name value15000/value /parameter parameter namevalidationQuery/name valueSELECT version()/value /parameter parameter nametestOnBorrow/name valuetrue/value /parameter parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter parameter namemaxIdle/name value100/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter parameter nameremoveAbandonedTimeout/name value60/value /parameter parameter namelogAbandoned/name valuetrue/value /parameter /ResourceParams /web-app I'm sure this is something simple I am missing but the docs are not leading me in the right direction. Thanks for any help, CC - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Mysql JDBC Drivers: Use 2.x or 3.x?
I am starting to build an application using Tomcat 5.0x and am having problems getting the connection pool setup. Should I be using the 3.x or 2.x Mysql drivers? The 2 files I have downloaded are: mysql-connector-java-2.0.14.tar.gz mysql-connector-java-3.0.15-ga.tar.gz I am currently trying to get it working with the 3.x driver and have copied it into $CATALINA_HOME/common/lib. However, when I try my sample webapp out I get this following error in the logs/catalina.out file: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at chuck.DBTest1.init(DBTest1.java:20) at org.apache.jsp.test_jsp._jspService(test_jsp.java:50) snip Thanks for any help, rhugga - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Mysql JDBC Drivers: Use 2.x or 3.x?
we are using a combination of 3.0.8-stable and 3.0.14-production on our servers. The jar files are placed into the same folder you have placed yours. What connect string are you using? Bob On Monday 20 September 2004 05:48 pm, Chuck Carson wrote: I am starting to build an application using Tomcat 5.0x and am having problems getting the connection pool setup. Should I be using the 3.x or 2.x Mysql drivers? The 2 files I have downloaded are: mysql-connector-java-2.0.14.tar.gz mysql-connector-java-3.0.15-ga.tar.gz I am currently trying to get it working with the 3.x driver and have copied it into $CATALINA_HOME/common/lib. However, when I try my sample webapp out I get this following error in the logs/catalina.out file: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' at - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Mysql JDBC Drivers: Use 2.x or 3.x? (Kinda Long, sry)
--- Robert Bateman [EMAIL PROTECTED] wrote: we are using a combination of 3.0.8-stable and 3.0.14-production on our servers. The jar files are placed into the same folder you have placed yours. What connect string are you using? Bob I am basically just trying to setup a connection pool as in the documentaion. I am relatively new to java but have several years of C/C++. I am also a System Engineer during the day, but I am writing a network mangement app for my company and decided to go with tomcat/java. So I am a bit rusty on the nitty-gritty of the app server setup. First, here is my server.xml (sorry long) ?xml version='1.0' encoding='utf-8'? Server Listener className=org.apache.catalina.mbeans.ServerLifecycleListener/ Listener className=org.apache.catalina.mbeans.GlobalResourcesLifecycleListener/ GlobalNamingResources Environment name=simpleValue type=java.lang.Integer value=30/ Resource auth=Container description=User database that can be updated and saved name=UserDatabase type=org.apache.catalina.UserDatabase/ Resource name=jdbc/MysqlTest1 auth=Container type=javax.sql.DataSource/ ResourceParams name=UserDatabase parameter namefactory/name valueorg.apache.catalina.users.MemoryUserDatabaseFactory/value /parameter parameter namepathname/name valueconf/tomcat-users.xml/value /parameter /ResourceParams ResourceParams name=jdbc/MysqlTest1 parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namevalidationQuery/name valueSELECT * FROM TEST_USER/value /parameter parameter namemaxWait/name value5000/value /parameter parameter namemaxActive/name value4/value /parameter parameter namepassword/name valuec4milez/value /parameter parameter nameurl/name valuejdbc:mysql://localhost:3306/tomcat-test1?autoReconnect=true/value /parameter parameter namedriverClassName/name valueorg.gjt.mm.mysql.Driver/value /parameter parameter namemaxIdle/name value2/value /parameter parameter nameusername/name valuetomcat5/value /parameter /ResourceParams /GlobalNamingResources Service name=Catalina Connector acceptCount=100 connectionTimeout=2 disableUploadTimeout=true port=8080 redirectPort=8443 maxSpareThreads=75 maxThreads=150 minSpareThreads=25 /Connector Connector port=8009 protocol=AJP/1.3 protocolHandlerClassName=org.apache.jk.server.JkCoyoteHandler redirectPort=8443 /Connector Engine defaultHost=localhost name=Catalina Host appBase=webapps name=localhost Logger className=org.apache.catalina.logger.FileLogger prefix=localhost_log. suffix=.txt timestamp=true/ /Host Logger className=org.apache.catalina.logger.FileLogger prefix=catalina_log. suffix=.txt timestamp=true/ Realm className=org.apache.catalina.realm.UserDatabaseRealm/ /Engine /Service /Server And here is my webapps/testapp1/WEB-INF/web.xml file: ?xml version=1.0 encoding=ISO-8859-1? web-app descriptionTest App 1/description resource-ref descriptionDB Connection/description res-ref-namejdbc/MysqlTest1/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref /web-app I created the DataSource using the Admin app within Tomcat but then I noticed it did not add a factory line as in the docs, so I added this by hand and restarted tomcat: parameter namefactory/name valueorg.apache.catalina.users.MemoryUserDatabaseFactory/value /parameter Here is a simple class I am using to test with: package chuck; import javax.naming.*; import javax.sql.*; import java.sql.*; public class DBTest1 { String foo = Not Connected; int bar = -1; public void init() { try { Context ctx = new InitialContext(); if (ctx == null) throw new Exception(Error: No context.); DataSource ds = (DataSource) ctx.lookup(java:comp/env/jdbc/MysqlTest1); if (ds != null) { Connection conn = ds.getConnection(); if (conn != null) { foo = Database connection established: + conn.toString(); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(select * from TEST_USER); if (rs.next()) { foo = rs.getString(2); bar = rs.getInt(1);
Re: Mysql JDBC Drivers: Use 2.x or 3.x? (Kinda Long, sry)
Chuck, I think you need to move your connection pooling over to your context.xml at the web application level. Here is my pool definition from one of my apps: Resource name=jdbc/MySQL_Sequoia_Admin scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/MySQL_Sequoia_Admin !-- The JDBC connection url for connecting to your MySQL dB. The autoReconnect=true argument to the url makes sure that the mysql JDBC Driver will automatically reconnect if mysqld closed the connection. mysqld by default closes idle connections after 8 hours. -- parameter nameurl/name valuejdbc:mysql://localhost:3306/Sequoia_Admin?autoReconnect=true,maxReconnects=3/value /parameter !-- MySQL dB username and password for dB connections -- parameter nameusername/name valuex/value /parameter parameter namepassword/name value/value /parameter !-- Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit. -- parameter namemaxActive/name value100/value /parameter !-- Maximum time to wait for a dB connection to become available in ms, in this example 15 seconds. An Exception is thrown if this timeout is exceeded. Set to -1 to wait indefinitely. -- parameter namemaxWait/name value15000/value /parameter !-- Validation Query to insure our connection is still valid. -- parameter namevalidationQuery/name valueSELECT version()/value /parameter !-- Make sure we test each and every connection before we borrow it to see if it is still valid. -- parameter nametestOnBorrow/name valuetrue/value /parameter parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter !-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. -- parameter namemaxIdle/name value100/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter !--Use the removeAbandonedTimeout parameter / seconds.-- parameter nameremoveAbandonedTimeout/name value60/value /parameter parameter namelogAbandoned/name valuetrue/value /parameter /ResourceParams it may not be perfect, but it works on our end. Hope that helps! Bob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Mysql JDBC Drivers: Use 2.x or 3.x? (Kinda Long, sry)
--- Robert Bateman [EMAIL PROTECTED] wrote: Chuck, I think you need to move your connection pooling over to your context.xml at the web application level. Here is my pool definition from one of my apps: Resource name=jdbc/MySQL_Sequoia_Admin scope=Shareable type=javax.sql.DataSource/ ResourceParams name=jdbc/MySQL_Sequoia_Admin !-- The JDBC connection url for connecting to your MySQL dB. The autoReconnect=true argument to the url makes sure that the mysql JDBC Driver will automatically reconnect if mysqld closed the connection. mysqld by default closes idle connections after 8 hours. -- parameter nameurl/name valuejdbc:mysql://localhost:3306/Sequoia_Admin?autoReconnect=true,maxReconnects=3/value /parameter !-- MySQL dB username and password for dB connections -- parameter nameusername/name valuex/value /parameter parameter namepassword/name value/value /parameter !-- Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit. -- parameter namemaxActive/name value100/value /parameter !-- Maximum time to wait for a dB connection to become available in ms, in this example 15 seconds. An Exception is thrown if this timeout is exceeded. Set to -1 to wait indefinitely. -- parameter namemaxWait/name value15000/value /parameter !-- Validation Query to insure our connection is still valid. -- parameter namevalidationQuery/name valueSELECT version()/value /parameter !-- Make sure we test each and every connection before we borrow it to see if it is still valid. -- parameter nametestOnBorrow/name valuetrue/value /parameter parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter !-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. -- parameter namemaxIdle/name value100/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter !--Use the removeAbandonedTimeout parameter / seconds.-- parameter nameremoveAbandonedTimeout/name value60/value /parameter parameter namelogAbandoned/name valuetrue/value /parameter /ResourceParams it may not be perfect, but it works on our end. Hope that helps! Bob Thanks, I give that a shot... -rhugga = Chuck Carson - Sr. Systems Engineer Syrrx, Inc. - www.syrrx.com 10410 Science Center Drive San Diego, CA 92121 Work: 858.731.3540 Fax: 858.550.0526 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Using old JDBC drivers, Tomcat 5.0.25
I have an old JDBC driver for a Legacy Data Base that I'm attempting to access in Tomcat 5.0.25. When I attempt to call DriverManager.getConnection() on my legacy Data Base, I get the following log (some snipped to make it easier to read...) 2004-06-30 12:22:02 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception javax.servlet.jsp.JspTagException: Error: SQLException thrown by doStartTag_pre() in MtgCoXMLGenerTag Error while trying to connect to database, Exception message: access denied (java.lang.RuntimePermission accessClassInPackage.sun.reflect) at com.sequoiallc.sequoia_admin.pdox.MtgCoXMLGenerTag.doStartTag_pre(MtgCoXMLGenerTag.java:139) at com.sequoiallc.taglib.ExTagSupport2.doStartTag(ExTagSupport2.java:420) at org.apache.jsp.PlaceOrder_jsp._jspx_meth_px_2_MtgCoXMLGener_0(PlaceOrder_jsp.java:1630) at org.apache.jsp.PlaceOrder_jsp._jspService(PlaceOrder_jsp.java:237) In catalina.out I get the following: java.security.AccessControlException: access denied (java.lang.RuntimePermission setContextClassLoader) at java.security.AccessControlContext.checkPermission(AccessControlContext.java:270) at java.security.AccessController.checkPermission(AccessController.java:401) at java.lang.SecurityManager.checkPermission(SecurityManager.java:542) at java.lang.Thread.setContextClassLoader(Thread.java:1219) at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1623) at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1608) at java.lang.Thread.run(Thread.java:536) com.corel.pdx.driver.PdxJDBCSQLException: Error while trying to connect to database, Exception message: access denied (java.lang.RuntimePermission accessClassInPackage.sun.reflect) at com.corel.pdx.driver.PdxJDBCDriver.connect(PdxJDBCDriver.java:302) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:193) In my catalina.policy I have grant { permission java.lang.RuntimePermission accessClassInPackage.sun.reflect; permission java.lang.RuntimePermission accessClassInPackage.sun.reflect.*; permission java.lang.RuntimePermission setContextClassLoader; }; I don't see this specific set of circumstances in the bug data base and the above works in Tomcat 4.1.27. ANY help greatly appreciated! Bob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Using old JDBC drivers, Tomcat 5.0.25
Almost forgot to note, once I get the access error, I can no longer talk to Tomcat (it's looking for access to 127.0.0.1:35479) Bob On Wednesday 30 June 2004 12:32 pm, Robert Bateman wrote: I have an old JDBC driver for a Legacy Data Base that I'm attempting to access in Tomcat 5.0.25. When I attempt to call DriverManager.getConnection() on my legacy Data Base, I get the following log (some snipped to make it easier to read...) 2004-06-30 12:22:02 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception javax.servlet.jsp.JspTagException: Error: SQLException thrown by doStartTag_pre() in MtgCoXMLGenerTag Error while trying to connect to database, Exception message: access denied (java.lang.RuntimePermission accessClassInPackage.sun.reflect) at com.sequoiallc.sequoia_admin.pdox.MtgCoXMLGenerTag.doStartTag_pre(MtgCoXMLG enerTag.java:139) at com.sequoiallc.taglib.ExTagSupport2.doStartTag(ExTagSupport2.java:420) at org.apache.jsp.PlaceOrder_jsp._jspx_meth_px_2_MtgCoXMLGener_0(PlaceOrder_js p.java:1630) at org.apache.jsp.PlaceOrder_jsp._jspService(PlaceOrder_jsp.java:237) In catalina.out I get the following: java.security.AccessControlException: access denied (java.lang.RuntimePermission setContextClassLoader) at java.security.AccessControlContext.checkPermission(AccessControlContext.jav a:270) at java.security.AccessController.checkPermission(AccessController.java:401) at java.lang.SecurityManager.checkPermission(SecurityManager.java:542) at java.lang.Thread.setContextClassLoader(Thread.java:1219) at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.process Children(ContainerBase.java:1623) at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(Con tainerBase.java:1608) at java.lang.Thread.run(Thread.java:536) com.corel.pdx.driver.PdxJDBCSQLException: Error while trying to connect to database, Exception message: access denied (java.lang.RuntimePermission accessClassInPackage.sun.reflect) at com.corel.pdx.driver.PdxJDBCDriver.connect(PdxJDBCDriver.java:302) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:193) In my catalina.policy I have grant { permission java.lang.RuntimePermission accessClassInPackage.sun.reflect; permission java.lang.RuntimePermission accessClassInPackage.sun.reflect.*; permission java.lang.RuntimePermission setContextClassLoader; }; I don't see this specific set of circumstances in the bug data base and the above works in Tomcat 4.1.27. ANY help greatly appreciated! Bob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: comparison of Type 4 JDBC drivers
Thanks Yoav for the suggestion! Can anyone point me to a comparison of Type 4 JDBC drivers supporting MS SQL Server and DB2 for the windows and IBM mainframe (Z_OS) linux platforms? thanks...gary... -Original Message- From: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 6:02 AM To: Tomcat Users List Subject: RE: Tomcat 4.1.12LE Disappears Hi, Any and all suggestions will be welcome? ;) OK. Drop the JdbcOdbc bridge so fast you do it even before the end of this sentence. Use a thin/type4 JDBC driver for your database. What's happening is that your JdbcOdbc bridge driver is crashing with a native-level (i.e. some DLL on Windoze) error. That's crashing the JVM internally, hence the hs_err_pid logs. (HS stands for HotSpot). After tomcat crashes the ISAPI connector can't connect to it, hence the jk errors in your log: these will go away if you fix your tomcat. Yoav Shapira Millennium Research Informatics -Original Message- From: Gary Fix [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 4:40 PM To: Tomcat Users List Subject: Tomcat 4.1.12LE Disappears Hi, We are running Tomcat 4.1.12LE under Win2000 SP2 within a command window. We use j2sdk1.4.1_02 for our servlet code. We also use the isapi_redirect.dll dated 11/8/2002. About the time we upgraded from version 3 of Tomcat to version 4, we strated having problems of Tomcat disappearing with no apparent error messages. In the last 8 days, it has disappeared 8 times. I have searched for a solution with no luck. The only error messages I could find are in the isapi_redirect.log and some files named hs_err_pid1208.log showing up in the Tomcat \bin folder. The isapi_redirect.log error messages look like this: [Mon Mar 15 16:19:39 2004] [jk_isapi_plugin.c (724)]: HttpExtensionProc error, service() failed [Mon Mar 15 16:19:40 2004] [jk_connect.c (143)]: jk_open_socket, connect() failed errno = 61 [Mon Mar 15 16:19:40 2004] [jk_ajp13_worker.c (196)]: In jk_endpoint_t::connect_to_tomcat, failed errno = 61 [Mon Mar 15 16:19:40 2004] [jk_ajp13_worker.c (635)]: Error connecting to the Tomcat process. [Mon Mar 15 16:19:40 2004] [jk_ajp13_worker.c (848)]: In jk_endpoint_t::service, send_request failed in send loop 1 [Mon Mar 15 16:19:41 2004] [jk_connect.c (143)]: jk_open_socket, connect() failed errno = 61 [Mon Mar 15 16:19:41 2004] [jk_ajp13_worker.c (196)]: In jk_endpoint_t::connect_to_tomcat, failed errno = 61 [Mon Mar 15 16:19:41 2004] [jk_ajp13_worker.c (635)]: Error connecting to the Tomcat process. [Mon Mar 15 16:19:41 2004] [jk_ajp13_worker.c (848)]: In jk_endpoint_t::service, send_request failed in send loop 0 [Mon Mar 15 16:19:41 2004] [jk_connect.c (143)]: jk_open_socket, connect() failed errno = 61 [Mon Mar 15 16:19:41 2004] [jk_ajp13_worker.c (196)]: In jk_endpoint_t::connect_to_tomcat, failed errno = 61 [Mon Mar 15 16:19:41 2004] [jk_ajp13_worker.c (635)]: Error connecting to the Tomcat process. [Mon Mar 15 16:19:41 2004] [jk_ajp13_worker.c (848)]: In jk_endpoint_t::service, send_request failed in send loop 2 [Mon Mar 15 16:19:41 2004] [jk_isapi_plugin.c (724)]: HttpExtensionProc error, service() failed Notice these seem to be loggin about once each second. We also some some console messages like this: 361031 [Thread-8] WARN common.ChannelSocket - server has closed the current con nection (-1) The hs_err_pid1208.log files have errors like this: An unexpected exception has been detected in native code outside the VM. Unexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC=0x77FCB8F4 Function=RtlFreeHeap+0x263 Library=C:\WINNT\System32\ntdll.dll Current Java thread: at sun.jdbc.odbc.JdbcOdbc.freeConnect(Native Method) at sun.jdbc.odbc.JdbcOdbc.SQLFreeConnect(JdbcOdbc.java:3287) at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:952) at sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:740) at sun.jdbc.odbc.JdbcOdbcConnection.finalize(JdbcOdbcConnection.java:87) at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83) at java.lang.ref.Finalizer.access$100(Finalizer.java:14) at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160) Dynamic libraries: followed by a bunch of DLLs. Any and all suggestions would be greatly appreciated. thanks...gary... - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail
mssqlserver jdbc drivers - memory leaks
This is more of an informative e-mail than a problem. I was using the mssqlserver jdbc drivers on both Solaris and Linux platforms. The web application is using lots of @@Identity and inserts into the database. There was an instance to test some stuff that I was attempting lots of inserts ( more than 10,000 ). When attempting to do some logging I got a (Too may open files) exception. Well I changed out the mssqlserver jdbc to an existing JTurbo jdbc license we had and the problem went away. So needless to say there are memory leaks in the microsoft jdbc drivers. I was pulling my hair out over this and I was hoping to spare anybody anguish if possible. Stephen Jackson - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
JDBC Drivers Exception ...
Hi: I am using Apache 1.3.26 + JBoss + Tomcat on my Web/APP Server and Oracle 9.1 on DB Server. I installed JDBC Drivers ojdbc14.jar, classes12.jar, nls_charset111.jar on my APPLICATION Server and SET the CLASSPATH accordingly. What all need to be done as far as this is concerned? When I run my Simple Web Applicatin which Access my DB Server: I get Exception at following Line: -- try { Class.forName(oracle.jdbc.OracleDriver); con = DriverManager.getConnection(url,user,pass); stmt = con.createStatement(); } catch (Exception e) { System.out.println(Exceptino raised at Clas.forname.); } -- Can anyone TELL what is this error about? Also, my APP SERVER has just moved to JDK1.4 whereas my DB Server still has JDK 1.3. Do you think this is an issues? Thanks! _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: JDBC Drivers Exception ...
Howdy, A few things. I installed JDBC Drivers ojdbc14.jar, classes12.jar, nls_charset111.jar on Why both ojdbc14.jar and classes12.jar? If you're connecting to an Oracle 9.1 database, you don't want classes12.jar in there. These two jars have some overlapping classnames which will cause problems. my APPLICATION Server and SET the CLASSPATH accordingly. Tomcat ignores the CLASSPATH environment variable. You need to make sure the JDBC driver distribution is in the proper place. Usually, this is inside the /WEB-INF/lib directory of your web application OR the common/lib (or equivalent) directory on the server. When I run my Simple Web Applicatin which Access my DB Server: I get Exception at following Line: --- --- try { Class.forName(oracle.jdbc.OracleDriver); con = DriverManager.getConnection(url,user,pass); stmt = con.createStatement(); } catch (Exception e) { System.out.println(Exceptino raised at Clas.forname.); } --- --- Which line generates the exception? All three lines above, not to mention you ..., can generate exceptions. Break up the code into multiple try-catch blocks. Also, what is the exception? You didn't give details. Please give the full stack trace and message for the exception. In addition, I thought the Oracle docs said to use oracle.jdbc.driver.OracleDriver to load the driver, not the shorter oracle.jdbc.OracleDriver. Check the Oracle JDBC driver docs on that. Also, my APP SERVER has just moved to JDK1.4 whereas my DB Server still has JDK 1.3. Do you think this is an issues? Probably not an issue. But then again, I haven't even seen your stack trace yet. Yoav Shapira Millennium ChemInformatics This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: JDBC Drivers Exception ...
Should be using nls_charset12.jar, if you're using classes12.jar. If you're to use the version 12 drivers, then you ought to include ocrs12.jar as well. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Shapira, Yoav [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 12:18 PM To: Tomcat Users List Subject: RE: JDBC Drivers Exception ... Howdy, A few things. I installed JDBC Drivers ojdbc14.jar, classes12.jar, nls_charset111.jar on Why both ojdbc14.jar and classes12.jar? If you're connecting to an Oracle 9.1 database, you don't want classes12.jar in there. These two jars have some overlapping classnames which will cause problems. my APPLICATION Server and SET the CLASSPATH accordingly. Tomcat ignores the CLASSPATH environment variable. You need to make sure the JDBC driver distribution is in the proper place. Usually, this is inside the /WEB-INF/lib directory of your web application OR the common/lib (or equivalent) directory on the server. When I run my Simple Web Applicatin which Access my DB Server: I get Exception at following Line: --- --- try { Class.forName(oracle.jdbc.OracleDriver); con = DriverManager.getConnection(url,user,pass); stmt = con.createStatement(); } catch (Exception e) {System.out.println(Exceptino raised at Clas.forname.); } --- --- Which line generates the exception? All three lines above, not to mention you ..., can generate exceptions. Break up the code into multiple try-catch blocks. Also, what is the exception? You didn't give details. Please give the full stack trace and message for the exception. In addition, I thought the Oracle docs said to use oracle.jdbc.driver.OracleDriver to load the driver, not the shorter oracle.jdbc.OracleDriver. Check the Oracle JDBC driver docs on that. Also, my APP SERVER has just moved to JDK1.4 whereas my DB Server still has JDK 1.3. Do you think this is an issues? Probably not an issue. But then again, I haven't even seen your stack trace yet. Yoav Shapira Millennium ChemInformatics This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: JDBC Drivers Exception ...
Hi Shapira Yoav, The Stack Trace Shows: [STDOUT] java.sql.SQLException: IO Exception: The Network Adapter could not establish the connection Any hints for this trace??? Thanks! From: Shapira, Yoav [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Subject: RE: JDBC Drivers Exception ... Date: Wed, 19 Feb 2003 15:17:48 -0500 Howdy, A few things. I installed JDBC Drivers ojdbc14.jar, classes12.jar, nls_charset111.jar on Why both ojdbc14.jar and classes12.jar? If you're connecting to an Oracle 9.1 database, you don't want classes12.jar in there. These two jars have some overlapping classnames which will cause problems. my APPLICATION Server and SET the CLASSPATH accordingly. Tomcat ignores the CLASSPATH environment variable. You need to make sure the JDBC driver distribution is in the proper place. Usually, this is inside the /WEB-INF/lib directory of your web application OR the common/lib (or equivalent) directory on the server. When I run my Simple Web Applicatin which Access my DB Server: I get Exception at following Line: --- --- try { Class.forName(oracle.jdbc.OracleDriver); con = DriverManager.getConnection(url,user,pass); stmt = con.createStatement(); } catch (Exception e) { System.out.println(Exceptino raised at Clas.forname.); } --- --- Which line generates the exception? All three lines above, not to mention you ..., can generate exceptions. Break up the code into multiple try-catch blocks. Also, what is the exception? You didn't give details. Please give the full stack trace and message for the exception. In addition, I thought the Oracle docs said to use oracle.jdbc.driver.OracleDriver to load the driver, not the shorter oracle.jdbc.OracleDriver. Check the Oracle JDBC driver docs on that. Also, my APP SERVER has just moved to JDK1.4 whereas my DB Server still has JDK 1.3. Do you think this is an issues? Probably not an issue. But then again, I haven't even seen your stack trace yet. Yoav Shapira Millennium ChemInformatics _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: using DataSource with Microsoft's JDBC drivers
Excellent. This worked for me. Thanks! Several of the parameters were different than expected, and I think it was the driverName parameter that was the key. I recommend that this set-up example get added to http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html, to thus provide an example for MS SQLServer access. Thanks again, Kevin Lacobie Pierre-Laurent Ribault wrote: - It was not straightforward here either, but we finally found a working configuration, using a usenet post by a MS guy as the base for our experiments (Look for the thread Steps for Setting up DataSource in Tomcat4.0 Using SQLServerDataSource in the microsoft.public.sqlserver.jdbcdriver group on Google) Here is the server.xml chunk that is working for us: Context path=/myapp_sqlserver docBase=myapp_sqlserver debug=0 reloadable=true Resource name=jdbc/SQLserverDB auth=Container type=com.microsoft.jdbcx.sqlserver.SQLServerDataSource / ResourceParams name=jdbc/SQLserverDB parameter namefactory/name valuecom.microsoft.jdbcx.sqlserver.SQLServerDataSourceFactory/value /parameter parameter namedriverClassName/name valuecom.microsoft.jdbcx.sqlserver.SQLServerDataSource/value /parameter parameter namedriverName/name valueSQLServer/value /parameter parameter namedescription/name valueSQL Server DataSource/value /parameter parameter nameserverName/name valuemyserver/value /parameter parameter nameportNumber/name value1433/value /parameter parameter nameuser/name valuemyuser/value /parameter parameter namepassword/name valuemypassword/value /parameter /ResourceParams /Context -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
using DataSource with Microsoft's JDBC drivers
I've anyone's successfully configured Tomcat to use Microsoft's JDBC driver package (i.e., com.microsoft.jdbcx.sqlserver) as a Tomcat Resource, for creating connections via DataSource, I'd love to hear from you. I've gotten their driver to work via the DriverManager path, but via a DataSource am having no luck.Intead of repeating all what I've tried, I'd just like to know if anyone's got the driver to work well with Tomcat, and a bit about their environment. Best, Kevin Lacobie -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: using DataSource with Microsoft's JDBC drivers
Hello, It was not straightforward here either, but we finally found a working configuration, using a usenet post by a MS guy as the base for our experiments (Look for the thread Steps for Setting up DataSource in Tomcat4.0 Using SQLServerDataSource in the microsoft.public.sqlserver.jdbcdriver group on Google) Here is the server.xml chunk that is working for us: Context path=/myapp_sqlserver docBase=myapp_sqlserver debug=0 reloadable=true Resource name=jdbc/SQLserverDB auth=Container type=com.microsoft.jdbcx.sqlserver.SQLServerDataSource / ResourceParams name=jdbc/SQLserverDB parameter namefactory/name valuecom.microsoft.jdbcx.sqlserver.SQLServerDataSourceFactory/value /parameter parameter namedriverClassName/name valuecom.microsoft.jdbcx.sqlserver.SQLServerDataSource/value /parameter !-- parameter namedriverName/name valuejdbc:microsoft:sqlserver://myserver:1433/value /parameter -- parameter namedriverName/name valueSQLServer/value /parameter parameter namedescription/name valueSQL Server DataSource/value /parameter parameter nameserverName/name valuemyserver/value /parameter parameter nameportNumber/name value1433/value /parameter parameter nameuser/name valuemyuser/value /parameter parameter namepassword/name valuemypassword/value /parameter /ResourceParams /Context The environment is : Tomcat 4.0 Windows 2000 pro SQL Server 2000 JDBC drivers from the MS site Good Luck Pierre-Laurent Kevin J. Lacobie wrote: I've anyone's successfully configured Tomcat to use Microsoft's JDBC driver package (i.e., com.microsoft.jdbcx.sqlserver) as a Tomcat Resource, for creating connections via DataSource, I'd love to hear from you. I've gotten their driver to work via the DriverManager path, but via a DataSource am having no luck.Intead of repeating all what I've tried, I'd just like to know if anyone's got the driver to work well with Tomcat, and a bit about their environment. Best, Kevin Lacobie -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- Pierre-Laurent Ribault Fujitsu Info Software Technologies Ltd. [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Oracle JDBC Drivers on Tomcat
Zip and Jar are the same format. Simply rename .zip to .jar and use it. Tomcat ignores .zip. -Mensaje original- De: hari hari [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 25 de septiembre de 2002 0:13 Para: [EMAIL PROTECTED] Asunto: Re: Oracle JDBC Drivers on Tomcat hi there, thanks for replying. Do we need ZIP version or JAR version of JDBC Drivers on Tomcat...? thks. --HARI From: [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Subject: Re: Oracle JDBC Drivers on Tomcat Date: Tue, 24 Sep 2002 16:41:56 +1000 No don't bother, its fine. I use Ora9i and the rest of the stuff, didn't unzip. (In case u have download something : U can't use a tar ball though !) Tam, Michael wrote: It works fine for me as in .zip extension. Cheers, Michael -Original Message- From: hari hari [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 1:25 PM To: [EMAIL PROTECTED] Subject: Oracle JDBC Drivers on Tomcat hi every1, i using java servlets to connect to my Oracle db. I get the jdbc-drivers and installed into app server and included in my classpath. these drivers are in zip format - do I need to extract them or will they do fine just with zip? --HARI _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- 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: Oracle JDBC Drivers on Tomcat
Jar version. And driver jar must be copied in the TOMCAT_HOME/common/lib so that it can be shared between your web applications and tomcat internal classes. Raj
RE: Oracle JDBC Drivers on Tomcat
You need to rename the zip file to jar file. Servlets specification (so tomcat too) only accept .jar. Regards -Mensaje original- De: Tam, Michael [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 25 de septiembre de 2002 1:10 Para: 'Tomcat Users List' Asunto: RE: Oracle JDBC Drivers on Tomcat Oracle JDBC driver comes as ZIP and so you leave it as it is. Cheers, Michael -Original Message- From: hari hari [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 3:13 PM To: [EMAIL PROTECTED] Subject: Re: Oracle JDBC Drivers on Tomcat hi there, thanks for replying. Do we need ZIP version or JAR version of JDBC Drivers on Tomcat...? thks. --HARI From: [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Subject: Re: Oracle JDBC Drivers on Tomcat Date: Tue, 24 Sep 2002 16:41:56 +1000 No don't bother, its fine. I use Ora9i and the rest of the stuff, didn't unzip. (In case u have download something : U can't use a tar ball though !) Tam, Michael wrote: It works fine for me as in .zip extension. Cheers, Michael -Original Message- From: hari hari [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 1:25 PM To: [EMAIL PROTECTED] Subject: Oracle JDBC Drivers on Tomcat hi every1, i using java servlets to connect to my Oracle db. I get the jdbc-drivers and installed into app server and included in my classpath. these drivers are in zip format - do I need to extract them or will they do fine just with zip? --HARI _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- 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]
Oracle JDBC Drivers on Tomcat
hi every1, i using java servlets to connect to my Oracle db. I get the jdbc-drivers and installed into app server and included in my classpath. these drivers are in zip format - do I need to extract them or will they do fine just with zip? --HARI _ Join the worldÂ’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Oracle JDBC Drivers on Tomcat
It works fine for me as in .zip extension. Cheers, Michael -Original Message- From: hari hari [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 1:25 PM To: [EMAIL PROTECTED] Subject: Oracle JDBC Drivers on Tomcat hi every1, i using java servlets to connect to my Oracle db. I get the jdbc-drivers and installed into app server and included in my classpath. these drivers are in zip format - do I need to extract them or will they do fine just with zip? --HARI _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- 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: Oracle JDBC Drivers on Tomcat
No don't bother, its fine. I use Ora9i and the rest of the stuff, didn't unzip. (In case u have download something : U can't use a tar ball though !) Tam, Michael wrote: It works fine for me as in .zip extension. Cheers, Michael -Original Message- From: hari hari [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 1:25 PM To: [EMAIL PROTECTED] Subject: Oracle JDBC Drivers on Tomcat hi every1, i using java servlets to connect to my Oracle db. I get the jdbc-drivers and installed into app server and included in my classpath. these drivers are in zip format - do I need to extract them or will they do fine just with zip? --HARI _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- 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: Oracle JDBC Drivers on Tomcat
hi there, thanks for replying. Do we need ZIP version or JAR version of JDBC Drivers on Tomcat...? thks. --HARI From: [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Subject: Re: Oracle JDBC Drivers on Tomcat Date: Tue, 24 Sep 2002 16:41:56 +1000 No don't bother, its fine. I use Ora9i and the rest of the stuff, didn't unzip. (In case u have download something : U can't use a tar ball though !) Tam, Michael wrote: It works fine for me as in .zip extension. Cheers, Michael -Original Message- From: hari hari [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 1:25 PM To: [EMAIL PROTECTED] Subject: Oracle JDBC Drivers on Tomcat hi every1, i using java servlets to connect to my Oracle db. I get the jdbc-drivers and installed into app server and included in my classpath. these drivers are in zip format - do I need to extract them or will they do fine just with zip? --HARI _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Oracle JDBC Drivers on Tomcat
Oracle JDBC driver comes as ZIP and so you leave it as it is. Cheers, Michael -Original Message- From: hari hari [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 3:13 PM To: [EMAIL PROTECTED] Subject: Re: Oracle JDBC Drivers on Tomcat hi there, thanks for replying. Do we need ZIP version or JAR version of JDBC Drivers on Tomcat...? thks. --HARI From: [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Subject: Re: Oracle JDBC Drivers on Tomcat Date: Tue, 24 Sep 2002 16:41:56 +1000 No don't bother, its fine. I use Ora9i and the rest of the stuff, didn't unzip. (In case u have download something : U can't use a tar ball though !) Tam, Michael wrote: It works fine for me as in .zip extension. Cheers, Michael -Original Message- From: hari hari [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 1:25 PM To: [EMAIL PROTECTED] Subject: Oracle JDBC Drivers on Tomcat hi every1, i using java servlets to connect to my Oracle db. I get the jdbc-drivers and installed into app server and included in my classpath. these drivers are in zip format - do I need to extract them or will they do fine just with zip? --HARI _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- 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: Oracle JDBC Drivers on Tomcat
jar files are the .zip format. So, grab the .zip file and rename it to .jar, then put it in common/lib and you are good to go. Jake At 10:13 PM 9/24/2002 +, you wrote: hi there, thanks for replying. Do we need ZIP version or JAR version of JDBC Drivers on Tomcat...? thks. --HARI From: [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Subject: Re: Oracle JDBC Drivers on Tomcat Date: Tue, 24 Sep 2002 16:41:56 +1000 No don't bother, its fine. I use Ora9i and the rest of the stuff, didn't unzip. (In case u have download something : U can't use a tar ball though !) Tam, Michael wrote: It works fine for me as in .zip extension. Cheers, Michael -Original Message- From: hari hari [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 1:25 PM To: [EMAIL PROTECTED] Subject: Oracle JDBC Drivers on Tomcat hi every1, i using java servlets to connect to my Oracle db. I get the jdbc-drivers and installed into app server and included in my classpath. these drivers are in zip format - do I need to extract them or will they do fine just with zip? --HARI _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Classloaders, JDBC drivers (etc.), and reloading webapps with the /manager
Hello, If I include a JAR file for a JDBC driver within my webapp's /WEB-INF/lib path, calling Class.forName(some.driver) registers the driver with the java.sql DriverManager. No problem... until I reload the context using the /manager webapp. Is the class definition (and in particular, the driver instance) still valid, given that the classloader used for the driver (and all classes loaded by it, including the driver) will have been reloaded ? Thanks, Chris B. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Classloaders, JDBC drivers (etc.), and reloading webapps with the /manager
if your driver is a pure java driver(type 4, I think) then you would be ok. If your driver uses native libraries for its java implementation, then you will have a problem. you want to put the jar in your /common/lib so that it is is loaded once and shared for all contexts that need it. This way a reload will not affect it. Charlie -Original Message- From: Chris Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 3:57 AM To: tomcat-user Subject: Classloaders, JDBC drivers (etc.), and reloading webapps with the /manager Hello, If I include a JAR file for a JDBC driver within my webapp's /WEB-INF/lib path, calling Class.forName(some.driver) registers the driver with the java.sql DriverManager. No problem... until I reload the context using the /manager webapp. Is the class definition (and in particular, the driver instance) still valid, given that the classloader used for the driver (and all classes loaded by it, including the driver) will have been reloaded ? Thanks, Chris B. -- 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]
JDBC Drivers
Hi guys and gals, Could someone give me advice on the best (and free if possible) sql server drivers to use in my tomcat servlets? The sql server I have available is a MySql server or a MS SQL Server should I need it. Thanks, SS -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: JDBC Drivers
Best is relative. MS SQL Server 2000 Type 4 JDBC Driver is here: http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?ur l=/MSDN-FILES/027/001/779/msdncompositedoc.xml Note: it doesn't work with SQL Server 6.5. John Turner [EMAIL PROTECTED] -Original Message- From: Stuart Stephen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 11:52 AM To: [EMAIL PROTECTED] Subject: JDBC Drivers Hi guys and gals, Could someone give me advice on the best (and free if possible) sql server drivers to use in my tomcat servlets? The sql server I have available is a MySql server or a MS SQL Server should I need it. Thanks, SS -- 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 Drivers
http://mmmysql.sourceforge.net/ -Original Message- From: Stuart Stephen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 10:52 AM To: [EMAIL PROTECTED] Subject: JDBC Drivers Hi guys and gals, Could someone give me advice on the best (and free if possible) sql server drivers to use in my tomcat servlets? The sql server I have available is a MySql server or a MS SQL Server should I need it. Thanks, SS -- 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: Oracle JDBC Drivers not fully working
It is still true. Did you find another drivers to replace them??? Thanx Arno. -Message d'origine- De: Power-Netz (Schwarz) [SMTP:[EMAIL PROTECTED]] Date: mardi 4 juin 2002 10:29 A: tomcat liste Objet: Oracle JDBC Drivers not fully working Hi, last time i tried oracle, i found that serveral extremly nice functions about traversing a resultset, are not implemented in the oracle drivers. They just throw SQL-exceptions. Be prepared for it :-) POWER-NETZ? Full-Service-Provider Online-Support: Support: 0190 - 15 11 15 (EUR 0,62/Min) http://Support.Power-Netz.de (kostenlos) http://Support.Power-Netz.com (kostenlos) Vertrieb Tel: 01805 - 57 35 57 (EUR 0,12/Min.) Vertrieb Fax: 01805 - 57 45 57 (EUR 0,12/Min.) Power-Netz Am Plan 1 37581 Bad Gandersheim http://www.Power-Netz.de mailto:[EMAIL PROTECTED] +=+ --I N F O C E N T E R-- + Senden Sie eine leere e-mail an: + Providerwechsel: mailto:[EMAIL PROTECTED] + Daten/Preise Webspace: mailto:[EMAIL PROTECTED] + Reseller-Programm: mailto:[EMAIL PROTECTED] + Dedizierte Server: mailto:[EMAIL PROTECTED] + Adult/Erotikserver: mailto:[EMAIL PROTECTED] + Domainpreise: mailto:[EMAIL PROTECTED] + Domain-Nameserver: mailto:[EMAIL PROTECTED] + SSL-Zertifikate: mailto:[EMAIL PROTECTED] + Geschaeftsbedingungen: 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]
AW: Oracle JDBC Drivers not fully working
It is still true. Did you find another drivers to replace them??? No. I had to work around it. But I didn't searched the whole internet for it ;) M.Schwarz -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Oracle JDBC Drivers not fully working
Hi, last time i tried oracle, i found that serveral extremly nice functions about traversing a resultset, are not implemented in the oracle drivers. They just throw SQL-exceptions. Be prepared for it :-) POWER-NETZ® Full-Service-Provider Online-Support: Support: 0190 - 15 11 15 (EUR 0,62/Min) http://Support.Power-Netz.de (kostenlos) http://Support.Power-Netz.com (kostenlos) Vertrieb Tel: 01805 - 57 35 57 (EUR 0,12/Min.) Vertrieb Fax: 01805 - 57 45 57 (EUR 0,12/Min.) Power-Netz Am Plan 1 37581 Bad Gandersheim http://www.Power-Netz.de mailto:[EMAIL PROTECTED] +=+ --I N F O C E N T E R-- + Senden Sie eine leere e-mail an: + Providerwechsel: mailto:[EMAIL PROTECTED] + Daten/Preise Webspace: mailto:[EMAIL PROTECTED] + Reseller-Programm: mailto:[EMAIL PROTECTED] + Dedizierte Server: mailto:[EMAIL PROTECTED] + Adult/Erotikserver: mailto:[EMAIL PROTECTED] + Domainpreise: mailto:[EMAIL PROTECTED] + Domain-Nameserver: mailto:[EMAIL PROTECTED] + SSL-Zertifikate: mailto:[EMAIL PROTECTED] + Geschaeftsbedingungen: mailto:[EMAIL PROTECTED] + =+ -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
JDBC Drivers
I don't know if I should post this here or not but here goes I am trying to connect to an oracle DB using a thin connection. I have downloaded the classes12.zip file and put it in $TOMCAT_HOME/common/lib but I am getting a java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver Do I need to put the class file elsewhere? The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you received this communication in error, please notify us immediately by responding to this email and then delete it from your system. Appleyard Finance Holdings Ltd or its subsidiaries are neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Drivers
rename the zip to .jar -Original Message- From: Richard Johnstone [mailto:[EMAIL PROTECTED]] Sent: 16. aprÃl 2002 09:34 To: [EMAIL PROTECTED] Subject: JDBC Drivers I don't know if I should post this here or not but here goes I am trying to connect to an oracle DB using a thin connection. I have downloaded the classes12.zip file and put it in $TOMCAT_HOME/common/lib but I am getting a java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver Do I need to put the class file elsewhere? -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Drivers
I suppose you have to change the name of 'classes12.zip' file to 'classes12.jar'. Teemu Keiski -Original Message- From: Richard Johnstone [mailto:[EMAIL PROTECTED]] Sent: 16. huhtikuuta 2002 12:34 To: [EMAIL PROTECTED] Subject: JDBC Drivers I don't know if I should post this here or not but here goes I am trying to connect to an oracle DB using a thin connection. I have downloaded the classes12.zip file and put it in $TOMCAT_HOME/common/lib but I am getting a java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver Do I need to put the class file elsewhere? -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Drivers
You need to set your classpath up to the file, not just the directory. It is a bit picky. eg, set classpath=%classpath%;c:\javastuff\oracle\classes12.jar That should then work. Stuart Stephen -Original Message- From: Teemu Keiski [mailto:[EMAIL PROTECTED]] Sent: 16 April 2002 10:38 To: Tomcat Users List Subject: RE: JDBC Drivers I suppose you have to change the name of 'classes12.zip' file to 'classes12.jar'. Teemu Keiski -Original Message- From: Richard Johnstone [mailto:[EMAIL PROTECTED]] Sent: 16. huhtikuuta 2002 12:34 To: [EMAIL PROTECTED] Subject: JDBC Drivers I don't know if I should post this here or not but here goes I am trying to connect to an oracle DB using a thin connection. I have downloaded the classes12.zip file and put it in $TOMCAT_HOME/common/lib but I am getting a java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver Do I need to put the class file elsewhere? -- 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: JDBC Drivers
Thats fixed it. Cheers Matey [EMAIL PROTECTED] 04/16/02 10:27am rename the zip to .jar -Original Message- From: Richard Johnstone [mailto:[EMAIL PROTECTED]] Sent: 16. aprÃl 2002 09:34 To: [EMAIL PROTECTED] Subject: JDBC Drivers I don't know if I should post this here or not but here goes I am trying to connect to an oracle DB using a thin connection. I have downloaded the classes12.zip file and put it in $TOMCAT_HOME/common/lib but I am getting a java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver Do I need to put the class file elsewhere? -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:tReceived: from APC_DOM-MTA by AVCMAIL.appleyard-contracts.co.uk [EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you received this communication in error, please notify us immediately by responding to this email and then delete it from your system. Appleyard Finance Holdings Ltd or its subsidiaries are neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
JDBC drivers
All, The JDBC drivers provided by Oracle are zipped but as I understand it, only jar files are recognised. Is this correct? If so, I guess I'll have to unzip and then jar? I'm using TC 4 on Solaris 8. Thanks, John Quote for the week: The men with the muck-rakes are often indispensable to the well-being of society; but only if they know when to stop raking the muck. Theodore Roosevelt, Speech in New York, 11 Nov. 1902 -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC drivers
JAR = Zip + restrictions on the structure. It turns out that Oracle was kind enough to include the correct structure so all you need to do is rename the .zip to .jar. Randy -Original Message- From: John Wadkin [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 8:35 AM To: Tomcat Users List (E-mail) Subject: JDBC drivers All, The JDBC drivers provided by Oracle are zipped but as I understand it, only jar files are recognised. Is this correct? If so, I guess I'll have to unzip and then jar? I'm using TC 4 on Solaris 8. Thanks, John Quote for the week: The men with the muck-rakes are often indispensable to the well-being of society; but only if they know when to stop raking the muck. Theodore Roosevelt, Speech in New York, 11 Nov. 1902 -- 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: JDBC drivers
just rename the file, you don't have unzip and rejar it (a jar is a zip file..) Mvgr Martin -Original Message- From: John Wadkin [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 14:35 To: Tomcat Users List (E-mail) Subject: JDBC drivers All, The JDBC drivers provided by Oracle are zipped but as I understand it, only jar files are recognised. Is this correct? If so, I guess I'll have to unzip and then jar? I'm using TC 4 on Solaris 8. Thanks, John Quote for the week: The men with the muck-rakes are often indispensable to the well-being of society; but only if they know when to stop raking the muck. Theodore Roosevelt, Speech in New York, 11 Nov. 1902 -- 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]
Where to place JDBC drivers? How?
I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Where to place JDBC drivers? How?
You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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: Where to place JDBC drivers? How?
I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Where to place JDBC drivers? How?
There are variations between versions of Tomcat on how things work. For instance, Tomcat 3.2 recognized things in the classpath whereas Tomcat 3.3 doesn't. 3.3 has directories in its installation where jars can be added globally. I don't know how 4.x handles it. To be safe, I think WEB-INF/lib is the recommended and most universal place to put jar files for your web application. Best Regards, Jason Koeninger JJ Computer Consulting http://www.jjcc.com On Wed, 28 Nov 2001 11:08:35 -0700, Mike Kelley wrote: I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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] -- 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: Where to place JDBC drivers? How?
It needs to be in the Classpath variable so that the jar file can be found. You can add it to the WEB-INF folder but then you will have to put a copy of the driver in the WEB-INF folder of every application that should be able to access the database. As for the other files it depends whether you're running Tomcat as a service under NT or not etc. There is a classpath variable that is passed to java in each of these files. The files are simple to edit, just open them up and have a look. -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:09 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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] -- 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: Where to place JDBC drivers? How?
Yeah, I'm not afraid of editing the files, as you said that easy enough, yours was the first to suggest editing those files though ... The drivers came with some JSP HTML pages that are supposed to scces the as400 db, with all of these files though there was no WEB-INF file Would simply creating a WEB-INF file and placing said drivers in the folder be enough? Or do the jar/driver files just need to be in the WEB-INF in the webapps branch? (where I unpacked all the sample files from the jdbc provider)? Just for Info I'm running win2k sp2, apache 1.3.22, TC4.0, jdk1.3.1_01 The applications (apache tomact and apache) are listed as services under the windows services manager, I currently have them set as manual services so I can control the start up order and have easy access to starting/stopping/restarting -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:19 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? It needs to be in the Classpath variable so that the jar file can be found. You can add it to the WEB-INF folder but then you will have to put a copy of the driver in the WEB-INF folder of every application that should be able to access the database. As for the other files it depends whether you're running Tomcat as a service under NT or not etc. There is a classpath variable that is passed to java in each of these files. The files are simple to edit, just open them up and have a look. -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:09 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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] -- 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] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Where to place JDBC drivers? How? SOLUTION FOUND!
(for my tower of cards at least) I'm new to all this and this is probably not the best solution BUT Placing my new JDBC.jar driver files within the Tomcat 4.0/common/lib/ folder got things to work . -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:29 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? Yeah, I'm not afraid of editing the files, as you said that easy enough, yours was the first to suggest editing those files though ... The drivers came with some JSP HTML pages that are supposed to scces the as400 db, with all of these files though there was no WEB-INF file Would simply creating a WEB-INF file and placing said drivers in the folder be enough? Or do the jar/driver files just need to be in the WEB-INF in the webapps branch? (where I unpacked all the sample files from the jdbc provider)? Just for Info I'm running win2k sp2, apache 1.3.22, TC4.0, jdk1.3.1_01 The applications (apache tomact and apache) are listed as services under the windows services manager, I currently have them set as manual services so I can control the start up order and have easy access to starting/stopping/restarting -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:19 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? It needs to be in the Classpath variable so that the jar file can be found. You can add it to the WEB-INF folder but then you will have to put a copy of the driver in the WEB-INF folder of every application that should be able to access the database. As for the other files it depends whether you're running Tomcat as a service under NT or not etc. There is a classpath variable that is passed to java in each of these files. The files are simple to edit, just open them up and have a look. -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:09 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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] -- 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] -- 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: Where to place JDBC drivers? How? SOLUTION FOUND!
If you have only one web-app that references this driver, you should put it in WEB-INF/lib. This allows for better maintenance and management of your libraries and dependencies. To reference/load the driver classname, you could use a parameter entry in the web.xml file... You could even have a startup servlet to load the driver in DriverManager and/or have it available through some lookup system such as a JNDI service. I think this is cleaner than having it in Tomcat/common/lib UNLESS you want those drivers to be available for all web-apps you create. - Original Message - From: Mike Kelley [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 02:02 PM Subject: RE: Where to place JDBC drivers? How? SOLUTION FOUND! (for my tower of cards at least) I'm new to all this and this is probably not the best solution BUT Placing my new JDBC.jar driver files within the Tomcat 4.0/common/lib/ folder got things to work . -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Where to place JDBC drivers? How? SOLUTION FOUND!
But what about those of us who use the Oracle JDBC driver as part of the Oracle client install in /oracle/product//jdbc/lib/classes12.zip ^^^ - not jar Mitchell Evan Marx[EMAIL PROTECTED] ATT IP Network Configuration Provisioning Development -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 2:03 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? SOLUTION FOUND! (for my tower of cards at least) I'm new to all this and this is probably not the best solution BUT Placing my new JDBC.jar driver files within the Tomcat 4.0/common/lib/ folder got things to work . -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:29 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? Yeah, I'm not afraid of editing the files, as you said that easy enough, yours was the first to suggest editing those files though ... The drivers came with some JSP HTML pages that are supposed to scces the as400 db, with all of these files though there was no WEB-INF file Would simply creating a WEB-INF file and placing said drivers in the folder be enough? Or do the jar/driver files just need to be in the WEB-INF in the webapps branch? (where I unpacked all the sample files from the jdbc provider)? Just for Info I'm running win2k sp2, apache 1.3.22, TC4.0, jdk1.3.1_01 The applications (apache tomact and apache) are listed as services under the windows services manager, I currently have them set as manual services so I can control the start up order and have easy access to starting/stopping/restarting -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:19 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? It needs to be in the Classpath variable so that the jar file can be found. You can add it to the WEB-INF folder but then you will have to put a copy of the driver in the WEB-INF folder of every application that should be able to access the database. As for the other files it depends whether you're running Tomcat as a service under NT or not etc. There is a classpath variable that is passed to java in each of these files. The files are simple to edit, just open them up and have a look. -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:09 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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] -- 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
RE: Where to place JDBC drivers? How? SOLUTION FOUND!
I don't know why Oracle still names those files .zip, but it doesn't hurt anything to rename them to .jar. If you're on Unix, you can make a soft-link in WEB-INF/lib with a .jar extension that points to the .zip file. Donnie [EMAIL PROTECTED] 11/28/01 02:26PM But what about those of us who use the Oracle JDBC driver as part of the Oracle client install in /oracle/product//jdbc/lib/classes12.zip ^^^ - not jar Mitchell Evan Marx[EMAIL PROTECTED] ATT IP Network Configuration Provisioning Development -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 2:03 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? SOLUTION FOUND! (for my tower of cards at least) I'm new to all this and this is probably not the best solution BUT Placing my new JDBC.jar driver files within the Tomcat 4.0/common/lib/ folder got things to work . -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:29 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? Yeah, I'm not afraid of editing the files, as you said that easy enough, yours was the first to suggest editing those files though ... The drivers came with some JSP HTML pages that are supposed to scces the as400 db, with all of these files though there was no WEB-INF file Would simply creating a WEB-INF file and placing said drivers in the folder be enough? Or do the jar/driver files just need to be in the WEB-INF in the webapps branch? (where I unpacked all the sample files from the jdbc provider)? Just for Info I'm running win2k sp2, apache 1.3.22, TC4.0, jdk1.3.1_01 The applications (apache tomact and apache) are listed as services under the windows services manager, I currently have them set as manual services so I can control the start up order and have easy access to starting/stopping/restarting -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:19 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? It needs to be in the Classpath variable so that the jar file can be found. You can add it to the WEB-INF folder but then you will have to put a copy of the driver in the WEB-INF folder of every application that should be able to access the database. As for the other files it depends whether you're running Tomcat as a service under NT or not etc. There is a classpath variable that is passed to java in each of these files. The files are simple to edit, just open them up and have a look. -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:09 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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
Re: Where to place JDBC drivers? How? SOLUTION FOUND!
Not in my test with TC 4.01. I had to rename classes12.zip to .jar and distribute it with the WAR. Denis Balazuc wrote: Just rename the ZIP file to JAR...(100% safe) Or maybe Tomcat does support the ZIP extension too ? - Original Message - From: Marx, Mitchell E (Mitch), ALSVC [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 02:26 PM Subject: RE: Where to place JDBC drivers? How? SOLUTION FOUND! But what about those of us who use the Oracle JDBC driver as part of the Oracle client install in /oracle/product//jdbc/lib/classes12.zip ^^^ - not jar Mitchell Evan Marx[EMAIL PROTECTED] ATT IP Network Configuration Provisioning Development -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 2:03 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? SOLUTION FOUND! (for my tower of cards at least) I'm new to all this and this is probably not the best solution BUT Placing my new JDBC.jar driver files within the Tomcat 4.0/common/lib/ folder got things to work . -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:29 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? Yeah, I'm not afraid of editing the files, as you said that easy enough, yours was the first to suggest editing those files though ... The drivers came with some JSP HTML pages that are supposed to scces the as400 db, with all of these files though there was no WEB-INF file Would simply creating a WEB-INF file and placing said drivers in the folder be enough? Or do the jar/driver files just need to be in the WEB-INF in the webapps branch? (where I unpacked all the sample files from the jdbc provider)? Just for Info I'm running win2k sp2, apache 1.3.22, TC4.0, jdk1.3.1_01 The applications (apache tomact and apache) are listed as services under the windows services manager, I currently have them set as manual services so I can control the start up order and have easy access to starting/stopping/restarting -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:19 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? It needs to be in the Classpath variable so that the jar file can be found. You can add it to the WEB-INF folder but then you will have to put a copy of the driver in the WEB-INF folder of every application that should be able to access the database. As for the other files it depends whether you're running Tomcat as a service under NT or not etc. There is a classpath variable that is passed to java in each of these files. The files are simple to edit, just open them up and have a look. -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:09 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location
Re: JDBC Drivers
Go to www.oracle.com Dimiter
RE: JDBC Drivers
Denis, I believe Oracle provides drivers for all their Databases on their website. I can't remember where exactly but I'm sure if you have a bit of a look around you'll be able to find them. Hamish -Original Message- From: The Duke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 3:04 PM To: Tomcat-user Mailinglist Subject: JDBC Drivers I'm looking for a JDBC Driver for an Oracle Database. I have found some on the java.sun.com. But I don't know wich one I need. It is for a simple application. Can anyone help? Dennis Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp
RE: JDBC Drivers
We get ours from technet.oracle.com - you will have to register but they have all of the oci, thin, etc for the various platforms and oracle versions. You should wind up with a classes12.zip file which you should rename to classes12.jar and deploy -Original Message- From: The Duke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 9:04 AM To: Tomcat-user Mailinglist Subject: JDBC Drivers I'm looking for a JDBC Driver for an Oracle Database. I have found some on the java.sun.com. But I don't know wich one I need. It is for a simple application. Can anyone help? Dennis Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp
Re: JDBC Drivers
Hello, You can find a Type-4 JDBC driver for Oracle 8i on Oracle web site called classes12.zip. Cheers, - Shiv. The Duke wrote: I'm looking for a JDBC Driver for an Oracle Database. I have found some on the java.sun.com. But I don't know wich one I need. It is for a simple application. Can anyone help? Dennis Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp
Re: JDBC Drivers
Hi, you can find the classes at the ORACLE web-site; it's called classes12.zip. for use with TOMCAT rename it to classes12.jar. Hth Peter The Duke wrote: I'm looking for a JDBC Driver for an Oracle Database. I have found some on the java.sun.com. But I don't know wich one I need. It is for a simple application. Can anyone help? Dennis Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp
JDBC tyrex pool with JNetDirect JDBC drivers
I'm struggling to get the JDBC-JNDI-Tyrex connection pool working with the Netdirect JDBC driver and I keep getting a cast exception error java.lang.ClassCastException: tyrex.jdbc.xa.EnabledDataSource I configured the JBDC according to the Tomcat 4.0 docs, but I must be missing something... web.xml - resource-ref descriptionCampus Datasource/description res-ref-namejdbc/campus/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref server.xml - Resource name=jdbc/campus auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/campus parameter nameuser/namevaluesa/value /parameter parameter namepassword/namevalue.../value /parameter parameter namedriverClassName/namevaluecom.jnetdirect.jsql.JSQLDriver/value /parameter parameter namedriverName/name valuejdbc:JSQLConnect://localhost:1433/database=campus/value /parameter /ResourceParams Application - Context env = (Context) new InitialContext().lookup(java:comp/env); DataSource ds = (DataSource) env.lookup(jdbc/campus); The J-netdirect drivers come with a JSQLXADataSource class, do I somehow use this instead? If anyone has figured this out, I'd appreciate a tip. Dave
JDBC drivers for SQL server
I am looking for goodcheap (free if possible) JDBC drivers for SQL server. Randy, you told me inetsoftware.de make good drivers. Maybe we will opt for this cie but their prices range from USD 200 to 400... Its expensive for mere drivers (are JDBC drivers so difficult to develop?) And i was wondering if there isn't any JDBC drivers supplied with SQL server. If so, we wouldn't have to pay third-party cie, the migration to servlet would be cheaper, and my boss, happier. If not, what other (cheaper or free if possible) alternatives do i have? Thx alex
Re: JDBC drivers for SQL server
www.easysoft.com Alexandre Bouchard wrote: I am looking for goodcheap (free if possible) JDBC drivers for SQL server. Randy, you told me inetsoftware.de make good drivers. Maybe we will opt for this cie but their prices range from USD 200 to 400... Its expensive for mere drivers (are JDBC drivers so difficult to develop?) And i was wondering if there isn't any JDBC drivers supplied with SQL server. If so, we wouldn't have to pay third-party cie, the migration to servlet would be cheaper, and my boss, happier. If not, what other (cheaper or free if possible) alternatives do i have? Thx alex -- yuzz System Engineer EmasOnline Dot Com Sdn. Bhd. http://www.EmasOnline.com [EMAIL PROTECTED] Tel No: 606+ 3345666 ext 2174 Fax No: 606+ 3372233 #Slackware live...
Re: JDBC drivers for SQL server
We're using freetds (http://www.freetds.org) which is an open source JDBC driver for SQL Server. We've been running with it for a month and only had one problem (jdbc realm wasn't working) that got cleared up by some supportive folks on their mailing list. Chris Alexandre Bouchard wrote: I am looking for goodcheap (free if possible) JDBC drivers for SQL server. Randy, you told me inetsoftware.de make good drivers. Maybe we will opt for this cie but their prices range from USD 200 to 400... Its expensive for mere drivers (are JDBC drivers so difficult to develop?) And i was wondering if there isn't any JDBC drivers supplied with SQL server. If so, we wouldn't have to pay third-party cie, the migration to servlet would be cheaper, and my boss, happier. If not, what other (cheaper or free if possible) alternatives do i have? Thx alex
Where to put JDBC drivers? (Was How to configure Mysql with Tomcat.)
Tony Keith [EMAIL PROTECTED] wrote: snip Noel Morgan wrote: For Tomcat 3.2b6 I used: my setup: Apache 1.3.12 RH 6.2 Linux 2.2.14-5.0 Class.forName("org.gjt.mm.mysql.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/DatabaseName?user=dbuserpassword=dbpassword"); put the jdbc drivers in the classes folder of your app like: cp -Rf $JDBC_HOME/org $MYAPP_HOME/WEB-INF/classes I tried this but I still get the same error... Is there any other configuration to the web.xml? I'm having a similar problem getting JDBCRealm, following the JDBCRealm HOWTO, to work on Tomcat 3.2b7 on Apache 1.3.12 and NT 4.0. I'm using the inet Type 4 driver with a user database in SQL Server 7. When I try to start Tomcat, it fails, and the jvm.stderr log contains the following: 2000-11-16 04:33:01 - ContextManager: Adding context Ctx( /examples ) 2000-11-16 04:33:01 - ContextManager: Adding context Ctx( /admin ) 2000-11-16 04:33:01 - ContextManager: Adding context Ctx( ) 2000-11-16 04:33:01 - ContextManager: Adding context Ctx( /simple ) 2000-11-16 04:33:01 - ContextManager: Adding context Ctx( /test ) java.lang.RuntimeException: JDBCRealm.start.readXml: java.lang.ClassNotFoundException: com.inet.tds.TdsDriver at org.apache.tomcat.request.JDBCRealm.contextInit(JDBCRealm.java:434) at org.apache.tomcat.core.ContextManager.initContext(ContextManager.java:493) at org.apache.tomcat.core.ContextManager.init(ContextManager.java:453) at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:197) at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:237) and jvm.stdout has Starting tomcat. Check logs/tomcat.log for error messages FATAL:java.lang.RuntimeException: JDBCRealm.start.readXml: java.lang.ClassNotFoundException: com.inet.tds.TdsDriver There is nothing in tomcat.log. I've opened the driver jar file, and the TdsDriver class is definitely in there, and I get the same error whether I put the jar in TOMCAT_HOME/lib or in WEB-INF/lib or in WEB-INF/classes. I've even tried adding it to my CLASSPATH and rebooting. I wrote a little java console program to test the driver and it works fine by running it with the -classpath option. Thanks for any suggestions. Larry P.S. Here's the relevant portion of server.xml: !-- Check if the request requires an authenticated role. -- RequestInterceptor className="org.apache.tomcat.request.AccessInterceptor" debug="0" / !-- Check permissions. -- RequestInterceptor className="org.apache.tomcat.request.JDBCRealm" debug="99" driverName="com.inet.tds.TdsDriver" connectionURL="jdbc:inetdae:localhost:1433?database=AppSecurity" userTable="users" userNameCol="user_name" userCredCol="user_pass" userRoleTable="user_roles" roleNameCol="role_name" /