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:@(protected)"/>
  <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.