[jboss-jira] [JBoss JIRA] Commented: (JBMESSAGING-1491) add support for Ingres RDBMS to JBoss Messaging

[murray armfield (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBMESSAGING-1491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12448918#action_12448918 ] 

murray armfield commented on JBMESSAGING-1491:
----------------------------------------------

Hi Folks,
    I've resolved the issue I was having with the queue-failover example and now all examples work correctly on an Ingres RDBMS with a transaction isolation level of READ_COMMITTED. 

   On my Ingres dbms, I have relaxed the locking policy to readlock = nolock. (This is an ingres specific setting that any ingres dba would be aware of). By default, ingres runs with a very high level of locking out-of-the-box, leaning towards consistency rather than concurrency. This setting is a very standard setting used.

   Net result:
     1/ if you want complete consistency, you can run ingres out-of-the box and set jdbc transaction isolation level to SERIALIZABLE.
     2/ if you want more concurrency, you can run ingres with readlock = nolock and set jdbc transaction isolation level to READ_COMMITTED.

    If there is any more testing or explanation or work that anyone would like me to do towards supporting Ingres, please feel free to ask.

Take care,
    Murray.

> add support for Ingres RDBMS to JBoss Messaging
> -----------------------------------------------
>
>                 Key: JBMESSAGING-1491
>                 URL: https://jira.jboss.org/jira/browse/JBMESSAGING-1491
>             Project: JBoss Messaging
>          Issue Type: Patch
>    Affects Versions: 1.4.0.SP3.CP06, 2.0.0 Beta, EAP/SOA-P Integration, 1.4.3.GA, 2.0.0.GA, Unscheduled, AS 5.0 Integration
>         Environment: N/A
>            Reporter: murray armfield
>            Assignee: Tim Fox
>            Priority: Minor
>         Attachments: ingres-persistence-service.newrev.xml, ingres-persistence-service.xml, ingres-persistence-service.xml
>
>   Original Estimate: 30 minutes
>  Remaining Estimate: 30 minutes
>
> I've been working on JBoss support on Ingres.
> I've written an ingres-persistence-service.xml file for use with Ingres for inclusion as part of JBoss Messaging

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira