Re: Cannot create Oracle driver not matter what I do!
Yep, I have an older Oracle server which I connect to as well. That connection string looks like this: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=oracleserver.myhost.com)(PROTOCOL=tcp)(PORT=30999))(CONNECT_DATA=(SID=sidOfMyDatabase))) Either way works. Kleth is right, though. You need to check whether you can make the connection from a basic java class. If you can't do that, then how is DBCP supposed to connect to Oracle? Jake At 06:56 AM 11/13/2002 +0100, you wrote: Have you tried to access the Oracle directly from your JVM ? Else read this article, it helped me yesterday, where I had somewhat of the same problem with Tomcat and my JVM: http://www.experts-exchange.com/Databases/Oracle/Q_20154416.html I ended up using a slightly different url than the normal url ( jdbc:oracle:thin:@oracleserver:1521:mydatabase) My URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS =(PROTOCOL=TCP)(HOST=MyServer.FullyQualifiedDomain.com)(PORT=1521)))(CONNECT_DATA =(SERVICE_NAME=MyServiceName)(SERVER=DEDICATED))) Regards Kleth -- Kristian A. Leth. Systemsdeveloper, Maersk Data A/S. -- Professionals are predictable; the world is full of dangerous amateurs. -- |-+ | || | | Jacob Kjome| | | [EMAIL PROTECTED]| | || | | 13-11-2002 | | | 06:30 | | | Please respond | | | to Tomcat | | | Users List| | || | || |-+ --| | | | To: Tomcat Users List [EMAIL PROTECTED] | | cc: | | Subject: Re: Cannot create Oracle driver not matter what I do!| --| The oracle driver works just dandy for me. I renamed classes12.zip to classes12.jar and put it in common/lib. Make absolutely sure that you don't include the oracle driver in your WEB-INF/lib. You will just confuse the classloaders. Put it in common/lib and that is it, end of story. Then I set up my config like this: Resource name=jdbc/myDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/myDB parameter nameusername/name valuescott/value /parameter parameter namepassword/name valuetiger/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@oracleserver:1521:mydatabase/value /parameter parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value100/value /parameter parameter namemaxIdle/name value3/value /parameter parameter namemaxWait/name value100/value /parameter parameter namevalidationQuery/name valueSELECT MAX(id) FROM Users/value /parameter /ResourceParams I haven't had a single problem with this setup under any of the latest 4.1.x releases. Jake At 01:36 PM 11/13/2002 +0900, you wrote: Neither repackaging the jar without the javax.sql classes, nor just placing one copy in common/lib worked. Another person suggested I use ojdbc14.jar instead of classes12.jar, but this didn't work either. So, now I'm looking into the Orion server Extranet [EMAIL PROTECTED] - 11/12/2002 10:47 PM Please respond to [EMAIL PROTECTED] To: tomcat-user cc: Subject: Re: Cannot create Oracle driver not matter what I do! On a related note, There may also be problems with the classes12 file - for some unknown reason, it contains the javax.sql package. I have seen cases where JDK 14x just flat refuses to load it. You may want to unzip the jar, remove those classes and repackage it without them. Larry [EMAIL PROTECTED] 11/11/02 21:05 PM Don't put it everywhere. I've seen things break consistently when put in more than one classloader. Put it in your commons/lib directory. I'm using this and it works just fine under 4.0.4. Can you verify that you
Re: Cannot create Oracle driver not matter what I do!
I haven't been able to get the example to work. I (was sure) that I followed the examples, but I still haven't been able to get this to work for me. Initially I was getting the 'can't create driver null' error and now I'm getting 'object not bound in this context' errors. Can you tell me where exactly you put this code? Thanks, Tom Jacob Kjome wrote: The oracle driver works just dandy for me. I renamed classes12.zip to classes12.jar and put it in common/lib. Make absolutely sure that you don't include the oracle driver in your WEB-INF/lib. You will just confuse the classloaders. Put it in common/lib and that is it, end of story. Then I set up my config like this: Resource name=jdbc/myDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/myDB parameter nameusername/name valuescott/value /parameter parameter namepassword/name valuetiger/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@oracleserver:1521:mydatabase/value /parameter parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value100/value /parameter parameter namemaxIdle/name value3/value /parameter parameter namemaxWait/name value100/value /parameter parameter namevalidationQuery/name valueSELECT MAX(id) FROM Users/value /parameter /ResourceParams I haven't had a single problem with this setup under any of the latest 4.1.x releases. Jake At 01:36 PM 11/13/2002 +0900, you wrote: Neither repackaging the jar without the javax.sql classes, nor just placing one copy in common/lib worked. Another person suggested I use ojdbc14.jar instead of classes12.jar, but this didn't work either. So, now I'm looking into the Orion server Extranet [EMAIL PROTECTED] - 11/12/2002 10:47 PM Please respond to [EMAIL PROTECTED] To: tomcat-user cc: Subject: Re: Cannot create Oracle driver not matter what I do! On a related note, There may also be problems with the classes12 file - for some unknown reason, it contains the javax.sql package. I have seen cases where JDK 14x just flat refuses to load it. You may want to unzip the jar, remove those classes and repackage it without them. Larry [EMAIL PROTECTED] 11/11/02 21:05 PM Don't put it everywhere. I've seen things break consistently when put in more than one classloader. Put it in your commons/lib directory. I'm using this and it works just fine under 4.0.4. Can you verify that you can reproduce the problem under 4.0.4? All attempts to create an Oracle database pool in 4.1.12 have failed. java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(Unknown Source) at org.apache.commons.dbcp.BasicDataSource.getConnection(Unknown Source) at com.opensymphony.module.user.provider.jdbc.JDBCCredentialsProvider.list(JDBCCredentialsProvider.java:40) at com.opensymphony.module.user.UserManager.getEntities(UserManager.java:288) at com.opensymphony.module.user.UserManager.getUsers(UserManager.java:127) etc What I've tried: 1. Renamed classes12.zip to classes12.jar. 2. Put it EVERYWHERE, under every lib directory in the Tomcat directory structure. 3. Added it to the CLASSPATH (in setclasspath.sh) Prove to me that I am making the right decision in moving from WebLogic to Tomcat for a smal project! Ira This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. - Ce message et toutes les pieces jointes (ci-apres le message) sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer
Re[2]: Cannot create Oracle driver not matter what I do!
Hello Tom, There are a few places. If it is for one particular app, just place it within the Context ... element that defines your webapp. Do this either in server.xml or in a Context Configuration File (see admin.xml and manager.xml for examples). Jake Wednesday, November 13, 2002, 9:39:22 AM, you wrote: TM I haven't been able to get the example to work. I (was sure) that I followed the examples, but I still TM haven't been able to get this to work for me. TM Initially I was getting the 'can't create driver null' error and now I'm getting 'object not bound in this TM context' errors. Can you tell me where exactly you put this code? TM Thanks, TM Tom TM Jacob Kjome wrote: The oracle driver works just dandy for me. I renamed classes12.zip to classes12.jar and put it in common/lib. Make absolutely sure that you don't include the oracle driver in your WEB-INF/lib. You will just confuse the classloaders. Put it in common/lib and that is it, end of story. Then I set up my config like this: Resource name=jdbc/myDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/myDB parameter nameusername/name valuescott/value /parameter parameter namepassword/name valuetiger/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@oracleserver:1521:mydatabase/value /parameter parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value100/value /parameter parameter namemaxIdle/name value3/value /parameter parameter namemaxWait/name value100/value /parameter parameter namevalidationQuery/name valueSELECT MAX(id) FROM Users/value /parameter /ResourceParams I haven't had a single problem with this setup under any of the latest 4.1.x releases. Jake At 01:36 PM 11/13/2002 +0900, you wrote: Neither repackaging the jar without the javax.sql classes, nor just placing one copy in common/lib worked. Another person suggested I use ojdbc14.jar instead of classes12.jar, but this didn't work either. So, now I'm looking into the Orion server Extranet [EMAIL PROTECTED] - 11/12/2002 10:47 PM Please respond to [EMAIL PROTECTED] To: tomcat-user cc: Subject: Re: Cannot create Oracle driver not matter what I do! On a related note, There may also be problems with the classes12 file - for some unknown reason, it contains the javax.sql package. I have seen cases where JDK 14x just flat refuses to load it. You may want to unzip the jar, remove those classes and repackage it without them. Larry [EMAIL PROTECTED] 11/11/02 21:05 PM Don't put it everywhere. I've seen things break consistently when put in more than one classloader. Put it in your commons/lib directory. I'm using this and it works just fine under 4.0.4. Can you verify that you can reproduce the problem under 4.0.4? All attempts to create an Oracle database pool in 4.1.12 have failed. java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(Unknown Source) at org.apache.commons.dbcp.BasicDataSource.getConnection(Unknown Source) at com.opensymphony.module.user.provider.jdbc.JDBCCredentialsProvider.list(JDBCCredentialsProvider.java:40) at com.opensymphony.module.user.UserManager.getEntities(UserManager.java:288) at com.opensymphony.module.user.UserManager.getUsers(UserManager.java:127) etc What I've tried: 1. Renamed classes12.zip to classes12.jar. 2. Put it EVERYWHERE, under every lib directory in the Tomcat directory structure. 3. Added it to the CLASSPATH (in setclasspath.sh) Prove to me that I am making the right decision in moving from WebLogic to Tomcat for a smal project! Ira This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. - Ce message et toutes les pieces jointes (ci-apres le message) sont etablis a l'intention exclusive de ses destinataires et sont confidentiels
RE: Cannot create Oracle driver not matter what I do!
Download the ojdbc14.jar from Oracle, replace the classes12.zip, then try again. Eddie Liang Database Architect Phone: 630-810-9669 x253 -Original Message- From: [EMAIL PROTECTED] [mailto:ira.waxberg;japan.bnpparibas.com] Sent: Monday, November 11, 2002 9:54 PM To: [EMAIL PROTECTED] Subject: Cannot create Oracle driver not matter what I do! All attempts to create an Oracle database pool in 4.1.12 have failed. java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(Unknown Source) at org.apache.commons.dbcp.BasicDataSource.getConnection(Unknown Source) at com.opensymphony.module.user.provider.jdbc.JDBCCredentialsProvider.list(JDBC CredentialsProvider.java:40) at com.opensymphony.module.user.UserManager.getEntities(UserManager.java:288) at com.opensymphony.module.user.UserManager.getUsers(UserManager.java:127) etc What I've tried: 1. Renamed classes12.zip to classes12.jar. 2. Put it EVERYWHERE, under every lib directory in the Tomcat directory structure. 3. Added it to the CLASSPATH (in setclasspath.sh) Prove to me that I am making the right decision in moving from WebLogic to Tomcat for a smal project! Ira This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. - Ce message et toutes les pieces jointes (ci-apres le message) sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
Re: Cannot create Oracle driver not matter what I do!
On a related note, There may also be problems with the classes12 file - for some unknown reason, it contains the javax.sql package. I have seen cases where JDK 14x just flat refuses to load it. You may want to unzip the jar, remove those classes and repackage it without them. Larry [EMAIL PROTECTED] 11/11/02 21:05 PM Don't put it everywhere. I've seen things break consistently when put in more than one classloader. Put it in your commons/lib directory. I'm using this and it works just fine under 4.0.4. Can you verify that you can reproduce the problem under 4.0.4? All attempts to create an Oracle database pool in 4.1.12 have failed. java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(Unknown Source) at org.apache.commons.dbcp.BasicDataSource.getConnection(Unknown Source) at com.opensymphony.module.user.provider.jdbc.JDBCCredentialsProvider.list(JDBCCredentialsProvider.java:40) at com.opensymphony.module.user.UserManager.getEntities(UserManager.java:288) at com.opensymphony.module.user.UserManager.getUsers(UserManager.java:127) etc What I've tried: 1. Renamed classes12.zip to classes12.jar. 2. Put it EVERYWHERE, under every lib directory in the Tomcat directory structure. 3. Added it to the CLASSPATH (in setclasspath.sh) Prove to me that I am making the right decision in moving from WebLogic to Tomcat for a smal project! Ira This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. - Ce message et toutes les pieces jointes (ci-apres le message) sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
RE: Cannot create Oracle driver not matter what I do!
I tried this (put in common/lib) but I get the same error. Ira Extranet [EMAIL PROTECTED] - 11/12/2002 11:37 PM Please respond to [EMAIL PROTECTED] To: tomcat-user cc: Subject: RE: Cannot create Oracle driver not matter what I do! Download the ojdbc14.jar from Oracle, replace the classes12.zip, then try again. Eddie Liang Database Architect Phone: 630-810-9669 x253 -Original Message- From: [EMAIL PROTECTED] [mailto:ira.waxberg;japan.bnpparibas.com] Sent: Monday, November 11, 2002 9:54 PM To: [EMAIL PROTECTED] Subject: Cannot create Oracle driver not matter what I do! All attempts to create an Oracle database pool in 4.1.12 have failed. java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(Unknown Source) at org.apache.commons.dbcp.BasicDataSource.getConnection(Unknown Source) at com.opensymphony.module.user.provider.jdbc.JDBCCredentialsProvider.list(JDBC CredentialsProvider.java:40) at com.opensymphony.module.user.UserManager.getEntities(UserManager.java:288) at com.opensymphony.module.user.UserManager.getUsers(UserManager.java:127) etc What I've tried: 1. Renamed classes12.zip to classes12.jar. 2. Put it EVERYWHERE, under every lib directory in the Tomcat directory structure. 3. Added it to the CLASSPATH (in setclasspath.sh) Prove to me that I am making the right decision in moving from WebLogic to Tomcat for a smal project! Ira This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. - Ce message et toutes les pieces jointes (ci-apres le message) sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. - Ce message et toutes les pieces jointes (ci-apres le message) sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
Re: Cannot create Oracle driver not matter what I do!
Neither repackaging the jar without the javax.sql classes, nor just placing one copy in common/lib worked. Another person suggested I use ojdbc14.jar instead of classes12.jar, but this didn't work either. So, now I'm looking into the Orion server Extranet [EMAIL PROTECTED] - 11/12/2002 10:47 PM Please respond to [EMAIL PROTECTED] To: tomcat-user cc: Subject: Re: Cannot create Oracle driver not matter what I do! On a related note, There may also be problems with the classes12 file - for some unknown reason, it contains the javax.sql package. I have seen cases where JDK 14x just flat refuses to load it. You may want to unzip the jar, remove those classes and repackage it without them. Larry [EMAIL PROTECTED] 11/11/02 21:05 PM Don't put it everywhere. I've seen things break consistently when put in more than one classloader. Put it in your commons/lib directory. I'm using this and it works just fine under 4.0.4. Can you verify that you can reproduce the problem under 4.0.4? All attempts to create an Oracle database pool in 4.1.12 have failed. java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(Unknown Source) at org.apache.commons.dbcp.BasicDataSource.getConnection(Unknown Source) at com.opensymphony.module.user.provider.jdbc.JDBCCredentialsProvider.list(JDBCCredentialsProvider.java:40) at com.opensymphony.module.user.UserManager.getEntities(UserManager.java:288) at com.opensymphony.module.user.UserManager.getUsers(UserManager.java:127) etc What I've tried: 1. Renamed classes12.zip to classes12.jar. 2. Put it EVERYWHERE, under every lib directory in the Tomcat directory structure. 3. Added it to the CLASSPATH (in setclasspath.sh) Prove to me that I am making the right decision in moving from WebLogic to Tomcat for a smal project! Ira This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. - Ce message et toutes les pieces jointes (ci-apres le message) sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. - Ce message et toutes les pieces jointes (ci-apres le message) sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
RE: Cannot create Oracle driver not matter what I do!
Strange... I'm using Oracle and Tomcat 4.1.12 and have it all working fine. I followed the instructions in http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how to.html... Special attention to the docs: NOTE:Third Party drivers should be in jarfiles, not zipfiles. Tomcat only adds $CATALINA_HOME/common/lib/*.jar to the classpath. NOTE: Do not install these jarfiles in your /WEB-INF/lib, or $JAVA_HOME/jre/lib/ext, or anywhere else. You will experience problems if you install them anyplace other than $CATALINA_HOME/common/lib. So make sure you don't have classes12.jar in your classpath ANYWHERE (i.e. in setclasspath.sh)... Including in your WEB-INF/lib! Matto. -Original Message- From: [EMAIL PROTECTED] [mailto:ira.waxberg;japan.bnpparibas.com] Sent: Wednesday, 13 November 2002 2:36 PM To: [EMAIL PROTECTED] Subject: Re: Cannot create Oracle driver not matter what I do! Neither repackaging the jar without the javax.sql classes, nor just placing one copy in common/lib worked. Another person suggested I use ojdbc14.jar instead of classes12.jar, but this didn't work either. So, now I'm looking into the Orion server Extranet [EMAIL PROTECTED] - 11/12/2002 10:47 PM Please respond to [EMAIL PROTECTED] To: tomcat-user cc: Subject: Re: Cannot create Oracle driver not matter what I do! On a related note, There may also be problems with the classes12 file - for some unknown reason, it contains the javax.sql package. I have seen cases where JDK 14x just flat refuses to load it. You may want to unzip the jar, remove those classes and repackage it without them. Larry [EMAIL PROTECTED] 11/11/02 21:05 PM Don't put it everywhere. I've seen things break consistently when put in more than one classloader. Put it in your commons/lib directory. I'm using this and it works just fine under 4.0.4. Can you verify that you can reproduce the problem under 4.0.4? All attempts to create an Oracle database pool in 4.1.12 have failed. java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(Unknown Source) at org.apache.commons.dbcp.BasicDataSource.getConnection(Unknown Source) at com.opensymphony.module.user.provider.jdbc.JDBCCredentialsProvider.list(JDBC CredentialsProvider.java:40) at com.opensymphony.module.user.UserManager.getEntities(UserManager.java:288) at com.opensymphony.module.user.UserManager.getUsers(UserManager.java:127) etc What I've tried: 1. Renamed classes12.zip to classes12.jar. 2. Put it EVERYWHERE, under every lib directory in the Tomcat directory structure. 3. Added it to the CLASSPATH (in setclasspath.sh) Prove to me that I am making the right decision in moving from WebLogic to Tomcat for a smal project! Ira This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. - Ce message et toutes les pieces jointes (ci-apres le message) sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall
Re: Cannot create Oracle driver not matter what I do!
The oracle driver works just dandy for me. I renamed classes12.zip to classes12.jar and put it in common/lib. Make absolutely sure that you don't include the oracle driver in your WEB-INF/lib. You will just confuse the classloaders. Put it in common/lib and that is it, end of story. Then I set up my config like this: Resource name=jdbc/myDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/myDB parameter nameusername/name valuescott/value /parameter parameter namepassword/name valuetiger/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@oracleserver:1521:mydatabase/value /parameter parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value100/value /parameter parameter namemaxIdle/name value3/value /parameter parameter namemaxWait/name value100/value /parameter parameter namevalidationQuery/name valueSELECT MAX(id) FROM Users/value /parameter /ResourceParams I haven't had a single problem with this setup under any of the latest 4.1.x releases. Jake At 01:36 PM 11/13/2002 +0900, you wrote: Neither repackaging the jar without the javax.sql classes, nor just placing one copy in common/lib worked. Another person suggested I use ojdbc14.jar instead of classes12.jar, but this didn't work either. So, now I'm looking into the Orion server Extranet [EMAIL PROTECTED] - 11/12/2002 10:47 PM Please respond to [EMAIL PROTECTED] To: tomcat-user cc: Subject: Re: Cannot create Oracle driver not matter what I do! On a related note, There may also be problems with the classes12 file - for some unknown reason, it contains the javax.sql package. I have seen cases where JDK 14x just flat refuses to load it. You may want to unzip the jar, remove those classes and repackage it without them. Larry [EMAIL PROTECTED] 11/11/02 21:05 PM Don't put it everywhere. I've seen things break consistently when put in more than one classloader. Put it in your commons/lib directory. I'm using this and it works just fine under 4.0.4. Can you verify that you can reproduce the problem under 4.0.4? All attempts to create an Oracle database pool in 4.1.12 have failed. java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(Unknown Source) at org.apache.commons.dbcp.BasicDataSource.getConnection(Unknown Source) at com.opensymphony.module.user.provider.jdbc.JDBCCredentialsProvider.list(JDBCCredentialsProvider.java:40) at com.opensymphony.module.user.UserManager.getEntities(UserManager.java:288) at com.opensymphony.module.user.UserManager.getUsers(UserManager.java:127) etc What I've tried: 1. Renamed classes12.zip to classes12.jar. 2. Put it EVERYWHERE, under every lib directory in the Tomcat directory structure. 3. Added it to the CLASSPATH (in setclasspath.sh) Prove to me that I am making the right decision in moving from WebLogic to Tomcat for a smal project! Ira This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. - Ce message et toutes les pieces jointes (ci-apres le message) sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail
Re: Cannot create Oracle driver not matter what I do!
Have you tried to access the Oracle directly from your JVM ? Else read this article, it helped me yesterday, where I had somewhat of the same problem with Tomcat and my JVM: http://www.experts-exchange.com/Databases/Oracle/Q_20154416.html I ended up using a slightly different url than the normal url ( jdbc:oracle:thin:@oracleserver:1521:mydatabase) My URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS =(PROTOCOL=TCP)(HOST=MyServer.FullyQualifiedDomain.com)(PORT=1521)))(CONNECT_DATA =(SERVICE_NAME=MyServiceName)(SERVER=DEDICATED))) Regards Kleth -- Kristian A. Leth. Systemsdeveloper, Maersk Data A/S. -- Professionals are predictable; the world is full of dangerous amateurs. -- |-+ | || | | Jacob Kjome| | | [EMAIL PROTECTED]| | || | | 13-11-2002 | | | 06:30 | | | Please respond | | | to Tomcat | | | Users List| | || | || |-+ --| | | | To: Tomcat Users List [EMAIL PROTECTED] | | cc: | | Subject: Re: Cannot create Oracle driver not matter what I do! | --| The oracle driver works just dandy for me. I renamed classes12.zip to classes12.jar and put it in common/lib. Make absolutely sure that you don't include the oracle driver in your WEB-INF/lib. You will just confuse the classloaders. Put it in common/lib and that is it, end of story. Then I set up my config like this: Resource name=jdbc/myDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/myDB parameter nameusername/name valuescott/value /parameter parameter namepassword/name valuetiger/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter nameurl/name valuejdbc:oracle:thin:@oracleserver:1521:mydatabase/value /parameter parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value100/value /parameter parameter namemaxIdle/name value3/value /parameter parameter namemaxWait/name value100/value /parameter parameter namevalidationQuery/name valueSELECT MAX(id) FROM Users/value /parameter /ResourceParams I haven't had a single problem with this setup under any of the latest 4.1.x releases. Jake At 01:36 PM 11/13/2002 +0900, you wrote: Neither repackaging the jar without the javax.sql classes, nor just placing one copy in common/lib worked. Another person suggested I use ojdbc14.jar instead of classes12.jar, but this didn't work either. So, now I'm looking into the Orion server Extranet [EMAIL PROTECTED] - 11/12/2002 10:47 PM Please respond to [EMAIL PROTECTED] To: tomcat-user cc: Subject: Re: Cannot create Oracle driver not matter what I do! On a related note, There may also be problems with the classes12 file - for some unknown reason, it contains the javax.sql package. I have seen cases where JDK 14x just flat refuses to load it. You may want to unzip the jar, remove those classes and repackage it without them. Larry [EMAIL PROTECTED] 11/11/02 21:05 PM Don't put it everywhere. I've seen things break consistently when put in more than one classloader. Put it in your commons/lib directory. I'm using this and it works just fine under 4.0.4. Can you verify that you can reproduce the problem under 4.0.4? All attempts to create an Oracle database pool in 4.1.12 have failed. java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(Unknown
Cannot create Oracle driver not matter what I do!
All attempts to create an Oracle database pool in 4.1.12 have failed. java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(Unknown Source) at org.apache.commons.dbcp.BasicDataSource.getConnection(Unknown Source) at com.opensymphony.module.user.provider.jdbc.JDBCCredentialsProvider.list(JDBCCredentialsProvider.java:40) at com.opensymphony.module.user.UserManager.getEntities(UserManager.java:288) at com.opensymphony.module.user.UserManager.getUsers(UserManager.java:127) etc What I've tried: 1. Renamed classes12.zip to classes12.jar. 2. Put it EVERYWHERE, under every lib directory in the Tomcat directory structure. 3. Added it to the CLASSPATH (in setclasspath.sh) Prove to me that I am making the right decision in moving from WebLogic to Tomcat for a smal project! Ira This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. - Ce message et toutes les pieces jointes (ci-apres le message) sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
Re: Cannot create Oracle driver not matter what I do!
Don't put it everywhere. I've seen things break consistently when put in more than one classloader. Put it in your commons/lib directory. I'm using this and it works just fine under 4.0.4. Can you verify that you can reproduce the problem under 4.0.4? All attempts to create an Oracle database pool in 4.1.12 have failed. java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(Unknown Source) at org.apache.commons.dbcp.BasicDataSource.getConnection(Unknown Source) at com.opensymphony.module.user.provider.jdbc.JDBCCredentialsProvider.list(JDBCCredentialsProvider.java:40) at com.opensymphony.module.user.UserManager.getEntities(UserManager.java:288) at com.opensymphony.module.user.UserManager.getUsers(UserManager.java:127) etc What I've tried: 1. Renamed classes12.zip to classes12.jar. 2. Put it EVERYWHERE, under every lib directory in the Tomcat directory structure. 3. Added it to the CLASSPATH (in setclasspath.sh) Prove to me that I am making the right decision in moving from WebLogic to Tomcat for a smal project! Ira This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. - Ce message et toutes les pieces jointes (ci-apres le message) sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org