Package org.hibernate.test.sql.hand

Examples of org.hibernate.test.sql.hand.Organization

32
33
34
35
36
37
38
39
40
41
42
  }

  public void testBadInsertionFails() {
    Session session = openSession();
    session.beginTransaction();
    Organization org = new Organization( "hola!" );
    try {
      session.save( org );
      session.delete( org );
      fail( "expecting bad custom insert statement to fail" );
    }
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
    s.beginTransaction();

    sfi().getStatistics().clear();

    // create an Organization...
    Organization jboss = new Organization( "JBoss" );
    s.persist( jboss );

    // now query on Employment, this should not cause an auto-flush
    s.createSQLQuery( getEmploymentSQL() ).list();
    assertEquals( 0, sfi().getStatistics().getEntityInsertCount() );
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
152
  }

  public void testSQLQueryInterface() {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Organization ifa = new Organization("IFA");
    Organization jboss = new Organization("JBoss");
    Person gavin = new Person("Gavin");
    Employment emp = new Employment(gavin, jboss, "AU");

    s.persist(ifa);
    s.persist(jboss);
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
209
  }

  public void testResultSetMappingDefinition() {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Organization ifa = new Organization("IFA");
    Organization jboss = new Organization("JBoss");
    Person gavin = new Person("Gavin");
    Employment emp = new Employment(gavin, jboss, "AU");

    s.persist(ifa);
    s.persist(jboss);
View Full Code Here
231
232
233
234
235
236
237
238
239
240
241
242
  public void testScalarValues() throws Exception {
    Session s = openSession();
    Transaction t = s.beginTransaction();

    Organization ifa = new Organization( "IFA" );
    Organization jboss = new Organization( "JBoss" );

    Serializable idIfa = s.save( ifa );
    Serializable idJBoss = s.save( jboss );

    s.flush();
View Full Code Here
306
307
308
309
310
311
312
313
314
315
316
317
  }

  public void testMappedAliasStrategy() {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Organization ifa = new Organization("IFA");
    Organization jboss = new Organization("JBoss");
    Person gavin = new Person("Gavin");
    Employment emp = new Employment(gavin, jboss, "AU");
    Serializable orgId = s.save(jboss);
    Serializable orgId2 = s.save(ifa);
    s.save(gavin);
View Full Code Here
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
  }

  public void testAutoDetectAliasing() {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Organization ifa = new Organization("IFA");
    Organization jboss = new Organization("JBoss");
    Person gavin = new Person("Gavin");
    Employment emp = new Employment(gavin, jboss, "AU");
    Serializable orgId = s.save(jboss);
    Serializable orgId2 = s.save(ifa);
    s.save(gavin);
    s.save(emp);
    t.commit();
    s.close();

    s = openSession();
    t = s.beginTransaction();
    List list = s.createSQLQuery( getEmploymentSQL() )
        .addEntity( Employment.class.getName() )
        .list();
    assertEquals( 1,list.size() );

    Employment emp2 = (Employment) list.get(0);
    assertEquals(emp2.getEmploymentId(), emp.getEmploymentId() );
    assertEquals(emp2.getStartDate().getDate(), emp.getStartDate().getDate() );
    assertEquals(emp2.getEndDate(), emp.getEndDate() );

    s.clear();

    list = s.createSQLQuery( getEmploymentSQL() )
    .addEntity( Employment.class.getName() )
    .setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP)
    .list();
    assertEquals( 1,list.size() );
    Map m = (Map) list.get(0);
    assertTrue(m.containsKey("Employment"));
    assertEquals(1,m.size());

    list = s.createSQLQuery(getEmploymentSQL()).list();
    assertEquals(1, list.size());
    Object[] o = (Object[]) list.get(0);
    assertEquals(8, o.length);

    list = s.createSQLQuery( getEmploymentSQL() ).setResultTransformer( new UpperCasedAliasToEntityMapResultTransformer() ).list();
    assertEquals(1, list.size());
    m = (Map) list.get(0);
    assertTrue(m.containsKey("EMPID"));
    assertTrue(m.containsKey("VALUE"));
    assertTrue(m.containsKey("ENDDATE"));
    assertEquals(8, m.size());

    list = s.createSQLQuery( getEmploymentSQLMixedScalarEntity() ).addScalar( "employerid" ).addEntity( Employment.class ).list();
    assertEquals(1, list.size());
    o = (Object[]) list.get(0);
    assertEquals(2, o.length);
    assertClassAssignability( o[0].getClass(), Number.class);
    assertClassAssignability( o[1].getClass(), Employment.class);



    Query queryWithCollection = s.getNamedQuery("organizationEmploymentsExplicitAliases");
    queryWithCollection.setLong("id",  jboss.getId() );
    list = queryWithCollection.list();
    assertEquals(list.size(),1);

    s.clear();
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
  }

  public void testBadInsertionFails() {
    Session session = openSession();
    session.beginTransaction();
    Organization org = new Organization( "hola!" );
    try {
      session.save( org );
      session.delete( org );
      fail( "expecting bad custom insert statement to fail" );
    }
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
    s.beginTransaction();

    sfi().getStatistics().clear();

    // create an Organization...
    Organization jboss = new Organization( "JBoss" );
    s.persist( jboss );

    // now query on Employment, this should not cause an auto-flush
    s.createSQLQuery( getEmploymentSQL() ).list();
    assertEquals( 0, sfi().getStatistics().getEntityInsertCount() );
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
153
  }

  public void testSQLQueryInterface() {
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Organization ifa = new Organization("IFA");
    Organization jboss = new Organization("JBoss");
    Person gavin = new Person("Gavin");
    Employment emp = new Employment(gavin, jboss, "AU");

    s.persist(ifa);
    s.persist(jboss);
View Full Code Here
TOP

Related Classes of org.hibernate.test.sql.hand.Organization

  • org.hibernate.test.sql.hand.custom.CustomSQLTestSupport
  • org.hibernate.test.sql.hand.custom.CustomStoredProcTestSupport
  • org.hibernate.test.sql.hand.identity.CustomInsertSQLWithIdentityColumnTest
  • org.hibernate.test.sql.hand.query.NativeSQLQueriesTest
  • java.util.HashSet
    • Copyright © 2018 www.massapicom. 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.