[jbpm-dev] Re: [jbpm-issues] [JBoss JIRA] Resolved: (JBPM-1755) make field Join.parentLockMode persistent

[Tom Baeyens]

 > I want to go ahead and check whether this change is feasible against DB2
 > and Oracle even if we do not officially support it yet.

that is a must.

another thing that we need to cover is migration instructions.

what do our users have to do to upgrade ?  can they do that with a couple of DDL and 
DML statements ?  or do they have to create 2 full schemas next to each other and 
migrate the whole DB contents ?

regards, tom.



Alejandro Guizar wrote:
> Tom,
> 
> Another change I am considering is converting varchar(4000) columns to
> text (JBPM-701) by virtue of setting type="text" in property mappings. 
> The currently supported databases (hsql, postgresql, mysql and sybase)
> work well with text columns. 
> 
> If this text type worked correctly on all databases, it would give us
> three big benefits:
> 
> 1) a single set set of mapping files for all databases
> 2) no need to specify a predefined, arbitrary length
> 3) helps address the page size problem (JBPM-1176)
> 
> I want to go ahead and check whether this change is feasible against DB2
> and Oracle even if we do not officially support it yet.
> 
> -Alejandro
> 
> On Fri, 2008-10-17 at 09:15 +0200, Tom Baeyens wrote:
>> Alejandro,
>>
>> Is this is the only DB schema change ?  Then we should check if this is worthed.  So 
>> much easier for people running into production if they don't have to upgrade the DB.
>>
>> regards, tom.
>>
>>
>>
>> Alejandro Guizar (JIRA) wrote:
>>>      [ https://jira.jboss.org/jira/browse/JBPM-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
>>>
>>> Alejandro Guizar resolved JBPM-1755.
>>> ------------------------------------
>>>
>>>     Resolution: Done
>>>
>>>
>>> made field Join.parentLockMode persistent
>>> allow any lock mode, not just UPGRADE
>>> added lock attribute to join element in xml schema
>>> registered jpdl 3.3 schema in parser
>>>
>>>> make field Join.parentLockMode persistent
>>>> -----------------------------------------
>>>>
>>>>                 Key: JBPM-1755
>>>>                 URL: https://jira.jboss.org/jira/browse/JBPM-1755
>>>>             Project: JBoss jBPM
>>>>          Issue Type: Bug
>>>>      Security Level: Public(Everyone can see) 
>>>>          Components: Core Engine
>>>>    Affects Versions: jBPM 3.3.0 CR1
>>>>            Reporter: Alejandro Guizar
>>>>            Assignee: Alejandro Guizar
>>>>             Fix For: jBPM 3.3.0 GA
>>>>
>>>>
>>>> The value of field Join.parentLockMode is read from the process definition but no database mapping was defined for it.
> 
> _______________________________________________
> jbpm-dev mailing list
> jbpm-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/jbpm-dev

-- 
regards, tom.