[JBoss JIRA] Created: (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
7:53 a.m.
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
4:54 a.m.
New subject: [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>
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
9:26 a.m.
New subject: [JBoss JIRA] Closed: (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=all ]
Tom Baeyens closed JBPM-1025.
-----------------------------
Resolution: Deferred
you can still tweak the generated DDL before you load it into your database.
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
6606
days inactive
6648
days old
2 comments
2 participants
participants (2)
-
Lior Ban (JIRA) -
Tom Baeyens (JIRA)