[jboss-user] [JBoss jBPM] - JBPM Oracle connection Issue
Kodee
do-not-reply at jboss.com
Thu Nov 13 02:08:45 EST 2008
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
More information about the jboss-user
mailing list