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(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

        private static final long serialVersionUID = 1L;
        public Object execute(Environment environment) throws Exception {
          Session session = environment.get(Session.class);
          if (!PropertyImpl.propertiesTableExists(session)) {
            try {
              session.createSQLQuery("select CLASSNAME_ from JBPM4_VARIABLE").list();
              return JbpmVersion.V_4_1;


            } catch (HibernateException e) {
              return JbpmVersion.V_4_0;
            }

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

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.