ode-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sean Ahn (JIRA)" <j...@apache.org>
Subject [jira] Updated: (ODE-457) DeploymentService undeploy error
Date Tue, 09 Dec 2008 06:19:44 GMT

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


Mime
View raw message