Problem with Data Source Definition

[Ralf Schneider]

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]