Search in sources :

Example 1 with Car

use of com.baeldung.jpa.model.Car in project tutorials by eugenp.

the class StoredProcedureIntegrationTest method findCarsByYearNamedProcedure.

@Test
public void findCarsByYearNamedProcedure() {
    final StoredProcedureQuery findByYearProcedure = entityManager.createNamedStoredProcedureQuery("findByYearProcedure");
    final StoredProcedureQuery storedProcedure = findByYearProcedure.setParameter("p_year", 2015);
    storedProcedure.getResultList().forEach(c -> Assert.assertEquals(new Integer(2015), ((Car) c).getYear()));
}
Also used : Car(com.baeldung.jpa.model.Car) StoredProcedureQuery(javax.persistence.StoredProcedureQuery) Test(org.junit.Test)

Example 2 with Car

use of com.baeldung.jpa.model.Car in project tutorials by eugenp.

the class StoredProcedureIntegrationTest method findCarsByYearNoNamed.

@Test
public void findCarsByYearNoNamed() {
    final StoredProcedureQuery storedProcedure = entityManager.createStoredProcedureQuery("FIND_CAR_BY_YEAR", Car.class).registerStoredProcedureParameter(1, Integer.class, ParameterMode.IN).setParameter(1, 2015);
    storedProcedure.getResultList().forEach(c -> Assert.assertEquals(new Integer(2015), ((Car) c).getYear()));
}
Also used : Car(com.baeldung.jpa.model.Car) StoredProcedureQuery(javax.persistence.StoredProcedureQuery) Test(org.junit.Test)

Example 3 with Car

use of com.baeldung.jpa.model.Car in project tutorials by eugenp.

the class StoredProcedureIntegrationTest method createCarTest.

@Test
public void createCarTest() {
    final EntityTransaction transaction = entityManager.getTransaction();
    try {
        transaction.begin();
        final Car car = new Car("Fiat Marea", 2015);
        entityManager.persist(car);
        transaction.commit();
    } catch (final Exception e) {
        System.out.println(e.getCause());
        if (transaction.isActive()) {
            transaction.rollback();
        }
    }
}
Also used : EntityTransaction(javax.persistence.EntityTransaction) Car(com.baeldung.jpa.model.Car) Test(org.junit.Test)

Aggregations

Car (com.baeldung.jpa.model.Car)3 Test (org.junit.Test)3 StoredProcedureQuery (javax.persistence.StoredProcedureQuery)2 EntityTransaction (javax.persistence.EntityTransaction)1