Hibernate Community • View topic - Determine if db-connection fails

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Determine if db-connection fails

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

JonnyRico

Post subject: Determine if db-connection fails

Posted: Tue Mar 30, 2010 4:07 pm

Beginner

Joined: Wed Mar 03, 2010 4:06 am
Posts: 21

Hi,

i'd like do know if the db connection could be established when my program starts up. I thought I can just handle the exception in the class "HibernateUtil" while creating the session factory but unfortunately it doesn't work. Hibernate throws a nested exception and i can't catch it.
There must be a better way to check the connection-state than performing a sql-statement right? May anybody give me a piece of advise? Thanks a lot.

Jonny

Top

pb00067

Post subject: Re: Determine if db-connection fails

Posted: Wed Mar 31, 2010 9:16 am

Expert

Joined: Tue Jun 16, 2009 3:36 am
Posts: 990

Once you have builded the sessionfactory you can test the connection to the database in following way:

Code:

try {
    java.sql.Connection conn =
   ((org.hibernate.impl.SessionFactoryImpl) sessionfactory).getConnectionProvider().getConnection();
    conn.close();  // connection was sucessfull, closing it again (frees resources !)
}
catch Exception (x) {
    sys.err ("Connection to database could not be established: " + x.toString());
}

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum