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

    assertEquals(1,s.getNamedQuery( "native-delete-car" ).setString( 0, "NotKirsten" ).executeUpdate());
    
    
    assertEquals(0,s.createSQLQuery( "delete from SUV where owner = :owner" ).setString( "owner", "NotThere" ).executeUpdate());
    assertEquals(1,s.createSQLQuery( "delete from SUV where owner = :owner" ).setString( "owner", "Joe" ).executeUpdate());
    s.createSQLQuery( "delete from Pickup" ).executeUpdate();


    l = s.createQuery("from Vehicle").list();
    assertEquals(l.size(),0);

View Full Code Here


    s = getFactory().openSession();
    t = s.beginTransaction();
    
    // Check value conversion on insert
    Double sizeViaSql = (Double)s.createSQLQuery("select size_mb from documents").uniqueResult();
    assertEquals( SIZE_IN_MB, sizeViaSql, 0.01d );


    // Test explicit fetch of all properties
    doc = (Document) s.createQuery("from Document fetch all properties").uniqueResult();
    assertTrue( Hibernate.isPropertyInitialized( doc, "sizeKb" ) );

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

    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

    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


      s = new Category();
      s.setName("WannaBeFound");
      session.flush();


      Query query = session.createSQLQuery("select {category.*} from category {category} where {category}.name = :name", "category", Category.class);


      query.setProperties(s);
      //query.setParameter("name", s.getName());


      query.list();

View Full Code Here

      query.setProperties(s);
      //query.setParameter("name", s.getName());


      query.list();


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


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

View Full Code Here

      query = session.createSQLQuery("select {category.*} from category {category} where {category}.name in (:names)", "category", Category.class);
      String[] str = new String[] { "WannaBeFound", "NotThere" };
      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();


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

View Full Code Here


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


      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);

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.