3 Replies Latest reply on Jul 24, 2007 2:50 PM by andyredhead

    3.2.1 jbpm.jpdl.postgresql.sql

    andyredhead

      Hi,

      has anyone had any problems running the ddl for creating a 3.2.1 schema in postgresql?

      To run the script from plsql I had to put a ";" at the end of each line...

      I also had to remove the "drop xxx" statements at the start.

      Cheers,

      Andy

        • 1. Re: 3.2.1 jbpm.jpdl.postgresql.sql
          rgeorgy

          Hi Andy,
          I faced the same problem using MySQL schema. I found the solution at http://www.jboss.org/wiki/Wiki.jsp?page=JbpmWiki, you'll find a valid mysql schema attached to this page, I know you're using postgresql, however mysql's schema could be helpful.

          Best regards,
          Remon Georgy.

          • 2. Re: 3.2.1 jbpm.jpdl.postgresql.sql
            luukey

            Yes, there are no semicolons at the end of the line, but no big deal:

            postgres> cat jbpm.jpdl.postgresql.sql | while read line; do echo "$line;" | psql jbpm; done
            . While the creation, the database complains about nonexistent tables, but the script goes on, and eventually creates the required structure. I use PostgreSQL 8.1.4.

            • 3. Re: 3.2.1 jbpm.jpdl.postgresql.sql
              andyredhead

              Thanks for the example, I used something similar myself ;)

              I don't run plsql in auto-commit mode, so I wrapped the script with BEGIN/COMMIT - but as soon as you get an error inside a transaction you have to roll back, hence removing the drop statements.

              It's nice to know that there are other people using PostgreSQL (I'm on 8.2).

              Cheers,

              Andy