JBoss and Hibernate cannot create table

[torsten.jenkner]

Hello,

while runningJboss 4.0.5. GA and EJB3.0 i get the following message
while automatically exporting the schema of an entity to the HSQL
database:


23:32:47,924 INFO [SchemaExport] Running hbm2ddl schema export
23:32:47,924 INFO [SchemaExport] exporting generated schema to
database
23:32:47,924 ERROR [SchemaExport] Unsuccessful: create table
PUBLIC.CABIN (ID) integer not null, NAME) varchar(255), BED_COUNT)
integer, DECK_LEVEL) integer, SHIP_ID) integer, prim
ary key (ID)))
23:32:47,924 ERROR [SchemaExport] Wrong data type: ) in statement
[create table PUBLIC.CABIN (ID)]
23:32:47,924 INFO [SchemaExport] schema export complete

... although the dialect ist HSQLDialect this wrong syntax is generated
(wrong ending brackets). What has to be done other than giving the
correct dialect to EJB3 to generate the correct syntax?

regards

Torsten Jenkner

 

[Torsten Jenkner]

Hello,

while runningJboss 4.0.5. GA and EJB3.0 i get the following message
while automatically exporting the schema of an entity to the HSQL
database:


23:32:47,924 INFO [SchemaExport] Running hbm2ddl schema export
23:32:47,924 INFO [SchemaExport] exporting generated schema to
database
23:32:47,924 ERROR [SchemaExport] Unsuccessful: create table
PUBLIC.CABIN (ID) integer not null, NAME) varchar(255), BED_COUNT)
integer, DECK_LEVEL) integer, SHIP_ID) integer, prim
ary key (ID)))
23:32:47,924 ERROR [SchemaExport] Wrong data type: ) in statement
[create table PUBLIC.CABIN (ID)]
23:32:47,924 INFO [SchemaExport] schema export complete

.. although the dialect ist HSQLDialect this wrong syntax is generated
(wrong ending brackets). What has to be done other than giving the
correct dialect to EJB3 to generate the correct syntax?

regards

Torsten Jenkner

I just got the solution:

The code included some strange ending brackets in the entity, deleting
them just solved this problem, the entity is deployed now. Thank you
anyways!

Torsten Jenkner