Hi Thomas Setiabudi!
I have been trying to also get a new database, but I am using MySQL instead.
I have also managed to generate the tables in the database.
But when I try to run the demo application (through Eclipse), I get the following error:
05/10 09:10:06,785[main] ERROR service.hornetq.HornetQTaskClientConnector.connect - Unable to connect to server using configuration org-hornetq-core-remoting-impl-netty-NettyConnectorFactory?port=5445&host=127-0-0-1
org.jbpm.workflow.instance.WorkflowRuntimeException: [com.sample.evaluation:1 - Self Evaluation:2] -- Could not connect task client: on ip: 127.0.0.1 - port: 5445
I have browsed following threads to find the error to no avail:
https://community.jboss.org/thread/201620
https://community.jboss.org/message/758919#758919
What I have done sofar:
1. Changed hibernate dialect in:
"db/persistence.xml" to
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
(I have also tried the MySQLDialect, but noticed that I run an InnoDB version of MySQL)
"task-service/resources/META-INF/persistence.xml" to
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
"task-service/resources/war/persistence.xml to
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
"task-service/target/war/persistence.xml" to
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
2. Modified the "standalone.xml" just like you have it in your step 9. (Apart that I have MySQL credentials, and the way it is described in the Demo tutorial)
3. Double checked the build.xml and the section for the mysql driver
<property name="db.driver.jar.name" value="mysql-connector-java.jar" />
4. Ensured the standalone.xml to ensure driver name
<driver>mysql</driver>
match with:
<driver name="mysql" module="com.mysql">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
5. Ensure build.xml has correct prefix:
<property name="db.driver.module.prefix" value="com/mysql"/>
6. Ensure the "db/driver_jar_module.xml" looks correct:
<module xmlns="urn:jboss:module:1.0" name="com.mysql">
<resources>
<resource-root path="mysql-connector-java.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>
7. Ensure the "db\driver" has the right driver in the directory:
mysql-connector-java.jar
8. Try to run the application and I get the same results.
Verified in the JBOSS AS Management console that the Human Task Service is running.
(See attachment "JBOSS Management.png")
9. Then I read on to change another persistence.xml in the jbpm-console:
- Uncompress the jbpm-5.3.0.Final-gwt-console.zip => jbpm-gwt-console-5.3.0.Final.war & jbpm-gwt-console-server-5.3.0.Final.war
- "Unwar" the jbpm-gwt-console-server-5.3.0.Final.war.
- Change the "jbpm-gwt-console-server-5.3.0.Final/WEB-INF/classes/META-INF/Persistence.xml" to
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
10. Try to "re-war" "jbpm-gwt-console-server-5.3.0.Final" into its original package.
But this is where I am stuck!
This is my build.xml and I am trying to war this using ant with the follwing command: "ant build-war".
<?xml version="1.0" encoding="UTF-8"?>
<target name="build-war">
<war destfile="jbpm-gwt-console-server-5.3.0.Final.war" webxml="jbpm-gwt-console-server-5.3.0.Final/WEB-INF/web.xml">
<fileset dir="jbpm-gwt-console-server-5.3.0.Final"/>
<lib dir="jbpm-gwt-console-server-5.3.0.Final/WEB-INF/lib"/>
<classes dir="jbpm-gwt-console-server-5.3.0.Final/WEB-INF/classes"/>
</war>
</target>
I get the following message:
C:\War changes\New One\build.xml:2: Unexpected element "{}target" {antlib:org.ap
ache.tools.ant}target
How should the build.xml look like to "re-war" the directory: "jbpm-gwt-console-server-5.3.0.Final"?
Attached is my directory structure ("directory structure war.png")