[jbpm-users] [JBoss jBPM] - JBPM Oracle connection Issue
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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...