2 Replies Latest reply on Aug 13, 2008 10:10 AM by lvoale

    import.sql feature problem

    lvoale
      Hi!
      I am confused about using import.sql feature as well a few things around it and i hope u guys could help me get
      a few clues how to solve it.
      i am using jboss seam 2.0.3.CR1, jboss AS 4.2.2 GA, Postgres db.

      Now i have 2 tables for 2 entitys/classes. None of the tables gets updated
      with stuff from import.sql if i am using setting
      <property name="hibernate.hbm2ddl.auto" value="update"/>
      but both gets updated with one of those 2 setting.
      <property name="hibernate.hbm2ddl.auto" value="create-drop"/>
      or ||
      <property name="hibernate.hbm2ddl.auto" value="create"/>
      in persistence.xml file.

      My question is why or at least where can the problem be ? :) I can post those classes as well as table definition if needed.

      Please help!
      /Alex
        • 1. Re: import.sql feature problem
          blabno

          You need to put this file in root of EJB jar, next to seam.properties.

          • 2. Re: import.sql feature problem
            lvoale

            Hi, but it does work just not with update setting, i see values from import.sql in those table if i let hibernate create tables itslef (create-drop setting). And i wonder what sort of problem would make it impossible for hibernate to update existing table. Does update realy mean update or probably somethings else ? :-)
            /Alex