-
1. Re: Transactions fail due to confiuration of Persistence
kazam Jul 17, 2006 5:02 AM (in response to kazam)I couldn't find the file configuring HiLo so, I changed all references to jbpmDS to DefaultDS.
Now, however, I am getting the error of missing table HILOSEQUENCESProblem starting service jboss:service=KeyGeneratorFactory, type=HiLo java.sql.SQLException : ORA-00942:table or view does not exist
Thanks, Kazam. -
2. Re: Transactions fail due to confiuration of Persistence
kazam Jul 17, 2006 5:37 AM (in response to kazam)I tried to create the table directly into the schema, but the reply is still table or view doesn't exist.
I think the entry for hilo configuration is not pointing to correct schema.
If someone knows how to configure hiLo please, respond.
Thanks, Kazam. -
3. Re: Transactions fail due to confiuration of Persistence
falazar Jul 17, 2006 10:40 AM (in response to kazam)Im not sure about the hilo part, but for oracle, we created and used teh OracleDS instead:
Making the JBPM Web Application use our Oracle DataSource
The first is ${JBOSS_HOME}/server/jbpm/deploy/jbpm.sar/META-INF/jboss-service.xml, which is used to control what DataSource the JBPM web application uses for its discrete JDBC activity.
We want this file to look like this:<?xml version="1.0" encoding="UTF-8"?> <server> <mbean code="org.jbpm.db.jmx.JbpmService" name="jboss.jbpm:name=DefaultJbpm,service=JbpmService" description="Default jBPM Service"> <attribute name="JndiName">java:/jbpm/JbpmConfiguration</attribute> <depends>jboss.jca:service=DataSourceBinding,name=OracleDS</depends> </mbean> </server>
(this is taken from teh Oracle JBMP wiki page I sent you, which has some more instructions as well) -
4. Re: Transactions fail due to confiuration of Persistence
kazam Jul 17, 2006 1:32 PM (in response to kazam)Hi,
I changed the database for JBPM back to HSSQL but still same issue.
I have found that the persistence fails only for IdentitySession.JbpmContext context = JbpmConfiguratoin.getInstance().createJbpmContext(); Session session = jbpmContext.getSession(); IdentitySession idsession = new IdentitySession(session); idesession.beginTransaction(); ..... idsessoin.saveGroup(aGroup); idsession.commitTransaction(); idsessoin.close(); finally { jbpmContext.close{} }
Errororg.jbpm.persistence.JbpmPersistenceException: coudlnt commit hibernate sessoin. transaction not successfully started.
-
5. Re: Transactions fail due to confiuration of Persistence
kazam Jul 17, 2006 2:21 PM (in response to kazam)Just wanted to add, that I can easily loadGroup() from the database using identitySession and saveGroup() without committing. But as soon as I commit, the persistence service fails.
Please help!
Thanks. -
6. Re: Transactions fail due to confiuration of Persistence
hosierdm Jul 18, 2006 1:33 AM (in response to kazam)The configuration for the HiLo stuff is in deploy/uuid-key-generator.sar/META-INF/jboss-service.xml. I think that's really I'm able to add on this topic. I've been using Oracle10g with jBPM, and I left HSQL deployed for some of that junk like the HiLo, and I haven't noticed any issues with jBPM or the identity component. I'll try to look more closely as time permits, unless of course someone else comes to the rescue.