Hi, I have an Rich Client Applictation (RCP) which uses Hibernate.

I want individual users to access the underlying DB with their corresponding accounts.
I create a new Hibernate Configuration, letting it populate all properties from the standard hibernate conf xml file, but before creating the SessionFactory, i set the username/password properties programmatically, and then create the Factory.

This works well if username and password are correct.

However, if they are not, I have no way to catch Exceptions while Hibernate or the connection pooling I'm using (c3po) throws Exceptions, since they seem to be catched by Hibernate, and it seems that my app runs into timeouts before any stacktraces are written to err.out. I have no chance to provide feedback to the user.

What I want is this: just after my application launches, ask the user for his DB username and password (a classic login screen), and then configure Hibernate to use those credentials. If they are ok, run the application. If they are not, prompt the ueser with info that his credentials are wrong.

How should I do this ? Obviously, the way I'm doing it now is the wrong approach.

Thanks for any suggestions.

the getConnection of the DataSource throws SQLException[1], which would be wrapped with HibernateException. So, you should look at
the cause and make out whether the username/password is correct. For example:

try{
session.saveOrUpdate(object);
} catch(HibernateException e) {
Throwable cause = e.getCause();
if(cause instanceof SQLException) {
SQLExeption sqlEx = (SQLException) cause;
// check the vendor code/sql state to identify the login/password is correct.
}
}

[1] http://www.mchange.com/projects/c3p0/ap ... ang.String,
java.lang.String)

Or maybe just try to connect using direct jdbc with the given credentials, then only use these credentials in Hibernate if you could for example perform a query like "select 1 from dual" on an Oracle dbms?