Package org.hibernate.classic

Examples of org.hibernate.classic.Session.createQuery()

704
705
706
707
708
709
710
711
712
713
714
    assertEquals( "Incorrect discrim subclass update count", 1, count );

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

    count = s.createQuery( "update PettingZoo pz set pz.name = pz.name where pz.id = :id" )
        .setLong( "id", data.pettingZoo.getId().longValue() )
        .executeUpdate();
    assertEquals( "Incorrect discrim subclass update count", 1, count );

    t.rollback();
View Full Code Here
712
713
714
715
716
717
718
719
720
721
722
    assertEquals( "Incorrect discrim subclass update count", 1, count );

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

    count = s.createQuery( "update Zoo as z set z.name = z.name" ).executeUpdate();
    assertEquals( "Incorrect discrim subclass update count", 2, count );

    t.rollback();
    t = s.beginTransaction();
View Full Code Here
720
721
722
723
724
725
726
727
728
729
730
    t.rollback();
    t = s.beginTransaction();

    // TODO : not so sure this should be allowed.  Seems to me that if they specify an alias,
    // property-refs should be required to be qualified.
    count = s.createQuery( "update Zoo as z set name = name where id = :id" )
        .setLong( "id", data.zoo.getId().longValue() )
        .executeUpdate();
    assertEquals( "Incorrect discrim subclass update count", 1, count );

    t.commit();
View Full Code Here
737
738
739
740
741
742
743
744
745
746
747
    TestData data = new TestData();
    data.prepare();

    Session s = openSession();
    Transaction t = s.beginTransaction();
    int count = s.createQuery( "update Animal set description = description where description = :desc" )
        .setString( "desc", data.frog.getDescription() )
        .executeUpdate();
    assertEquals( "Incorrect entity-updated count", 1, count );

    count = s.createQuery( "update Animal set description = :newDesc where description = :desc" )
View Full Code Here
742
743
744
745
746
747
748
749
750
751
752
    int count = s.createQuery( "update Animal set description = description where description = :desc" )
        .setString( "desc", data.frog.getDescription() )
        .executeUpdate();
    assertEquals( "Incorrect entity-updated count", 1, count );

    count = s.createQuery( "update Animal set description = :newDesc where description = :desc" )
        .setString( "desc", data.polliwog.getDescription() )
        .setString( "newDesc", "Tadpole" )
        .executeUpdate();
    assertEquals( "Incorrect entity-updated count", 1, count );
View Full Code Here
751
752
753
754
755
756
757
758
759
760
761
    assertEquals( "Incorrect entity-updated count", 1, count );

    Animal tadpole = ( Animal ) s.load( Animal.class, data.polliwog.getId() );
    assertEquals( "Update did not take effect", "Tadpole", tadpole.getDescription() );

    count = s.createQuery( "update Animal set bodyWeight = bodyWeight + :w1 + :w2" )
        .setDouble( "w1", 1 )
        .setDouble( "w2", 2 )
        .executeUpdate();
    assertEquals( "incorrect count on 'complex' update assignment", count, 6 );
View Full Code Here
759
760
761
762
763
764
765
766
767
768
769
        .executeUpdate();
    assertEquals( "incorrect count on 'complex' update assignment", count, 6 );

    if ( ! ( getDialect() instanceof MySQLDialect ) ) {
      // MySQL does not support (even un-correlated) subqueries against the update-mutating table
      s.createQuery( "update Animal set bodyWeight = ( select max(bodyWeight) from Animal )" )
          .executeUpdate();
    }

    t.commit();
    s.close();
View Full Code Here
776
777
778
779
780
781
782
783
784
785
786
    data.prepare();

    Session s = openSession();
    Transaction t = s.beginTransaction();

    int count = s.createQuery( "update Mammal set description = description" ).executeUpdate();
    assertEquals( "incorrect update count against 'middle' of joined-subclass hierarchy", 2, count );

    count = s.createQuery( "update Mammal set bodyWeight = 25" ).executeUpdate();
    assertEquals( "incorrect update count against 'middle' of joined-subclass hierarchy", 2, count );
View Full Code Here
779
780
781
782
783
784
785
786
787
788
789
    Transaction t = s.beginTransaction();

    int count = s.createQuery( "update Mammal set description = description" ).executeUpdate();
    assertEquals( "incorrect update count against 'middle' of joined-subclass hierarchy", 2, count );

    count = s.createQuery( "update Mammal set bodyWeight = 25" ).executeUpdate();
    assertEquals( "incorrect update count against 'middle' of joined-subclass hierarchy", 2, count );

    if ( ! ( getDialect() instanceof MySQLDialect ) ) {
      // MySQL does not support (even un-correlated) subqueries against the update-mutating table
      count = s.createQuery( "update Mammal set bodyWeight = ( select max(bodyWeight) from Animal )" ).executeUpdate();
View Full Code Here
784
785
786
787
788
789
790
791
792
793
794
    count = s.createQuery( "update Mammal set bodyWeight = 25" ).executeUpdate();
    assertEquals( "incorrect update count against 'middle' of joined-subclass hierarchy", 2, count );

    if ( ! ( getDialect() instanceof MySQLDialect ) ) {
      // MySQL does not support (even un-correlated) subqueries against the update-mutating table
      count = s.createQuery( "update Mammal set bodyWeight = ( select max(bodyWeight) from Animal )" ).executeUpdate();
      assertEquals( "incorrect update count against 'middle' of joined-subclass hierarchy", 2, count );
    }

    t.commit();
    s.close();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.