with the following mapping document in mind, i'd like to be able to search using the following query:
"from BandLevel as bl where bl.id=:id"
however the closest i can get is this:
"from BandLevel as bl where bl.band_level=:id"

so briefly i can't get my query to use the field name of the bean, instead i can only use the column name the field maps to.

Is there a way to make hibernate map the field name?

Hibernate version: 2
Mapping document:


Name and version of the database you are using:oracle 8

i'm trying the same at the moment, because i don't want to use the real-db-column-names in my application.

First i thought this will work automatically ... but it seems not (or, perhaps i'm a little bit stupid ... can be ;) ) ...

To implement an own NamingStrategy won't work i think ... in the next step i will take a look in the EntityPersister ... perhaps i can find there something helpfull ...

or (in the meantime) do you have a better idea?!

gtx
leaner

i thought changing my mapping file to this might work, but no:

when i use "FROM BandLevel as bl WHERE bl.id=:id"
i get the error "path expression ends in a composite value: bandlevel0_.id [FROM package.BandLevel as bl WHERE bl.id=:id ]"

when i use "FROM BandLevel as bl WHERE bl.BAND_LEVEL=:id"
i get the error "could not resolve property: BAND_LEVEL of: package.BandLevel [FROM package.BandLevel as bl WHERE bl.BAND_LEVEL=:id ]"

ok, that 'path expression ends in a composite value' error was because i was using the keyword 'id' for a field name. so now i'm testing with a different field and still getting problems

HQL : FROM BandLevel as bl WHERE bl.companyNo=:companyNo
SQL : select bandlevel0_.id as id, bandlevel0_.companyNo as companyNo, bandlevel0_.employeeType as employee3_, bandlevel0_.BAND_LEVEL as BAND_LEVEL, bandlevel0_.COMPANY_NO as COMPANY_NO, bandlevel0_.EMPLOYEE_TYPE as EMPLOYEE6_, bandlevel0_.DESCRIPTION as DESCRIPT7_ from LU_BAND_LEVELS bandlevel0_ where (bandlevel0_.companyNo=? )
EXC : java.sql.SQLException: ORA-00904: invalid column name

so obviously it doesn't want to map 'companyNo' to it's column name 'COMPANY_NO', so i try that in the HQL:

HQL : FROM BandLevel as bl WHERE bl.COMPANY_NO=:companyNo
EXC : could not resolve property: COMPANY_NO of: com.gunn.etime.jdo.reference.BandLevel [FROM com.gunn.etime.jdo.reference.BandLevel as bl WHERE bl.COMPANY_NO=:companyNo]

so it would seem that the only way i could get this to work would be to change my db field name to 'companyno' or change my field name to 'company_no'.. neither of which are options unfortunately.

i've got no idea where to go from here .. would love some help!!!!!

finally got it working. my mapping file is now this:

using the HQL: FROM BandLevel as ae WHERE ae.companyNo=:companyNo AND ae.code=:code

and it seems to work now .. so the only difference from the original was that i was using the id keyword as a field name... i'm sure this is something any hibernate expert could have told me from a quick glance.. so thanks experts!

thanks for your solution!
My mistake was, that i haven't used aliases for my attribute-names. But good to know not to use any fields with name "id" ...

gtx
curio