[jboss-user] [JBoss jBPM] - jBPM with Oracle: How to insert auto generated values for Pr

[Anandnatraj]

I am using Oracle integration with jBPM. And when I am trying to deploy a newly created process in the Oracle through Eclipse, my server is throwing the exception, "cannot insert null into (JBPM_PROCESSDEFINITION.ID_)."

It is evident that the same process is perfectly getting uploaded in HSQDB. When I've gone through the DB scripts, i found that the HSQ db DDL are having default value generation for ID_ field, whereas the Oracle DDL is not having any such equivalent.

Does Hibernate have any solution for inserting PrimaryKey values with Sequence generated values Or I have to configure something before I upload the process ?

I tried writing a trigger on this table to insert the Key, but that is not succesful due to other reasons.

Thanks,
anand

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3966811#3966811

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3966811