[
https://issues.apache.org/jira/browse/ODE-457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Ahn updated ODE-457:
-------------------------
Attachment: ode-457.1x.patch
Patch attached.
1. Due to a bug introduced to OpenJPA 1.2.0, multiple definitions on columns
are not possible with that OpenJPA version; upgraded to 1.3.0-SNAPSHOT.
2. The problem is that Mysql does not like the table name being used as the
target for deletion and part of the sub-select. Because of that, OpenJPA
generated a totally wrong sql queries for those cases. Almost all
instance/process deletion queries have been re-worked.
> DeploymentService undeploy error
> --------------------------------
>
> Key: ODE-457
> URL: https://issues.apache.org/jira/browse/ODE-457
> Project: ODE
> Issue Type: Bug
> Components: BPEL Runtime
> Reporter: Sean Ahn
> Attachments: ode-457.1x.patch
>
>
> When un-deploying a process, a multi-table targetting delete query is
> generated on mysql/openjpa and fails.
> ERROR - GeronimoLog.error(108) | DbError
> <openjpa-1.2.0-r422266:683325 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Unknown table 't0' in
> MULTI DELETE {prepstmnt 11114689 DELETE t0, t1 FROM ODE_EVENT WHERE EVENT_ID
> IN (SELECT DISTINCT t0.EVENT_ID FROM ODE_EVENT t0 INNER JOIN
> ODE_PROCESS_INSTANCE t1 ON t0.INSTANCE_ID = t1.ID WHERE (t1.PROCESS_ID =?))
> [params=(long) 51]} [code=1109, state=42S02] FailedObject: DELETE t0, t1 FROM
> ODE_EVENT WHERE EVENT_ID IN (SELECT DISTINCT t0.EVENT_ID FROM ODE_EVENT t0
> INNER JOIN ODE_PROCESS_INSTANCE t1 ON t0.INSTANCE_ID = t1.ID WHERE
> (t1.PROCESS_ID = ?)) [java.lang.String]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
