unable to reconnect to DB in Hibernate after database server restarted

[Padmanabha Mishra]

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.

[Padmanabha Mishra]

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>