David
From: "Regis Melo" <[EMAIL PROTECTED]>
Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
Subject: How to use DBCP with Struts
Date: Mon, 3 Feb 2003 12:14:03 -0300
Hello,
I'm trying to use the DBCP with Struts. My struts-config.xml is:
<data-source key="sgr" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<set-property property="url"
value="jdbc:microsoft:sqlserver://JAVA:1433;DatabaseName=SGR;selectmethod=cursor" />
<set-property property="maxActive"
value="2" /> <!-- Cresce de forma indefinida -->
<set-property property="maxIdle"
value="5" /> <!-- Terá pelo menos 5 conexões no pool -->
<set-property property="maxWait"
value="-1" /> <!-- O cliente esperará indefinidamente pelo pool -->
<set-property property="validationQuery"
value="select 'SoftSite TBCW'" />
<set-property property="removeAbandoned"
value="true" />
<set-property property="defaultAutoCommit"
value="false" />
<set-property property="defaultReadOnly"
value="false" />
<set-property property="userName"
value="sa" />
<set-property property="password"
value="secret" />
</data-source>
But, I always receive the follow error (in tomcat logs):
java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:386)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(Unknown Source)
at org.apache.commons.dbcp.BasicDataSource.setLogWriter(Unknown Source)
at org.apache.struts.action.ActionServlet.initApplicationDataSources(ActionServlet.java:846)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:419)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
What can I do?
T.I.A.,
Regis Melo
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
