[esb-issues] [JBoss JIRA] Updated: (JBESB-2755) Patch to add Ingres support to JBoss ESB

Patch to add Ingres support to JBoss ESB ---------------------------------------- Key: JBESB-2755 URL: https://jira.jboss.org/jira/browse/JBESB-2755 Project: JBoss ESB Issue Type: Patch Security Level: Public(Everyone can see) Affects Versions: 4.5 Environment: N/A Reporter: murray armfield Attachments: jbossesb-4.5.GA-src-ingres.diff, jbossesb-4.6-src-ingres.diff Original Estimate: 30 minutes Remaining Estimate: 30 minutes Hi Folks, I've been working with getting JBoss ESB and its test suite(qa directory of src tarball download) ported to use the Ingres database system. Interested users should use the most recent Ingres release. I am in a position where I am passing all the same tests as the hsqldb. The ones that fail, fail in the same way as the hsqldb db fails. The failing tests are 1/ JmsGatewayListenerUnit Test - I get 'the destination does not exist' errors when it tries to create the topic used in the test. 2/ BPMOrchestration2Test - The last action, shipping, doesn't occur - state seems to be the same as hslqdb upon inspection through jbpm web console. 3/ JMSecuredTest - No classloaders found for JDBCJMSUserManagerService. If I need to revisit any of these or run any other test suites, please let me know and I will get on top of it immediately. Currently, Ingres 9.2 which is the current Ingres release, does not support object names greater than 32 characters. This is being addressed in future versions of Ingres. In the community version of Ingres, you can download and build the source code with an appropriate flag switched which will turn on much bigger object names. Some of the drools code in JBossESB uses objects with names greater than this limit, but it has not affected any of the tests that run. I am looking at doing something with drools to work with Ingres temporarily Take care, Murray