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


     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

  private void componentTest(String sql) throws SQLException {
        Session session = openSession();
      
      Componentizable c = setupComponentData( session );
        
      Query q = session.createSQLQuery(sql, "comp", Componentizable.class);
      List list = q.list();
      
      assertEquals(list.size(),1);
      
      Componentizable co = (Componentizable) list.get(0);

View Full Code Here

    Category s = new Category();
    s.setName(String.valueOf(nextLong++));
    session.save(s);
    session.flush();


    Query query = session.createSQLQuery("select s.category_key_col as {category.id}, s.name as {category.name}, s.\"assign-able-id\" as {category.assignable} from {category} s", "category", Category.class);
    List list = query.list();


    assertNotNull(list);
    assertTrue(list.size() > 0);
    assertTrue(list.get(0) instanceof Category);

View Full Code Here


    if ( getDialect() instanceof MySQLDialect ) return;


    session = openSession();


    Query query = session.createSQLQuery("select s.category_key_col as {category.id}, s.name as {category.name}, s.\"assign-able-id\" as {category.assignable} from {category} s", "category", Category.class);
    List list = query.list();


    assertNotNull(list);
    assertTrue(list.size() > 0);
    assertTrue(list.get(0) instanceof Category);

View Full Code Here


    B savedB = new B();
    session.save(savedB);
    session.flush();


    Query query = session.createSQLQuery("select identifier_column as {a.id}, clazz_discriminata as {a.class}, name as {a.name}, count_ as {a.count} from TA {a}", "a", A.class);
    List list = query.list();


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

View Full Code Here

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


    session = openSession();


    Query query = session.createSQLQuery("select identifier_column as {a.id}, clazz_discriminata as {a.class}, count_ as {a.count}, name as {a.name} from TA", "a", A.class);
    List list = query.list();


    assertNotNull(list);
    assertEquals(count, list.size());
    session.connection().commit();

View Full Code Here

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


        s = openSession();
        // having a composite id with one property named id works since the map used by sqlloader to map names to properties handles it.
        Query query = s.createSQLQuery("select system as {c.system}, id as {c.id}, name as {c.name}, foo as {c.composite.foo}, bar as {c.composite.bar} from CompositeIdId where system=? and id=?", "c", CompositeIdId.class);
        query.setString(0, "c64");
        query.setString(1, "games");


        CompositeIdId id2 = (CompositeIdId) query.uniqueResult();
        check(id, id2);

View Full Code Here

    Session session = openSession();
    Transaction txn = session.beginTransaction();
    Simple sim = new Simple();
    sim.setDate( new Date() );
    session.save( sim, new Long(1) );
    Query q = session.createSQLQuery("select {sim.*} from Simple {sim} where {sim}.date_ = ?", "sim", Simple.class);
    q.setTimestamp( 0, sim.getDate() );
    assertTrue ( q.list().size()==1 );
    session.delete(sim);
    txn.commit();
    session.close();

View Full Code Here


    B b = new B();
    session.save(b);
    session.flush();


    session.createSQLQuery("select {category.*} from category {category}", "category", Category.class).list();
    session.createSQLQuery("select {simple.*} from Simple {simple}", "simple", Simple.class).list();
    session.createSQLQuery("select {a.*} from TA {a}", "a", A.class).list();


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

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.