public static int updateNaturalOrderForPipeline(Session session, Long pipelineId, double naturalOrder) { String sql = "UPDATE pipelines SET naturalOrder = :naturalOrder WHERE id = :pipelineId"; SQLQuery query = session.createSQLQuery(sql); query.setLong("pipelineId", pipelineId); query.setDouble("naturalOrder", naturalOrder); return query.executeUpdate(); }
public int getSchemaVersion() throws DataAccessException { return (Integer) getHibernateTemplate().execute((HibernateCallback) session -> session.createSQLQuery("select max(change_number) from changelog").uniqueResult()); } }
private void dropTable() { Session session = openSession(); Transaction transaction = session.beginTransaction(); Query query = session.createSQLQuery( "DROP TABLE IF EXISTS MyEntity;" ); query.executeUpdate(); transaction.commit(); session.close(); }
private void createTable() { Session session = openSession(); Transaction transaction = session.beginTransaction(); Query query = session.createSQLQuery( "CREATE TABLE MyEntity(id bigint, name varchar(255));" ); query.executeUpdate(); transaction.commit(); session.close(); }
private void createFunctionIndex() { Session session = openSession(); Transaction transaction = session.beginTransaction(); Query query = session.createSQLQuery( "CREATE UNIQUE INDEX uk_MyEntity_name_lowercase ON MyEntity (lower(name));" ); query.executeUpdate(); transaction.commit(); session.close(); }
private void printConfig() { String sql = "select value from V$NLS_PARAMETERS where parameter = 'NLS_CHARACTERSET'"; Session session = openSession(); session.beginTransaction(); Query query = session.createSQLQuery( sql ); String s = (String) query.uniqueResult(); log.debug( "Using Oracle charset " + s ); } }
@After public void cleanup() { doInHibernate( this::sessionFactory, session -> { session.createSQLQuery( "delete from MATERIAL_RATINGS" ).executeUpdate(); session.createSQLQuery( "delete from BUILDING_RATINGS" ).executeUpdate(); session.createSQLQuery( "delete from ASSOCIATION_TABLE" ).executeUpdate(); session.createSQLQuery( "delete from MAIN_TABLE" ).executeUpdate(); } ); }
private long getTableRowCount(Session s, String tableName) { // the type returned for count(*) in a native query depends on the dialect // Oracle returns Types.NUMERIC, which is mapped to BigDecimal; // H2 returns Types.BIGINT, which is mapped to BigInteger; Object retVal = s.createSQLQuery( "select count(*) from " + tableName ).uniqueResult(); assertTrue( Number.class.isInstance( retVal ) ); return ( ( Number ) retVal ).longValue(); }
@After public void cleanup() { Session session = openSession(); session.beginTransaction(); { session.createSQLQuery( "delete from MATERIAL_RATINGS" ).executeUpdate(); session.createSQLQuery( "delete from COLLECTION_TABLE" ).executeUpdate(); session.createSQLQuery( "delete from MAIN_TABLE" ).executeUpdate(); } session.getTransaction().commit(); session.close(); }
@After public void cleanup() { Session session = openSession(); session.beginTransaction(); { session.createSQLQuery( "delete from MATERIAL_RATINGS" ).executeUpdate(); session.createSQLQuery( "delete from COLLECTION_TABLE" ).executeUpdate(); session.createSQLQuery( "delete from MAIN_TABLE" ).executeUpdate(); } session.getTransaction().commit(); session.close(); }
@After public void cleanup() { Session session = openSession(); session.beginTransaction(); { session.createSQLQuery( "delete from MATERIAL_RATINGS" ).executeUpdate(); session.createSQLQuery( "delete from COLLECTION_TABLE" ).executeUpdate(); session.createSQLQuery( "delete from MAIN_TABLE" ).executeUpdate(); } session.getTransaction().commit(); session.close(); }
private List<Object[]> retrieveTimeline(Session session, PipelineTimeline pipelineTimeline) { SQLQuery query = session.createSQLQuery(queryExtensions.retrievePipelineTimeline()); query.setLong(0, pipelineTimeline.maximumId()); List<Object[]> matches = loadTimeline(query); sortTimeLineByPidAndPmrId(matches); return matches; }
@Test @RequiresDialect(MySQL5Dialect.class) public void testEscapeColonInSQL() throws QueryException { Session s = openSession(); Transaction t = s.beginTransaction(); SQLQuery query = s.createSQLQuery( "SELECT @row \\:= 1" ); List list = query.list(); assertTrue( list.get( 0 ).toString().equals( "1" ) ); t.commit(); s.close(); }
@After public void tearDown() { TransactionUtil.doInHibernate( this::sessionFactory, session -> { session.createSQLQuery( "DROP SYNONYM test_synonym FORCE" ).executeUpdate(); }); }
@After public void cleanup() { doInHibernate( this::sessionFactory, session -> { session.createSQLQuery( "delete from MAIN_TABLE" ).executeUpdate(); } ); }
@Before public void setUp() { TransactionUtil.doInHibernate( this::sessionFactory, session -> { session.createSQLQuery( "CREATE VIEW test_synonym AS SELECT * FROM test_entity" ).executeUpdate(); } ); }
@Test @FailureExpected(jiraKey = "HHH-2225") public void testNativeQueryWithFormulaAttributeWithoutAlias() { String sql = "select TABLE_NAME , sysdate() from all_tables where TABLE_NAME = 'AUDIT_ACTIONS' "; Session s = openSession(); s.beginTransaction(); s.createSQLQuery( sql ).addEntity( "t", AllTables.class ).list(); s.getTransaction().commit(); s.close(); }
@After public void cleanup() { doInHibernate( this::sessionFactory, session -> { session.createSQLQuery( "delete from MAIN_TABLE" ).executeUpdate(); } ); }
@Before public void setUp() { TransactionUtil.doInHibernate( this::sessionFactory, session -> { session.createSQLQuery( "CREATE SYNONYM test_synonym FOR test_entity" ).executeUpdate(); } ); }
@After public void tearDown() { TransactionUtil.doInHibernate( this::sessionFactory, session -> { session.createSQLQuery( "DROP VIEW test_synonym CASCADE" ).executeUpdate(); } ); }