File path: /hibernate-distribution-3.3.2.GA/project/testsuite/src/test/java/org/hibernate/test/dialect/functional/cache/SQLFunctionsInterSystemsTest.java | File path: /hibernate-distribution-3.3.2.GA/project/testsuite/src/test/java/org/hibernate/test/legacy/SQLFunctionsTest.java | |||
Method name: void testCachedQuery()
|
Method name: void testCachedQuery()
|
|||
Number of AST nodes: 52 | Number of AST nodes: 52 | |||
1 | Session s = openSession(); ↵ | 1 | Session s = openSession();↵ | |
2 | Transaction t = s.beginTransaction(); ↵ | 2 | Transaction t = s.beginTransaction();↵ | |
3 | Simple simple = new Simple(); ↵ | 3 | Simple simple = new Simple();↵ | |
4 | simple.setName("Simple 1"); ↵ | 4 | simple.setName("Simple 1");↵ | |
5 | s.save( simple, new Long(10) ); ↵ | 5 | s.save( simple, new Long(10) );↵ | |
6 | t.commit(); ↵ | 6 | t.commit();↵ | |
7 | s.close();↵ | 7 | s.close();↵ | |
8 | ↵ | |||
9 | s = openSession(); ↵ | 8 | s = openSession();↵ | |
10 | t = s.beginTransaction(); ↵ | 9 | t = s.beginTransaction();↵ | |
11 | Query q = s.createQuery("from Simple s where s.name=?"); ↵ | 10 | Query q = s.createQuery("from Simple s where s.name=?");↵ | |
12 | q.setCacheable(true); ↵ | 11 | q.setCacheable(true);↵ | |
13 | q.setString(0, "Simple 1"); ↵ | 12 | q.setString(0, "Simple 1");↵ | |
14 | assertTrue( q.list().size()==1 ); ↵ | 13 | assertTrue( q.list().size()==1 );↵ | |
15 | assertTrue( q.list().size()==1 ); ↵ | 14 | assertTrue( q.list().size()==1 );↵ | |
16 | assertTrue( q.list().size()==1 ); ↵ | 15 | assertTrue( q.list().size()==1 );↵ | |
17 | q = s.createQuery("from Simple s where s.name=:name"); ↵ | 16 | q = s.createQuery("from Simple s where s.name=:name");↵ | |
18 | q.setCacheable(true); ↵ | 17 | q.setCacheable(true);↵ | |
19 | q.setString("name", "Simple 1"); ↵ | 18 | q.setString("name", "Simple 1");↵ | |
20 | assertTrue( q.list().size()==1 ); ↵ | 19 | assertTrue( q.list().size()==1 );↵ | |
21 | simple = (Simple) q.list().get(0);↵ | 20 | simple = (Simple) q.list().get(0);↵ | |
22 | ↵ | |||
23 | q.setString("name", "Simple 2"); ↵ | 21 | q.setString("name", "Simple 2");↵ | |
24 | assertTrue( q.list().size()==0 ); ↵ | 22 | assertTrue( q.list().size()==0 );↵ | |
25 | assertTrue( q.list().size()==0 ); ↵ | 23 | assertTrue( q.list().size()==0 );↵ | |
26 | simple.setName("Simple 2"); ↵ | 24 | simple.setName("Simple 2");↵ | |
27 | assertTrue( q.list().size()==1 ); ↵ | 25 | assertTrue( q.list().size()==1 );↵ | |
28 | assertTrue( q.list().size()==1 ); ↵ | 26 | assertTrue( q.list().size()==1 );↵ | |
29 | t.commit(); ↵ | 27 | t.commit();↵ | |
30 | s.close();↵ | 28 | s.close();↵ | |
31 | ↵ | |||
32 | s = openSession(); ↵ | 29 | s = openSession();↵ | |
33 | t = s.beginTransaction(); ↵ | 30 | t = s.beginTransaction();↵ | |
34 | q = s.createQuery("from Simple s where s.name=:name"); ↵ | 31 | q = s.createQuery("from Simple s where s.name=:name");↵ | |
35 | q.setString("name", "Simple 2"); ↵ | 32 | q.setString("name", "Simple 2");↵ | |
36 | q.setCacheable(true); ↵ | 33 | q.setCacheable(true);↵ | |
37 | assertTrue( q.list().size()==1 ); ↵ | 34 | assertTrue( q.list().size()==1 );↵ | |
38 | assertTrue( q.list().size()==1 ); ↵ | 35 | assertTrue( q.list().size()==1 );↵ | |
39 | t.commit(); ↵ | 36 | t.commit();↵ | |
40 | s.close();↵ | 37 | s.close();↵ | |
41 | ↵ | |||
42 | s = openSession(); ↵ | 38 | s = openSession();↵ | |
43 | t = s.beginTransaction(); ↵ | 39 | t = s.beginTransaction();↵ | |
44 | s.update( simple, new Long(10) ); ↵ | 40 | s.update( simple, new Long(10) );↵ | |
45 | s.delete(simple); ↵ | 41 | s.delete(simple);↵ | |
46 | t.commit(); ↵ | 42 | t.commit();↵ | |
47 | s.close();↵ | 43 | s.close();↵ | |
48 | ↵ | |||
49 | s = openSession(); ↵ | 44 | s = openSession();↵ | |
50 | t = s.beginTransaction(); ↵ | 45 | t = s.beginTransaction();↵ | |
51 | q = s.createQuery("from Simple s where s.name=?"); ↵ | 46 | q = s.createQuery("from Simple s where s.name=?");↵ | |
52 | q.setCacheable(true); ↵ | 47 | q.setCacheable(true);↵ | |
53 | q.setString(0, "Simple 1"); ↵ | 48 | q.setString(0, "Simple 1");↵ | |
54 | assertTrue( q.list().size()==0 ); ↵ | 49 | assertTrue( q.list().size()==0 );↵ | |
55 | assertTrue( q.list().size()==0 ); ↵ | 50 | assertTrue( q.list().size()==0 );↵ | |
56 | t.commit(); ↵ | 51 | t.commit();↵ | |
57 | s.close(); | 52 |
| |
See real code fragment | See real code fragment |
Number of common nesting structure subtrees | 1 |
Number of refactorable cases | 1 |
Number of non-refactorable cases | 0 |
Time elapsed for finding largest common nesting structure subtrees (ms) | 0.0 |
Clones location | Clones are in different classes having the same super class |
Number of node comparisons | 861 |
Number of mapped statements | 52 |
Number of unmapped statements in the first code fragment | 0 |
Number of unmapped statements in the second code fragment | 0 |
Time elapsed for statement mapping (ms) | 0.0 |
Clone type | Type 1 |
ID | Statement | ID | Statement | |
---|---|---|---|---|
1 | Session s = openSession(); | 1 | Session s = openSession(); | |
2 | Transaction t = s.beginTransaction(); | 2 | Transaction t = s.beginTransaction(); | |
3 | Simple simple = new Simple(); | 3 | Simple simple = new Simple(); | |
4 | simple.setName("Simple 1"); | 4 | simple.setName("Simple 1"); | |
5 | s.save(simple, new Long(10)); | 5 | s.save(simple, new Long(10)); | |
6 | t.commit(); | 6 | t.commit(); | |
7 | s.close(); | 7 | s.close(); | |
8 | s = openSession(); | 8 | s = openSession(); | |
9 | t = s.beginTransaction(); | 9 | t = s.beginTransaction(); | |
10 | Query q = s.createQuery("from Simple s where s.name=?"); | 10 | Query q = s.createQuery("from Simple s where s.name=?"); | |
11 | q.setCacheable(true); | 11 | q.setCacheable(true); | |
12 | q.setString(0, "Simple 1"); | 12 | q.setString(0, "Simple 1"); | |
13 | assertTrue(q.list().size() == 1); | 13 | assertTrue(q.list().size() == 1); | |
14 | assertTrue(q.list().size() == 1); | 14 | assertTrue(q.list().size() == 1); | |
15 | assertTrue(q.list().size() == 1); | 15 | assertTrue(q.list().size() == 1); | |
16 | q = s.createQuery("from Simple s where s.name=:name"); | 16 | q = s.createQuery("from Simple s where s.name=:name"); | |
17 | q.setCacheable(true); | 17 | q.setCacheable(true); | |
18 | q.setString("name", "Simple 1"); | 18 | q.setString("name", "Simple 1"); | |
19 | assertTrue(q.list().size() == 1); | 19 | assertTrue(q.list().size() == 1); | |
20 | simple = (Simple)q.list().get(0); | 20 | simple = (Simple)q.list().get(0); | |
21 | q.setString("name", "Simple 2"); | 21 | q.setString("name", "Simple 2"); | |
22 | assertTrue(q.list().size() == 0); | 22 | assertTrue(q.list().size() == 0); | |
23 | assertTrue(q.list().size() == 0); | 23 | assertTrue(q.list().size() == 0); | |
24 | simple.setName("Simple 2"); | 24 | simple.setName("Simple 2"); | |
25 | assertTrue(q.list().size() == 1); | 25 | assertTrue(q.list().size() == 1); | |
26 | assertTrue(q.list().size() == 1); | 26 | assertTrue(q.list().size() == 1); | |
27 | t.commit(); | 27 | t.commit(); | |
28 | s.close(); | 28 | s.close(); | |
29 | s = openSession(); | 29 | s = openSession(); | |
30 | t = s.beginTransaction(); | 30 | t = s.beginTransaction(); | |
31 | q = s.createQuery("from Simple s where s.name=:name"); | 31 | q = s.createQuery("from Simple s where s.name=:name"); | |
32 | q.setString("name", "Simple 2"); | 32 | q.setString("name", "Simple 2"); | |
33 | q.setCacheable(true); | 33 | q.setCacheable(true); | |
34 | assertTrue(q.list().size() == 1); | 34 | assertTrue(q.list().size() == 1); | |
35 | assertTrue(q.list().size() == 1); | 35 | assertTrue(q.list().size() == 1); | |
36 | t.commit(); | 36 | t.commit(); | |
37 | s.close(); | 37 | s.close(); | |
38 | s = openSession(); | 38 | s = openSession(); | |
39 | t = s.beginTransaction(); | 39 | t = s.beginTransaction(); | |
40 | s.update(simple, new Long(10)); | 40 | s.update(simple, new Long(10)); | |
41 | s.delete(simple); | 41 | s.delete(simple); | |
42 | t.commit(); | 42 | t.commit(); | |
43 | s.close(); | 43 | s.close(); | |
44 | s = openSession(); | 44 | s = openSession(); | |
45 | t = s.beginTransaction(); | 45 | t = s.beginTransaction(); | |
46 | q = s.createQuery("from Simple s where s.name=?"); | 46 | q = s.createQuery("from Simple s where s.name=?"); | |
47 | q.setCacheable(true); | 47 | q.setCacheable(true); | |
48 | q.setString(0, "Simple 1"); | 48 | q.setString(0, "Simple 1"); | |
49 | assertTrue(q.list().size() == 0); | 49 | assertTrue(q.list().size() == 0); | |
50 | assertTrue(q.list().size() == 0); | 50 | assertTrue(q.list().size() == 0); | |
51 | t.commit(); | 51 | t.commit(); | |
52 | s.close(); | 52 | s.close(); |
Row | Violation |
---|