Re: Problem with Data Source Definition
Am Dienstag, 20. April 2004 08:53 schrieb Xuemin Guan: Tomcat (5.0.19) comes together with commons-pool-1.1.jar, which is under CALINA_HOME/common/lib. This directory is both seen by container and you web applications. So, I guess the problem is not cause by the lack of commons-pool-1.1.jar. Am I missing anything here? Exactly, commons-pool-1.1.jar as well as commons-dbcp-1.1.jar are located in CATALINE_HOME/common/lib and I added them as external JARs to the build path of the project. So I guess it should be found by the application. Is there a way to get a more detailed information about what's going wrong during startup? The displayed message StandardContext[/demo_03]Servlet /demo_03 threw load() exception javax.servlet.UnavailableException: Initializing application data source local_01 at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:1091) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472) at javax.servlet.GenericServlet.init(GenericServlet.java:256) does not really help to fix this problem. Probably, the problem might be one of the properties. I took them from the example from the Struts HowTo on accessing databases. Any ideas? Best regards, Ralf. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problem with Data Source Definition
I don't know the cause of this problem. I set up the datasource inforamtion in both Tomcat's server.xml and the application specific web.xml rather than in struts-config.xml, and I have no problem. The regarding part in the server.xml: Resource name=jdbc/LocalNesSQLServer scope=Shareable type=javax.sql.DataSource auth=Container description=The Nes SQLServer Database residing on machine, 192.168.8.136 /Resource ResourceParams name=jdbc/LocalNesSQLServer parameter namedriverClassName/name valuecom.microsoft.jdbc.sqlserver.SQLServerDriver/value /parameter parameter nameurl/name valuejdbc:microsoft:sqlserver://localhost:1433;databaseName=nes;SelectMeth od=cursor/value /parameter parameter nameusername/name valuenesuser/value /parameter parameter namepassword/name valuepassword/value /parameter !-- Maximum number of dB connections in pool. Make sure you configure your DB max_connections large enough to handle all of your db connections. Set to 0 for no limit. -- parameter namemaxActive/name value100/value /parameter !-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. -- parameter namemaxIdle/name value30/value /parameter /ResourceParams The conserning part in my web.xml: resource-ref res-ref-namejdbc/LocalNesSQLServer/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref Alternatively, please read http://lin.kz/?b6v00 Best, Xuemin Am Dienstag, 20. April 2004 08:53 schrieb Xuemin Guan: Tomcat (5.0.19) comes together with commons-pool-1.1.jar, which is under CALINA_HOME/common/lib. This directory is both seen by container and you web applications. So, I guess the problem is not cause by the lack of commons-pool-1.1.jar. Am I missing anything here? Exactly, commons-pool-1.1.jar as well as commons-dbcp-1.1.jar are located in CATALINE_HOME/common/lib and I added them as external JARs to the build path of the project. So I guess it should be found by the application. Is there a way to get a more detailed information about what's going wrong during startup? The displayed message StandardContext[/demo_03]Servlet /demo_03 threw load() exception javax.servlet.UnavailableException: Initializing application data source local_01 at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j ava:1091) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472) at javax.servlet.GenericServlet.init(GenericServlet.java:256) does not really help to fix this problem. Probably, the problem might be one of the properties. I took them from the example from the Struts HowTo on accessing databases. Any ideas? Best regards, Ralf. - 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: Problem with Data Source Definition
Tomcat (5.0.19) comes together with commons-pool-1.1.jar, which is under CALINA_HOME/common/lib. This directory is both seen by container and you web applications. So, I guess the problem is not cause by the lack of commons-pool-1.1.jar. Am I missing anything here? Xuemin - Original Message - From: Matthias Wessendorf [EMAIL PROTECTED] To: 'Struts Users Mailing List' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 2:58 PM Subject: RE: Problem with Data Source Definition Ralf, did you add common-pools.jar http://jakarta.apache.org/commons/pool/ to WEB-INF/lib ? i had a time ago a similar problem, but after that it works cheers, matthias -Original Message- From: Ralf Schneider [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 12:40 AM To: Struts Users Mailing List Subject: Problem with Data Source Definition Hi, I'm trying to setup Struts 1.1 with a database connection using DBCP 1.1 to connect to a SAP DB 7.4 database. Unfortunately, I get the following error during startup of Tomcat (5.0.19): StandardContext[/demo_03]Servlet /demo_03 threw load() exception javax.servlet.UnavailableException: Initializing application data source local_01 at org.apache.struts.action.ActionServlet.initModuleDataSources(A ctionServlet.java:1091) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472) at javax.servlet.GenericServlet.init(GenericServlet.java:256) This is the data sources part of my struts-config.xml: data-sources data-source key=local_01 type=org.apache.commons.dbcp.BasicDataSource set-property property=description value=My DB Configuration / set-property property=driverClassName value=com.sap.dbtech.jdbc.DriverSapDB / set-property property=url value=jdbc:sapdb://localhost/ENIWDB / set-property property=user value=test / set-property property=password value=Test / set-property property=defaultAutoCommit value=false / set-property property=defaultReadOnly value=false / set-property property=maxActive value=10 / set-property property=maxWait value=5000 / set-property property=validationQuery value=SELECT COUNT(*) FROM dual / /data-source /data-sources The same connection settings work in another project not using Struts and DBCP. Any ideas what the problem is with this configuration? Thanks in advance, Ralf. - 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: Problem with Data Source Definition
I've a problem with dbcp but it was different: I was declaring my ds in a tomcat config file but the .jar file (which contains the jdbc driver) was available only for my application (in WEB-INF/lib) and not for the Tomcat itself :-( Is your driver available in WEB-INF/lib ? Xuemin Guan wrote: Tomcat (5.0.19) comes together with commons-pool-1.1.jar, which is under CALINA_HOME/common/lib. This directory is both seen by container and you web applications. So, I guess the problem is not cause by the lack of commons-pool-1.1.jar. Am I missing anything here? Xuemin - Original Message - From: Matthias Wessendorf [EMAIL PROTECTED] To: 'Struts Users Mailing List' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 2:58 PM Subject: RE: Problem with Data Source Definition Ralf, did you add common-pools.jar http://jakarta.apache.org/commons/pool/ to WEB-INF/lib ? i had a time ago a similar problem, but after that it works cheers, matthias -Original Message- From: Ralf Schneider [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 12:40 AM To: Struts Users Mailing List Subject: Problem with Data Source Definition Hi, I'm trying to setup Struts 1.1 with a database connection using DBCP 1.1 to connect to a SAP DB 7.4 database. Unfortunately, I get the following error during startup of Tomcat (5.0.19): StandardContext[/demo_03]Servlet /demo_03 threw load() exception javax.servlet.UnavailableException: Initializing application data source local_01 at org.apache.struts.action.ActionServlet.initModuleDataSources(A ctionServlet.java:1091) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472) at javax.servlet.GenericServlet.init(GenericServlet.java:256) This is the data sources part of my struts-config.xml: data-sources data-source key=local_01 type=org.apache.commons.dbcp.BasicDataSource set-property property=description value=My DB Configuration / set-property property=driverClassName value=com.sap.dbtech.jdbc.DriverSapDB / set-property property=url value=jdbc:sapdb://localhost/ENIWDB / set-property property=user value=test / set-property property=password value=Test / set-property property=defaultAutoCommit value=false / set-property property=defaultReadOnly value=false / set-property property=maxActive value=10 / set-property property=maxWait value=5000 / set-property property=validationQuery value=SELECT COUNT(*) FROM dual / /data-source /data-sources The same connection settings work in another project not using Struts and DBCP. Any ideas what the problem is with this configuration? Thanks in advance, Ralf. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problem with Data Source Definition
--- Johannes Wolfgang Woger [EMAIL PROTECTED] escreveu: Daniel Henrique Alves Lima wrote: I've a problem with dbcp but it was different: I was declaring my ds in a tomcat config file but the .jar file (which contains the jdbc driver) was available only for my application (in WEB-INF/lib) and not for the Tomcat itself :-( if you use JNDI, all connection-related .jar should be in tomcat/common/lib Yes, i know...It was a solved problem :-) Wolfgang __ Yahoo! Messenger - Fale com seus amigos online. Instale agora! http://br.download.yahoo.com/messenger/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Problem with Data Source Definition
Hi, I'm trying to setup Struts 1.1 with a database connection using DBCP 1.1 to connect to a SAP DB 7.4 database. Unfortunately, I get the following error during startup of Tomcat (5.0.19): StandardContext[/demo_03]Servlet /demo_03 threw load() exception javax.servlet.UnavailableException: Initializing application data source local_01 at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:1091) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472) at javax.servlet.GenericServlet.init(GenericServlet.java:256) This is the data sources part of my struts-config.xml: data-sources data-source key=local_01 type=org.apache.commons.dbcp.BasicDataSource set-property property=description value=My DB Configuration / set-property property=driverClassName value=com.sap.dbtech.jdbc.DriverSapDB / set-property property=url value=jdbc:sapdb://localhost/ENIWDB / set-property property=user value=test / set-property property=password value=Test / set-property property=defaultAutoCommit value=false / set-property property=defaultReadOnly value=false / set-property property=maxActive value=10 / set-property property=maxWait value=5000 / set-property property=validationQuery value=SELECT COUNT(*) FROM dual / /data-source /data-sources The same connection settings work in another project not using Struts and DBCP. Any ideas what the problem is with this configuration? Thanks in advance, Ralf. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]