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)

[kukeltje]

do you know how to configure hibernate correctly? Most likely a wrong dialect

[salaboy21]

Yes.. you should be sure that you change this line in the hibernate.cfg.xml file:

<property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>

To the correct Oracle dialect

[kukeltje]

wow... what a great level of free (hibernate) support do all these people get here...

[salaboy21]

yeah!!!!!!!!! this is because if he is a new user, he probably spend a lot of time reading about hibernate (not a bad thing) and have less time to read about jBPM...

[kodee]

Thanks a lot! Will check and let u know.. I thught it might be due to Oracle query execution

anyways will confirm the dialect configuration and reply soon!

cheers,
Kodee

[kodee]

After changing oracledialect, it works fine.. Thanks for the help

cheers,
Kodee

[kukeltje]

"salaboy21" wrote:
yeah!!!!!!!!! this is because if he is a new user, he probably spend a lot of time reading about hibernate (not a bad thing) and have less time to read about jBPM...

Uhmmm... if he spend a lot of time on hibernate, and read the basic jBPM docs, he would have known hibernate is used in jBPM and would have known he had to change the dialect.

So....

[salaboy21]

Yes.. i think you are right.. but.. when I started jBPM i see it like it involves a lot of things and i was not able to do the basic things..
When you can make it work.. you start to understand things and then knows in what you need to focus..

So if I can help here to make the things work.. then for each particular case the users/developers knows what they need to read .. like I did..

But I don't know.. I try to not bother here.. I only try to help the new people to get started.