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 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 | ↵ | |||
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.setCacheable(true);↵ | 12 | q.setCacheable(true); ↵ | |
12 | q.setString(0, "Simple 1");↵ | 13 | q.setString(0, "Simple 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 | assertTrue( q.list().size()==1 ); ↵ | |
16 | q = s.createQuery("from Simple s where s.name=:name");↵ | 17 | q = s.createQuery("from Simple s where s.name=:name"); ↵ | |
17 | q.setCacheable(true);↵ | 18 | q.setCacheable(true); ↵ | |
18 | q.setString("name", "Simple 1");↵ | 19 | q.setString("name", "Simple 1"); ↵ | |
19 | assertTrue( q.list().size()==1 );↵ | 20 | assertTrue( q.list().size()==1 ); ↵ | |
20 | simple = (Simple) q.list().get(0);↵ | 21 | simple = (Simple) q.list().get(0);↵ | |
22 | ↵ | |||
21 | q.setString("name", "Simple 2");↵ | 23 | q.setString("name", "Simple 2"); ↵ | |
22 | assertTrue( q.list().size()==0 );↵ | 24 | assertTrue( q.list().size()==0 ); ↵ | |
23 | assertTrue( q.list().size()==0 );↵ | 25 | assertTrue( q.list().size()==0 ); ↵ | |
24 | simple.setName("Simple 2");↵ | 26 | simple.setName("Simple 2"); ↵ | |
25 | assertTrue( q.list().size()==1 );↵ | 27 | assertTrue( q.list().size()==1 ); ↵ | |
26 | assertTrue( q.list().size()==1 );↵ | 28 | assertTrue( q.list().size()==1 ); ↵ | |
27 | t.commit();↵ | 29 | t.commit(); ↵ | |
28 | s.close();↵ | 30 | s.close();↵ | |
31 | ↵ | |||
29 | s = openSession();↵ | 32 | s = openSession(); ↵ | |
30 | t = s.beginTransaction();↵ | 33 | t = s.beginTransaction(); ↵ | |
31 | q = s.createQuery("from Simple s where s.name=:name");↵ | 34 | q = s.createQuery("from Simple s where s.name=:name"); ↵ | |
32 | q.setString("name", "Simple 2");↵ | 35 | q.setString("name", "Simple 2"); ↵ | |
33 | q.setCacheable(true);↵ | 36 | q.setCacheable(true); ↵ | |
34 | assertTrue( q.list().size()==1 );↵ | 37 | assertTrue( q.list().size()==1 ); ↵ | |
35 | assertTrue( q.list().size()==1 );↵ | 38 | assertTrue( q.list().size()==1 ); ↵ | |
36 | t.commit();↵ | 39 | t.commit(); ↵ | |
37 | s.close();↵ | 40 | s.close();↵ | |
41 | ↵ | |||
38 | s = openSession();↵ | 42 | s = openSession(); ↵ | |
39 | t = s.beginTransaction();↵ | 43 | t = s.beginTransaction(); ↵ | |
40 | s.update( simple, new Long(10) );↵ | 44 | s.update( simple, new Long(10) ); ↵ | |
41 | s.delete(simple);↵ | 45 | s.delete(simple); ↵ | |
42 | t.commit();↵ | 46 | t.commit(); ↵ | |
43 | s.close();↵ | 47 | s.close();↵ | |
48 | ↵ | |||
44 | s = openSession();↵ | 49 | s = openSession(); ↵ | |
45 | t = s.beginTransaction();↵ | 50 | t = s.beginTransaction(); ↵ | |
46 | q = s.createQuery("from Simple s where s.name=?");↵ | 51 | q = s.createQuery("from Simple s where s.name=?"); ↵ | |
47 | q.setCacheable(true);↵ | 52 | q.setCacheable(true); ↵ | |
48 | q.setString(0, "Simple 1");↵ | 53 | q.setString(0, "Simple 1"); ↵ | |
49 | assertTrue( q.list().size()==0 );↵ | 54 | assertTrue( q.list().size()==0 ); ↵ | |
50 | assertTrue( q.list().size()==0 );↵ | 55 | assertTrue( q.list().size()==0 ); ↵ | |
51 | t.commit();↵ | 56 | t.commit(); ↵ | |
52 | s.close(); | 57 |
| |
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 |
---|