package com.example;
import org.hibernate.Session;
import org.hibernate.dialect.H2Dialect;
import org.hibernate.testing.RequiresDialect;
import org.hibernate.testing.junit4.BaseNonConfigCoreFunctionalTestCase;
import org.hibernate.type.NumericBooleanType;
import org.hibernate.type.YesNoType;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import javax.persistence.ParameterMode;
@RequiresDialect(H2Dialect.class)
public class StoredProcedureApiTest extends BaseNonConfigCoreFunctionalTestCase {
private Session session;
@Before
public void setUp() {
session = openSession();
}
@After
public void tearDown() {
session.close();
}
@Test
public void testNumericBooleanTypeInParameter() {
session.createStoredProcedureQuery("test")
.registerStoredProcedureParameter(1, NumericBooleanType.class, ParameterMode.IN)
.registerStoredProcedureParameter(2, String.class, ParameterMode.OUT)
.setParameter(1, false);
}
@Test
public void testYesNoTypeInParameter() {
session.createStoredProcedureQuery("test")
.registerStoredProcedureParameter(1, YesNoType.class, ParameterMode.IN)
.registerStoredProcedureParameter(2, String.class, ParameterMode.OUT)
.setParameter(1, false);
}
}
