Hibernate version:
3.2.1

Name and version of the database you are using:
MySQL 4.x


I'm relatively new to Hibernate, so I was hoping to get some help on this...it should be easy but I just can't figure it out!

So here's the problem: I am not able to detect if the database connection settings are incorrect until I try to interact with the database (save, query, delete, etc.). I would like to be able to tell when I first open the Session. The odd thing is that when I open the Session, an exception (SQLException) is logged from the org.hibernate.cfg.SettingsFactory object with the text 'Could not obtain connection metadata' but it is consumed and handled before it gets to my code.

I am having this problem with both an incorrect IP address (SQLState error 08S01) and incorrect login information with the correct database IP. For an incorrect IP address, I can't handle the error until the database connection times out twice (one for the Session creation, one for a query) which is a long time to wait.

Background: I am setting up the connection manually by creating a Configuration object and setting up the properties, then I add the mapping file to the Configuration object (addResource), then I build the SessionFactory, and then use the factory to open the Session. It works fine when I have the correct connection settings defined.

Any help would be greatly appreciated!!!

why can't you do the check yourself before creating the session factory

http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Connection.html#getMetaData()

I think what you are saying will solve my problem, but I don't know how to get access to the Connection object (for some reason, I feel really dumb saying that...it will probably hit me like a ton of bricks once I see what's going on!)

I currently go through the following steps before getting a Session object via factory.openSession():
1. Create a Configuration object
2. Use the 'setProperty' method on the Configuration object for db IP, port, user, password
3. Use the 'addResource' method on the Configuration object to set the mapping file
4. Create a SessionFactory using the 'buildSessionFactory' method on the Connection object
5. Create the session using the 'openSession' method on the SessionFactory object
6. Interact with the Session object (.save(), etc)

Is there a different way I should be initiating the connection manually? Thank you for your quick response and it seems like the issue is close to being solved!

after creating sessionFactory in step 5 do
Connection connection = mySessionFactory.openSession.connection();
// test connection

Thanks for the help...I never would have thought about doing that. Is that a standard thing to do when setting up a connection?

As a side note, the 'getMetaData()' API says that it can throw a SQLException, but my catch method never catches it. If I catch just an Exception, then it works. It appears that the SQLException is being wrapped by org.hibernate.exception.GenericJDBCException? ...in the stack trace, the GenericJDBCException has the text 'Caused by: java.sql.SQLException: Access denied for user 'wronguser'@192.168.1.98 '. Not that it is important to answer this, but this was another thing that I found odd.