was quite happy cause hibernate successfully mapped my class to the db
when i tried to execute a query and got a sql invalid column name error!!
but im sure i mapped the class's field to the correct column name

<property name="cmp" type="string" column="C_CMP" not-null="true"/>

this is the query:
from fuckthegest.model.PropostaOrdine as po where po.cmp = :cmp and po.prg = :prg

i cant figure this out

does anybody have a useful clue??

thank u (please.....)

some info from my log:

[2005-07-08 1224:04]WARN [http-8080-Processor25](JDBCExceptionReporter.java:57) - SQL Error: 904, SQLState: 42000
[2005-07-08 1224:04]ERROR[http-8080-Processor25](JDBCExceptionReporter.java:58) - ORA-00904: invalid column name

[2005-07-08 1224:04]ERROR[http-8080-Processor25](PoSelectAction.java:55) - Could not execute query
net.sf.hibernate.exception.SQLGrammarException: Could not execute query
at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:69)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
at net.sf.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:550)
at fuckthegest.model.ManagePropostaOrdine.select(ManagePropostaOrdine.java:37)
at fuckthegest.web.PoSelectAction.execute(PoSelectAction.java:45)

You need to provide more information and turn on sql output.

hib generated query (ugly... :D )

select propostaor0_.cmp as cmp, propostaor0_.prg as prg,
propostaor0_.C_CMP as C_CMP,
propostaor0_.N_PRG_RIC_ORD as N_PRG_RI4_,
propostaor0_.C_STA_RIC as C_STA_RIC,
propostaor0_.C_TIP_ORD as C_TIP_ORD
from LOY_RIC_ORDINE propostaor0_
where (propostaor0_.cmp=? )and(propostaor0_.prg=? )


propostaor0_.cmp
propostaor0_.prg
are not valid column names, they are named C_CMP and N_PRG_RIC_ORD
so why hib does that??

im posting the mapping doc too

well ... i'm no expert in using hibernate ... but if i were you, i would start reading the docs an learn how to make a hibernate-mapping.

Your mapping seams to be wrong (in my eyes) ... especially the "key-property" - mapping ...

No, not more help ... because this is answerd 1000 times in this forum and in the docs ... just a hint ...

gtx
curio

Read the documentation, especially chapter 6.1.5 (composite-id). You will recognize that the element <key-property> also contains an attribute "column".

Best regards
Sven