01: /*
02: * Licensed to the Apache Software Foundation (ASF) under one
03: * or more contributor license agreements. See the NOTICE file
04: * distributed with this work for additional information
05: * regarding copyright ownership. The ASF licenses this file
06: * to you under the Apache License, Version 2.0 (the
07: * "License"); you may not use this file except in compliance
08: * with the License. You may obtain a copy of the License at
09: *
10: * http://www.apache.org/licenses/LICENSE-2.0
11: *
12: * Unless required by applicable law or agreed to in writing,
13: * software distributed under the License is distributed on an
14: * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
15: * KIND, either express or implied. See the License for the
16: * specific language governing permissions and limitations
17: * under the License.
18: */
19: package org.apache.openjpa.persistence.simple;
20:
21: import javax.persistence.Query;
22: import javax.persistence.EntityManager;
23:
24: import org.apache.openjpa.persistence.test.SingleEMFTestCase;
25:
26: public class TestCaseInsensitiveKeywordsInJPQL extends
27: SingleEMFTestCase {
28:
29: public void setUp() {
30: // expecting only data that is inserted in this test case
31: setUp(AllFieldTypes.class, CLEAR_TABLES);
32: }
33:
34: public void testCaseInsensitiveBooleans() {
35: EntityManager em = emf.createEntityManager();
36: em.getTransaction().begin();
37:
38: AllFieldTypes aft = new AllFieldTypes();
39: em.persist(aft);
40: aft.setBooleanField(true);
41:
42: aft = new AllFieldTypes();
43: em.persist(aft);
44: aft.setBooleanField(false);
45:
46: em.flush();
47:
48: Query q = em
49: .createQuery("select count(o) from AllFieldTypes o where o.booleanField = TrUe");
50: Number n = (Number) q.getSingleResult();
51: assertEquals(1, n.intValue());
52:
53: q = em.createQuery("select count(o) from AllFieldTypes o "
54: + "where o.booleanField = falSe");
55: n = (Number) q.getSingleResult();
56: assertEquals(1, n.intValue());
57:
58: em.getTransaction().rollback();
59: }
60: }
|