This content has been marked as final.
Show 5 replies
-
1. Re: Oracle mapping or dialect issue (column not found)
koen.aers Jul 21, 2005 7:06 AM (in response to brittm)Britt,
Did you use the correct hibernate dialect? For Oracle this is :hibernate.dialect=org.hibernate.dialect.Oracle9Dialect //Oracle 9 hibernate.dialect=org.hibernate.dialect.OracleDialect //Oracle 8
Regards,
Koen -
2. Re: Oracle mapping or dialect issue (column not found)
kukeltje Jul 21, 2005 8:46 AM (in response to brittm)There is also something with a mapping of 0=false, 1=true or something. I think it is documented in the wiki and in the SF forums. Don't know, but hope this has already made it into the oracle hibernate config files
-
3. Re: Oracle mapping or dialect issue (column not found)
brittm Jul 21, 2005 11:44 AM (in response to brittm)Yes, I have the correct dialect. I've determined that I can solve the problem by including the following in hibernate's configuration (jbpm.hibernate.config.xml in my case)
hibernate.query.substitutions=true '1', false '0'
I suppose the above config line is the correct solution and just hasn't made it into the public jbpm-db build. I just wanted to be sure I hadn't made a common build mistake or something.
-Britt -
4. Re: Oracle mapping or dialect issue (column not found)
mosabua Jul 21, 2005 2:06 PM (in response to brittm)The correct hibernate mapping is actually
hibernate.query.substitutions=true 1, false 0
since the boolean field is using int (not char) as far as I recall.
I commited the entry in hibernate.properties in CVS.
manfred -
5. Re: Oracle mapping or dialect issue (column not found)
mosabua Jul 21, 2005 2:09 PM (in response to brittm)Oh .. and btw. it would be great if you could run the whole test suite with Oracle using the jbpm.db project and let us know where things go wrong.
manfred