8 Replies Latest reply on Nov 14, 2008 8:25 AM by Mauricio Salatino

    JBPM Oracle connection Issue

    Kodeeswaran Kempraj Newbie

      Hi,
      We are new to Jbpm and we are trying to change default hsqldb to oracledb.

      When we try to connect with Oracle database with jbpm, while deploying my processdefinition.xml, it displays the following error.

      Please do the needful

      Warm Regards,
      Kodee

      Error Message in Console

      10:45:10,118 DEBUG [LogFilter] request http://localhost:8080/jbpm/upload

      10:45:10,118 DEBUG [JbpmContextInfo] creating jbpm context with service factories '[message, schedul

      er, authentication, persistence, logging]'

      10:45:10,118 DEBUG [JbpmContext] creating JbpmContext

      10:45:10,165 DEBUG [NodeTypes] node 'page' will not be available. class 'org.jboss.seam.pageflow.Pag

      e' couldn't be loaded

      10:45:10,165 DEBUG [NodeTypes] node 'start-page' will not be available. class 'org.jboss.seam.pagefl

      ow.Page' couldn't be loaded

      10:45:10,165 DEBUG [FileDefinition] preparing file 'processimage.jpg' for storage in the database

      10:45:10,165 DEBUG [FileDefinition] preparing file 'forms.xml' for storage in the database

      10:45:10,165 DEBUG [FileDefinition] preparing file 'processdefinition.xml' for storage in the databa

      se

      10:45:10,165 DEBUG [FileDefinition] preparing file 'gpd.xml' for storage in the database

      10:45:10,165 DEBUG [FileDefinition] preparing file 'Deal Entry.xhtml' for storage in the database

      10:45:10,165 DEBUG [UploadServlet] Created a processdefinition : SampleJBPM

      10:45:10,165 DEBUG [DbPersistenceServiceFactory] creating persistence service

      10:45:10,165 DEBUG [DbPersistenceService] creating hibernate session

      10:45:10,165 DEBUG [DbPersistenceService] beginning hibernate transaction

      10:45:10,165 WARN [JDBCExceptionReporter] SQL Error: 923, SQLState: 42000

      10:45:10,165 ERROR [JDBCExceptionReporter] ORA-00923: FROM keyword not found where expected


      10:45:10,368 INFO [STDOUT] org.hibernate.exception.SQLGrammarException: could not execute query

      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)

      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

      at org.hibernate.loader.Loader.doList(Loader.java:2150)

      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)

      at org.hibernate.loader.Loader.list(Loader.java:2021)

      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)

      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)

      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1020)

      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)

      at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:650)

      at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:153)

      at org.jbpm.db.GraphSession.deployProcessDefinition(GraphSession.java:67)

      at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)

      at org.jbpm.webapp.servlet.UploadServlet.doDeployment(UploadServlet.java:94)

      at org.jbpm.webapp.servlet.UploadServlet.handleRequest(UploadServlet.java:81)

      at org.jbpm.webapp.servlet.UploadServlet.service(UploadServlet.java:50)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j

      ava:252)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)