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()));
}
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()));
}
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();
}
}
}
Aggregations