1 Reply Latest reply on Dec 6, 2008 12:07 PM by Ronald van Kuijk

    Need the full set of JBPM 3.3.0 SQL scripts for SQL Server 2

    Sabyasachi Sengupta Newbie

      Hi,

      I have set up JBPM 3.3.0 with SQL Server 2005 & JBOSS 4.2.3 GA. I ran the SQL scripts that were part of the release under database folder in the JBPM 3.3.0 release version. I had to change the .hbm.xml files inside the location server\default\deploy\jbpm\jbpm-enterprise-bundle.ear to make it point to my defined schema.

      Earlier I faced an error whenever I tried to deploy the process archive as it was calling the JBPM_PROCESSDEFINTION table directly without a schema name & rightly so. So I made changes in jbpm-identity.jar & jbpm-jpdl.jar to make it point to my defined schema eg <schema_name>.JBPM_PREOCESSDEFITNITION. & the process got deployed successfully.

      Now when I try to login through the jbpm console, I can't enter since there is no corresponding table & data that is created in SQL Server 2005 for the same.

      I found in some of the sites that there are some tables eg JBPM_ID_USER,JBPM_ID_MEMBERSHIP but I didn't find this as a part of the sql script with this release.

      Where can I get the full set of JBPM 3.3.0 SQL scripts for SQL Server 2005?