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

      query = session.createSQLQuery("select {category.*} from category {category} where {category}.name in (:names)", "category", Category.class);
      str = new String[] { "WannaBeFound" };
      query.setParameterList("names", str);
      query.uniqueResult();


      query = session.createSQLQuery("select {category.*} from category {category} where {category}.name in :names", "category", Category.class);
      query.setParameterList("names", str);      
      query.uniqueResult();


      session.connection().commit();
      session.close();

View Full Code Here

    s.flush();
    s.connection().commit();
    s.close();


    s = openSession();
    List list = s.createSQLQuery("select {category.*} from category {category}", "category", Category.class).list();
    list.get(0);
    s.connection().commit();
    s.close();
    
    if ( getDialect() instanceof MySQLDialect ) return;

View Full Code Here

    s.close();


    if ( getDialect() instanceof MySQLDialect ) return;


    s = openSession();
    List list = s.createSQLQuery("select {category.*}, {assignable.*} from category {category}, \"assign-able\" {assignable}", new String[] { "category", "assignable" }, new Class[] { Category.class, Assignable.class }).list();


    assertTrue(list.size() == 6); // crossproduct of 2 categories x 3 assignables
    assertTrue(list.get(0) instanceof Object[]);
    s.connection().commit();
    s.close();

View Full Code Here

    s.flush();
    s.connection().commit();
    s.close();


    s = openSession();
    Query basicParam = s.createSQLQuery("select {category.*} from category {category} where {category}.name = 'Best'", "category", Category.class);
    List list = basicParam.list();
    assertEquals(1, list.size());


    Query unnamedParam = s.createSQLQuery("select {category.*} from category {category} where {category}.name = ? or {category}.name = ?", "category", Category.class);
    unnamedParam.setString(0, "Good");

View Full Code Here

    s = openSession();
    Query basicParam = s.createSQLQuery("select {category.*} from category {category} where {category}.name = 'Best'", "category", Category.class);
    List list = basicParam.list();
    assertEquals(1, list.size());


    Query unnamedParam = s.createSQLQuery("select {category.*} from category {category} where {category}.name = ? or {category}.name = ?", "category", Category.class);
    unnamedParam.setString(0, "Good");
    unnamedParam.setString(1, "Best");
    list = unnamedParam.list();
    assertEquals(2, list.size());

View Full Code Here

    unnamedParam.setString(0, "Good");
    unnamedParam.setString(1, "Best");
    list = unnamedParam.list();
    assertEquals(2, list.size());


    Query namedParam = s.createSQLQuery("select {category.*} from category {category} where ({category}.name=:firstCat or {category}.name=:secondCat)", "category", Category.class);
    namedParam.setString("firstCat", "Better");
    namedParam.setString("secondCat", "Best");
    list = namedParam.list();
    assertEquals(2, list.size());

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

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.