[JBoss jBPM] - calling process from the database of JBPM
by btl_ayd
Hi
I want o call websale process that deploying on he server of jpm database.
I found some code about it on this forums.But when execute this code the error has been occured.
here is code for starting process:
| public static void startProcessDefinition() {
| String processDefinitionName = new String("websale");
| JbpmConfiguration jbpmConfiguration = JbpmConfiguration.getInstance();
| JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();
| try {
| GraphSession graphSession = jbpmContext.getGraphSession();
| ProcessDefinition definition = graphSession.findLatestProcessDefinition(processDefinitionName);
| ProcessInstance instance = definition.createProcessInstance();
| instance.signal();
| jbpmContext.save(instance);
| } finally {
| jbpmContext.close();
| }
| }
|
error has beeb occured
| org.hibernate.exception.SQLGrammarException: could not execute query
| at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
| at org.hibernate.loader.Loader.doList(Loader.java:2223)
| at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
| at org.hibernate.loader.Loader.list(Loader.java:2099)
| at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
| at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
| at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
| at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
| at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
| at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
| at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:153)
| at uzak.startProcessDefinition(uzak.java:24)
| at uzak.main(uzak.java:34)
| Caused by: java.sql.SQLException: Table not found in statement [select top ? processdef0_.ID_ as ID1_0_, processdef0_.NAME_ as NAME3_0_, processdef0_.DESCRIPTION_ as DESCRIPT4_0_, processdef0_.VERSION_ as VERSION5_0_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_0_, processdef0_.STARTSTATE_ as STARTSTATE7_0_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
| at org.hsqldb.jdbc.Util.throwError(Unknown Source)
| at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
| at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
| at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
| at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
| at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
| at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
| at org.hibernate.loader.Loader.doQuery(Loader.java:673)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
| at org.hibernate.loader.Loader.doList(Loader.java:2220)
| ... 11 more
| 09:58:31,439 [main] ERROR GraphSession : org.hibernate.exception.SQLGrammarException: could not execute query
| 09:58:31,439 [main] DEBUG JbpmContext : closing JbpmContext
| 09:58:31,439 [main] DEBUG Services : closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@98bbf6
| 09:58:31,439 [main] DEBUG DbPersistenceService : committing hibernate transaction org.hibernate.transaction.JDBCTransaction@1c6a99d
| 09:58:31,439 [main] DEBUG DbPersistenceService : closing hibernate session
| 09:58:31,439 [main] DEBUG Services : closing service 'tx': org.jbpm.tx.TxService@1aa0e3b
| Exception in thread "main" org.jbpm.JbpmException: couldn't find process definition 'websale'
| at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:170)
| at uzak.startProcessDefinition(uzak.java:24)
| at uzak.main(uzak.java:34)
| Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
| at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
| at org.hibernate.loader.Loader.doList(Loader.java:2223)
| at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
| at org.hibernate.loader.Loader.list(Loader.java:2099)
| at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
| at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
| at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
| at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
| at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
| at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
| at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:153)
| ... 2 more
| Caused by: java.sql.SQLException: Table not found in statement [select top ? processdef0_.ID_ as ID1_0_, processdef0_.NAME_ as NAME3_0_, processdef0_.DESCRIPTION_ as DESCRIPT4_0_, processdef0_.VERSION_ as VERSION5_0_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_0_, processdef0_.STARTSTATE_ as STARTSTATE7_0_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
| at org.hsqldb.jdbc.Util.throwError(Unknown Source)
| at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
| at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
| at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
| at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
| at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
| at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
| at org.hibernate.loader.Loader.doQuery(Loader.java:673)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
| at org.hibernate.loader.Loader.doList(Loader.java:2220)
| ... 11 more
|
the websale process is in the jbpm database server.What is the problem can anyboyd help me?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4161061#4161061
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4161061
17 years, 9 months
injecting Spring beans into action handlers
by Matthias Pretzer
Dear all,
I'd like to use beans from my existing Spring context inside my
ActionHandler. I'm aware of Spring's JbpmHandlerProxy ActionHandler.
However, that won't allow me to set properties of my ActionHandler
implementation from within the process definition.
What I'd like to have is some kind of combination of a jbpm-configured
ActionHandler and a spring-configured one. I think that's only possible,
if the action handler is configured by jbpm and delegates some logic to
a spring bean.
Does anyone know, how to do this?
best regards,
Matthias
17 years, 9 months