Hi all,

I'm working with Oracle9i via JDBC and I've find a bug is the createSQLQuery method (I think it's a bug, perhaps i'm mistaking...).

Indeed, when I try this :
createSQLQuery("select {mytab.*} from MYTABLE {mytab} where {mytab.idtable}=1", "mytab", MyTable.class);

Hibernate generate a query like :
select MYTAB.IDTABLE AS IDTABLE0_, MYTAB.TABLENAME AS TABLENAME0_ [...] FROM MYTABLE MYTAB WHERE IDTABLE0_=1

It generates an JDBC error ORA-00904 : Invalid indentifier. It's true, because IDTABLE0_ doesn't exist in the table MYTAB, but IDTABLE does... so it's a bug i think, isn't it ?? Hibernate might use MYTAB.IDTABLE-like expressions in the where clause...

What do you think about it people ?

Thanks !! =)

that is not an error - {}-syntax is just for aliases...and if the db does not support aliases in the where clause then use the direct table/column name instead...

Hi Max ! =)

Following your post, I've tried this one :

createSQLQuery("select {mytab.*} from MYTABLE {mytab} where {mytab}.IDTABLE=1", "mytab", MyTable.class);

And it worked fine !! =D

Thanks !!

-TEUF-