1 Reply Latest reply on Feb 10, 2013 11:58 PM by padma818

    unable to reconnect to DB in Hibernate after database server restarted

    padma818

      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.