[jboss-jira] [JBoss JIRA] Updated: (JBMESSAGING-1037) JDBCPersistenceManager.java - reference should be inserted after message (ORA-02291: integrity constraint)

[Mariusz Olejnik (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBMESSAGING-1037?page=all ]

Mariusz Olejnik updated JBMESSAGING-1037:
-----------------------------------------

    Attachment: jboss-messaging-trunk-rev2988.patch

addReference(channelID, ref, psReference, false);
^
|
v
updateWithRetry(psMessage);

> JDBCPersistenceManager.java - reference should be inserted after message (ORA-02291: integrity constraint)
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: JBMESSAGING-1037
>                 URL: http://jira.jboss.com/jira/browse/JBMESSAGING-1037
>             Project: JBoss Messaging
>          Issue Type: Patch
>          Components: Messaging Core Persistence
>    Affects Versions: 1.4.0.CR1
>         Environment: Windows XP / Oracle 10g
>            Reporter: Mariusz Olejnik
>         Assigned To: Tim Fox
>            Priority: Critical
>             Fix For: 1.4.0.CR1
>
>         Attachments: jboss-messaging-trunk-rev2988.patch
>
>
> Reference should be inserted after message because:
> oracle-persistence-service.xml 
> CREATE TABLE JBM_MSG_REF (
>   CHANNEL_ID INTEGER, 
>   MESSAGE_ID INTEGER REFERENCES JBM_MSG(MESSAGE_ID) 
> [...]

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