[jboss-user] [JBoss jBPM] - Need the full set of JBPM 3.3.0 SQL scripts for SQL Server 2

[sabyasachi.seng]

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?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4194575#4194575

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4194575