Table of Contents |
---|
Java Basic Samples
...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
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(); } } |
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
... 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(); } } ... |
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
... 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); } ... |
...
JavaScript
...
Job Samples
Samples
Hibernate Query
- SOSHibernateSession
- sos_hibernate_session_query_execute.job.xml
- sos_hibernate_session_query_results.job.xml
- sos_hibernate_session_native_query_results.job.xml
- SOSHibernateSQLExecutor( session.getSQLExecutor() )
PostgreSQL
...