I'm trying to deploy a simple process in a jbpm 3.2 installation over jboss 4.2 and an oracle 10g db.
the jbpm tables are empty, since this should be the first process. I have designed a small process with the eclipse's gpd plug in. when I try deploying it an exception is thrown at the server's log complaining it can't find the process definition for tester, which is the name I gave to the test process.
13:19:31,970 ERROR [ProcessUploadServlet] Failed to deploy process tester org.jbpm.JbpmException: could not find process definition 'tester' ...
an blames the failure to a malformed sql command
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) ... Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) ...
before this exception is thrown the failing query is
13:19:31,963 INFO [STDOUT] Hibernate: /* named HQL query GraphSession.findLatestProcessDefinitionQuery */ select 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 limit ? 13:19:31,970 WARN [JDBCExceptionReporter] SQL Error: 933, SQLState: 42000 13:19:31,970 ERROR [JDBCExceptionReporter] ORA-00933: SQL command not properly ended
this query won't return any values because the JBPM_PROCESSDEFINITION table is empty, but it complains on the query. any configuration I'm missing?
Fixed! The db dialect had to be changed.
<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>