[jboss-user] [Beginner's Corner] - unable to reconnect to DB in Hibernate after database server restarted

[Padmanabha Mishra]

Padmanabha Mishra [https://community.jboss.org/people/padma818] created the discussion

"unable to reconnect to DB in Hibernate after database server restarted"

To view the discussion, visit: https://community.jboss.org/message/794212#794212

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

Reply to this message by going to Community
[https://community.jboss.org/message/794212#794212]

Start a new discussion in Beginner's Corner at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2075]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130125/81e9354d/attachment.html