Re: Problem with Data Source Definition

Johannes Wolfgang Woger Tue, 20 Apr 2004 04:37:26 -0700

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

Wolfgang

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]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Problem with Data Source Definition

Reply via email to