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

2008-03-07 Thread 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.dialectorg.hibernate.dialect.HSQLDialect/property
  | 
  | 
  | 
  | !-- JDBC connection properties (begin) --
  | 
  | property 
name=hibernate.connection.driver_classorg.hsqldb.jdbcDriver/property
  | 
  | property 
name=hibernate.connection.urljdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}jbpmDB/property
  | 
  | property name=hibernate.connection.usernamesa/property
  | 
  | property name=hibernate.connection.password/property
  | 
  | !-- JDBC connection properties (end) --
  | 
  | 
  | 
  | property 
name=hibernate.cache.provider_classorg.hibernate.cache.HashtableCacheProvider/property
  | 
  | 
  | 
  | !-- DataSource properties (begin) ===
  | 
  | property name=hibernate.connection.datasourcejava:/JbpmDS/property
  | 
  |  DataSource properties (end) --
  | 
  | etc.
  | 

and the jbpm-ds.xml file


  | ?xml version=1.0 encoding=UTF-8?
  | 
  | 
  | 
  | datasources
  | 
  | 
  | 
  |local-tx-datasource
  | 
  |   jndi-nameJbpmDS/jndi-name
  | 
  |   
connection-urljdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}jbpmDB/connection-url
  | 
  |   driver-classorg.hsqldb.jdbcDriver/driver-class
  | 
  |   user-namesa/user-name
  | 
  |   password/password
  | 
  |   min-pool-size1/min-pool-size
  | 
  |   max-pool-size5/max-pool-size
  | 
  |   idle-timeout-minutes0/idle-timeout-minutes
  | 
  |   track-statements/
  | 
  |   !-- 
  | 
  |   security-domainHsqlDbRealm/security-domain
  | 
  |   --
  | 
  |   prepared-statement-cache-size32/prepared-statement-cache-size
  | 
  |   metadatatype-mappingHypersonic SQL/type-mapping/metadata
  | 
  |   dependsjboss:service=Hypersonic,database=jbpmDB/depends
  | 
  |/local-tx-datasource
  | 
  | 
  | 
  |mbean code=org.jboss.jdbc.HypersonicDatabase 
  | 
  |  name=jboss:service=Hypersonic,database=jbpmDB
  | 
  |  attribute name=DatabasejbpmDB/attribute
  | 
  |  attribute name=InProcessModetrue/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=bbop=viewtopicp=4134759#4134759

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4134759

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

2008-03-07 Thread mputz
If you want to use hsqldb as defined in jbpm-ds.xml, you have to make sure that 
the JbpmDS datasource is referenced from hibernate.cfg.xml. Change it to:

!-- JDBC connection properties (begin) ===
  | NOT USED, THE CONNECTION PROPERTIES ARE DEFINED IN jbpm-ds.xml!
  | property 
name=hibernate.connection.driver_classorg.hsqldb.jdbcDriver/property
  | property 
name=hibernate.connection.urljdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}jbpmDB/property
  | property name=hibernate.connection.usernamesa/property
  | property name=hibernate.connection.password/property
  | ===JDBC connection properties (end) --
  | 
  | 
  | 
  | !-- DataSource properties (begin) --
  | property 
name=hibernate.connection.datasourcejava:/JbpmDS/property
  | !-- DataSource properties (end) --



View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4134765#4134765

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4134765
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user


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

2008-03-07 Thread chrisrjcox
Please consider this thred Closed.

mputz, Thank you so much for your assistance with this, it has solved the issue.

I just had an issue with Eclipse running the incorrect server (the non updated 
one)

Chris

View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4134940#4134940

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4134940
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user


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

2008-03-06 Thread kukeltje
anonymous wrote : Could Hybernate be looking at an incorrect database? or 
something?

Yes

View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=4134715#4134715

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4134715
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user