[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=12450335#action_12450335 ] 

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

Hi Folks,
    I've finished working on JBoss Messaging and running the test suite against Ingres community edition 9.2 build 134 on linux 32 bit.

    I've been using the './build.sh report' version of the tests and have been tuning Ingres so that it works correctly and passes all tests. For those that are interested, the settings that should be used/configured in Ingres are:

1/ DBMS->system_locklevel = row
2/ DBMS->connect_limit = 512
3/ DBMS->table_auto_structure = ON
4/ DBMS->qsf_guideline = huge
5/ Locking->per_tx_limit = 2500

    It should be noted that any version on Ingres lower than 9.2 will not work correctly due to the enhancements made in 9.2 specifically around (C/B)LOB's. I have also tried using build 140 and 141 on linux 32 bit and 64bit. That release of Ingres has some problems and should not be used.

    Ingres is currently in our release cycle for the 9.2 enterprise version(as opposed to the community version). Releases come out for all our different platforms one by one. It is my intention to support JBoss Messaging on Ingres 9.2 enterprise edition going forth. I will continue to test running the JBoss Messaging test suite against Ingres 9.2 enterprise editions that are released if I have hardware and community editions, again if I have hardware.

    I've made a svn diff file for adding ingres support against the JBoss-Messaging-1.4.2.GA code line for people to use/commit etc. It is attached to this jIRA. I'd like to also add a file documenting suggested Ingres settings for use with JBoss Messaging, and I would think that other db's also have recommended settings, but not sure where to put this.

    Would it be possible to get this patch applied to the 1.4.3 code so it is included in that release? If not, is there anything I need to do to help out in getting Ingres added to the supported database options?

> 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