Software caused connection abort:

Hello experts,

I have my apps running on tomcat 6 under windows server 2003. the apps  throws this exception when try to open JDBC connection

" Io exception: Software caused connection abort: socket write error"

when i got this exception , i restarted tomcat , the apps work fine ,so how should i handle this exception?

Web_AdminAsked:
Who is Participating?
 
objectsConnect With a Mentor Commented:
that would be expected, its not a problem with the application but instead related to database or network ie. external to the application
0
 
CEHJCommented:
Can you repeat the error after restarting or has it 'gone'?

Generally it would be better to use a connection pool as it will insulate you from establishing communication links
0
 
Web_AdminAuthor Commented:
when i restarted tomcat, exception gone and apps r working just fine :)
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Web_AdminAuthor Commented:
I am using datasource connection :)
0
 
objectsCommented:
>  the apps  throws this exception when try to open JDBC connection

that error is not related to opening the connection
it means the connection to the database was lost, check your database log.
Or could be caused by a network problem
not much you can do
0
 
Web_AdminAuthor Commented:
objects:
why then when i restarted the tomcat, the excption gone and apps working ?
0
 
Web_AdminAuthor Commented:
objects:

what files should i requested from our DBA? we running oracle 10 g
0
 
CEHJConnect With a Mentor Commented:
Ask the dba to check the connection logs for network and connection issues
0
 
objectsCommented:
> what files should i requested from our DBA? we running oracle 10 g

not sure, better to tell the dba whats actually going on. They should have a good idea where to check.
0
 
Web_AdminAuthor Commented:
The DBA replied:

"I suspect that the timeout is the reason of such error" so he increase the timout for the database

is this could be the reason ?
0
 
objectsCommented:
yes that would do it. The connection times out server side without the your application being aware so it still tries to write to it.
0
 
Web_AdminAuthor Commented:
Thanks all for ur time :) points divided :)
0
 
CEHJCommented:
:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.