Integration

Hi,

Can somebody from the Development team for Sun One webserver 6.1 answer my query? This is really urgent.

I am using Sun One Web Server 6.1 and Oracle 8.1.7. The application I have developed fetches some data from the database tables and displays to the user in a JSP page.
After starting the Sun One Web Server 6.1, the application runs fine for sometime (2-3 hours), after that I get an error like :-
java.sql.SQLException: Io exception: Connection reset
The Error code is :- 17002
After getting this error once, I keep getting it, till I re-start the web server again. Hence the application cannot be accessed during this time. The only solution is to restart the web-server again.
This re-starting of web server has to be done 10-12 times per day. This has become a major issue of concern in production.

The code for getting the connection is as follows:-
/**********
private static DataSource m_DsCIF = (javax.sql.DataSource) (new InitialContext()).lookup(m_DsnName);
Connection l_Conn = m_DsCIF.getConnection();
**********/

All the code is with in try-catch and I have closed all the ResultSets, Statements and Connection objects in the "finally" block.

I have tried with both class12.zip and ojdbc14.jar drivers, but this error persisted.
I am not able to find out the exact reason as to why this error is occuring. I have searched forums and no where has the reply been satisfactory.

Please help....

Thanks,
Anjali.