[jboss-user] [JBoss jBPM] - Re: Table not found in statement. While deloying a Process D

[chrisrjcox]

Thanks for the short but sweet reply Ronald :)

I have the following config files.

jbpm.cfg.xml


  | <jbpm-configuration>
  | 
  |   <jbpm-context>
  |     <service name='persistence' factory='org.jbpm.persistence.db.DbPersistenceServiceFactory' />
  |     <service name='message' factory='org.jbpm.msg.db.DbMessageServiceFactory' />
  |     <service name='scheduler' factory='org.jbpm.scheduler.db.DbSchedulerServiceFactory' />
  |     <service name='logging' factory='org.jbpm.logging.db.DbLoggingServiceFactory' />
  |     <service name='authentication' factory='org.jbpm.security.authentication.DefaultAuthenticationServiceFactory' />
  |   </jbpm-context>
  | 
  |   <!-- configuration resource files pointing to default configuration files in jbpm-{version}.jar -->
  |   <string name='resource.hibernate.cfg.xml' value='hibernate.cfg.xml' />
  |   <!-- <string name='resource.hibernate.properties' value='hibernate.properties' /> -->
  |   <string name='resource.business.calendar' value='org/jbpm/calendar/jbpm.business.calendar.properties' />
  |   <string name='resource.default.modules' value='org/jbpm/graph/def/jbpm.default.modules.properties' />
  |   <string name='resource.converter' value='org/jbpm/db/hibernate/jbpm.converter.properties' />
  |   <string name='resource.action.types' value='org/jbpm/graph/action/action.types.xml' />
  |   <string name='resource.node.types' value='org/jbpm/graph/node/node.types.xml' />
  |   <string name='resource.parsers' value='org/jbpm/jpdl/par/jbpm.parsers.xml' />
  |   <string name='resource.varmapping' value='org/jbpm/context/exe/jbpm.varmapping.xml' />
  | 
  |   <int name='jbpm.byte.block.size' value="1024" singleton="true" />
  |   <bean name='jbpm.task.instance.factory' class='org.jbpm.taskmgmt.impl.DefaultTaskInstanceFactoryImpl' singleton='true' />
  |   <bean name='jbpm.variable.resolver' class='org.jbpm.jpdl.el.impl.JbpmVariableResolver' singleton='true' />
  | 
  | </jbpm-configuration>
  | 

Hybernate.cfg.xml file.


  | <?xml version='1.0' encoding='utf-8'?>
  | 
  | 
  | 
  | <!DOCTYPE hibernate-configuration PUBLIC
  | 
  |           "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  | 
  |           "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
  | 
  | 
  | 
  | <hibernate-configuration>
  | 
  |   <session-factory>
  | 
  | 
  | 
  |     <!-- hibernate dialect -->
  | 
  |     <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
  | 
  | 
  | 
  |     <!-- JDBC connection properties (begin) -->
  | 
  |     <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
  | 
  |     <property name="hibernate.connection.url">jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}jbpmDB</property>
  | 
  |     <property name="hibernate.connection.username">sa</property>
  | 
  |     <property name="hibernate.connection.password"></property>
  | 
  |     <!-- JDBC connection properties (end) -->
  | 
  |     
  | 
  |     <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
  | 
  |     
  | 
  |     <!-- DataSource properties (begin) ===
  | 
  |     <property name="hibernate.connection.datasource">java:/JbpmDS</property>
  | 
  |     ==== DataSource properties (end) -->
  | 
  | etc.............
  | 

and the jbpm-ds.xml file


  | <?xml version="1.0" encoding="UTF-8"?>
  | 
  | 
  | 
  | <datasources>
  | 
  | 
  | 
  |    <local-tx-datasource>
  | 
  |       <jndi-name>JbpmDS</jndi-name>
  | 
  |       <connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}jbpmDB</connection-url>
  | 
  |       <driver-class>org.hsqldb.jdbcDriver</driver-class>
  | 
  |       <user-name>sa</user-name>
  | 
  |       <password></password>
  | 
  |       <min-pool-size>1</min-pool-size>
  | 
  |       <max-pool-size>5</max-pool-size>
  | 
  |       <idle-timeout-minutes>0</idle-timeout-minutes>
  | 
  |       <track-statements/>
  | 
  |       <!-- 
  | 
  |       <security-domain>HsqlDbRealm</security-domain>
  | 
  |       -->
  | 
  |       <prepared-statement-cache-size>32</prepared-statement-cache-size>
  | 
  |       <metadata><type-mapping>Hypersonic SQL</type-mapping></metadata>
  | 
  |       <depends>jboss:service=Hypersonic,database=jbpmDB</depends>
  | 
  |    </local-tx-datasource>
  | 
  | 
  | 
  |    <mbean code="org.jboss.jdbc.HypersonicDatabase" 
  | 
  |      name="jboss:service=Hypersonic,database=jbpmDB">
  | 
  |      <attribute name="Database">jbpmDB</attribute>
  | 
  |      <attribute name="InProcessMode">true</attribute>
  | 
  |    </mbean>
  | 
  | 
  | 
  | </datasources>
  | 

I can't see what could be wrong? The files are the standard ones from the jBPM package, and there is no assistance within the jBPM jPDL User Guide to reflect having to change the config file to get this to work.

Does anyone see anything incorrect within the above files?

Thanks

Chris

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4134759#4134759

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4134759