[jboss-jira] [JBoss JIRA] Updated: (JBAS-6372) Add data source configuration files for Ingres RDBMS support

[murray armfield (JIRA)]

     [ https://jira.jboss.org/jira/browse/JBAS-6372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

murray armfield updated JBAS-6372:
----------------------------------

    Attachment: jboss-soa-p.4.3.0.tar.gz


Please find enclosed a zip file of the work I've done to get Jboss-SOA-p.4.3.0 going on Ingres RDBMS.

The tarball contains mainly ingres components which would need to be added to the server configuration deploy directory on a jboss-soa-p.4.3.0 installation. The one file that I had to alter to work on Ingres is juddi-service.sar/META-INF/ddl/juddi_create_db.ddl. Hopefully the changes I made to that file are still compatible with other dbms's.

Additionally, I updated the schema directory from the tools directory which automates the changing of a database for JBoss-soa. I have left out the jdbc driver for Ingres which is the file iijdbc.jar. That file is found in a Ingres install or downloadable from the Ingres website. I also updated the build.xml and build.properties files in the schema directory to add ingres support.

With these changes, JBoss-soa-p.4.3.0 successfully starts and runs for me with one exception. The timers table creation is hard-coded in the org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin. I have included a script, timers.sql, which may be manually used to create this table before running JBoss.

> Add data source configuration files for Ingres RDBMS support
> ------------------------------------------------------------
>
>                 Key: JBAS-6372
>                 URL: https://jira.jboss.org/jira/browse/JBAS-6372
>             Project: JBoss Application Server
>          Issue Type: Patch
>      Security Level: Public(Everyone can see) 
>          Components: Other
>    Affects Versions: JBossAS-5.0.1.GA, JBossAS-4.2.4.GA, JBossAS-5.1.0.Beta1, JBossAS-6.0.0.Alpha1
>         Environment: N/A
>            Reporter: murray armfield
>            Priority: Optional
>         Attachments: jboss-soa-p.4.3.0.tar.gz
>
>   Original Estimate: 30 minutes
>  Remaining Estimate: 30 minutes
>
> I'm working on getting JBoss going against the Ingres RDBMS database server. I've got some initial config files that can be included as part of the data source configurations. I have other patches for different components, but this issue is just to get two data source definitions added to the jbossas/trunk/connector/src/etc/example-config directory, one for a  local-tx-datasource and one for a xa-datasource.

-- 
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