Examples of org.hibernate.classic.Session.createSQLQuery()

org.hibernate.classic.Session.createSQLQuery()
Create a new instance of Query for the given SQL string. @deprecated will be replaced with a more Query like interface in later release @param sql a query expressed in SQL @param returnAlias a table alias that appears inside {} in the SQL string @param returnClass the returned persistent class

    int count = session.createQuery("from A").list().size();
    session.close();


    session = openSession();


    Query query = session.createSQLQuery("select a.identifier_column as {a1.id}, a.clazz_discriminata as {a1.class}, a.count_ as {a1.count}, a.name as {a1.name} " +
                      ", b.identifier_column as {a2.id}, b.clazz_discriminata as {a2.class}, b.count_ as {a2.count}, b.name as {a2.name} " +
                      " from TA a, TA b" +
                      " where a.identifier_column = b.identifier_column", new String[] {"a1", "a2" }, new Class[] {A.class, A.class});
    List list = query.list();

View Full Code Here

     session.flush();
     session.connection().commit();


     session.clear();


     Query query = session.createSQLQuery("select {sing.*} from Single {sing}", "sing", Single.class);


     List list = query.list();


     assertTrue(list.size()==1);

View Full Code Here


     assertTrue(list.size()==1);


     session.clear();


     query = session.createSQLQuery("select {sing.*} from Single {sing} where sing.id = ?", "sing", Single.class);
     query.setString(0, "my id");
     list = query.list();


     assertTrue(list.size()==1);

View Full Code Here


     assertTrue(list.size()==1);


     session.clear();


     query = session.createSQLQuery("select s.id as {sing.id}, s.string_ as {sing.string}, s.prop as {sing.prop} from Single s where s.id = ?", "sing", Single.class);
     query.setString(0, "my id");
     list = query.list();


     assertTrue(list.size()==1);

View Full Code Here


     assertTrue(list.size()==1);


     session.clear();


     query = session.createSQLQuery("select s.id as {sing.id}, s.string_ as {sing.string}, s.prop as {sing.prop} from Single s where s.id = ?", "sing", Single.class);
     query.setString(0, "my id");
     list = query.list();


     assertTrue(list.size()==1);

View Full Code Here


    Query query;
    if( getDialect() instanceof TimesTenDialect) {
            // TimesTen does not permit general expressions (like UPPER) in the second part of a LIKE expression,
            // so we execute a similar test 
            query = session.createSQLQuery("select identifier_column as {a.id}, clazz_discriminata as {a.class}, count_ as {a.count}, name as {a.name} from TA where {fn ucase(name)} like 'MAX'", "a", A.class);
        } else {
            query = session.createSQLQuery("select identifier_column as {a.id}, clazz_discriminata as {a.class}, count_ as {a.count}, name as {a.name} from TA where {fn ucase(name)} like {fn ucase('max')}", "a", A.class);
        }
    List list = query.list();

View Full Code Here

    if( getDialect() instanceof TimesTenDialect) {
            // TimesTen does not permit general expressions (like UPPER) in the second part of a LIKE expression,
            // so we execute a similar test 
            query = session.createSQLQuery("select identifier_column as {a.id}, clazz_discriminata as {a.class}, count_ as {a.count}, name as {a.name} from TA where {fn ucase(name)} like 'MAX'", "a", A.class);
        } else {
            query = session.createSQLQuery("select identifier_column as {a.id}, clazz_discriminata as {a.class}, count_ as {a.count}, name as {a.name} from TA where {fn ucase(name)} like {fn ucase('max')}", "a", A.class);
        }
    List list = query.list();


    assertNotNull(list);
    assertEquals(1, list.size());

View Full Code Here

    int count = session.createQuery("from A").list().size();
    session.close();


    session = openSession();


    Query query = session.createSQLQuery("select a.identifier_column as {a1.id}, a.clazz_discriminata as {a1.class}, a.count_ as {a1.count}, a.name as {a1.name} " +
                      ", b.identifier_column as {a2.id}, b.clazz_discriminata as {a2.class}, b.count_ as {a2.count}, b.name as {a2.name} " +
                      " from TA a, TA b" +
                      " where a.identifier_column = b.identifier_column", new String[] {"a1", "a2" }, new Class[] {A.class, A.class});
    List list = query.list();

View Full Code Here

     session.flush();
     session.connection().commit();


     session.clear();


     Query query = session.createSQLQuery("select {sing.*} from Single {sing}", "sing", Single.class);


     List list = query.list();


     assertTrue(list.size()==1);

View Full Code Here


     assertTrue(list.size()==1);


     session.clear();


     query = session.createSQLQuery("select {sing.*} from Single {sing} where sing.id = ?", "sing", Single.class);
     query.setString(0, "my id");
     list = query.list();


     assertTrue(list.size()==1);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.