[jboss-user] [jBPM] - JBPM5 cannot run on DB2?

[roxy1987]

roxy1987 [https://community.jboss.org/people/roxy1987] created the discussion

"JBPM5 cannot run on DB2?"

To view the discussion, visit: https://community.jboss.org/message/787644#787644

--------------------------------------------------------------
Hi,

I read somewhere that jbpm5 has troubles running on db2. Apparently there is a problem with the length of one of the db table columns. And with the release of jbpm6 we will be able to run it with DB2.

Is this true? I need this info urgently as the project design would need to change accordingly. Please share any info available on this topic. Many Thanks.

Regards.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/787644#787644]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Mauricio Salatino]

Mauricio Salatino [https://community.jboss.org/people/salaboy21] created the discussion

"Re: JBPM5 cannot run on DB2?"

To view the discussion, visit: https://community.jboss.org/message/787650#787650

--------------------------------------------------------------
Did you try jbpm 5.4.0.Final? If it has problems with DB2 we definitely we will fix it.
If you have problems with it, please let us know. If there is a problem with the jpa mappings, it shouldn't be hard to override them for DB2.
Cheers
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/787650#787650]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[roxy1987]

roxy1987 [https://community.jboss.org/people/roxy1987] created the discussion

"Re: JBPM5 cannot run on DB2?"

To view the discussion, visit: https://community.jboss.org/message/787657#787657

--------------------------------------------------------------
Hi Mauricio,

Thanks for a quick response. The tables are created. But any run of the APIs, I get the following error.

Caused by: com.ibm.db2.jcc.am.co: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, S
QLERRMC=null, DRIVER=3.57.82

Which occurs when there is a column datatype length mismatch. I think a Jira has been raised for the same. Link is below.


https://issues.jboss.org/browse/JBPM-3445?focusedCommentId=12643883&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel https://issues.jboss.org/browse/JBPM-3445?focusedCommentId=12643883&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/787657#787657]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[roxy1987]

roxy1987 [https://community.jboss.org/people/roxy1987] created the discussion

"Re: JBPM5 cannot run on DB2?"

To view the discussion, visit: https://community.jboss.org/message/787695#787695

--------------------------------------------------------------
Hey Mauricio,

I migrated my entire application to jbpm 5.4.0.Final. Now it runs like a charm on DB2. :) Finally I got rid of H2.
Appreciate your help man. Cheers.

For community users, I will soon post my application in the community.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/787695#787695]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[javafreeker]

javafreeker [https://community.jboss.org/people/javafreeker] created the discussion

"Re: JBPM5 cannot run on DB2?"

To view the discussion, visit: https://community.jboss.org/message/824627#824627

--------------------------------------------------------------
Hi Shobhit

Please provide steps you followed to remove h2 database and integrate your jbpm5.4 application with db2 database.

Thanks
-SD
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/824627#824627]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Nicolas Louis]

Nicolas Louis [https://community.jboss.org/people/nicols] created the discussion

"Re: JBPM5 cannot run on DB2?"

To view the discussion, visit: https://community.jboss.org/message/824693#824693

--------------------------------------------------------------
Hello Javafreeker,

You just have to change the dialect into the persistance.xml to :

<property name="hibernate.dialect" value="org.hibernate.dialect.DB2Dialect" />

Regards,

Nicolas.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/824693#824693]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Nicolas Louis]

Nicolas Louis [https://community.jboss.org/people/nicols] created the discussion

"Re: JBPM5 cannot run on DB2?"

To view the discussion, visit: https://community.jboss.org/message/817988#817988

--------------------------------------------------------------
Hi Shobit,

Can you share your solution to use the DB2 database ?

Thanks a lot,

Nicolas.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/817988#817988]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Shobhit Tyagi]

Shobhit Tyagi [https://community.jboss.org/people/roxy1987] created the discussion

"Re: JBPM5 cannot run on DB2?"

To view the discussion, visit: https://community.jboss.org/message/818013#818013

--------------------------------------------------------------
Nicolas,

Are you facing problems with DB migration? Its the same as any other Database.
The problem was I was using version 5.3 it had some compatibility issues. so I switched to version 5.4 and it resolved my problem.

The whole process is available in user guide. Section 3 i think. Lemme know if you face issues..

Regards.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/818013#818013]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Nicolas Louis]

Nicolas Louis [https://community.jboss.org/people/nicols] created the discussion

"Re: JBPM5 cannot run on DB2?"

To view the discussion, visit: https://community.jboss.org/message/818019#818019

--------------------------------------------------------------
I had some configuration problem, but i suceed to correct this and yes, everything works fine with the version 5.4 for me.

Sorry for trouble,

Regards,

Nicolas.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/818019#818019]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[rahul roy]

rahul roy [https://community.jboss.org/people/rahul_roy] created the discussion

"Re: JBPM5 cannot run on DB2?"

To view the discussion, visit: https://community.jboss.org/message/819385#819385

--------------------------------------------------------------
Hi Nicolas,

we have started doing migration from jbpm3.2 to jbpm5. After creating a simple hello world program and adding a service task, it is giving error No Interface Found. Drools error.
This is just the start of the migration activity and we are stuck.
A quick help would really be appreciable.

Thanks
Rahul
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/819385#819385]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Mauricio Salatino]

Mauricio Salatino [https://community.jboss.org/people/salaboy21] created the discussion

"Re: JBPM5 cannot run on DB2?"

To view the discussion, visit: https://community.jboss.org/message/819388#819388

--------------------------------------------------------------
Can you please specify which version are you using?
And what is the exact error that you are getting?

Cheers
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/819388#819388]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[rahul roy]

rahul roy [https://community.jboss.org/people/rahul_roy] created the discussion

"Re: JBPM5 cannot run on DB2?"

To view the discussion, visit: https://community.jboss.org/message/819685#819685

--------------------------------------------------------------
I am trying with version jbpm 5.4. The exact error that comes in the Problems window in eclipse is
No Interface found. Drools Error.

Thanks
Rahul
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/819685#819685]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]