Hi,
I just noticed that the jbosstest test suite
fails some of the tests due to a problem with
JAWS table creation.
Seems like the problem is because of a change
recently committed to
org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.
The problem is that the CONSTRAINT keyword is not
understood by all databases. In particular it is
not understood by the Hypersonic database that
happens to be the default datasource in JBoss,
and as such is used in the test suite.
If this piece of code is commented out everything
runs fine.
The problem can be tricky to find or reproduce,
since it does not occur if the table has already
been created.
And with the default log level used, debug messages
are not logged. And since the error message is
printed with log.debug(...) in line 127, it is not
printed by default.
Shouldn't this be log.error(...)?
With log.error(...), I get:
[JAWS] Could not create table nextgen_EnterpriseEntity:
Unexpected token: CONSTRAINT in statement [CREATE
TABLE nextgen_EnterpriseEntity (name VARCHAR(256)
CONSTRAINT pknextgen_EnterpriseEntity PRIMARY KEY,
otherField INTEGER)]
I'm not familiar with JAWS, so I'll rather not touch
this. But I guess someone (mgroot?) should.
Best Regards,
Ole Husgaard.
