[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

[Lior Ban (JIRA)]

    [ 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>



> 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
> ------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: JBPM-1025
>                 URL: http://jira.jboss.com/jira/browse/JBPM-1025
>             Project: JBoss jBPM
>          Issue Type: Bug
>          Components: Core Engine
>    Affects Versions: jBPM jPDL 3.2
>         Environment: Oracle on Unix Solaris
>            Reporter: Lior Ban
>         Assigned To: Tom Baeyens
>
> We create the Oracle JBPM DB tables by running Hbm2Ddl,
> In the StringInstance.hbm.xml file it is writen:
> <property name="value" type="string" length="4000">
> However still when creating the DB in the DB explorer we see that it is VARCHAR2(255) length 255
> Maybe it is veacuse setValue and getValue return object in VarilableInstance object from which StringInstance inherits?
> When we have string with length 269 it can't be put in the DB and we get exception.

-- 
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