1 Reply Latest reply on Apr 10, 2006 7:53 AM by Koen Aers

    changiing web-sale´s database

    Alejandro Montenegro Novice

      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?