-
1. Re: Ticket Monster in MySQL issue
jaikiran Sep 3, 2014 3:18 AM (in response to leets003)The only way I can think of fixing this issue is by using a better table name for that entity ticket-monster/Show.java at 2.6.x-develop · jboss-developer/ticket-monster · GitHub. Their github repo jboss-developer/ticket-monster · GitHub doesn't link to a JIRA or other issue tracking instance where you could raise this issue. Maybe arungupta or ctomc might be able to bring this to the attention of the right developers.
-
2. Re: Ticket Monster in MySQL issue
vineet.reynolds Sep 23, 2014 11:57 AM (in response to leets003)Hi,
Sorry about the late reply. This has just been fixed recently. Getting it updated on the site will take some time.
For now, I'd recommend using the @Table annotation to specify a table name for the 'Show' entity, that doesn't conflict with the SHOW reserved word in MySQL. In the fix, I've opted for 'Appearance', but you could specify any other name. You'll also need to make changes in the import.sql script and specify the new table name, instead of 'Show'.
You can use this git commit as a reference: JDF-500 Add MySQL support to TicketMonster. · e968bb1 · jboss-developer/ticket-monster · GitHub
Thanks,
Vineet