[JBoss JIRA] Commented: (JBESB-377) Add MySQL support to the admin console.
by Bernard Tison (JIRA)
[ http://jira.jboss.com/jira/browse/JBESB-377?page=comments#action_12363344 ]
Bernard Tison commented on JBESB-377:
-------------------------------------
I did something similar some time ago. Maybe you can reuse some of this stuff.
Attached are the files I changed/added:
product/tools/console/distro/distro-build.xml : added mysql as possible choice for
the database
product/tools/console/distro/mysql/build.xml: mysql specific build file
product/tools/console/distro/mysql/db.applications.modules.xml: mysql specific modules
product/tools/console/distro/mysql/jboss-esb-console-ds.xml: datasource definition
product/tools/console/distro/mysql/persistence.xml: persistence deployment descriptor
One issue I ran into is that the class org.jboss.soa.esb.admin.console.contract.MessageContract contains a field usage, which is mapped to a column with name usage. But usage is a reserved word in MySQL, so this did not work. So I mapped the usage field ta a column with name messagecontract_usage with the annotation @Column(name="messagecontract_usage"). I also had to modify the product/tools/console/resources/import.sql to reflect this change.
The mapping modification will also affect the other supported db's (hsqldb, postgres), so maybe there is another workaround possible for this reserved word issue.
I tested the ESB console with MySQL 5.0.27 on linux.
> Add MySQL support to the admin console.
> ---------------------------------------
>
> Key: JBESB-377
> URL: http://jira.jboss.com/jira/browse/JBESB-377
> Project: JBoss ESB
> Issue Type: Feature Request
> Security Level: Public(Everyone can see)
> Components: Tooling
> Affects Versions: 4.0 CR2
> Reporter: Tom Fennelly
> Assigned To: Tom Fennelly
> Fix For: 5.0
>
>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
17 years, 6 months