[ https://jira.jboss.org/jira/browse/JBAS-6372?page=com.atlassian.jira.plug... ] Dimitris Andreadis commented on JBAS-6372: ------------------------------------------ Ok, then attach your example datasources so we can take a look, thanks. Also, please don't set the fix versions yourself. -- 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

[ https://jira.jboss.org/jira/browse/JBAS-6372?page=com.atlassian.jira.plug... ] 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. -- 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

[ https://jira.jboss.org/jira/browse/JBAS-6372?page=com.atlassian.jira.plug... ] murray armfield updated JBAS-6372: ---------------------------------- Attachment: create_database.sql create_database.sql Hi, Over the weekend, I redid two of the create database scripts for Ingres. Please note that these two files are updates to the ones I included in the tarball, so please disregard the earlier two I submitted as part of that tarball. The first file (sorry they're both called create_database.sql, is just that that is their name in an installation) is for creating the table message, for the message store. It has been updated to use modern data types rather than the older 'text' data type. This file should be installed in server/$conf/deploy/jbossesb.esb/message-store-sql/ingres. The second file is for creating the tables as part of the juddi-sql registry. It has been updated to reflect the current table structures and data that is found in the current source of the jUDDI project. This file should be installed in server/$conf/deploy/jbossesb.sar/juddi-sql/ingres directory on jboss. I will be posting this jUDDI work to the jUDDI project. Continuing to work away on jboss... -- 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

[ https://jira.jboss.org/jira/browse/JBAS-6372?page=com.atlassian.jira.plug... ] murray armfield commented on JBAS-6372: --------------------------------------- Hi Folks, I have been working around this for some time and have put together a better set of files for inclusion as JBoss AS. Please disregard all previous uploads except JBAS-ingres.tar.gz. Although this is the most recent upload, it is not the last one in the list of downloads. In this tarball, there are the datasource templates for using Ingres and the messaging configuration file for Ingres. Additionally, Ingres use requires an updated CMP from what has been shipping in JBoss AS for some time now. I have included a copy of standardjbosscmp-jdbc.xml which has the current updated CMP for use with Ingres. Using this CMP means that all the other files that used to be part of this jIRA are no longer necessary. As an aside, the old download jboss-soa-p.4.3.0.tar.gz does have the ingres versions/files for what is distributed with JBoss SOA to make use of the automatic database reconfiguration scripts if your interested/can use them. 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