JBoss and Hibernate cannot create table

Discussion in 'Java' started by torsten.jenkner@web.de, Jul 27, 2007.

  1. Guest

    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
     
    , Jul 27, 2007
    #1
    1. Advertising

  2. schrieb:
    > 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
     
    Torsten Jenkner, Jul 27, 2007
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Rob Mitchell
    Replies:
    0
    Views:
    2,204
    Rob Mitchell
    Jan 25, 2006
  2. Jubz
    Replies:
    0
    Views:
    2,326
  3. contact1981
    Replies:
    1
    Views:
    972
    Oliver Wong
    Sep 21, 2006
  4. jstorta
    Replies:
    1
    Views:
    11,805
  5. Amit Jain
    Replies:
    7
    Views:
    3,335
    Amit Jain
    Apr 27, 2009
Loading...

Share This Page