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

Reply via email to