Hello,
I am having a recurring problem with struts and jdbc. The demo
driver I am using, inet's Sprinta200, only allows 2 connections. I have
my data source max set to 1, but I still get errors from the driver:
java.sql.SQLException: [TDS Driver]Too many connections :3
at com.inet.tds.e.<init>(Unknown Source)
at com.inet.tds.TdsDriver.connect(Unknown Source)
at
org.apache.struts.util.GenericDataSource.createConnection(GenericDataSource.java:731)
at org.apache.struts.util.GenericDataSource.open(GenericDataSource.java:668)
at
org.apache.struts.action.ActionServlet.initDataSources(ActionServlet.java:1077)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:471)
at javax.servlet.GenericServlet.init(GenericServlet.java:52)
at com.caucho.server.http.Application.createServlet(Application.java:1741)
___________________________________________
this is how I have it set up in my struts-config:
<data-source>
<set-property property="autoCommit" value="false"/>
<set-property property="description" value="I-Net Sprinta2000"/>
<set-property property="driverClass" value="com.inet.tds.TdsDriver"/>
<set-property property="maxCount" value="1"/>
<set-property property="minCount" value="1"/>
<set-property property="password" value="password"/>
<set-property property="url"value="jdbc:inetdae7a:192.168.0.20:1433/>
<set-property property="user" value="sa"/>
</data-source>
I sometimes get this problem right after I stop and start resin and
bring up a JSP that doesn't even use a connection. Any ideas?
Bill