JNDI lookup of datasource objects.
Is there a way to configure Tomcat so I can lookup datasoruce objects by doing .lookup(jdbc/someName) instead of .lookup(java:comp/env/jdbc/someName). I'm trying to work locally on a webphere project using Tomcat / Netbeans. In Webphere lookups are done using jdbc/someName. Thanks, Robert Wynkoop - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object.
V1.3 C:\jdk1.3.1_08\jre\bin\java -classpath C:\web\Tomcat4.1\bin\bootstrap.jar;C:\jdk1.3.1_08\lib\tools.jar -Dcatalina.home=C:\web\Tomcat4.1 -Dcatalina.base=C:\web\Tomcat4.1 -Original Message- From: Filip Hanik [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 6:20 PM To: Tomcat Users List Subject: Re: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object. what JDK are you using? Filip - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Cannot load JDBC driver class 'null'
I'm having the same problem. From what I read the most common problem is that you jdbc driver jar is not in tomcatehome/common/lib dir. Apparently if its only the the web apps ../WEB-INF/lib the tomcat runtime does not have access to it. But, I still have the same problem. I know the jar file is getting used from ../common/lib because I can delete it when Tomkitty is fired up. What version of Tomcat are you using. I'm using V4.1.27LE(No sax parser included.) JDK 1.3. I'm currently doing a new install of tomcat LE. If that does not work I'm trying Tomcat standard from http://www.tux.org/pub/net/apache/dist/jakarta/tomcat-4/ Later, Rober Wynkoop -Original Message- From: Ben Anderson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 7:17 AM To: [EMAIL PROTECTED] Subject: Cannot load JDBC driver class 'null' Ok, I know this topic has been posted many times, but I can't find anything to help. I have OracleDriver in [$CATALINA_HOME]/common/lib here's my server.xml GlobalNamingResources .. Resource name=myDS scope=Shareable type=javax.sql.DataSource auth=Container/ ResourceParams name=myDS parameter namevalidationQuery/name valueselect user from dual;/value /parameter parameter nameurl/name valuejdbc:oracle:thin:myMachine:1521:myDBName/value /parameter parameter nameusername/name valuehris/value /parameter parameter namepassword/name value/value /parameter parameter namemaxActive/name value4/value /parameter parameter namemaxWait/name value5000/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter namemaxIdle/name value2/value /parameter /ResourceParams /GlobalNamingResources and my web.xml: resource-ref res-ref-namejdbc/fsaDS/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth res-sharing-scopeShareable/res-sharing-scope /resource-ref in the administrative tool: the top level Resources-DataSources looks ok as MyDS is listed there but the /my_context-Resources-Datasources gives: org.apache.jasper.JasperException: Exception retrieving attribute 'driverClassName' and the localhost_log.xxx.txt (when it tries to use myDS): java.sql.SQLException: Cannot load JDBC driver class 'null Any help would be great - I've been trying everything - reloading with different configurations about 50 times - looking through books, mailing lists/archives. Thanks, Ben _ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es - 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: Cannot load JDBC driver class 'null'
I meant to say I can't delete the ../common/lib/classes12.jar when TomCat is running. Blip, Robert Wynkoop -Original Message- From: Wynkoop, Robert M Sent: Thursday, September 11, 2003 7:54 AM To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' I'm having the same problem. From what I read the most common problem is that you jdbc driver jar is not in tomcatehome/common/lib dir. Apparently if its only the the web apps ../WEB-INF/lib the tomcat runtime does not have access to it. But, I still have the same problem. I know the jar file is getting used from ../common/lib because I can delete it when Tomkitty is fired up. What version of Tomcat are you using. I'm using V4.1.27LE(No sax parser included.) JDK 1.3. I'm currently doing a new install of tomcat LE. If that does not work I'm trying Tomcat standard from http://www.tux.org/pub/net/apache/dist/jakarta/tomcat-4/ Later, Rober Wynkoop -Original Message- From: Ben Anderson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 7:17 AM To: [EMAIL PROTECTED] Subject: Cannot load JDBC driver class 'null' Ok, I know this topic has been posted many times, but I can't find anything to help. I have OracleDriver in [$CATALINA_HOME]/common/lib here's my server.xml GlobalNamingResources .. Resource name=myDS scope=Shareable type=javax.sql.DataSource auth=Container/ ResourceParams name=myDS parameter namevalidationQuery/name valueselect user from dual;/value /parameter parameter nameurl/name valuejdbc:oracle:thin:myMachine:1521:myDBName/value /parameter parameter nameusername/name valuehris/value /parameter parameter namepassword/name value/value /parameter parameter namemaxActive/name value4/value /parameter parameter namemaxWait/name value5000/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter namemaxIdle/name value2/value /parameter /ResourceParams /GlobalNamingResources and my web.xml: resource-ref res-ref-namejdbc/fsaDS/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth res-sharing-scopeShareable/res-sharing-scope /resource-ref in the administrative tool: the top level Resources-DataSources looks ok as MyDS is listed there but the /my_context-Resources-Datasources gives: org.apache.jasper.JasperException: Exception retrieving attribute 'driverClassName' and the localhost_log.xxx.txt (when it tries to use myDS): java.sql.SQLException: Cannot load JDBC driver class 'null Any help would be great - I've been trying everything - reloading with different configurations about 50 times - looking through books, mailing lists/archives. Thanks, Ben _ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Cannot load JDBC driver class 'null'
I'm still not working after a fresh install of Tomcat. Maybe this is just a Oracle thing. I'm going to check with my DBA's here. Later, Robert Wynkoop -Original Message- From: Ben Anderson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:04 AM To: [EMAIL PROTECTED] Subject: RE: Cannot load JDBC driver class 'null' I have the jar in $CATALINA_HOME/common/lib here's my info: Server Information Tomcat Version JVM Version JVM Vendor OS Name OS Version OS Architecture Apache Tomcat/4.1.241.4.1_02-b06Sun Microsystems Inc. Windows 2000 5.0 x86 -Ben From: Wynkoop, Robert M [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Subject: RE: Cannot load JDBC driver class 'null' Date: Thu, 11 Sep 2003 08:57:35 -0400 I meant to say I can't delete the ../common/lib/classes12.jar when TomCat is running. Blip, Robert Wynkoop -Original Message- From: Wynkoop, Robert M Sent: Thursday, September 11, 2003 7:54 AM To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' I'm having the same problem. From what I read the most common problem is that you jdbc driver jar is not in tomcatehome/common/lib dir. Apparently if its only the the web apps ../WEB-INF/lib the tomcat runtime does not have access to it. But, I still have the same problem. I know the jar file is getting used from ../common/lib because I can delete it when Tomkitty is fired up. What version of Tomcat are you using. I'm using V4.1.27LE(No sax parser included.) JDK 1.3. I'm currently doing a new install of tomcat LE. If that does not work I'm trying Tomcat standard from http://www.tux.org/pub/net/apache/dist/jakarta/tomcat-4/ Later, Rober Wynkoop -Original Message- From: Ben Anderson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 7:17 AM To: [EMAIL PROTECTED] Subject: Cannot load JDBC driver class 'null' Ok, I know this topic has been posted many times, but I can't find anything to help. I have OracleDriver in [$CATALINA_HOME]/common/lib here's my server.xml GlobalNamingResources .. Resource name=myDS scope=Shareable type=javax.sql.DataSource auth=Container/ ResourceParams name=myDS parameter namevalidationQuery/name valueselect user from dual;/value /parameter parameter nameurl/name valuejdbc:oracle:thin:myMachine:1521:myDBName/value /parameter parameter nameusername/name valuehris/value /parameter parameter namepassword/name value/value /parameter parameter namemaxActive/name value4/value /parameter parameter namemaxWait/name value5000/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter namemaxIdle/name value2/value /parameter /ResourceParams /GlobalNamingResources and my web.xml: resource-ref res-ref-namejdbc/fsaDS/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth res-sharing-scopeShareable/res-sharing-scope /resource-ref in the administrative tool: the top level Resources-DataSources looks ok as MyDS is listed there but the /my_context-Resources-Datasources gives: org.apache.jasper.JasperException: Exception retrieving attribute 'driverClassName' and the localhost_log.xxx.txt (when it tries to use myDS): java.sql.SQLException: Cannot load JDBC driver class 'null Any help would be great - I've been trying everything - reloading with different configurations about 50 times - looking through books, mailing lists/archives. Thanks, Ben _ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _ Fast, faster, fastest: Upgrade to Cable or DSL today! https://broadband.msn.com - 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
RE: Cannot load JDBC driver class 'null' and org.apache.jasper.Ja sperException: Exception retrieving attribute 'driverClassName'
I thought about this and then went into the Tomcat admin. Under service/localhost/contextmyapp When I click Datasource(under my apps context) I get the error: org.apache.jasper.JasperException: Exception retrieving attribute 'driverClassName' at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 54) in my browser window. My app is at p:.../somename/web/WEB-INF/. So are you telling me I need to create a file called web.xml. Can't do that. I already have my real web.xml there. Where can I find more information on this config file in the tomcat docs? Later, Robert Wynkoop -Original Message- From: Kevin Passey [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:26 AM To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' Rather than changing your server XML create an xml file in your webapps directory with the same name as your app directory. Here is an example:- - Context className=org.apache.catalina.core.StandardContext crossContext=false reloadable=false mapperClass=org.apache.catalina.core.StandardContextMapper useNaming=true debug=0 swallowOutput=false privileged=false displayName=Shilton wrapperClass=org.apache.catalina.core.StandardWrapper docBase=C:/Tomcat4.1/webapps/shilton cookies=true path=/shilton cachingAllowed=true charsetMapperClass=org.apache.catalina.util.CharsetMapper Resource name=mail/Session scope=Shareable type=javax.mail.Session auth=Container description=Resource reference to a factory for javax.mail.Session instances that may be used for sending electronic mail messages, preconfigured to connect to the appropriate SMTP server. / Resource name=jdbc/shiltonDB auth=Container type=javax.sql.DataSource / - ResourceParams name=jdbc/shiltonDB - parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter - parameter namemaxActive/name value100/value /parameter - parameter namemaxIdle/name value5/value /parameter - parameter namemaxWait/name value100/value /parameter - parameter nameusername/name valueINTERNET/value /parameter - parameter namepassword/name value**/value /parameter - parameter namedriverClassName/name valuecom.ibm.as400.access.AS400JDBCDriver/value /parameter - parameter nameurl/name valuejdbc:as400://REX/value /parameter /ResourceParams /Context Stop and re-start Tomcat and hey presto!! OK I mine is for DB2 on an iSeries - by hey it works !! Anyway shouldn't your Web XML file have myDS not fsaDS. Good luck Kevin -Original Message- From: Ben Anderson [mailto:[EMAIL PROTECTED] Sent: 11 September 2003 13:17 To: [EMAIL PROTECTED] Subject: Cannot load JDBC driver class 'null' Ok, I know this topic has been posted many times, but I can't find anything to help. I have OracleDriver in [$CATALINA_HOME]/common/lib here's my server.xml GlobalNamingResources .. Resource name=myDS scope=Shareable type=javax.sql.DataSource auth=Container/ ResourceParams name=myDS parameter namevalidationQuery/name valueselect user from dual;/value /parameter parameter nameurl/name valuejdbc:oracle:thin:myMachine:1521:myDBName/value /parameter parameter nameusername/name valuehris/value /parameter parameter namepassword/name value/value /parameter parameter namemaxActive/name value4/value /parameter parameter namemaxWait/name value5000/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter namemaxIdle/name value2/value /parameter /ResourceParams /GlobalNamingResources and my web.xml: resource-ref res-ref-namejdbc/fsaDS/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth res-sharing-scopeShareable/res-sharing-scope /resource-ref in the administrative tool: the top level Resources-DataSources looks ok as MyDS is listed there but the /my_context-Resources-Datasources gives: org.apache.jasper.JasperException: Exception retrieving attribute 'driverClassName' and the localhost_log.xxx.txt (when it tries to use myDS): java.sql.SQLException: Cannot load JDBC driver class 'null Any help would be great - I've been trying everything - reloading with different configurations about 50 times - looking through books, mailing lists/archives. Thanks, Ben _ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object.
I don't know how to answer other than I have it in: GlobalNamingResources When you say normal context, what are we talking about? :) Are talking about something like: !-- Tomcat Examples Context -- Context path=/examples blah, blah, blah. **snip Resource name=jdbc/EmployeeAppDb auth=SERVLET type=javax.sql.DataSource/ ResourceParams name=jdbc/EmployeeAppDb parameternameuser/namevaluesa/value/parameter parameternamepassword/namevalue//parameter parameternamedriverClassName/name valueorg.hsql.jdbcDriver/value/parameter parameternamedriverName/name valuejdbc:HypersonicSQL:database/value/parameter /ResourceParams /Context Thanks, Robert Wynkoop -Original Message- From: Manolo Ramirez T. [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 9:27 AM To: Tomcat Users List Subject: Re: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object. Are you declaring the JNDI resource in DefaultContext or with ResourceLink? if yes, try with a normal Context and Resource. Regards, _ Manolo Ramirez T. Wynkoop, Robert M wrote: Yeah I had already tried that. When It was not there I got this message on Tomcat startup - java.lang.reflect.InvocationTargetException: java.lang.NoClassDefFoundError: javax/sql/DataSource I'm kind of stumped on this. Any other ideas? Later, Robert Wynkoop -Original Message- From: Phillip Qin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 5:11 PM To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object. If you use oracle jdbc driver, put classes12.jar in common/lib -Original Message- From: Wynkoop, Robert M [mailto:[EMAIL PROTECTED] Sent: September 10, 2003 6:06 PM To: Tomcat Mailing List (E-mail) Subject: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1.27 w hen trying instantiate datasource object. The error(Wen I try to use a JNDI resource in my webapp.): C:\jdk1.3.1_08\jre\bin\java -classpath C:\web\Tomcat4.1\bin\bootstrap.jar;C:\jdk1.3.1_08\lib\tools.jar -Dcatalina.home=C:\web\Tomcat4.1 -Dcatalina.base=C:\web\Tomcat4.1 org.apache.catalina.startup.Bootstrap start [INFO] Registry - -Loading registry information [INFO] Registry - -Creating new Registry instance [INFO] Registry - -Creating MBeanServer [INFO] Http11Protocol - -Initializing Coyote HTTP/1.1 on port 8080 Starting service Tomcat-Standalone Apache Tomcat/4.1.18-LE-jdk14 [INFO] PropertyMessageResources - -Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true [INFO] PropertyMessageResources - -Initializing, config='org.apache.struts.action.ActionResources', returnNull=true [INFO] PropertyMessageResources - -Initializing, config='remic_msgcat', returnNull=true [INFO] Http11Protocol - -Starting Coyote HTTP/1.1 on port 8080 [INFO] ChannelSocket - -JK2: ajp13 listening on 0.0.0.0/0.0.0.0:8009 [INFO] JkMain - -Jk running ID=0 time=0/200 config=C:\web\Tomcat4.1\conf\jk2.properties Cannot load JDBC driver class 'null' java.lang.NullPointerException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:115) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav a:523) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 29) at com.citimortgage.common.datasource.DataSourceManager.getConnection(DataSourc eManager.java:80) I know I have the Oracle jar in the right place because I get this msg when if I don't have it in tomcatHome/common/lib. C:\jdk1.3.1_08\jre\bin\java -classpath C:\web\Tomcat4.1\bin\bootstrap.jar;C:\jdk1.3.1_08\lib\tools.jar -Dcatalina.home=C:\web\Tomcat4.1 -Dcatalina.base=C:\web\Tomcat4.1 org.apache.catalina.startup.Bootstrap start [INFO] Registry - -Loading registry information [INFO] Registry - -Creating new Registry instance [INFO] Registry - -Creating MBeanServer [INFO] Http11Protocol - -Initializing Coyote HTTP/1.1 on port 8080 Exception during startup processing java.lang.reflect.InvocationTargetException: java.lang.NoClassDefFoundError: javax/sql/DataSource at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:488) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:106) I googled for this answer. The most common problem is not finding the database driver in tomcatHome/common/lib. Later, Robert Wynkoop - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED
RE: Cannot load JDBC driver class 'null' and org.apache.jasper.Ja sperException: Exception retrieving attribute 'driverClassName'
I don't see your comments about myDS and fsaDS. Can you echo them again. :) Thanks, Robert Wynkoop -Original Message- From: Kevin Passey [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:55 AM To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' and org.apache.jasper.Ja sperException: Exception retrieving attribute 'driverClassName' No the xml file should be called myapp.xml in webapps along with your war file Did you note my other comment about myDS and fsaDS that looks like it's more your problem. Leave it how you had it and just change that - stop and start tomcat and see if that flies. Regards Kevin -Original Message- From: Wynkoop, Robert M [mailto:[EMAIL PROTECTED] Sent: 11 September 2003 14:54 To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' and org.apache.jasper.Ja sperException: Exception retrieving attribute 'driverClassName' I thought about this and then went into the Tomcat admin. Under service/localhost/contextmyapp When I click Datasource(under my apps context) I get the error: org.apache.jasper.JasperException: Exception retrieving attribute 'driverClassName' at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 54) in my browser window. My app is at p:.../somename/web/WEB-INF/. So are you telling me I need to create a file called web.xml. Can't do that. I already have my real web.xml there. Where can I find more information on this config file in the tomcat docs? Later, Robert Wynkoop -Original Message- From: Kevin Passey [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:26 AM To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' Rather than changing your server XML create an xml file in your webapps directory with the same name as your app directory. Here is an example:- - Context className=org.apache.catalina.core.StandardContext crossContext=false reloadable=false mapperClass=org.apache.catalina.core.StandardContextMapper useNaming=true debug=0 swallowOutput=false privileged=false displayName=Shilton wrapperClass=org.apache.catalina.core.StandardWrapper docBase=C:/Tomcat4.1/webapps/shilton cookies=true path=/shilton cachingAllowed=true charsetMapperClass=org.apache.catalina.util.CharsetMapper Resource name=mail/Session scope=Shareable type=javax.mail.Session auth=Container description=Resource reference to a factory for javax.mail.Session instances that may be used for sending electronic mail messages, preconfigured to connect to the appropriate SMTP server. / Resource name=jdbc/shiltonDB auth=Container type=javax.sql.DataSource / - ResourceParams name=jdbc/shiltonDB - parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter - parameter namemaxActive/name value100/value /parameter - parameter namemaxIdle/name value5/value /parameter - parameter namemaxWait/name value100/value /parameter - parameter nameusername/name valueINTERNET/value /parameter - parameter namepassword/name value**/value /parameter - parameter namedriverClassName/name valuecom.ibm.as400.access.AS400JDBCDriver/value /parameter - parameter nameurl/name valuejdbc:as400://REX/value /parameter /ResourceParams /Context Stop and re-start Tomcat and hey presto!! OK I mine is for DB2 on an iSeries - by hey it works !! Anyway shouldn't your Web XML file have myDS not fsaDS. Good luck Kevin -Original Message- From: Ben Anderson [mailto:[EMAIL PROTECTED] Sent: 11 September 2003 13:17 To: [EMAIL PROTECTED] Subject: Cannot load JDBC driver class 'null' Ok, I know this topic has been posted many times, but I can't find anything to help. I have OracleDriver in [$CATALINA_HOME]/common/lib here's my server.xml GlobalNamingResources .. Resource name=myDS scope=Shareable type=javax.sql.DataSource auth=Container/ ResourceParams name=myDS parameter namevalidationQuery/name valueselect user from dual;/value /parameter parameter nameurl/name valuejdbc:oracle:thin:myMachine:1521:myDBName/value /parameter parameter nameusername/name valuehris/value /parameter parameter namepassword/name value/value /parameter parameter namemaxActive/name value4/value /parameter parameter namemaxWait/name value5000/value /parameter parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter namemaxIdle/name value2/value /parameter /ResourceParams /GlobalNamingResources and my web.xml: resource-ref res-ref-namejdbc/fsaDS/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth res-sharing
RE: new Aspen Group Email
I sent him a email to his new address at [EMAIL PROTECTED] - no reply and he is still on the list. Robert Wynkoop -Original Message- From: Mike Curwen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 9:08 AM To: 'Tomcat Users List' Subject: RE: new Aspen Group Email If [EMAIL PROTECTED] has been discontinued, then perhaps the owner of this 'former' email address can no longer send an unsubscribe message. Seriously, I know how you apache guys feel about list-admin duties.. but is there no way to kill this guy's old email for him and for us. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 9:01 AM To: [EMAIL PROTECTED] Subject: new Aspen Group Email Due to problems with SPAM, [EMAIL PROTECTED] has been discontinued. Please note my new email address. To prevent automated systems from obtaining my new email address, I will spell out the @ symbol. Please send all future email to: gordon[at]aspengroup.net - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object.
I moved the resources to the webApps context in server.xml. Now I'm getting this error when I try to get a connection. java.lang.UnsupportedOperationException at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.ja va:125) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 29) I will check my jar versions. Has anyone seen this? Later, Robert Wynkoop -Original Message- From: Manolo Ramirez T. [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:44 AM To: Tomcat Users List Subject: Re: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object. Yep, that's what I'm talking about, check the archives, some people had problems with ResourceLink's and DefaultContext. Defining your context in a myApp.xml is the best option to avoid it, you must to follow Phillip Qin advise. Happy Coding! Regards, __ Manolo Ramirez T. Wynkoop, Robert M wrote: I don't know how to answer other than I have it in: GlobalNamingResources When you say normal context, what are we talking about? :) Are talking about something like: !-- Tomcat Examples Context -- Context path=/examples blah, blah, blah. **snip Resource name=jdbc/EmployeeAppDb auth=SERVLET type=javax.sql.DataSource/ ResourceParams name=jdbc/EmployeeAppDb parameternameuser/namevaluesa/value/parameter parameternamepassword/namevalue//parameter parameternamedriverClassName/name valueorg.hsql.jdbcDriver/value/parameter parameternamedriverName/name valuejdbc:HypersonicSQL:database/value/parameter /ResourceParams /Context Thanks, Robert Wynkoop -Original Message- From: Manolo Ramirez T. [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 9:27 AM To: Tomcat Users List Subject: Re: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object. Are you declaring the JNDI resource in DefaultContext or with ResourceLink? if yes, try with a normal Context and Resource. Regards, _ Manolo Ramirez T. Wynkoop, Robert M wrote: Yeah I had already tried that. When It was not there I got this message on Tomcat startup - java.lang.reflect.InvocationTargetException: java.lang.NoClassDefFoundError: javax/sql/DataSource I'm kind of stumped on this. Any other ideas? Later, Robert Wynkoop -Original Message- From: Phillip Qin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 5:11 PM To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object. If you use oracle jdbc driver, put classes12.jar in common/lib -Original Message- From: Wynkoop, Robert M [mailto:[EMAIL PROTECTED] Sent: September 10, 2003 6:06 PM To: Tomcat Mailing List (E-mail) Subject: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1.27 w hen trying instantiate datasource object. The error(Wen I try to use a JNDI resource in my webapp.): C:\jdk1.3.1_08\jre\bin\java -classpath C:\web\Tomcat4.1\bin\bootstrap.jar;C:\jdk1.3.1_08\lib\tools.jar -Dcatalina.home=C:\web\Tomcat4.1 -Dcatalina.base=C:\web\Tomcat4.1 org.apache.catalina.startup.Bootstrap start [INFO] Registry - -Loading registry information [INFO] Registry - -Creating new Registry instance [INFO] Registry - -Creating MBeanServer [INFO] Http11Protocol - -Initializing Coyote HTTP/1.1 on port 8080 Starting service Tomcat-Standalone Apache Tomcat/4.1.18-LE-jdk14 [INFO] PropertyMessageResources - -Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true [INFO] PropertyMessageResources - -Initializing, config='org.apache.struts.action.ActionResources', returnNull=true [INFO] PropertyMessageResources - -Initializing, config='remic_msgcat', returnNull=true [INFO] Http11Protocol - -Starting Coyote HTTP/1.1 on port 8080 [INFO] ChannelSocket - -JK2: ajp13 listening on 0.0.0.0/0.0.0.0:8009 [INFO] JkMain - -Jk running ID=0 time=0/200 config=C:\web\Tomcat4.1\conf\jk2.properties Cannot load JDBC driver class 'null' java.lang.NullPointerException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:115) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav a:523) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 29) at com.citimortgage.common.datasource.DataSourceManager.getConnection(DataSourc eManager.java:80) I know I have the Oracle jar in the right place because I get this msg when if I don't have it in tomcatHome/common/lib. C:\jdk1.3.1_08\jre\bin\java -classpath C:\web\Tomcat4.1\bin\bootstrap.jar;C:\jdk1.3.1_08\lib\tools.jar -Dcatalina.home=C:\web\Tomcat4.1 -Dcatalina.base=C
RE: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object.
Reply to myself. Dam - commons-dbcp.jar does not support: getConnection(String uname, String passwd) throws SQLException. Only. getConnection() throws SQLException I guess I need to talk to the comons-dbcp group. So why did I have to move the resources to the webApp group to make this work? P.S. - So moving the resources to the webApp context did fix my problem. Later, Robert Wynkoop -Original Message- From: Wynkoop, Robert M Sent: Thursday, September 11, 2003 10:53 AM To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object. I moved the resources to the webApps context in server.xml. Now I'm getting this error when I try to get a connection. java.lang.UnsupportedOperationException at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.ja va:125) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 29) I will check my jar versions. Has anyone seen this? Later, Robert Wynkoop -Original Message- From: Manolo Ramirez T. [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:44 AM To: Tomcat Users List Subject: Re: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object. Yep, that's what I'm talking about, check the archives, some people had problems with ResourceLink's and DefaultContext. Defining your context in a myApp.xml is the best option to avoid it, you must to follow Phillip Qin advise. Happy Coding! Regards, __ Manolo Ramirez T. Wynkoop, Robert M wrote: I don't know how to answer other than I have it in: GlobalNamingResources When you say normal context, what are we talking about? :) Are talking about something like: !-- Tomcat Examples Context -- Context path=/examples blah, blah, blah. **snip Resource name=jdbc/EmployeeAppDb auth=SERVLET type=javax.sql.DataSource/ ResourceParams name=jdbc/EmployeeAppDb parameternameuser/namevaluesa/value/parameter parameternamepassword/namevalue//parameter parameternamedriverClassName/name valueorg.hsql.jdbcDriver/value/parameter parameternamedriverName/name valuejdbc:HypersonicSQL:database/value/parameter /ResourceParams /Context Thanks, Robert Wynkoop -Original Message- From: Manolo Ramirez T. [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 9:27 AM To: Tomcat Users List Subject: Re: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object. Are you declaring the JNDI resource in DefaultContext or with ResourceLink? if yes, try with a normal Context and Resource. Regards, _ Manolo Ramirez T. Wynkoop, Robert M wrote: Yeah I had already tried that. When It was not there I got this message on Tomcat startup - java.lang.reflect.InvocationTargetException: java.lang.NoClassDefFoundError: javax/sql/DataSource I'm kind of stumped on this. Any other ideas? Later, Robert Wynkoop -Original Message- From: Phillip Qin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 5:11 PM To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object. If you use oracle jdbc driver, put classes12.jar in common/lib -Original Message- From: Wynkoop, Robert M [mailto:[EMAIL PROTECTED] Sent: September 10, 2003 6:06 PM To: Tomcat Mailing List (E-mail) Subject: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1.27 w hen trying instantiate datasource object. The error(Wen I try to use a JNDI resource in my webapp.): C:\jdk1.3.1_08\jre\bin\java -classpath C:\web\Tomcat4.1\bin\bootstrap.jar;C:\jdk1.3.1_08\lib\tools.jar -Dcatalina.home=C:\web\Tomcat4.1 -Dcatalina.base=C:\web\Tomcat4.1 org.apache.catalina.startup.Bootstrap start [INFO] Registry - -Loading registry information [INFO] Registry - -Creating new Registry instance [INFO] Registry - -Creating MBeanServer [INFO] Http11Protocol - -Initializing Coyote HTTP/1.1 on port 8080 Starting service Tomcat-Standalone Apache Tomcat/4.1.18-LE-jdk14 [INFO] PropertyMessageResources - -Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true [INFO] PropertyMessageResources - -Initializing, config='org.apache.struts.action.ActionResources', returnNull=true [INFO] PropertyMessageResources - -Initializing, config='remic_msgcat', returnNull=true [INFO] Http11Protocol - -Starting Coyote HTTP/1.1 on port 8080 [INFO] ChannelSocket - -JK2: ajp13 listening on 0.0.0.0/0.0.0.0:8009 [INFO] JkMain - -Jk running ID=0 time=0/200 config=C:\web\Tomcat4.1\conf\jk2.properties Cannot load JDBC driver class 'null' java.lang.NullPointerException at java.lang.Class.forName0(Native Method
RE: how to use single dbcp resource across multiple webapps
Paul, I just went through this exercise today. (See msgs with subject = java.sql.SQLException: Cannot load JDBC driver class 'null') I do not know why it does not work when set up in the global context(Tomcat admin puts datasources here). Let us know if you get an answer. Later, Robert Wynkoop -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 2:04 PM To: Tomcat Users List Subject: how to use single dbcp resource across multiple webapps hi, i setup dbcp according to Tomcat docs successfully for one web app, but when tried to use resource (defined in server.xml) in second web app (with appropriate WEB-INF/web.xml), get the following: java.sql.SQLException: Cannot load JDBC driver class 'null' meanwhile, dbcp resource works fine with first app. i figure it is because the resource is defined within following context, where path specifies first web app: Context path=/epl docBase=epl debug=5 reloadable=true crossContext=true do i need to define a second context and dbcp resource, or is there some way to use a single dbcp resource across contexts/web-apps? -paul lomack - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Cannot load JDBC driver class 'null' - Tomcat standalone 4.1.27 w hen trying instantiate datasource object.
The error(Wen I try to use a JNDI resource in my webapp.): C:\jdk1.3.1_08\jre\bin\java -classpath C:\web\Tomcat4.1\bin\bootstrap.jar;C:\jdk1.3.1_08\lib\tools.jar -Dcatalina.home=C:\web\Tomcat4.1 -Dcatalina.base=C:\web\Tomcat4.1 org.apache.catalina.startup.Bootstrap start [INFO] Registry - -Loading registry information [INFO] Registry - -Creating new Registry instance [INFO] Registry - -Creating MBeanServer [INFO] Http11Protocol - -Initializing Coyote HTTP/1.1 on port 8080 Starting service Tomcat-Standalone Apache Tomcat/4.1.18-LE-jdk14 [INFO] PropertyMessageResources - -Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true [INFO] PropertyMessageResources - -Initializing, config='org.apache.struts.action.ActionResources', returnNull=true [INFO] PropertyMessageResources - -Initializing, config='remic_msgcat', returnNull=true [INFO] Http11Protocol - -Starting Coyote HTTP/1.1 on port 8080 [INFO] ChannelSocket - -JK2: ajp13 listening on 0.0.0.0/0.0.0.0:8009 [INFO] JkMain - -Jk running ID=0 time=0/200 config=C:\web\Tomcat4.1\conf\jk2.properties Cannot load JDBC driver class 'null' java.lang.NullPointerException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:115) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav a:523) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 29) at com.citimortgage.common.datasource.DataSourceManager.getConnection(DataSourc eManager.java:80) I know I have the Oracle jar in the right place because I get this msg when if I don't have it in tomcatHome/common/lib. C:\jdk1.3.1_08\jre\bin\java -classpath C:\web\Tomcat4.1\bin\bootstrap.jar;C:\jdk1.3.1_08\lib\tools.jar -Dcatalina.home=C:\web\Tomcat4.1 -Dcatalina.base=C:\web\Tomcat4.1 org.apache.catalina.startup.Bootstrap start [INFO] Registry - -Loading registry information [INFO] Registry - -Creating new Registry instance [INFO] Registry - -Creating MBeanServer [INFO] Http11Protocol - -Initializing Coyote HTTP/1.1 on port 8080 Exception during startup processing java.lang.reflect.InvocationTargetException: java.lang.NoClassDefFoundError: javax/sql/DataSource at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:488) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:106) I googled for this answer. The most common problem is not finding the database driver in tomcatHome/common/lib. Later, Robert Wynkoop - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object.
Yeah I had already tried that. When It was not there I got this message on Tomcat startup - java.lang.reflect.InvocationTargetException: java.lang.NoClassDefFoundError: javax/sql/DataSource I'm kind of stumped on this. Any other ideas? Later, Robert Wynkoop -Original Message- From: Phillip Qin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 5:11 PM To: 'Tomcat Users List' Subject: RE: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1. 27 w hen trying instantiate datasource object. If you use oracle jdbc driver, put classes12.jar in common/lib -Original Message- From: Wynkoop, Robert M [mailto:[EMAIL PROTECTED] Sent: September 10, 2003 6:06 PM To: Tomcat Mailing List (E-mail) Subject: Cannot load JDBC driver class 'null' - Tomcat standalone 4.1.27 w hen trying instantiate datasource object. The error(Wen I try to use a JNDI resource in my webapp.): C:\jdk1.3.1_08\jre\bin\java -classpath C:\web\Tomcat4.1\bin\bootstrap.jar;C:\jdk1.3.1_08\lib\tools.jar -Dcatalina.home=C:\web\Tomcat4.1 -Dcatalina.base=C:\web\Tomcat4.1 org.apache.catalina.startup.Bootstrap start [INFO] Registry - -Loading registry information [INFO] Registry - -Creating new Registry instance [INFO] Registry - -Creating MBeanServer [INFO] Http11Protocol - -Initializing Coyote HTTP/1.1 on port 8080 Starting service Tomcat-Standalone Apache Tomcat/4.1.18-LE-jdk14 [INFO] PropertyMessageResources - -Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true [INFO] PropertyMessageResources - -Initializing, config='org.apache.struts.action.ActionResources', returnNull=true [INFO] PropertyMessageResources - -Initializing, config='remic_msgcat', returnNull=true [INFO] Http11Protocol - -Starting Coyote HTTP/1.1 on port 8080 [INFO] ChannelSocket - -JK2: ajp13 listening on 0.0.0.0/0.0.0.0:8009 [INFO] JkMain - -Jk running ID=0 time=0/200 config=C:\web\Tomcat4.1\conf\jk2.properties Cannot load JDBC driver class 'null' java.lang.NullPointerException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:115) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav a:523) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 29) at com.citimortgage.common.datasource.DataSourceManager.getConnection(DataSourc eManager.java:80) I know I have the Oracle jar in the right place because I get this msg when if I don't have it in tomcatHome/common/lib. C:\jdk1.3.1_08\jre\bin\java -classpath C:\web\Tomcat4.1\bin\bootstrap.jar;C:\jdk1.3.1_08\lib\tools.jar -Dcatalina.home=C:\web\Tomcat4.1 -Dcatalina.base=C:\web\Tomcat4.1 org.apache.catalina.startup.Bootstrap start [INFO] Registry - -Loading registry information [INFO] Registry - -Creating new Registry instance [INFO] Registry - -Creating MBeanServer [INFO] Http11Protocol - -Initializing Coyote HTTP/1.1 on port 8080 Exception during startup processing java.lang.reflect.InvocationTargetException: java.lang.NoClassDefFoundError: javax/sql/DataSource at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:488) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:106) I googled for this answer. The most common problem is not finding the database driver in tomcatHome/common/lib. Later, Robert Wynkoop - 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]