[JBoss-user] [JBoss jBPM] - Re: Cant get jBPM to work with oracle - please help
check out the wiki page now ^_^ View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3949852#3949852 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3949852 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss jBPM] - Re: Cant get jBPM to work with oracle - please help
Thanks :) Worked like a charm View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3934539#3934539 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3934539 --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss jBPM] - Re: Cant get jBPM to work with oracle - please help
Generate SQL scripts for oracle I hope this is useful...All you need to start is ant 1. Download the latest version of the JBoss jBPM Starters kit. This has got the jbpm-db folder which contains all the useful jBPM database stuff. http://www.jboss.org/products/jbpm/downloads 2. Download the latest version of the JBoss jBPM. http://www.jboss.org/products/jbpm/downloads This has all the latest source code. 3. Navigate to the ...\jbpm-starters-kit-X.X\jbpm-db folder. This folder should must contain the following files: ?build.properties ? Edit this file to correctly set the jbpm.3.location variable to the JBoss jBPM file path. eg | jbpm.3.location=C:/jbpm-X.X | | upgrade.hibernate.properties=hsqldb/hibernate.properties | upgrade.libdir=hsqldb/lib | upgrade.old.schema.script=hsqldb/upgrade.scripts/hsqldb.create.jbpm.3.0.2.sql | ? hibernate.cfg.xml ? Copy and paste in this file from ...\jbpm-starters-kit-X.X\jbpm\src\config.files Edit the connection properties | !-- jdbc connection properties -- | property name=hibernate.dialectorg.hibernate.dialect.Oracle9Dialect/property | property name=hibernate.connection.driver_classoracle.jdbc.driver.OracleDriver/property | property name=hibernate.connection.urljdbc:oracle:[EMAIL PROTECTED]:PORT:SID/property | property name=hibernate.connection.usernameUSER/property | property name=hibernate.connection.passwordPASSWORD/property | 4.Update the connection settings in the hibernate.properties file in ...\jbpm-starters-kit-X.X\jbpm-db\oracle | hibernate.dialect=org.hibernate.dialect.Oracle9Dialect | # for Oracle 8 compatibility use | #hibernate.dialect=org.hibernate.dialect.OracleDialect | | hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver | hibernate.connection.url=jdbc:oracle:[EMAIL PROTECTED]:PORT:SID | hibernate.connection.username=USERusername | hibernate.connection.password=PASSWORDpassword | | hibernate.show_sql=true | hibernate.c3p0.min_size=1 | hibernate.c3p0.max_size=3 | | hibernate.query.substitutions=true 1, false 0 | 5. Get the latest oracle driver from oracle: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html Put this in the ...\jbpm-starters-kit-X.X\jbpm-db\oracle\lib folder This test was run for classes12.zip 6. Open a cmd prompt and navigate to ...\jbpm-starters-kit-X.X\jbpm-db 7. On the command line type: ant oracle.scripts 8. The ant script should compile the latest source code into the following class folders in ...\jbpm-X.X\build. ?classes.examples ?classes.identity ?classes.identity.test ?classes.jbpm ?classes.jbpm.test ?classes.webapp It then uses these classes in the classpath to create the sql scripts. 9. The following scripts should be created in ?..\jbpm-starters-kit-X.X\jbpm-db\build\oracle\scripts ?oracle.clean.sql ?oracle.create.sql ?oracle.drop.create.sql ?oracle.drop.sql View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3934023#3934023 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3934023 --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss jBPM] - Re: Cant get jBPM to work with oracle - please help
The wiki is probably not up-to-date. Have a look at the docs : http://docs.jboss.com/jbpm/v3/userguide/thejbpmdatabase.html This describes the process for PostgreSQL and for MySQL. Oracle is just analogous... Regards, Koen View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3933861#3933861 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3933861 --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss jBPM] - Re: Cant get jBPM to work with oracle - please help
The wiki is probably not up-to-date. Have a look at the docs : http://docs.jboss.com/jbpm/v3/userguide/thejbpmdatabase.html This describes the process for PostgreSQL and for MySQL. Oracle is just analogous... As I mentioned in my post I read that document and I understand it, the problem is that the oracle scripts are not included. See No Oracle scripts: C:\jbpm-starters-kit-3.1\jbpm-db\builddir Volume in drive C has no label. Volume Serial Number is E4F2-0E0C Directory of C:\jbpm-starters-kit-3.1\jbpm-db\build 03/16/2006 10:19 AM . 03/16/2006 10:19 AM .. 03/16/2006 10:19 AM daffodildb 03/16/2006 10:19 AM derby 03/16/2006 10:19 AM firebird 03/16/2006 10:19 AM hsqldb 02/13/2006 07:11 PM jbpm-db-3.1 03/16/2006 10:19 AM mssql 03/16/2006 10:19 AM mysql 03/16/2006 10:19 AM postgresql 03/16/2006 10:19 AM sybase 0 File(s) 0 bytes 11 Dir(s) 8,140,623,872 bytes free C:\jbpm-starters-kit-3.1\jbpm-db\build View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3933881#3933881 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3933881 --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
