Padmanabha Mishra
2013-01-25 05:07:19 UTC
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]
"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]