oracle db script !!

[lethrech]

hi,
i use jbpm3.2, i want to use the oracle9i db with jboss4.0.4, but the script provided in the "db" folder of "jbpm-suite3.2" is wrong !!!!
have you a other script?

think you a lot

[estaub]

letrech,

I haven't used it directly from the distribution (I built the suite from source myself), but it worked for me.

Can you provide more info than "is wrong!!!!"?

-Ed Staub

[lethrech]

think you for your response,

some tables are absent (JBPM_ID_USER, JBPM_ID_GROUPE, JBPM_ID_MEMBERSHIP, JBPM_ID_PERMISSIONS,JBPM_ID_JOB), in adition to that i have the following probleme when jboss start

ERROR [JDBCExceptionReporter] ORA-00904: "JOB0_"."GRAPHELEMENT_" : identificateur non valide

ther are not a build.xml in db folder, i use jbpm3.2

[wjm]

"lethrech" wrote:
think you for your response,

some tables are absent (JBPM_ID_USER, JBPM_ID_GROUPE, JBPM_ID_MEMBERSHIP, JBPM_ID_PERMISSIONS,JBPM_ID_JOB)

Some of those tables are a part of the identity implementation, which is not referenced in the basic database initialization.

Your best bet is to let Hibernate do the entire job for you, including populating the identity database components with the sesame street users so that the demo will run in the console. See:

http://wiki.jboss.org/wiki/Wiki.jsp?page=UseHibernateToCreateJbpmDB

----
Bill

[lethrech]

think you wjm, it work now