Forgot to mention the error is that there is no space between the tablename and the open bracket....
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...
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.
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 ...