Hello All,

I am newbie to Hibernate. Today, I am assigned one issue to fix is ASAP. Whenever i execute following query against Oracle database and schema1

[b]session.createQuery("from " + objectName + orderBy)[/b]

i am getting following exception.

[b]org.hibernate.ObjectNotFoundException: No row with the given identifier exists:[/b]

But the same code works fine with schema2. As i have been assigned this task today, i purchases a Hibernate book and started reading it. But its going to take fews days to under stand hibernate. As people wants me to fix this issue ASAP, i will appreciate any pointers or help.

Thanks
Prashant

the db w/ schema1 has different data than the db w/ schema2 ?

Hi u r executing createQuery... which follows HQL formate...
so make as string., like

("from " + object + " " + orderby) ..

if u get help from this please vote.

orderBy is obviously a String.

i know orderBy is string...
but HQL want is as in string form like
"from customer c order by c.customername"

so there should be space between word so i was telling like this..
thanks..

and this explains why it can find a row in one database, but not in another?

Thank you everybody for reply. Because of some data referential integrety issue in schema1, Hibernate was throwing the exceptions. As it works fine with schema2, i compared data in schma1 with schma2 and found out the problem.

Both the objectName and orderBy are string.

I really appreciate all the replies.

Thanks
Prashant