Can I do a reconnection in my execption handling to all of the database operations? Do I need to rebuild the session factory?

Example below:

public abstract class AbstractEntityDao {
...
final public List<Object[]> select(String inSql, String whereClause) {
...
Retry connection 5 times in while

while (retryConn)
{

try{
session = HibernateSessionFactory.currentSession();
tx = session.beginTransaction();
Query objQuery = session.createSQLQuery();
res = objQuery.list();

retryConn = false;

} catch (JDBCConnectionException e) {

if(numOfRetries <= 5)
{
tx.rollback();
session.close();
numOfRetries++;
retryConn = true;
}
} catch (Exception e) {
retryConn = false;
log.error(e.getMessage(), e);
}
} // end while
}

Thanks

Such work is actually job of the connection-provider (hibernate.connection.provider_class) or DataSource and you should not take care about in your business code.For example many connection-providers do/can check their pooled connections regularily to see, if they are still alive (connected).