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.

Hi all ,
I found the solution to my previous post.
The following configuration solved my problem

<property name="hibernate.dbcp.validationQuery">SELECT 1 FROM DUAL</property>
<property name="hibernate.dbcp.testOnBorrow">true</property>