| /* |
| * Copyright (c) 2005, 2020 Oracle and/or its affiliates. All rights reserved. |
| * Copyright (c) 2005, 2015 SAP. All rights reserved. |
| * |
| * This program and the accompanying materials are made available under the |
| * terms of the Eclipse Public License v. 2.0 which is available at |
| * http://www.eclipse.org/legal/epl-2.0, |
| * or the Eclipse Distribution License v. 1.0 which is available at |
| * http://www.eclipse.org/org/documents/edl-v10.php. |
| * |
| * SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause |
| */ |
| |
| // Contributors: |
| // SAP - initial API and implementation |
| |
| package org.eclipse.persistence.testing.tests.wdf.jpa1.relation; |
| |
| import java.sql.Date; |
| import java.sql.SQLException; |
| |
| import jakarta.persistence.EntityManager; |
| import jakarta.persistence.Query; |
| |
| import org.eclipse.persistence.testing.framework.wdf.JPAEnvironment; |
| import org.eclipse.persistence.testing.models.wdf.jpa1.employee.Patent; |
| import org.eclipse.persistence.testing.models.wdf.jpa1.employee.PatentId; |
| import org.eclipse.persistence.testing.models.wdf.jpa1.employee.PatentReview; |
| import org.eclipse.persistence.testing.tests.wdf.jpa1.JPA1Base; |
| import org.junit.Test; |
| |
| public class TestPatentReview extends JPA1Base { |
| |
| @Test |
| public void testToOneRelationshipWithEmbddedKey() throws SQLException { |
| clearAllTables(); |
| final JPAEnvironment env = getEnvironment(); |
| final EntityManager em = env.getEntityManager(); |
| try { |
| final String FUSSBALL = "Fussball"; |
| env.beginTransaction(em); |
| PatentReview patentReview = new PatentReview(); |
| Patent patent = new Patent(FUSSBALL, 1857, "das Fu\u00dfballspiel", Date.valueOf("1857-01-01")); |
| patentReview.setId(17); |
| patentReview.setPatent(patent); |
| patentReview.setReviewText("Review des Patents des Fu\u00dfballspiels"); |
| em.persist(patent); |
| em.persist(patentReview); |
| env.commitTransactionAndClear(em); |
| Object found = em.find(PatentReview.class, Integer.valueOf(17)); |
| verify(found != null, "nothing found"); |
| verify(found instanceof PatentReview, "wrong instance: " + found.getClass().getName()); |
| PatentReview review = (PatentReview) found; |
| verify(review.getPatent() != null, "patent is null"); |
| Patent pat = review.getPatent(); |
| PatentId id = pat.getId(); |
| verify(FUSSBALL.equals(id.getName()), "patent has wrong name: " + id.getName()); |
| verify(id.getYear() == 1857, "patent has wrong year: " + id.getYear()); |
| } finally { |
| closeEntityManager(em); |
| } |
| } |
| |
| @Test |
| public void testNoEnBlocLoading() throws SQLException { |
| clearAllTables(); |
| final JPAEnvironment env = getEnvironment(); |
| final EntityManager em = env.getEntityManager(); |
| try { |
| env.beginTransaction(em); |
| |
| final String PARSER = "SQL Parser"; |
| PatentReview patentReview = new PatentReview(); |
| Patent patent = new Patent(PARSER, 2002, "SQL Parser", Date.valueOf("2002-01-01")); |
| patentReview.setId(20); |
| patentReview.setPatent(patent); |
| patentReview.setReviewText("Review vom SQL Parser Patent"); |
| em.persist(patent); |
| em.persist(patentReview); |
| |
| final String SORTER = "Foreign Key Sorter"; |
| patentReview = new PatentReview(); |
| patent = new Patent(SORTER, 2008, "Foreign Key Sorter", Date.valueOf("2008-01-01")); |
| patentReview.setId(21); |
| patentReview.setPatent(patent); |
| patentReview.setReviewText("Review vom Foreign Key Sorter"); |
| em.persist(patent); |
| em.persist(patentReview); |
| |
| final String MONITOR = "JPA Monitor"; |
| patentReview = new PatentReview(); |
| patent = new Patent(MONITOR, 2007, "JPA Monitor", Date.valueOf("2007-01-01")); |
| patentReview.setId(22); |
| patentReview.setPatent(patent); |
| patentReview.setReviewText("Review vom JPA Monitor"); |
| em.persist(patent); |
| em.persist(patentReview); |
| |
| final String MANAGER = "Environment Manager"; |
| patentReview = new PatentReview(); |
| patent = new Patent(MANAGER, 2005, "Environment Manager", Date.valueOf("2005-01-01")); |
| patentReview.setId(23); |
| patentReview.setPatent(patent); |
| patentReview.setReviewText("Review vom Environment Manager"); |
| em.persist(patent); |
| em.persist(patentReview); |
| |
| env.commitTransactionAndClear(em); |
| |
| env.beginTransaction(em); |
| Query query = em.createQuery("select r from PatentReview r"); |
| query.getResultList(); |
| |
| } finally { |
| closeEntityManager(em); |
| } |
| } |
| |
| @Test |
| public void testNativeQuery() throws SQLException { |
| clearAllTables(); |
| final JPAEnvironment env = getEnvironment(); |
| final EntityManager em = env.getEntityManager(); |
| try { |
| final String FUSSBALL = "Fussball"; |
| env.beginTransaction(em); |
| PatentReview patentReview = new PatentReview(); |
| Patent patent = new Patent(FUSSBALL, 1857, "das Fu\u00dfballspiel", Date.valueOf("1857-01-01")); |
| patentReview.setId(18); |
| patentReview.setPatent(patent); |
| patentReview.setReviewText("Review des Patents des Fu\u00dfballspiels"); |
| em.persist(patent); |
| em.persist(patentReview); |
| env.commitTransactionAndClear(em); |
| Query query = em |
| .createNativeQuery( |
| "select * from TMP_REVIEW join TMP_REVIEW_DETAILS on TMP_REVIEW.ID = TMP_REVIEW_DETAILS.REVIEW_ID where ID = 18", |
| PatentReview.class); |
| Object found = query.getSingleResult(); |
| verify(found != null, "nothing found"); |
| verify(found instanceof PatentReview, "wrong instance: " + found.getClass().getName()); |
| PatentReview review = (PatentReview) found; |
| verify(review.getPatent() != null, "patent is null"); |
| Patent pat = review.getPatent(); |
| PatentId id = pat.getId(); |
| verify(FUSSBALL.equals(id.getName()), "patent has wrong name: " + id.getName()); |
| verify(id.getYear() == 1857, "patent has wrong year: " + id.getYear()); |
| } finally { |
| closeEntityManager(em); |
| } |
| } |
| } |