5 Replies Latest reply on Oct 31, 2012 9:22 AM by nickarls

    TicketMonster - Postgresql Populating DB - drop constraint error

    jacktrades

      Trying to deployTicketMonster with PostgreSQL, program deploys, create the tables in the DB, populates them, but spits the following error:

       

       

      21:49:01,153 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (MSC service thread 1-7) HHH000227: Running hbm2ddl schema export

      21:49:01,155 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (MSC service thread 1-7) HHH000389: Unsuccessful: alter table Booking drop constraint FK6713A039F0809A8E

      21:49:01,156 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (MSC service thread 1-7) ERROR: relation "booking" does not exist

      21:49:01,158 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (MSC service thread 1-7) HHH000389: Unsuccessful: alter table Event drop constraint FK403827A28772A4E

      21:49:01,153 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (MSC service thread 1-7) HHH000227: Running hbm2ddl schema export

      21:49:01,155 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (MSC service thread 1-7) HHH000389: Unsuccessful: alter table Booking drop constraint FK6713A039F0809A8E

      21:49:01,156 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (MSC service thread 1-7) ERROR: relation "booking" does not exist

      21:49:01,158 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (MSC service thread 1-7) HHH000389: Unsuccessful: alter table Event drop constraint FK403827A28772A4E

       

      DB view:

      jboss.png