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 testCachedQueryRegion()
|
Method name: void testCachedQueryRegion()
|
|||
Number of AST nodes: 46 | Number of AST nodes: 46 | |||
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.setCacheRegion("foo"); ↵ | 11 | q.setCacheRegion("foo");↵ | |
13 | q.setCacheable(true); ↵ | 12 | q.setCacheable(true);↵ | |
14 | q.setString(0, "Simple 1"); ↵ | 13 | q.setString(0, "Simple 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 | assertTrue( q.list().size()==1 ); ↵ | 16 | assertTrue( q.list().size()==1 );↵ | |
18 | q = s.createQuery("from Simple s where s.name=:name"); ↵ | 17 | q = s.createQuery("from Simple s where s.name=:name");↵ | |
19 | q.setCacheRegion("foo"); ↵ | 18 | q.setCacheRegion("foo");↵ | |
20 | q.setCacheable(true); ↵ | 19 | q.setCacheable(true);↵ | |
21 | q.setString("name", "Simple 1"); ↵ | 20 | q.setString("name", "Simple 1");↵ | |
22 | assertTrue( q.list().size()==1 ); ↵ | 21 | assertTrue( q.list().size()==1 );↵ | |
23 | simple = (Simple) q.list().get(0);↵ | 22 | simple = (Simple) q.list().get(0);↵ | |
24 | ↵ | |||
25 | q.setString("name", "Simple 2"); ↵ | 23 | q.setString("name", "Simple 2");↵ | |
26 | assertTrue( q.list().size()==0 ); ↵ | 24 | assertTrue( q.list().size()==0 );↵ | |
27 | assertTrue( q.list().size()==0 ); ↵ | 25 | assertTrue( q.list().size()==0 );↵ | |
28 | simple.setName("Simple 2"); ↵ | 26 | simple.setName("Simple 2");↵ | |
29 | assertTrue( q.list().size()==1 ); ↵ | 27 | assertTrue( q.list().size()==1 );↵ | |
30 | assertTrue( q.list().size()==1 ); ↵ | 28 | assertTrue( q.list().size()==1 );↵ | |
31 | t.commit(); ↵ | 29 | t.commit();↵ | |
32 | s.close();↵ | 30 | s.close();↵ | |
33 | ↵ | |||
34 | s = openSession(); ↵ | 31 | s = openSession();↵ | |
35 | t = s.beginTransaction(); ↵ | 32 | t = s.beginTransaction();↵ | |
36 | s.update( simple, new Long(10) ); ↵ | 33 | s.update( simple, new Long(10) );↵ | |
37 | s.delete(simple); ↵ | 34 | s.delete(simple);↵ | |
38 | t.commit(); ↵ | 35 | t.commit();↵ | |
39 | s.close();↵ | 36 | s.close();↵ | |
40 | ↵ | |||
41 | s = openSession(); ↵ | 37 | s = openSession();↵ | |
42 | t = s.beginTransaction(); ↵ | 38 | t = s.beginTransaction();↵ | |
43 | q = s.createQuery("from Simple s where s.name=?"); ↵ | 39 | q = s.createQuery("from Simple s where s.name=?");↵ | |
44 | q.setCacheRegion("foo"); ↵ | 40 | q.setCacheRegion("foo");↵ | |
45 | q.setCacheable(true); ↵ | 41 | q.setCacheable(true);↵ | |
46 | q.setString(0, "Simple 1"); ↵ | 42 | q.setString(0, "Simple 1");↵ | |
47 | assertTrue( q.list().size()==0 ); ↵ | 43 | assertTrue( q.list().size()==0 );↵ | |
48 | assertTrue( q.list().size()==0 ); ↵ | 44 | assertTrue( q.list().size()==0 );↵ | |
49 | t.commit(); ↵ | 45 | t.commit();↵ | |
50 | s.close(); | 46 |
| |
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 | 749 |
Number of mapped statements | 46 |
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.setCacheRegion("foo"); | 11 | q.setCacheRegion("foo"); | |
12 | q.setCacheable(true); | 12 | q.setCacheable(true); | |
13 | q.setString(0, "Simple 1"); | 13 | q.setString(0, "Simple 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 | assertTrue(q.list().size() == 1); | 16 | assertTrue(q.list().size() == 1); | |
17 | q = s.createQuery("from Simple s where s.name=:name"); | 17 | q = s.createQuery("from Simple s where s.name=:name"); | |
18 | q.setCacheRegion("foo"); | 18 | q.setCacheRegion("foo"); | |
19 | q.setCacheable(true); | 19 | q.setCacheable(true); | |
20 | q.setString("name", "Simple 1"); | 20 | q.setString("name", "Simple 1"); | |
21 | assertTrue(q.list().size() == 1); | 21 | assertTrue(q.list().size() == 1); | |
22 | simple = (Simple)q.list().get(0); | 22 | simple = (Simple)q.list().get(0); | |
23 | q.setString("name", "Simple 2"); | 23 | q.setString("name", "Simple 2"); | |
24 | assertTrue(q.list().size() == 0); | 24 | assertTrue(q.list().size() == 0); | |
25 | assertTrue(q.list().size() == 0); | 25 | assertTrue(q.list().size() == 0); | |
26 | simple.setName("Simple 2"); | 26 | simple.setName("Simple 2"); | |
27 | assertTrue(q.list().size() == 1); | 27 | assertTrue(q.list().size() == 1); | |
28 | assertTrue(q.list().size() == 1); | 28 | assertTrue(q.list().size() == 1); | |
29 | t.commit(); | 29 | t.commit(); | |
30 | s.close(); | 30 | s.close(); | |
31 | s = openSession(); | 31 | s = openSession(); | |
32 | t = s.beginTransaction(); | 32 | t = s.beginTransaction(); | |
33 | s.update(simple, new Long(10)); | 33 | s.update(simple, new Long(10)); | |
34 | s.delete(simple); | 34 | s.delete(simple); | |
35 | t.commit(); | 35 | t.commit(); | |
36 | s.close(); | 36 | s.close(); | |
37 | s = openSession(); | 37 | s = openSession(); | |
38 | t = s.beginTransaction(); | 38 | t = s.beginTransaction(); | |
39 | q = s.createQuery("from Simple s where s.name=?"); | 39 | q = s.createQuery("from Simple s where s.name=?"); | |
40 | q.setCacheRegion("foo"); | 40 | q.setCacheRegion("foo"); | |
41 | q.setCacheable(true); | 41 | q.setCacheable(true); | |
42 | q.setString(0, "Simple 1"); | 42 | q.setString(0, "Simple 1"); | |
43 | assertTrue(q.list().size() == 0); | 43 | assertTrue(q.list().size() == 0); | |
44 | assertTrue(q.list().size() == 0); | 44 | assertTrue(q.list().size() == 0); | |
45 | t.commit(); | 45 | t.commit(); | |
46 | s.close(); | 46 | s.close(); |
Row | Violation |
---|