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.
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>
Retrieving data ...