Hi,

I have a many-to-one relationship.

<many-to-one name="host" class="HostnameMap" column="filesystemID" outer-join="auto"/>

Sometimes the value in 'host' is bad, and has no correponding record in the HostnameMap table, hibernate throws an exception:

net.sf.hibernate.ObjectNotFoundException: No row with the given identifier exists: 1560728141, of class: HostnameMap
at net.sf.hibernate.ObjectNotFoundException.throwIfNull(ObjectNotFoundException.java:24)
at net.sf.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:1925)
at net.sf.hibernate.proxy.LazyInitializer.initialize(LazyInitializer.java:53)
at net.sf.hibernate.proxy.LazyInitializer.initializeWrapExceptions(LazyInitializer.java:60)
at net.sf.hibernate.proxy.LazyInitializer.getImplementation(LazyInitializer.java:164)
at net.sf.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:108)
at HostnameMap$$EnhancerByCGLIB$$5d195980.toString(<generated>)


At that point I would like to log an error trace, but how can I get the string value of the invalid id of the hostnamemap???

thanks

your db is corrupted, is the foreign declared on db? if not just verify that there is a row in the table "HostnameMap" with the column id = 1560728141

Anthony,

thanks for the reply.
yes, I see the data is wrong in my db (that is ok by itself), I just want to log some info about the issue. My mapping looks like this:

<class name="Parent" table="Parent">
...
<many-to-one name="host" class="HostnameMap" column="filesystemID" outer-join="auto"/>
</class>

I have an instance of Parent, and the exception was thrown when I called parent.getHost();
What I want at that point is to be able to:
System.err.println("Bad data in db: " + parent.getId() + " has host: " + <THE ID OF THE HOST>);

I cannot see how to get the id, without getting the HostnameMap instance, which is unexistant thus the exception...

many thanks,
a plus,

use JDBC and execute
select a.fk from a where a.fk not in (select b.pk from b)

you'll have all corrupted rows

and don't forget your dba is your friend to guarantee data integrity

I new it was possilbe without jdbc...that code works for me

String res = "";
SessionImplementor sfi = (SessionImplementor) session;
Serializable sres = null;
try {
sres = HibernateProxyHelper.getIdentifier(o, sfi.getFactory().getPersister(classs));
}
catch (Exception e) {
...
}
return sres.toString();