Is there anyone work with JBOSS 4 + JBPM 3.0.1+ Oracle 10g +

[johnson6768]

Can anyone give more detail about how to setup (install) JBPM 3.0.
I have met some strange SQL, like CREATE TABLE ...(xxx bigint)
Is there anyone know Oracle support 'bigint'?
I use JBPM starter kit to generate sql scripts, but seems not work,
It took me many days, orz!!!

[kukeltje]

jBPM is known to work with 9i. If hibernate is supported on 10g, there is a big change it will work, but maybe there are some (non) subtle differences with oracle (there always seem to be) and some tweeking is required.

What errors do you get?

[johnson6768]

in Starters-kit, I use 'ant oracle.scripts' but I got the wrong sql scripts,
and I can not run from sqlplus, Ex:
create table XXX ( xxx bigint ), Oracle supports 'bigint' now ?

[tom.baeyens]

this is a problem with the jbpm script generation. the hsql db dialect is taken instead of the oracle dialect.

you can track the progress in the issue i created: http://jira.jboss.com/jira/browse/JBPM-339

regards, tom.