changiing web-sale´s database

[aamonten]

Hi I'm trying to use mysql as database for the web-sale application, I have followed the intructions at chapter 8 of the user guide, but I'm getting this error:

org.jbpm.configuration.ConfigurationException: no messaging service available
at org.jbpm.msg.command.CommandExecutorThread.executeCommand(CommandExec
utorThread.java:116)
at org.jbpm.msg.command.CommandExecutorThread.run(CommandExecutorThread.
java:79)
15:31:38,234 DEBUG [JbpmContext] closing JbpmContext
15:31:38,234 ERROR [CommandExecutorThread] java.lang.NullPointerException
15:31:38,265 DEBUG [JbpmContextInfo] creating jbpm context with service factorie
s '[authentication]'
15:31:38,265 DEBUG [JbpmContext] creating JbpmContext
15:31:38,265 DEBUG [SchedulerThread] checking for timers
15:31:38,265 DEBUG [JbpmContext] closing JbpmContext
15:31:38,265 INFO [SchedulerThread] runtime exception while executing timers
java.lang.NullPointerException
at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread
.java:106)
at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
15:31:43,234 DEBUG [JbpmContextInfo] creating jbpm context with service factorie
s '[authentication]'
15:31:43,234 DEBUG [JbpmContext] creating JbpmContext
15:31:43,234 DEBUG [CommandExecutorThread] command 'null' threw exception. rolli
ng back transaction
org.jbpm.configuration.ConfigurationException: no messaging service available
at org.jbpm.msg.command.CommandExecutorThread.executeCommand(CommandExec
utorThread.java:116)
at org.jbpm.msg.command.CommandExecutorThread.run(CommandExecutorThread.
java:79)
15:31:43,234 DEBUG [JbpmContext] closing JbpmContext
15:31:43,234 ERROR [CommandExecutorThread] java.lang.NullPointerException
15:31:43,265 DEBUG [JbpmContextInfo] creating jbpm context with service factorie
s '[authentication]'
15:31:43,265 DEBUG [JbpmContext] creating JbpmContext
15:31:43,265 DEBUG [SchedulerThread] checking for timers
15:31:43,265 DEBUG [JbpmContext] closing JbpmContext
15:31:43,265 INFO [SchedulerThread] runtime exception while executing timers
java.lang.NullPointerException
at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread
.java:106)
at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
15:31:48,234 DEBUG [JbpmContextInfo] creating jbpm context with service factorie
s '[authentication]'
15:31:55,953 DEBUG [JbpmContext] creating JbpmContext
15:31:55,953 DEBUG [CommandExecutorThread] command 'null' threw exception. rolli
ng back transaction
org.jbpm.configuration.ConfigurationException: no messaging service available
at org.jbpm.msg.command.CommandExecutorThread.executeCommand(CommandExec
utorThread.java:116)
at org.jbpm.msg.command.CommandExecutorThread.run(CommandExecutorThread.
java:79)
15:31:55,953 DEBUG [JbpmContext] closing JbpmContext
15:31:55,953 ERROR [CommandExecutorThread] java.lang.NullPointerException
15:31:55,953 DEBUG [JbpmContextInfo] creating jbpm context with service factorie
s '[authentication]'
15:31:55,953 DEBUG [JbpmContext] creating JbpmContext
15:31:55,953 DEBUG [SchedulerThread] checking for timers
15:31:55,953 DEBUG [JbpmContext] closing JbpmContext
15:31:55,953 INFO [SchedulerThread] runtime exception while executing timers
java.lang.NullPointerException
at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread
.java:106)
at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)

My settings/changes are:



hibernate.cfg.xml:

 <!-- jdbc connection properties -->
 <property name="hibernate.dialect">
 org.hibernate.dialect.MySQLDialect
 </property>
 <property name="hibernate.connection.datasource">
 java:/JbpmDS
 </property>

jbpm.sar\META-INF\jboss-service.xml:

<?xml version="1.0" encoding="UTF-8"?>
<server>
 <mbean code="org.jbpm.db.jmx.JbpmService"
 name="jboss.jbpm:name=DefaultJbpm,service=JbpmService"
 description="Default jBPM Service">
 <attribute name="JndiName">java:/jbpm/JbpmConfiguration</attribute>

<depends>jboss.jca:service=DataSourceBinding,name=JbpmDS</depends>
 </mbean>
</server>

And added the file jbpm-ds.xml:

<?xml version="1.0" encoding="UTF-8"?>

<datasources>
 <local-tx-datasource>
 <jndi-name>JbpmDS</jndi-name>
 <use-java-context>false</use-java-context>
 <connection-url>jdbc:mysql://localhost:3306/JbpmDB</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>root</user-name>
 <password>password</password>
 <metadata>
 <type-mapping>MySQL5</type-mapping>
 </metadata>
 </local-tx-datasource>
</datasources>

That all what I have modified, am I missing simething?

[koen.aers]

You have errors in the CommandExecutorThread and in the SchedulerThread. Are you sure you are creating the database for the correct jbpm version?
Did you generate the database creation scripts for MySQL yourself? I would start by doing that and use these to create the jbpm database.

Regards,
Koen