-
Bug
-
Resolution: Done
-
Major
-
None
-
None
-
JUnit tests via ANT for DB2
Add "RESULT SETS 1" in create statements for stored procedures in src/org/hibernate/test/sql/hand/custom/db2/Mapping.hbm.xml
Before:
CREATE PROCEDURE HIBDB2TST.selectAllEmployments ()
CREATE PROCEDURE HIBDB2TST.paramHandling (IN j SMALLINT, IN i SMALLINT)
CREATE PROCEDURE HIBDB2TST.simpleScalar (IN j SMALLINT)
After:
CREATE PROCEDURE HIBDB2TST.selectAllEmployments () RESULT SETS 1
CREATE PROCEDURE HIBDB2TST.paramHandling (IN j SMALLINT, IN i SMALLINT) RESULT SETS 1
CREATE PROCEDURE HIBDB2TST.simpleScalar (IN j SMALLINT) RESULT SETS 1
Without that, DB2 returns a SQL Warning code 464 and no result sets.
This causes the tests testScalarStoredProcedure, testParameterHandling and testEntityStoredProcedure under org.hibernate.test.sql.hand.custom.db2.DB2CustomSQLTest to fail.
- blocks
-
JBPAPP-983 Certify EAP 4.2/4.3 on DB2
- Resolved