Hi,
I'm a newbie to struts. Lately, I have tasked to maintain a struts
application which makes use of struts data-source. This is working fine, but
when after a certain period, it starts to give java.sql.SQLException: No more
data to read from socket and users of the website are not able to login. I
restart the service, it performing fine and when left for a certain period
again, it encountered the exception again. My data-source is defined as follow:
<!-- struts-config.xml-->
<struts-config>
<data-sources>
<data-source key="ds">
<set-property property="autoCommit" value="false"/>
<set-property property="description" value="Connection to Oracle
Database"/>
<set-property property="driverClass"
value="oracle.jdbc.driver.OracleDriver"/>
<set-property property="maxCount" value="10"/>
<set-property property="minCount" value="5"/>
<set-property property="password" value="psswd"/>
<set-property property="url"
value="jdbc:oracle:thin:@cancer.secorporation.com:1521:dms"/>
<set-property property="user" value="sunny"/>
</data-source>
</data-sources>
:
:
</struts-config>
App server is Tomcat 4.1.29 and DB is Oracle 8.1.7
How can i resolve this? Any comments / suggestions would be appreciated.
---------------------------------
Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get
things done faster.
