[jboss-user] [JBoss jBPM] - JBPM Oracle connection Issue

[Kodee]

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)

 


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

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