2 Replies Latest reply on May 14, 2003 12:27 AM by philross

    composite primary key + auto table creation?

    philross Newbie

      I'm having problems getting JBoss to auto create tables with a composite priimarkey key. I have a customer PK class with 2 longs and a string. These fields are included in the bean implementation and set as cmp fields in the deployment descriptor, etc, etc. The bean validates, it just doesnt use the correct SQL to create the table. It actually just leaves the fields out of the constraint definition:
      create table <table_name> ( columns... , constraint foo_pk primary key ())

      There are columns defined in the sql for each of the fields in the primary key class, but the column named are omitted from the constraint definition, which obviously generates an SQL error :(