MySQL, Entity beans and JBoss 3.2.2

[lynke]

With JBoss 3.2.2 on an insertion to a table, the SQL generated is
INSERT INTO table(......

in JBoss 3.2.1 the SQL generated is
INSERT INTO table (.....

MySql blows up with invalid syntax for the first statement. Is there a way of getting this to work without recompiling the source for JBoss - maybe MySQL tweak? or config file tweak?

Any help would be much appreciated....

thanks
regards,

Lynke

[lynke]

Forgot to mention the error is that there is no space between the tablename and the open bracket....

Regards,

Lynke

[wunderkind]

Hello Lynke,

maybe you should have a look into the
standardjbosscmp-jdbc.xml file. As fas as I know there are all the sql statements defined that jboss is using...

[jesper6tv]

We had to add the missing space and recompile, because it is hardcoded into org\jboss\ejb\plugins\cmp\jdbc\JDBCAbstractCreateCommand.class

In fact the bug is already fixed in the cvs.

Cheers
Jesper

[lynke]

Hi Jesper,

Thanks for that - I did the same thing yesterday and meant to follow up with a bug report this morning ...

it's amazing some of the small things which change - the change in that class was done since May so if anyone recompiles the code from JBoss 3.2.1 (not the release itself) I think it would have been in that too (I had done this and the only place it was working was on the release of 3.2.1...)

Good to know it is in there now though ...

Thanks!!

Regards
Lynke