I have a sessionEJB which create and active methods create connections to a database via JDBC. The EJB has a method call getData() that executes a query.
I also have a Web Application that in the first jsp creates an instance of the EJB and saves it into a session variable. In the second jsp, i get the EJB from the session variable and execute the method getData.
The EJB and WebApllication are deployed in Weblogic6.1.
The Database is shutdown every night.
In the case of weblogic6.1 in Windows plataform every thing is ok!. The problem is when the plaform is solaris. The database used is the same for Windowns and Solaris.
Every first time in a day that i try to use the web application, it throws the Exception: java.sql.SQLException: No more data to read from socket. the exception is throwned when i try to execute the method getData.
I stop the server(weblogic), start it and the problem disapears until the next morning!?!?
I am confused!!! Can anyone help me? It�s urgent!!!