File path: /hibernate-distribution-3.3.2.GA/project/testsuite/src/test/java/org/hibernate/test/legacy/SQLFunctionsTest.java | File path: /hibernate-distribution-3.3.2.GA/project/testsuite/src/test/java/org/hibernate/test/dialect/functional/cache/SQLFunctionsInterSystemsTest.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 | ↵ | |||
8 | s = openSession();↵ | 9 | s = openSession(); ↵ | |
9 | t = s.beginTransaction();↵ | 10 | t = s.beginTransaction(); ↵ | |
10 | Query q = s.createQuery("from Simple s where s.name=?");↵ | 11 | Query q = s.createQuery("from Simple s where s.name=?"); ↵ | |
11 | q.setCacheRegion("foo");↵ | 12 | q.setCacheRegion("foo"); ↵ | |
12 | q.setCacheable(true);↵ | 13 | q.setCacheable(true); ↵ | |
13 | q.setString(0, "Simple 1");↵ | 14 | q.setString(0, "Simple 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 | assertTrue( q.list().size()==1 ); ↵ | |
17 | q = s.createQuery("from Simple s where s.name=:name");↵ | 18 | q = s.createQuery("from Simple s where s.name=:name"); ↵ | |
18 | q.setCacheRegion("foo");↵ | 19 | q.setCacheRegion("foo"); ↵ | |
19 | q.setCacheable(true);↵ | 20 | q.setCacheable(true); ↵ | |
20 | q.setString("name", "Simple 1");↵ | 21 | q.setString("name", "Simple 1"); ↵ | |
21 | assertTrue( q.list().size()==1 );↵ | 22 | assertTrue( q.list().size()==1 ); ↵ | |
22 | simple = (Simple) q.list().get(0);↵ | 23 | simple = (Simple) q.list().get(0);↵ | |
24 | ↵ | |||
23 | q.setString("name", "Simple 2");↵ | 25 | q.setString("name", "Simple 2"); ↵ | |
24 | assertTrue( q.list().size()==0 );↵ | 26 | assertTrue( q.list().size()==0 ); ↵ | |
25 | assertTrue( q.list().size()==0 );↵ | 27 | assertTrue( q.list().size()==0 ); ↵ | |
26 | simple.setName("Simple 2");↵ | 28 | simple.setName("Simple 2"); ↵ | |
27 | assertTrue( q.list().size()==1 );↵ | 29 | assertTrue( q.list().size()==1 ); ↵ | |
28 | assertTrue( q.list().size()==1 );↵ | 30 | assertTrue( q.list().size()==1 ); ↵ | |
29 | t.commit();↵ | 31 | t.commit(); ↵ | |
30 | s.close();↵ | 32 | s.close();↵ | |
33 | ↵ | |||
31 | s = openSession();↵ | 34 | s = openSession(); ↵ | |
32 | t = s.beginTransaction();↵ | 35 | t = s.beginTransaction(); ↵ | |
33 | s.update( simple, new Long(10) );↵ | 36 | s.update( simple, new Long(10) ); ↵ | |
34 | s.delete(simple);↵ | 37 | s.delete(simple); ↵ | |
35 | t.commit();↵ | 38 | t.commit(); ↵ | |
36 | s.close();↵ | 39 | s.close();↵ | |
40 | ↵ | |||
37 | s = openSession();↵ | 41 | s = openSession(); ↵ | |
38 | t = s.beginTransaction();↵ | 42 | t = s.beginTransaction(); ↵ | |
39 | q = s.createQuery("from Simple s where s.name=?");↵ | 43 | q = s.createQuery("from Simple s where s.name=?"); ↵ | |
40 | q.setCacheRegion("foo");↵ | 44 | q.setCacheRegion("foo"); ↵ | |
41 | q.setCacheable(true);↵ | 45 | q.setCacheable(true); ↵ | |
42 | q.setString(0, "Simple 1");↵ | 46 | q.setString(0, "Simple 1"); ↵ | |
43 | assertTrue( q.list().size()==0 );↵ | 47 | assertTrue( q.list().size()==0 ); ↵ | |
44 | assertTrue( q.list().size()==0 );↵ | 48 | assertTrue( q.list().size()==0 ); ↵ | |
45 | t.commit();↵ | 49 | t.commit(); ↵ | |
46 | s.close(); | 50 |
| |
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 |
---|