Dude be carefull not to give too much info:
jdbc:oracle:thin:@cancer.secorporation.com:1521
it could cause you security issues...from potential evil disposed idiot
As per your question, I cannot help you cause I am myself a newbie!
Cheers,
Martin
2006/12/11, Aiping <[EMAIL PROTECTED]>:
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.
--
Martin Provost