/*******************************************************************************
* Copyright (c) 1998, 2015 Oracle and/or its affiliates. All rights reserved.
* This program and the accompanying materials are made available under the
* terms of the Eclipse Public License v1.0 and Eclipse Distribution License v. 1.0
* which accompanies this distribution.
* The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html
* and the Eclipse Distribution License is available at
* http://www.eclipse.org/org/documents/edl-v10.php.
*
* Contributors:
* 03/26/2008-1.0M6 Guy Pelletier
* - 211302: Add variable 1-1 mapping support to the EclipseLink-ORM.XML Schema
******************************************************************************/
package org.eclipse.persistence.testing.tests.jpa.fieldaccess.relationships;
import java.util.Collection;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Vector;
import javax.persistence.EntityManager;
import javax.persistence.NoResultException;
import javax.persistence.NonUniqueResultException;
import javax.persistence.PersistenceException;
import javax.persistence.Query;
import org.eclipse.persistence.exceptions.QueryException;
import org.eclipse.persistence.internal.jpa.EJBQueryImpl;
import org.eclipse.persistence.internal.jpa.EntityManagerImpl;
import org.eclipse.persistence.internal.queries.MapContainerPolicy;
import org.eclipse.persistence.queries.ReadAllQuery;
import org.eclipse.persistence.queries.ReadObjectQuery;
import org.eclipse.persistence.sessions.server.ServerSession;
import org.eclipse.persistence.testing.framework.QuerySQLTracker;
import org.eclipse.persistence.testing.framework.junit.JUnitTestCase;
import org.eclipse.persistence.testing.models.jpa.fieldaccess.relationships.Customer;
import org.eclipse.persistence.testing.models.jpa.fieldaccess.relationships.Customer2;
import org.eclipse.persistence.testing.models.jpa.fieldaccess.relationships.Item;
import org.eclipse.persistence.testing.models.jpa.fieldaccess.relationships.Order;
import org.eclipse.persistence.testing.models.jpa.fieldaccess.relationships.RelationshipsExamples;
import org.eclipse.persistence.testing.models.jpa.fieldaccess.relationships.RelationshipsTableManager;
import junit.framework.Test;
import junit.framework.TestSuite;
public class RelationshipModelJUnitTestSuite extends JUnitTestCase {
public RelationshipModelJUnitTestSuite() {
super();
}
public RelationshipModelJUnitTestSuite(String name) {
super(name);
}
public static Test suite() {
TestSuite suite = new TestSuite();
suite.setName("RelationshipModelJUnitTestSuite (field access)");
suite.addTest(new RelationshipModelJUnitTestSuite("testSetup"));
suite.addTest(new RelationshipModelJUnitTestSuite("testPersistCustomer"));
suite.addTest(new RelationshipModelJUnitTestSuite("testUpdateCustomer"));
suite.addTest(new RelationshipModelJUnitTestSuite("testReadCustomer"));
suite.addTest(new RelationshipModelJUnitTestSuite("testDeleteCustomer"));
suite.addTest(new RelationshipModelJUnitTestSuite("testExecuteUpdateTest"));
suite.addTest(new RelationshipModelJUnitTestSuite("testGetResultCollectionTest"));
suite.addTest(new RelationshipModelJUnitTestSuite("testGetResultListTest"));
suite.addTest(new RelationshipModelJUnitTestSuite("testGetSingleResultTest"));
suite.addTest(new RelationshipModelJUnitTestSuite("testNamedQueryDoesNotExistTest"));
suite.addTest(new RelationshipModelJUnitTestSuite("testNamedQueryDoesNotExistTest"));
suite.addTest(new RelationshipModelJUnitTestSuite("testRemoveReference"));
return suite;
}
/**
* The setup is done as a test, both to record its failure, and to allow execution in the server.
*/
public void testSetup() {
new RelationshipsTableManager().replaceTables(JUnitTestCase.getServerSession("fieldaccess"));
clearCache("fieldaccess");
}
/*
* Tests for the executeUpdate method on the EJBQueryImpl class.
* Also tests bugs 4288845 and 4293920, that params are passed in and used correctly.
*/
public void testExecuteUpdateTest() {
EntityManager em = createEntityManager("fieldaccess");
Integer[] cusIDs = new Integer[2];
String nameChange1 = "New Name1";
String nameChange2 = "New Name2";
String nameChange3 = "New Name3";
String returnedName1, returnedName2, returnedName3;
Exception expectedException = null;
Exception expectedException2 = null;
try {
Customer cusClone1 = RelationshipsExamples.customerExample1();
beginTransaction(em);
em.persist(cusClone1);
commitTransaction(em);
em.clear();
clearCache("fieldaccess");
cusIDs[0] = cusClone1.getCustomerId();
beginTransaction(em);
Customer cus = em.find(Customer.class, cusIDs[0]);
Query query = em.createQuery("UPDATE FieldAccessCustomer customer SET customer.name = '" + nameChange1 + "' WHERE customer.customerId = " + cusIDs[0]);
query.executeUpdate();
em.clear();
clearCache("fieldaccess");
// getEntityManager().refresh(cus);
cus = em.find(Customer.class, cusIDs[0]);
returnedName1 = cus.getName();
// tests bug 4288845
Query query2 = em.createQuery("UPDATE FieldAccessCustomer customer SET customer.name = :name WHERE customer.customerId = " + cusIDs[0]);
query2.setParameter("name", nameChange2);
query2.executeUpdate();
em.clear();
clearCache("fieldaccess");
// getEntityManager().refresh(cus);
cus = em.find(Customer.class, cusIDs[0]);
returnedName2 = cus.getName();
// tests bug 4293920
Query query3 = em.createQuery("UPDATE FieldAccessCustomer customer SET customer.name = :name WHERE customer.customerId = :id");
query3.setParameter("name", nameChange3);
query3.setParameter("id", cusIDs[0]);
query3.executeUpdate();
em.clear();
clearCache("fieldaccess");
// getEntityManager().refresh(cus);
cus = em.find(Customer.class, cusIDs[0]);
returnedName3 = cus.getName();
// tests bug 4294241
try {
Query query4 = em.createNamedQuery("findAllCustomersFieldAccess");
query4.executeUpdate();
} catch (IllegalStateException expected) {
expectedException = expected;
}
expectedException2 = null;
try {
commitTransaction(em);
expectedException2 = null;
} catch (Exception ex) {
expectedException2 = ex;
}
if ((returnedName1 == null || !returnedName1.equals(nameChange1))) {
fail("Customer name did not get updated correctly should be:" + nameChange1 + " is :" + returnedName1);
}
if ((returnedName2 == null || !returnedName2.equals(nameChange2))) {
fail("Customer name did not get updated correctly should be:" + nameChange2 + " is :" + returnedName2);
}
if ((returnedName3 == null || !returnedName3.equals(nameChange3))) {
fail("Customer name did not get updated correctly should be:" + nameChange3 + " is :" + returnedName3);
}
if (expectedException == null) {
fail("excuteUpdate did not result in an exception on findAllCustomersFieldAccess named ReadAllQuery");
}
if (expectedException2 == null) {
fail("commit did not throw expected RollbackException");
}
beginTransaction(em);
Customer cus1 = em.find(Customer.class, cusIDs[0]);
em.remove(cus1);
commitTransaction(em);
} finally {
if (isTransactionActive(em)) {
rollbackTransaction(em);
}
}
}
/*
* Tests using the 'getResultCollection' api on a Query object obtained from the
* EntityManager Also tests bugs 4300879 - check non Collection container
* policy error and 4297903 - check ReadObjectQuery fails
*/
public void testGetResultCollectionTest() {
Collection returnedCustomers1, returnedCustomers2;
QueryException expectedException1 = null;
String ejbql1 = "SELECT OBJECT(thecust) FROM FieldAccessCustomer thecust WHERE thecust.customerId = :id";
Integer[] cusIDs = new Integer[3];
Customer cusClone1 = RelationshipsExamples.customerExample1();
Customer cusClone2 = RelationshipsExamples.customerExample2();
EntityManager em = createEntityManager("fieldaccess");
beginTransaction(em);
em.persist(cusClone1);
em.persist(cusClone2);
commitTransaction(em);
em.clear();
clearCache("fieldaccess");
cusIDs[0] = cusClone1.getCustomerId();
cusIDs[1] = cusClone2.getCustomerId();
try {
beginTransaction(em);
EntityManagerImpl entityManagerImpl = (EntityManagerImpl) em.getDelegate();
EJBQueryImpl query1 = (EJBQueryImpl) entityManagerImpl.createNamedQuery("findAllCustomersFieldAccess");
returnedCustomers1 = query1.getResultCollection();
EJBQueryImpl query2 = (EJBQueryImpl) entityManagerImpl.createQuery(ejbql1);
query2.setParameter("id", new Integer(-10));
returnedCustomers2 = query2.getResultCollection();
// bug:4297903, check container policy failure
EJBQueryImpl query3 = (EJBQueryImpl) entityManagerImpl.createQuery(ejbql1);
ReadAllQuery readAllQuery = new ReadAllQuery(Customer.class);
MapContainerPolicy mapContainerPolicy = new MapContainerPolicy();
mapContainerPolicy.setContainerClass(HashMap.class);
mapContainerPolicy.setKeyName("hashCode");
readAllQuery.setContainerPolicy(mapContainerPolicy);
query3.setDatabaseQuery(readAllQuery);
try {
query3.getResultCollection();
} catch (PersistenceException exc) {// QueryException.INVALID_CONTAINER_CLASS
expectedException1 = (QueryException)exc.getCause();
rollbackTransaction(em);
beginTransaction(em);
}
entityManagerImpl = (EntityManagerImpl) em.getDelegate();
// bug:4300879, check ReadObjectQuery fails
EJBQueryImpl query4 = (EJBQueryImpl) entityManagerImpl.createQuery(ejbql1);
query4.setParameter("id", new Integer(-10));
ReadObjectQuery readObjectQuery2 = new ReadObjectQuery(Customer.class);
readObjectQuery2.setEJBQLString(ejbql1);
query4.setDatabaseQuery(readObjectQuery2);
query4.getResultCollection();
commitTransaction(em);
if (returnedCustomers1 == null || (returnedCustomers1.size() < 2)) {
fail("Not all customers were returned from findAllCustomers query ");
}
if (returnedCustomers2 == null || (returnedCustomers2.size() != 0)) {
fail("Customer from ReadObjectQuery was not returned using getResultCollection");
}
if (expectedException1 == null || (expectedException1.getErrorCode() != QueryException.INVALID_CONTAINER_CLASS)) {
fail("getResultCollection on query returning a hashtable did not throw expected INVALID_CONTAINER_CLASS QueryException");
}
beginTransaction(em);
Customer cus1 = em.find(Customer.class, cusIDs[0]);
em.remove(cus1);
Customer cus2 = em.find(Customer.class, cusIDs[1]);
em.remove(cus2);
commitTransaction(em);
} finally {
if (isTransactionActive(em)) {
rollbackTransaction(em);
}
}
}
/*
* Tests using the 'getSingleResult' api on a Query object obtained from the
* EntityManager Also tests bugs 4300879 - check non Collection container
* policy error and 4297903 - check ReadObjectQuery fails
*/
public void testGetResultListTest() {
Collection returnedCustomers1, returnedCustomers2;
QueryException expectedException1 = null;
String ejbql1 = "SELECT OBJECT(thecust) FROM FieldAccessCustomer thecust WHERE thecust.customerId = :id";
Integer[] cusIDs = new Integer[3];
Customer cusClone1 = RelationshipsExamples.customerExample1();
Customer cusClone2 = RelationshipsExamples.customerExample2();
EntityManager em = createEntityManager("fieldaccess");
beginTransaction(em);
em.persist(cusClone1);
em.persist(cusClone2);
commitTransaction(em);
em.clear();
clearCache("fieldaccess");
cusIDs[0] = cusClone1.getCustomerId();
cusIDs[1] = cusClone2.getCustomerId();
try {
beginTransaction(em);
EntityManagerImpl entityManagerImpl = (EntityManagerImpl) em.getDelegate();
Query query1 = em.createNamedQuery("findAllCustomersFieldAccess");
returnedCustomers1 = query1.getResultList();
Query query2 = em.createQuery(ejbql1);
query2.setParameter("id", new Integer(-10));
returnedCustomers2 = query2.getResultList();
// bug:4297903, check container policy failure
EJBQueryImpl query3 = (EJBQueryImpl) entityManagerImpl.createQuery(ejbql1);
ReadAllQuery readAllQuery = new ReadAllQuery(Customer.class);
MapContainerPolicy mapContainerPolicy = new MapContainerPolicy();
mapContainerPolicy.setContainerClass(HashMap.class);
mapContainerPolicy.setKeyName("hashCode");
readAllQuery.setContainerPolicy(mapContainerPolicy);
query3.setDatabaseQuery(readAllQuery);
try {
query3.getResultList();
} catch (PersistenceException exc) {// QueryException.INVALID_CONTAINER_CLASS
expectedException1 = (QueryException)exc.getCause();
rollbackTransaction(em);
beginTransaction(em);
}
entityManagerImpl = (EntityManagerImpl) em.getDelegate();
// bug:4300879, check ReadObjectQuery fails
EJBQueryImpl query4 = (EJBQueryImpl) entityManagerImpl.createQuery(ejbql1);
query4.setParameter("id", new Integer(-10));
ReadObjectQuery readObjectQuery2 = new ReadObjectQuery(Customer.class);
readObjectQuery2.setEJBQLString(ejbql1);
query4.setDatabaseQuery(readObjectQuery2);
query4.getResultList();
commitTransaction(em);
if (returnedCustomers1 == null || (returnedCustomers1.size() < 2)) {
fail("Not all customers were returned from findAllCustomers query ");
}
if (returnedCustomers2 == null || (returnedCustomers2.size() != 0)) {
fail("Customer from ReadObjectQuery was not returned using getResultCollection");
}
if (expectedException1 == null || (expectedException1.getErrorCode() != QueryException.INVALID_CONTAINER_CLASS)) {
fail("getResultCollection on query returning a hashtable did not throw expected INVALID_CONTAINER_CLASS QueryException");
}
beginTransaction(em);
Customer cus1 = em.find(Customer.class, cusIDs[0]);
em.remove(cus1);
Customer cus2 = em.find(Customer.class, cusIDs[1]);
em.remove(cus2);
commitTransaction(em);
} finally {
if (isTransactionActive(em)) {
rollbackTransaction(em);
}
}
}
/*
* Tests using the 'getSingleResult' api on a Query object obtained from the
* EntityManager Tests fixes for bugs 4202835 and 4301674
*
* modified for changes in bug:4628215 (EntityNotFoundException)
* EntityNotFoundException changed to NoResultException as per new spec
*/
public void testGetSingleResultTest() {
// used for verification
Customer returnedCustomer1, returnedCustomer2 = null;
NonUniqueResultException expectedException1 = null;
NoResultException expectedException2 = null;
String searchString = "notAnItemName";
Integer[] cusIDs = new Integer[3];
Customer cusClone1 = RelationshipsExamples.customerExample1();
Customer cusClone2 = RelationshipsExamples.customerExample2();
EntityManager em = createEntityManager("fieldaccess");
try {
beginTransaction(em);
em.persist(cusClone1);
em.persist(cusClone2);
commitTransaction(em);
clearCache("fieldaccess");
cusIDs[0] = cusClone1.getCustomerId();
cusIDs[1] = cusClone2.getCustomerId();
beginTransaction(em);
try {
returnedCustomer1 = (Customer) em.createNamedQuery("findAllCustomersFieldAccess").getSingleResult();
} catch (NonUniqueResultException exceptionExpected1) {
expectedException1 = exceptionExpected1;
}
try {
// should be no Items to find, which should cause an
// NoResultException
Query query1 = em.createNamedQuery("findAllFieldAccessItemsByName");
Item item = (Item) query1.setParameter(1, searchString).getSingleResult();
item.toString();
} catch (NoResultException exceptionExpected2) {
expectedException2 = exceptionExpected2;
}
// bug 4301674 test
EJBQueryImpl query2 = (EJBQueryImpl) em.createNamedQuery("findAllCustomersFieldAccess");
ReadAllQuery readAllQuery = new ReadAllQuery(Customer.class);
MapContainerPolicy mapContainerPolicy = new MapContainerPolicy();
mapContainerPolicy.setContainerClass(HashMap.class);
mapContainerPolicy.setKeyName("hashCode");
readAllQuery.setContainerPolicy(mapContainerPolicy);
query2.setDatabaseQuery(readAllQuery);
Map result = (Map) query2.getSingleResult();
result.toString();
// check for single result found.
Query query3 = em.createQuery("SELECT OBJECT(thecust) FROM FieldAccessCustomer thecust WHERE thecust.customerId = :id");
returnedCustomer1 = (Customer) query3.setParameter("id", cusIDs[0]).getSingleResult();
// check for single result using a ReadObjectQuery (tests previous
// fix for 4202835)
EJBQueryImpl query4 = (EJBQueryImpl) em.createQuery("SELECT OBJECT(thecust) FROM FieldAccessCustomer thecust WHERE thecust.customerId = :id");
query4.setParameter("id", cusIDs[0]);
ReadObjectQuery readObjectQuery = new ReadObjectQuery(Customer.class);
readObjectQuery.setEJBQLString("SELECT OBJECT(thecust) FROM FieldAccessCustomer thecust WHERE thecust.customerId = :id");
query4.setDatabaseQuery(readObjectQuery);
returnedCustomer2 = (Customer) query4.getSingleResult();
commitTransaction(em);
beginTransaction(em);
Customer cus1 = em.find(Customer.class, cusIDs[0]);
em.remove(cus1);
Customer cus2 = em.find(Customer.class, cusIDs[1]);
em.remove(cus2);
commitTransaction(em);
if (expectedException1 == null) {
fail("getSingelResult on query returning multiple values did not throw a NonUniqueResultException");
}
if (expectedException2 == null) {
fail("getSingelResult on query returning multiple values did not throw an NoResultException");
}
if (returnedCustomer1 == null || (!returnedCustomer1.getCustomerId().equals(cusIDs[0]))) {
fail("Incorrect Single Customer returned, found: " + returnedCustomer1);
}
if (returnedCustomer2 == null || (!returnedCustomer2.getCustomerId().equals(cusIDs[0]))) {
fail("Incorrect Single Customer returned, found: " + returnedCustomer2);
}
} finally {
if (isTransactionActive(em)) {
rollbackTransaction(em);
}
}
}
/**
* Tests trying to execute a named query that does not exist.
*
* @author Guy Pelletier
*/
public void testNamedQueryDoesNotExistTest() {
Exception m_exception = null;
boolean m_npeCaught;
boolean m_illegalArgumentExceptionCaught;
EntityManager em = createEntityManager("fieldaccess");
m_npeCaught = false;
m_illegalArgumentExceptionCaught = false;
try {
em.createNamedQuery("doesNotExist").getResultList();
} catch (NullPointerException e) {
m_npeCaught = true;
} catch (IllegalArgumentException e) {
m_illegalArgumentExceptionCaught = true;
} catch (Exception e) {
m_exception = e;
}
if (m_npeCaught) {
fail("A null pointer exception caught on the query.");
} else if (!m_illegalArgumentExceptionCaught) {
if (m_exception != null) {
fail("Expected IllegalArgumentException, caught: " + m_exception);
} else {
fail("No exception was caught on a named query that does not exist.");
}
}
}
// Bug#4646580 Query arguments are added in EJBQL
public void testNamedQueryWithArgumentsTest() {
Integer[] cusIDs = new Integer[3];
Integer[] orderIDs = new Integer[3];
Integer[] itemIDs = new Integer[3];
Exception exception = null;
List list = null;
Customer cusClone1 = RelationshipsExamples.customerExample1();
Item item1 = RelationshipsExamples.itemExample1();
Order order1 = RelationshipsExamples.orderExample1();
order1.setCustomer(cusClone1);
order1.setItem(item1);
EntityManager em = createEntityManager("fieldaccess");
try {
beginTransaction(em);
em.persist(cusClone1);
em.persist(order1);
commitTransaction(em);
cusIDs[0] = cusClone1.getCustomerId();
orderIDs[0] = order1.getOrderId();
itemIDs[0] = item1.getItemId();
clearCache("fieldaccess");
try {
ServerSession ss = getServerSession("fieldaccess");
Vector vec = new Vector();
vec.add(itemIDs[0]);
list = (List) ss.executeQuery("findAllFieldAccessOrdersByItem", vec);
} catch (Exception ex) {
exception = ex;
}
beginTransaction(em);
Customer cus1 = em.find(Customer.class, cusIDs[0]);
em.remove(cus1);
Order ord1 = em.find(Order.class, orderIDs[0]);
em.remove(ord1);
Item it1 = em.find(Item.class, itemIDs[0]);
em.remove(it1);
commitTransaction(em);
} finally {
if (isTransactionActive(em)) {
rollbackTransaction(em);
}
}
if (exception != null) {
fail("An exception is thrown: " + exception);
}
if (list.size() != 1) {
fail("One order is expected but " + list.size() + " was returned");
}
}
// Test that persisting a customer works correctly.
public void testPersistCustomer() {
Customer customer = RelationshipsExamples.customerExample4();
Item item1 = RelationshipsExamples.itemExample1();
Order order1 = RelationshipsExamples.orderExample1();
customer.addOrder(order1);
order1.setItem(item1);
Item item2 = RelationshipsExamples.itemExample2();
Order order2 = RelationshipsExamples.orderExample2();
customer.addOrder(order2);
order2.setItem(item2);
Item item3 = RelationshipsExamples.itemExample3();
Order order3 = RelationshipsExamples.orderExample3();
customer.addOrder(order3);
order3.setItem(item3);
EntityManager em = createEntityManager("fieldaccess");
try {
beginTransaction(em);
em.persist(customer);
commitTransaction(em);
beginTransaction(em);
verifyObjectInEntityManager(customer, "fieldaccess");
verifyObjectInEntityManager(order1, "fieldaccess");
verifyObjectInEntityManager(order2, "fieldaccess");
verifyObjectInEntityManager(item1, "fieldaccess");
verifyObjectInEntityManager(item2, "fieldaccess");
commitTransaction(em);
clearCache("fieldaccess");
beginTransaction(em);
verifyObjectInEntityManager(customer, "fieldaccess");
verifyObjectInEntityManager(order1, "fieldaccess");
verifyObjectInEntityManager(order2, "fieldaccess");
verifyObjectInEntityManager(item1, "fieldaccess");
verifyObjectInEntityManager(item2, "fieldaccess");
commitTransaction(em);
} finally {
if (isTransactionActive(em)) {
rollbackTransaction(em);
}
closeEntityManager(em);
}
}
// Test that updating a customer works correctly.
public void testUpdateCustomer() {
Customer customer = RelationshipsExamples.customerExample4();
EntityManager em = createEntityManager("fieldaccess");
try {
beginTransaction(em);
em.persist(customer);
commitTransaction(em);
closeEntityManager(em);
clearCache("fieldaccess");
em = createEntityManager("fieldaccess");
beginTransaction(em);
customer = em.find(Customer.class, customer.getCustomerId());
Item item1 = RelationshipsExamples.itemExample1();
Order order1 = RelationshipsExamples.orderExample1();
customer.addOrder(order1);
order1.setItem(item1);
em.flush();
Item item2 = RelationshipsExamples.itemExample2();
Order order2 = RelationshipsExamples.orderExample2();
customer.addOrder(order2);
order2.setItem(item2);
Item item3 = RelationshipsExamples.itemExample3();
Order order3 = RelationshipsExamples.orderExample3();
customer.addOrder(order3);
order3.setItem(item3);
// Force LAZY otherwise compare will fail on was.
getServerSession("fieldaccess").copy(customer);
commitTransaction(em);
beginTransaction(em);
verifyObjectInEntityManager(customer, "fieldaccess");
verifyObjectInEntityManager(order1, "fieldaccess");
verifyObjectInEntityManager(item1, "fieldaccess");
verifyObjectInEntityManager(order2, "fieldaccess");
verifyObjectInEntityManager(item2, "fieldaccess");
verifyObjectInEntityManager(order3, "fieldaccess");
verifyObjectInEntityManager(item3, "fieldaccess");
commitTransaction(em);
clearCache("fieldaccess");
beginTransaction(em);
verifyObjectInEntityManager(customer, "fieldaccess");
verifyObjectInEntityManager(order1, "fieldaccess");
verifyObjectInEntityManager(item1, "fieldaccess");
verifyObjectInEntityManager(order2, "fieldaccess");
verifyObjectInEntityManager(item2, "fieldaccess");
verifyObjectInEntityManager(order3, "fieldaccess");
verifyObjectInEntityManager(item3, "fieldaccess");
commitTransaction(em);
clearCache("fieldaccess");
} finally {
if (isTransactionActive(em)) {
rollbackTransaction(em);
}
closeEntityManager(em);
}
}
// Test that deleting a customer works correctly.
public void testDeleteCustomer() {
Customer customer = RelationshipsExamples.customerExample4();
EntityManager em = createEntityManager("fieldaccess");
try {
beginTransaction(em);
Item item1 = RelationshipsExamples.itemExample1();
Order order1 = RelationshipsExamples.orderExample1();
customer.addOrder(order1);
order1.setItem(item1);
Item item2 = RelationshipsExamples.itemExample2();
Order order2 = RelationshipsExamples.orderExample2();
customer.addOrder(order2);
order2.setItem(item2);
Item item3 = RelationshipsExamples.itemExample3();
Order order3 = RelationshipsExamples.orderExample3();
customer.addOrder(order3);
order3.setItem(item3);
em.persist(customer);
commitTransaction(em);
closeEntityManager(em);
clearCache("fieldaccess");
em = createEntityManager("fieldaccess");
beginTransaction(em);
customer = em.find(Customer.class, customer.getCustomerId());
em.remove(customer);
commitTransaction(em);
beginTransaction(em);
verifyDelete(customer, "fieldaccess");
commitTransaction(em);
} finally {
if (isTransactionActive(em)) {
rollbackTransaction(em);
}
closeEntityManager(em);
}
}
// Test reading a customer works correctly.
public void testReadCustomer() {
Customer customer = RelationshipsExamples.customerExample4();
EntityManager em = createEntityManager("fieldaccess");
QuerySQLTracker counter = null;
try {
beginTransaction(em);
Item item1 = RelationshipsExamples.itemExample1();
Order order1 = RelationshipsExamples.orderExample1();
customer.addOrder(order1);
order1.setItem(item1);
Item item2 = RelationshipsExamples.itemExample2();
Order order2 = RelationshipsExamples.orderExample2();
customer.addOrder(order2);
order2.setItem(item2);
Item item3 = RelationshipsExamples.itemExample3();
Order order3 = RelationshipsExamples.orderExample3();
customer.addOrder(order3);
order3.setItem(item3);
em.persist(customer);
commitTransaction(em);
closeEntityManager(em);
clearCache("fieldaccess");
em = createEntityManager("fieldaccess");
beginTransaction(em);
counter = new QuerySQLTracker(getServerSession("fieldaccess"));
customer = em.find(Customer.class, customer.getCustomerId());
for (Order order : customer.getOrders()) {
order.getCustomer();
}
if (isWeavingEnabled("fieldaccess") && counter.getSqlStatements().size() > 2) {
fail("Should have been 2 queries but was: " + counter.getSqlStatements().size());
}
commitTransaction(em);
} finally {
if (isTransactionActive(em)) {
rollbackTransaction(em);
}
if (counter != null) {
counter.remove();
}
closeEntityManager(em);
}
}
public void testRemoveReference() {
EntityManager em = createEntityManager("fieldaccess");
try {
beginTransaction(em);
Customer2 customer = new Customer2();
em.persist(customer);
int id = customer.getCustomerId();
commitTransaction(em);
closeEntityManager(em);
clearCache("fieldaccess");
em = createEntityManager("fieldaccess");
beginTransaction(em);
Customer2 customerReference = em.getReference(Customer2.class, id);
em.remove(customerReference);
commitTransaction(em);
assertNull("Customer was not removed", em.find(Customer2.class, id));
} finally {
if (isTransactionActive(em)) {
rollbackTransaction(em);
}
closeEntityManager(em);
}
}
}