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

[ https://jira.jboss.org/jira/browse/JBMESSAGING-1491?page=com.atlassian.ji... ] 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. -- 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