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 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
