Thank you for submitting your request to Quest Software Technical Support. We are unable to process your request because our records indicate that you are not registered for Technical Support.
To register, logon to our Supportlink web site http://www.quest.com/support , and self-register from the web. Or, you can phone Quest at one of the numbers below to register. Once you have registered, you can submit your request within Supportlink, by email at [EMAIL PROTECTED], by phone at one of the numbers below. Please do not reply to this email. If this is an URGENT matter please contact Quest Technical Support via telephone at one of the numbers listed below. Thank you, Quest Software Technical Support www.quest.com/support Quest Software Technical Support - Canada 902.442.5700 Quest Software Technical Support - United Kingdom 44.1628.601007 Quest Software Technical Support - United States 949.754.8000 > --------------------Original Message-------------------- > From: "Fumo, Vince" [mailto:[EMAIL PROTECTED] > Sent: Fri, 22 Aug 2003 15:32:09 -0400 > To: "'Struts Users Mailing List'" [EMAIL PROTECTED] > Subject: RE: <data source> problems > > Thank you David, I gave that a shot and I made some headway, however, now at > Tomcat startup (and obvioulsy Struts startup) I'm getting an exception that > basicly states "Cannot load JDBC driver class 'null'" (full startup is > below). I'm sure I have my struts-config correct and I have the JDBC driver > in the WEB-INF/lib directory and also the tomcat common/lib directory. Any > ideas on where I'm messed up this time? > > <relevant struts-config> > > <!-- ==================================== Data Source Configuration --> > > <data-sources> > <data-source type="org.apache.commons.dbcp.BasicDataSource"> > <set-property property="description" value="MySQL > datasource" /> > <set-property property="driverClass" > value="com.mysql.jdbc.Driver" /> > <set-property property="url" > value="jdbc:mysql://localhost/ed_test" /> > <set-property property="username" value="ed-web" /> > <set-property property="password" value="dashboard" /> > <set-property property="maxActive" value="10" > /> > <set-property property="maxCount" value="10" /> > <set-property property="minCount" value="2" /> > <set-property property="maxWait" value="5000" > /> > <set-property property="defaultAutoCommit" value="false" /> > <set-property property="defaultReadOnly" value="false" /> > <set-property property="validationQuery" value="SELECT > COUNT(*) FROM family" /> > </data-source> > </data-sources> > > <the tomcat startup log> > > Starting service Tomcat-Standalone > Apache Tomcat/4.1.24 > Aug 22, 2003 3:28:47 PM org.apache.struts.util.PropertyMessageResources > <init> > INFO: Initializing, config='org.apache.struts.util.LocalStrings', > returnNull=true > Aug 22, 2003 3:28:47 PM org.apache.struts.util.PropertyMessageResources > <init> > INFO: Initializing, config='org.apache.struts.action.ActionResources', > returnNull=true > Aug 22, 2003 3:28:47 PM org.apache.struts.util.PropertyMessageResources > <init> > INFO: Initializing, config='resources.application', returnNull=true > Aug 22, 2003 3:28:47 PM org.apache.struts.action.ActionServlet > initModuleDataSources > SEVERE: Initializing application data source > org.apache.struts.action.DATA_SOURCE > java.sql.SQLException: Cannot load JDBC driver class 'null' > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav > a:529) > at > org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:38 > 1) > at > org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j > ava:1087) > at > org.apache.struts.action.ActionServlet.init(ActionServlet.java:472) > at javax.servlet.GenericServlet.init(GenericServlet.java:256) > at > org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93 > 5) > at > org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823) > at > org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java: > 3420) > at > org.apache.catalina.core.StandardContext.start(StandardContext.java:3608) > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:8 > 21) > at > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) > at > org.apache.catalina.core.StandardHost.addChild(StandardHost.java:579) > at > org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.j > ava:307) > at > org.apache.catalina.core.StandardHost.install(StandardHost.java:772) > at > org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559 > ) > at > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401) > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718) > at > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358) > at > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor > t.java:166) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196) > at > org.apache.catalina.core.StandardHost.start(StandardHost.java:738) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347) > at > org.apache.catalina.core.StandardService.start(StandardService.java:497) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:2190) > at org.apache.catalina.startup.Catalina.start(Catalina.java:512) > at org.apache.catalina.startup.Catalina.execute(Catalina.java:400) > at org.apache.catalina.startup.Catalina.process(Catalina.java:180) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 > ) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl > .java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) > > > > > -----Original Message----- > From: David Graham [mailto:[EMAIL PROTECTED] > Sent: Friday, August 22, 2003 2:17 PM > To: Struts Users Mailing List > Subject: RE: <data source> problems > > > --- "Fumo, Vince" <[EMAIL PROTECTED]> wrote: > > Yes..I know that I can include the legacy jar but I don't want to. I'd > > prefer to not use depreciated librarys in my app. The thing I'm confused > > about is that I'm not sure how I'm even using GenericDataSource at all. > > I > > thought that by explicitly using the BasicDataSource I would be avoiding > > this problem. > > Having the jar in your lib directory doesn't mean you're using deprecated > functionality. Indeed, you're not even using GenericDataSource. You must > install that jar because Struts uses it internally. It has been removed > for 1.2. > > David > > > > > -----Original Message----- > > From: David Graham [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 22, 2003 1:08 PM > > To: Struts Users Mailing List > > Subject: Re: <data source> problems > > > > > > --- "Fumo, Vince" <[EMAIL PROTECTED]> wrote: > > > Hi all. I'm sure this has been asked before but I can't seem to find > > it > > > in > > > the archives. > > > > > > I'm building a simple web app and I want to use a connection pool. > > I've > > > decided to use the commons dbcp BasicDataSource class > > > (org.apache.commons.dbcp.BasicDataSource). Here is the struts-config > > I'm > > > using (based on the one from the struts faq) : > > > > > > <data-sources> > > > <data-source type="org.apache.commons.dbcp.BasicDataSource"> > > > <set-property property="autoCommit" value="true" /> > > > <set-property property="description" value="MySQL datasource" /> > > > <set-property property="driverClass" value="com.mysql.jdbc.Driver" > > > /> > > > <set-property property="maxCount" value="10" /> > > > <set-property property="minCount" value="2" /> > > > <set-property property="username" value="username" /> > > > <set-property property="password" value="password" /> > > > <set-property property="url" > > > value="jdbc:mysql://localhost:3306/databasename" /> > > > </data-source> > > > </data-sources> > > > > > > I have placed the following jars in my \WEB-INF\lib folder : > > > > > > commons-collections.jar > > > commons-dbcp.jar > > > commons-pool.jar > > > commons-logging.jar > > > mysql-connector-java-3.0.8-stable-bin.jar > > > struts.jar > > > > GenericDataSource lives in struts-legacy.jar. Add that to your lib > > directory and it should find it. > > > > David > > > > > > > > From what I've read and seen, this should work fine. However, no > > matter > > > what > > > I try, I get the following exception: > > > > > > java.lang.NoClassDefFoundError: > > > org/apache/struts/legacy/GenericDataSource > > > > > > I'm aware that GenericDataSource is depreciated. However, I'm not > > trying > > > to > > > use it. My only guess is that somehow struts/tomcat isn't finding the > > > commons.dbcp.BasicDataSource and it trying to default to the > > > GenericDataSource instead. > > > > > > Does anyone have any idea how I can get this to work? I'm willing to > > try > > > anything but my main goal is to have a pooled connection to my mySQL > > > database. > > > > > > Thanks in advance. > > > > > > v > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free, easy-to-use web site design software > > http://sitebuilder.yahoo.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 PROTECTED] > > > > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.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 PROTECTED] >
