I have successfully run MySQL. you need to change hibernate.cfg.xml properties to the following:
hibernate.connection.username=<your user name>
assuming your tables are InnoDB type. Your MySQL driver must also be referenced. I think im using the mysql connector downloaded in the mysql site. You also need to create the blank database beforehand which was my case. I ran the jbpm 3.01 version but I think this should do bec. this is a hibernate issue. You can check also under the jbpm-db folder of the starter's kit for the specific db configuration.
Sorry the connection url should be jdbc:mysql://localhost:3306/databasename where localhost can be changed with your host so is the databsename.
Hi and thanks for answering :)
I did create the database and run the scripts. I changed
the hibernate .properties file (i had same as yours except for
the port in the url) but I still have the same problem as hibernate
seems to want to save an unknown Column.
Could you deploy the HelloWorldBepl tutorial ?
Would you mind to check your JBPM_PROCESSDEFINITION table
description and see if the followings columns are defined ?
NAME_, VERSION_, ISTERMINATIONIMPLICIT_, STARTSTATE_, TARGETNAMESPACE_, ENABLECOMPENSATION_, EXPRESSIONLANG_, QUERYLANG_, ABSTRACT_, CLASS_
If so, would you please send me your .sql files for creating the database ?
The starters kit doesn't include BPEL support due to licensing issues. Also, the BPEL extension requires additional columns in existing jBPM tables and some tables of its own. We made sure jBPM and BPEL processes can coexist in the same database, tough.
To build the proper scripts, use the Hibernate configuration file from the jBPM BPEL distribution rather than the starters kit. It is located in directory src/resources.