String configFile           = "./hibernate.cfg.xml";
SOSHibernateFactory factory = null;
SOSHibernateSession session = null;

try
{
    factory = new SOSHibernateFactory(configFile);
    factory.build();
     
    // session = factory.openSession();     
    // session = factory.getCurrentSession();     
    session = factory.openStatelessSession();
     
    session.beginTransaction();
    ....
    session.commit();
} 
 
catch( Exception e ) 
{
    if ( session != null )
    {
        try
        {
            session.rollback();
        } 
 
		catch( Exception ex ) {}
	} 
    throw e;
}
finally
{
    if ( session != null )
    {
        session.close();
    }
    
    if ( factory != null )
    {
        factory.close();
    }
}

...
ScrollableResults sr = null;

try
{
    // Query or NativeQuery
    Query<?> query = session.createQuery("from MY_DBITEM_ENTITY");
    sr = session.scroll(query);             
    while (sr.next()) {                 
        // do something with the current record            
    }
}

catch( Exception e )
{
    throw e;
}

finally
{
    if ( sr != null ){
       sr.close(); 
    }
}             
...

...
executor = session.getSQLExecutor();
...    
ResultSet rs = null;

try
{
    rs = executor.getResultSet("select * from MY_TABLE");             
    Map<String, String> record = null;             
    while (!(record = executor.nextAsStringMap(rs)).isEmpty()) { //or ... executor.next(rs) ...               
        // do something with the current record            
    }
}

catch(Exception e)
{
    throw e;
}

finally
{
    executor.close(rs); 
}             
     
...