1 Reply Latest reply: Feb 10, 2013 11:58 PM by Padmanabha Mishra RSS

unable to reconnect to DB in Hibernate after database server restarted

Padmanabha Mishra Newbie

I have implemented hibernate in my web application to access oracle 10g database.

When my application is in running state I restarted my database service(Oracle).

 

Then my application is throwing exception   given below:

     java.sql.SQLException: No more data to read from socket

 

But my SessionFactory object still exist.

calling openSession() on sessionfactory is also fine.

This exception is coming while i m retriving a record from a table (example query.uniqresult())

I think its unable to reconnect to database.

 

please give me a solution.

 

Thanks,

Padmanabha.