[jboss-user] [JBoss jBPM] - ERROR JDBCExceptionReporter : Table not found in statement

[javi0704]

Hi anyone,
i am trying to deploy a simple processDefinition by programmatically. But i got a problem.

My processDefinition looks like this.

<?xml version="1.0" encoding="UTF-8"?><process-definition xmlns="urn:jbpm.org:jpdl-3.1" name="DecisionProcess">

<start-state name="start">
   
</start-state>
<task-node name="Request">
   
</task-node>
<task-node name="Checking">
   
</task-node>
<end-state name="End"/>
</process-definition>

And hier is my Java Code. package com.test;

import org.jbpm.JbpmConfiguration;
import org.jbpm.JbpmContext;
import org.jbpm.graph.def.ProcessDefinition;

public class DeployingTest {
public static void main(String[] args) {

JbpmConfiguration jbpmConfiguration = JbpmConfiguration.getInstance();
ProcessDefinition prd = ProcessDefinition.parseXmlResource("DecisionProcess/processdefinition.xml");
JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();
try{
if(jbpmConfiguration!=null){
jbpmContext.deployProcessDefinition(prd);
System.out.println("!!!=== Is Deployed");
}else{
System.out.println("!!!===  Is not Deployed");
}
}catch (Exception e) {
// TODO: handle exception
System.err.println("Which error?: " +e);
}finally{
jbpmContext.close();
}

}
}
When i try this i got this Exceptions:

12:35:39,828 [main] DEBUG DbPersistenceService : beginning hibernate transaction
12:35:39,906 [main] WARN  JDBCExceptionReporter : SQL Error: -22, SQLState: S0002
12:35:39,906 [main] ERROR JDBCExceptionReporter : Table not found in statement [select top ? processdef0_.ID_ as ID1_4_, processdef0_.NAME_ as NAME3_4_, processdef0_.DESCRIPTION_ as DESCRIPT4_4_, processdef0_.VERSION_ as VERSION5_4_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_4_, processdef0_.STARTSTATE_ as STARTSTATE7_4_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
org.hibernate.exception.SQLGrammarException: could not execute query

I proved the table in the Database aun it exist already

thanks in advance

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

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