Oracle mapping or dialect issue (column not found)

[brittm]

I'm porting a large application from Postgres to Oracle. I've begun to get Oracle errors indicating 'column not found' on some API calls. The following query is being generated by Hibernate and causes the error:

select
taskinstan0_.ID_ as ID1_,
...
taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM16_26_
from
JBPM_TASKINSTANCE taskinstan0_
where
taskinstan0_.TOKEN_=? and (taskinstan0_.END_ is null) and taskinstan0_.ISCANCELLED_=false

manually running the query with the last phrase changed to

taskinstan0_.ISCANCELLED_=0

enables the query to be run. I've noticed that the Oracle create scripts that were generated have naturally created these 'booleans' as number fields. Does anyone recognize this issue?

Thanks,
-Britt

[koen.aers]

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

[kukeltje]

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

[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

[mosabua]

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

[mosabua]

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