Hi,
I need help on making the connection pooling work with struts.
I downloaded the Trial version of DB2 V7.2 Enterprise edition for Linux
(I'm running RedHat 7.1) , Orion JSP server, Struts.
This is the error I get when I try to use a connection :
SQLException: [IBM][CLI Driver][DB2/LINUX] SQL1224N A database agent could
not be started to service a request, or was terminated as a result of a
database system shutdown or a force command. SQLSTATE=55032.
My struts-config.xml :
<data-source>
<set-property property="description" values="conn"/>
<set-property property="driverClass" values
="COM.ibm.db2.jdbc.app.DB2Driver"/>
<set-property property="autoCommit" values="true"/>
<set-property property="maxCount" values="10"/>
<set-property property="minCount" values="1"/>
<set-property property="url" values="jdbc:db2:MyDbName"/>
<set-property property="user" values="viewuser"/>
<set-property property="password" values="userpass"/>
</data-source>
If I don't use the struts datasource, but access the DB2 Driver from my
code in the action, everything works fine. So I guess there must be an
incompatibility problem between the connection pool and DB2 Driver. I did
try to use PoolMan ( ver. 2.1) , but with same results.
Help please.
Jano Fetyko
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
