[jboss-jira] [JBoss JIRA] Commented: (JBPM-1025) When running HBM2DDL on StringInstnace.hbm.xml on oracle DB, the length of the column length is 255 even that it defined 4000 in hbm

[ http://jira.jboss.com/jira/browse/JBPM-1025?page=comments#action_12371805 ] Lior Ban commented on JBPM-1025: -------------------------------- There is a solution to this, the file StringInstance.hbm.xml can be changed as follow to support this: <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping default-access="field"> <subclass name="org.jbpm.context.exe.variableinstance.StringInstance" extends="org.jbpm.context.exe.VariableInstance" discriminator-value="S"> <property name="value" type="string" column="STRINGVALUE_" length="4000"/> </subclass> <database-object> <create> ALTER TABLE "JBPM_VARIABLEINSTANCE" MODIFY "STRINGVALUE_" varchar(4000) </create> <drop></drop> <dialect-scope name="org.hibernate.dialect.SybaseAnywhereDialect"></dialect-scope> </database-object> <database-object> <create> ALTER TABLE jbpm_variableinstance MODIFY COLUMN STRINGVALUE_ VARCHAR(4000) </create> <drop></drop> <dialect-scope name="org.hibernate.dialect.MySQLDialect"></dialect-scope> <dialect-scope name="org.hibernate.dialect.DB2Dialect"></dialect-scope> <dialect-scope name="org.hibernate.dialect.OracleDialect"></dialect-scope> </database-object> </hibernate-mapping> -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira