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

        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

    Transaction t = s.beginTransaction();


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


    s.createSQLQuery( "insert into PICKUP (id, vin, owner) select id, vin, owner from Car" ).executeUpdate();


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


    t.commit();

View Full Code Here

    assertEquals(l.size(),5);


    t.commit();
    t = s.beginTransaction();


    s.createSQLQuery( "delete from TRUCK" ).executeUpdate();


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


    Car c = (Car) s.createQuery( "from Car where owner = 'Kirsten'" ).uniqueResult();

View Full Code Here

    c.setOwner("NotKirsten");
    assertEquals(0,s.getNamedQuery( "native-delete-car" ).setString( 0, "Kirsten" ).executeUpdate());
    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

    assertEquals(0,s.getNamedQuery( "native-delete-car" ).setString( 0, "Kirsten" ).executeUpdate());
    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

    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

    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

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.