RE: Please Please Help! -- DataSource Error
Thanks for pointing me in the right direction Craig. I've got it to work. Sincerely, Paul Idusogie -Original Message- From: Craig R. McClanahan [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 1:59 PM To: Struts Users Mailing List Subject: Re: Please Please Help! -- DataSource Error Paul Idusogie wrote: Thanks for your support, I was able to redeem a copy of the struts-legacy.jar. I have the following questions however: Does this datasource model still support connection pooling.? Yes. Now if this code is specified as legacy, are there better approaches to retrieving database data without using ejbs.? If your container supports it, I would recommend retrieving javax.sql.DataSource instances from the JNDI resources configured by the container. For Tomcat, the docs are at: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-resources-howto.html http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how to.html Sincerely, Paul Idusogie Craig - 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: Please Please Help! -- DataSource Error
Do you have the struts-legacy.jar in your WEB-INF/lib directory? - Original Message - From: Paul Idusogie [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 10:44 AM Subject: Please Please Help! -- DataSource Error I have the following setup within my struts-config.xml file data-sources data-source key=myDB type=org.apache.commons.dbcp.BasicDataSource set-property property=description value=my Database/ set-property property=url value=jdbc:mysql://localhost:3306/myDB/ set-property property=driverClass value=com.mysql.jdbc.Driver/ set-property property=maxCount value=5/ set-property property=minCount value=1/ set-property property=user value=root/ set-property property=password value=mypassword/ set-property property=maxActive value=10 / 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 userAttributes / /data-source /data-sources but I get the following error when I restart tomcat. - Root Cause - java.lang.NoClassDefFoundError: org/apache/struts/legacy/GenericDataSource at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:502) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLo ader.java:1680) at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.jav a:968) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav a:1410) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav a:1289) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315) at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j ava:1084) 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: 3421) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3609) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) 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.CatalinaService.start(CatalinaService.java:273) 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.BootstrapService.start(BootstrapService.java:245 ) at org.apache.catalina.startup.BootstrapService.main(BootstrapService.java:307) 2003-10-21 11:12:41 StandardWrapper[/pentstarjsp:default]: Loading container servlet default 2003-10-21 11:12:41 StandardWrapper[/pentstarjsp:invoker]: Loading container servlet invoker Now there is a file GenericDataSource class located within the package org/apache/struts/util/GenericDataSource in the struts.jar I cannot find the reference located at org/apache/struts/legacy/GenericDataSource I am using struts 1.1 Please help Sincerely, Paul Idusogie - 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: Please Please Help! -- DataSource Error
Paul: This might occur if you have multiple copies (perhaps differnt versions?) of struts.jar in your classpath. Make sure you have one and only one struts-jar in your WEB-INF/lib directory and that you compile against *that* jar. (Remove all other extaneous ones.) Recompile your app (if necessary) and then restart tomcat. This may resolve your problem.. Geeta Paul Idusogie wrote: I have the following setup within my struts-config.xml file data-sources data-source key=myDB type=org.apache.commons.dbcp.BasicDataSource set-property property=description value=my Database/ set-property property=url value=jdbc:mysql://localhost:3306/myDB/ set-property property=driverClass value=com.mysql.jdbc.Driver/ set-property property=maxCount value=5/ set-property property=minCount value=1/ set-property property=user value=root/ set-property property=password value=mypassword/ set-property property=maxActive value=10 / 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 userAttributes / /data-source /data-sources but I get the following error when I restart tomcat. - Root Cause - java.lang.NoClassDefFoundError: org/apache/struts/legacy/GenericDataSource at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:502) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLo ader.java:1680) at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.jav a:968) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav a:1410) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav a:1289) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315) at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j ava:1084) 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: 3421) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3609) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) 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.CatalinaService.start(CatalinaService.java:273) 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.BootstrapService.start(BootstrapService.java:245 ) at org.apache.catalina.startup.BootstrapService.main(BootstrapService.java:307) 2003-10-21 11:12:41 StandardWrapper[/pentstarjsp:default]: Loading container servlet default 2003-10-21 11:12:41 StandardWrapper[/pentstarjsp:invoker]: Loading container servlet invoker Now there is a file GenericDataSource class located within the package org/apache/struts/util/GenericDataSource in the struts.jar I cannot find the reference located at org/apache/struts/legacy/GenericDataSource I am using struts 1.1 Please help Sincerely, Paul Idusogie - 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: Please Please Help! -- DataSource Error
Hi there, this errors looks familiar to me as a one time struts newbie, you need to a file called struts-legacy.jar to help you. This is if ur using the generic data source. I still havent been able to figure out how to get org.apache.commons.dbcp.BasicDataSource to work fr me. Any pointers -Original Message- From: Paul Idusogie [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 10:45 AM To: [EMAIL PROTECTED] Subject: Please Please Help! -- DataSource Error Importance: High I have the following setup within my struts-config.xml file data-sources data-source key=myDB type=org.apache.commons.dbcp.BasicDataSource set-property property=description value=my Database/ set-property property=url value=jdbc:mysql://localhost:3306/myDB/ set-property property=driverClass value=com.mysql.jdbc.Driver/ set-property property=maxCount value=5/ set-property property=minCount value=1/ set-property property=user value=root/ set-property property=password value=mypassword/ set-property property=maxActive value=10 / 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 userAttributes / /data-source /data-sources but I get the following error when I restart tomcat. - Root Cause - java.lang.NoClassDefFoundError: org/apache/struts/legacy/GenericDataSource at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:502) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappCla ssLo ader.java:1680) at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader .jav a:968) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader .jav a:1410) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader .jav a:1289) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315) at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServl et.j ava:1084) 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.jav a:93 5) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.j ava: 3421) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3609 ) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) 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.CatalinaService.start(CatalinaService.java:2 73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl .java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.BootstrapService.start(BootstrapService.java :245 ) at org.apache.catalina.startup.BootstrapService.main(BootstrapService.java: 307) 2003-10-21 11:12:41 StandardWrapper[/pentstarjsp:default]: Loading container servlet default 2003-10-21 11:12:41 StandardWrapper[/pentstarjsp:invoker]: Loading container servlet invoker Now there is a file GenericDataSource class located within the package org/apache/struts/util/GenericDataSource in the struts.jar I cannot find the reference located at org/apache/struts/legacy/GenericDataSource I am using struts 1.1 Please help Sincerely, Paul Idusogie - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Please Please Help! -- DataSource Error
They way I got it working was including the struts-legacy.jar commons-dbcp.jar commons-pool.jar and it works. Barry - Original Message - From: Rajat Pandit [EMAIL PROTECTED] To: 'Struts Users Mailing List' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 11:07 AM Subject: RE: Please Please Help! -- DataSource Error Hi there, this errors looks familiar to me as a one time struts newbie, you need to a file called struts-legacy.jar to help you. This is if ur using the generic data source. I still havent been able to figure out how to get org.apache.commons.dbcp.BasicDataSource to work fr me. Any pointers -Original Message- From: Paul Idusogie [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 10:45 AM To: [EMAIL PROTECTED] Subject: Please Please Help! -- DataSource Error Importance: High I have the following setup within my struts-config.xml file data-sources data-source key=myDB type=org.apache.commons.dbcp.BasicDataSource set-property property=description value=my Database/ set-property property=url value=jdbc:mysql://localhost:3306/myDB/ set-property property=driverClass value=com.mysql.jdbc.Driver/ set-property property=maxCount value=5/ set-property property=minCount value=1/ set-property property=user value=root/ set-property property=password value=mypassword/ set-property property=maxActive value=10 / 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 userAttributes / /data-source /data-sources but I get the following error when I restart tomcat. - Root Cause - java.lang.NoClassDefFoundError: org/apache/struts/legacy/GenericDataSource at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:502) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappCla ssLo ader.java:1680) at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader .jav a:968) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader .jav a:1410) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader .jav a:1289) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315) at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServl et.j ava:1084) 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.jav a:93 5) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.j ava: 3421) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3609 ) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) 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.CatalinaService.start(CatalinaService.java:2 73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl .java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.BootstrapService.start(BootstrapService.java :245 ) at org.apache.catalina.startup.BootstrapService.main(BootstrapService.java: 307) 2003-10-21 11:12:41 StandardWrapper[/pentstarjsp:default]: Loading container servlet default 2003-10-21 11:12:41 StandardWrapper[/pentstarjsp:invoker]: Loading container servlet invoker Now there is a file GenericDataSource class located within the package org/apache/struts/util/GenericDataSource in the struts.jar I cannot find the reference located at org/apache/struts/legacy/GenericDataSource I am using struts 1.1 Please help Sincerely, Paul Idusogie - 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: Please Please Help! -- DataSource Error
Where do I find the struts legacy package? Sincerely, Paul Idusogie -Original Message- From: Barry Volpe [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 1:13 PM To: Struts Users Mailing List Subject: Re: Please Please Help! -- DataSource Error They way I got it working was including the struts-legacy.jar commons-dbcp.jar commons-pool.jar and it works. Barry - Original Message - From: Rajat Pandit [EMAIL PROTECTED] To: 'Struts Users Mailing List' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 11:07 AM Subject: RE: Please Please Help! -- DataSource Error Hi there, this errors looks familiar to me as a one time struts newbie, you need to a file called struts-legacy.jar to help you. This is if ur using the generic data source. I still havent been able to figure out how to get org.apache.commons.dbcp.BasicDataSource to work fr me. Any pointers -Original Message- From: Paul Idusogie [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 10:45 AM To: [EMAIL PROTECTED] Subject: Please Please Help! -- DataSource Error Importance: High I have the following setup within my struts-config.xml file data-sources data-source key=myDB type=org.apache.commons.dbcp.BasicDataSource set-property property=description value=my Database/ set-property property=url value=jdbc:mysql://localhost:3306/myDB/ set-property property=driverClass value=com.mysql.jdbc.Driver/ set-property property=maxCount value=5/ set-property property=minCount value=1/ set-property property=user value=root/ set-property property=password value=mypassword/ set-property property=maxActive value=10 / 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 userAttributes / /data-source /data-sources but I get the following error when I restart tomcat. - Root Cause - java.lang.NoClassDefFoundError: org/apache/struts/legacy/GenericDataSource at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:502) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappCla ssLo ader.java:1680) at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader .jav a:968) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader .jav a:1410) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader .jav a:1289) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315) at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServl et.j ava:1084) 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.jav a:93 5) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.j ava: 3421) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3609 ) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) 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.CatalinaService.start(CatalinaService.java:2 73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl .java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.BootstrapService.start(BootstrapService.java :245 ) at org.apache.catalina.startup.BootstrapService.main(BootstrapService.java: 307) 2003-10-21 11:12:41 StandardWrapper[/pentstarjsp:default]: Loading container servlet default 2003-10-21 11:12:41 StandardWrapper[/pentstarjsp:invoker]: Loading container servlet invoker Now there is a file GenericDataSource class located within the package org/apache/struts/util/GenericDataSource in the struts.jar I cannot find the reference located at org/apache/struts/legacy/GenericDataSource I am using struts 1.1 Please help Sincerely, Paul Idusogie - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED
Re: Please Please Help! -- DataSource Error
In the struts 1.1 Final release in the /lib directory Barry - Original Message - From: Paul Idusogie [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 11:17 AM Subject: RE: Please Please Help! -- DataSource Error Where do I find the struts legacy package? Sincerely, Paul Idusogie -Original Message- From: Barry Volpe [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 1:13 PM To: Struts Users Mailing List Subject: Re: Please Please Help! -- DataSource Error They way I got it working was including the struts-legacy.jar commons-dbcp.jar commons-pool.jar and it works. Barry - Original Message - From: Rajat Pandit [EMAIL PROTECTED] To: 'Struts Users Mailing List' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 11:07 AM Subject: RE: Please Please Help! -- DataSource Error Hi there, this errors looks familiar to me as a one time struts newbie, you need to a file called struts-legacy.jar to help you. This is if ur using the generic data source. I still havent been able to figure out how to get org.apache.commons.dbcp.BasicDataSource to work fr me. Any pointers -Original Message- From: Paul Idusogie [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 10:45 AM To: [EMAIL PROTECTED] Subject: Please Please Help! -- DataSource Error Importance: High I have the following setup within my struts-config.xml file data-sources data-source key=myDB type=org.apache.commons.dbcp.BasicDataSource set-property property=description value=my Database/ set-property property=url value=jdbc:mysql://localhost:3306/myDB/ set-property property=driverClass value=com.mysql.jdbc.Driver/ set-property property=maxCount value=5/ set-property property=minCount value=1/ set-property property=user value=root/ set-property property=password value=mypassword/ set-property property=maxActive value=10 / 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 userAttributes / /data-source /data-sources but I get the following error when I restart tomcat. - Root Cause - java.lang.NoClassDefFoundError: org/apache/struts/legacy/GenericDataSource at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:502) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappCla ssLo ader.java:1680) at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader .jav a:968) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader .jav a:1410) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader .jav a:1289) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315) at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServl et.j ava:1084) 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.jav a:93 5) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.j ava: 3421) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3609 ) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) 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.CatalinaService.start(CatalinaService.java:2 73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl .java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.BootstrapService.start(BootstrapService.java :245 ) at org.apache.catalina.startup.BootstrapService.main(BootstrapService.java: 307) 2003-10-21 11:12:41 StandardWrapper[/pentstarjsp:default]: Loading container servlet default 2003-10-21 11:12:41 StandardWrapper[/pentstarjsp:invoker]: Loading container servlet invoker Now there is a file GenericDataSource class located within
RE: Please Please Help! -- DataSource Error
Thanks for your support, I was able to redeem a copy of the struts-legacy.jar. I have the following questions however: Does this datasource model still support connection pooling.? Now if this code is specified as legacy, are there better approaches to retrieving database data without using ejbs.? Sincerely, Paul Idusogie -Original Message- From: Barry Volpe [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 1:20 PM To: Struts Users Mailing List Subject: Re: Please Please Help! -- DataSource Error In the struts 1.1 Final release in the /lib directory Barry - Original Message - From: Paul Idusogie [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 11:17 AM Subject: RE: Please Please Help! -- DataSource Error Where do I find the struts legacy package? Sincerely, Paul Idusogie -Original Message- From: Barry Volpe [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 1:13 PM To: Struts Users Mailing List Subject: Re: Please Please Help! -- DataSource Error They way I got it working was including the struts-legacy.jar commons-dbcp.jar commons-pool.jar and it works. Barry - Original Message - From: Rajat Pandit [EMAIL PROTECTED] To: 'Struts Users Mailing List' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 11:07 AM Subject: RE: Please Please Help! -- DataSource Error Hi there, this errors looks familiar to me as a one time struts newbie, you need to a file called struts-legacy.jar to help you. This is if ur using the generic data source. I still havent been able to figure out how to get org.apache.commons.dbcp.BasicDataSource to work fr me. Any pointers -Original Message- From: Paul Idusogie [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 10:45 AM To: [EMAIL PROTECTED] Subject: Please Please Help! -- DataSource Error Importance: High I have the following setup within my struts-config.xml file data-sources data-source key=myDB type=org.apache.commons.dbcp.BasicDataSource set-property property=description value=my Database/ set-property property=url value=jdbc:mysql://localhost:3306/myDB/ set-property property=driverClass value=com.mysql.jdbc.Driver/ set-property property=maxCount value=5/ set-property property=minCount value=1/ set-property property=user value=root/ set-property property=password value=mypassword/ set-property property=maxActive value=10 / 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 userAttributes / /data-source /data-sources but I get the following error when I restart tomcat. - Root Cause - java.lang.NoClassDefFoundError: org/apache/struts/legacy/GenericDataSource at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:502) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappCla ssLo ader.java:1680) at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader .jav a:968) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader .jav a:1410) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader .jav a:1289) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315) at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServl et.j ava:1084) 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.jav a:93 5) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.j ava: 3421) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3609 ) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) 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.CatalinaService.start(CatalinaService.java:2 73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke
Re: Please Please Help! -- DataSource Error
Read this: http://jakarta.apache.org/struts/faqs/database.html Also wanted to mention that I'm not sure if you are going to have problems if you are not using the struts.jar from release 1.1 The other item I had a problem with is: set-property property=validationQuery value=SELECT COUNT(*) FROM userAttributes / If this fails your datasource will not work. If it does fail completely remove this statement. Barry - Original Message - From: Paul Idusogie [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 11:44 AM Subject: RE: Please Please Help! -- DataSource Error Thanks for your support, I was able to redeem a copy of the struts-legacy.jar. I have the following questions however: Does this datasource model still support connection pooling.? Now if this code is specified as legacy, are there better approaches to retrieving database data without using ejbs.? Sincerely, Paul Idusogie -Original Message- From: Barry Volpe [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 1:20 PM To: Struts Users Mailing List Subject: Re: Please Please Help! -- DataSource Error In the struts 1.1 Final release in the /lib directory Barry - Original Message - From: Paul Idusogie [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 11:17 AM Subject: RE: Please Please Help! -- DataSource Error Where do I find the struts legacy package? Sincerely, Paul Idusogie -Original Message- From: Barry Volpe [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 1:13 PM To: Struts Users Mailing List Subject: Re: Please Please Help! -- DataSource Error They way I got it working was including the struts-legacy.jar commons-dbcp.jar commons-pool.jar and it works. Barry - Original Message - From: Rajat Pandit [EMAIL PROTECTED] To: 'Struts Users Mailing List' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 11:07 AM Subject: RE: Please Please Help! -- DataSource Error Hi there, this errors looks familiar to me as a one time struts newbie, you need to a file called struts-legacy.jar to help you. This is if ur using the generic data source. I still havent been able to figure out how to get org.apache.commons.dbcp.BasicDataSource to work fr me. Any pointers -Original Message- From: Paul Idusogie [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 10:45 AM To: [EMAIL PROTECTED] Subject: Please Please Help! -- DataSource Error Importance: High I have the following setup within my struts-config.xml file data-sources data-source key=myDB type=org.apache.commons.dbcp.BasicDataSource set-property property=description value=my Database/ set-property property=url value=jdbc:mysql://localhost:3306/myDB/ set-property property=driverClass value=com.mysql.jdbc.Driver/ set-property property=maxCount value=5/ set-property property=minCount value=1/ set-property property=user value=root/ set-property property=password value=mypassword/ set-property property=maxActive value=10 / 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 userAttributes / /data-source /data-sources but I get the following error when I restart tomcat. - Root Cause - java.lang.NoClassDefFoundError: org/apache/struts/legacy/GenericDataSource at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:502) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappCla ssLo ader.java:1680) at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader .jav a:968) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader .jav a:1410) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader .jav a:1289) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315) at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServl et.j ava:1084) 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.jav a:93 5) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.j ava: 3421) at org.apache.catalina.core.StandardContext.start(StandardContext.java
Re: Please Please Help! -- DataSource Error
Paul Idusogie wrote: Thanks for your support, I was able to redeem a copy of the struts-legacy.jar. I have the following questions however: Does this datasource model still support connection pooling.? Yes. Now if this code is specified as legacy, are there better approaches to retrieving database data without using ejbs.? If your container supports it, I would recommend retrieving javax.sql.DataSource instances from the JNDI resources configured by the container. For Tomcat, the docs are at: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-resources-howto.html http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html Sincerely, Paul Idusogie Craig - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
