Description of problem: Test: org.jbpm.context.exe.variableinstance.SerializableInstanceDbTest.testSerializableVariableKeepsId is failing with message: java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.math.BigInteger at org.jbpm.context.exe.variableinstance.SerializableInstanceDbTest.getLatestDbId(SerializableInstanceDbTest.java:138) at org.jbpm.context.exe.variableinstance.SerializableInstanceDbTest.testSerializableVariableKeepsId(SerializableInstanceDbTest.java:69) at org.jbpm.db.AbstractDbTestCase.runTest(AbstractDbTestCase.java:73) The exception is thrown when an attempt is made to cast the retrieved ID (from the JBPM_BYTEARRAY table) to BigInteger. Additional info: Looks like this is caused by Hibernate mapping the NUMERIC and NUMBER data type to BigDecimal when not specified otherwise.
Hi Marek, Sorry, I thought I posted a comment to this before I went on PTO, but it's not showing up here. In any case, which DB did you see this with?
Hi Marco! Welcome back! NP - I know you where enjoying the snow;). Which databases? All which declare the ID column on JBPM_BYTEARRAY as 'number' or 'numeric'. If I remember correctly then this includes mssql, sybase and oracle.
GSS considers this medium priority. jBPM gets plenty of attention, anything we can do to make it smoother is appreciated.
On Len's request appending comment: I don't think this is a regression. I was not able to found any bug fixes which would cause this error.
Technical note added. If any revisions are required, please edit the "Technical Notes" field accordingly. All revisions will be proofread by the Engineering Content Services team. New Contents: When using SerializableInstanceDbTest, an exception is thrown when an attempt is made to cast the retrieved ID (from the JBPM_BYTEARRAY table) to BigInteger.
Fixed, see http://git.app.eng.bos.redhat.com/?p=jbpm3.git;a=commit;h=34c36e5c6a39df73068605336f562d7012235977
Verified on SOA 5.3 ER4.
Marco Rietveld <marco.rietveld> updated the status of jira JBPM-3654 to Resolved