[ODE-1052] Improper database column definitions in Hibernate persistent classes

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.6
• Fix Version/s: 1.3.7, 1.4
• Component/s: BPEL Runtime
• Assignee: Sathwik
• Reporter: Sathwik
• Created: 05/Apr/16 05:51
• Updated: 28/Nov/17 07:56
• Resolved: 08/Jul/16 07:14

Description

Properties of persistent classes used by Hibernate DAO defines with type org.apache.ode.daohib.bpel.hobj.GZipDataType which is of Type java.sql.BLOB and database specific type as blob(2G).

The SQL syntax of blob(2G) is not supported by all databases.

@hibernate.property type="org.apache.ode.daohib.bpel.hobj.GZipDataType"
@hibernate.column name="DETAILS" sql-type="blob(2G)"

Persistent classes affected are as follows,
dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HActivityRecovery.java
dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HBpelEvent.java
dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HFaultData.java
dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HMessage.java
dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HMessageExchange.java
dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HPartnerLink.java
dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HProcessInstance.java
dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HXmlData.java

Issue Links

• is required by: ODE-1061 List of Bugs to be ported to trunk from 1.3.7