[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=12448904#action_12448904 ] 

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

Hi Howard and folks,
   I've been running the examples shipped with JBoss-Messaging 1.4.2.GA on the above mentioned setup and have come to the following conclusion.

   The one example which I have problems with is the queue-failover mentioned above. What I found is that if I run the cluster with a data source jdbc connection with an isolation level of SERIALIZABLE, the queue-failover example works fine - hooray! Any lower level of isolation fails with the same error. The error is around accessing a LOB column more than once. I will continue to play around with this and some LOB settings on Ingres 9.2

    If anyone is interested in using Ingres with JBoss 4.2.3.GA and JBoss-messaging-1.4.2.GA, you will need to create the timers table manually as the creation of this table is hard coded in a java class and has sql which is not entirely portable. Personally I use...

CREATE TABLE TIMERS(
	TIMERID VARCHAR(80) NOT NULL,
	TARGETID VARCHAR(80) NOT NULL,
	INITIALDATE DATE,
	TIMERINTERVAL BIGINT,
	INSTANCEPK LONG VARCHAR,
	INFO LONG VARCHAR,
	PRIMARY KEY(TIMERID, TARGETID));



> 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