Hibernate version: 3.0

Mapping documents: NA

Code between sessionFactory.openSession() and session.close():
NA
Full stack trace of any exception that occurs:
NA
Name and version of the database you are using:
NA
The generated SQL (show_sql=true):
NA
Debug level Hibernate log excerpt:
NA

I have 2 entity objects A and B; A contains a foriegn key back to B so...

class B {
private int id
private String name
private String ss#
private Set As
}

class A {
private int id
private String streetName
private String postalCodes
private B b
}

<many-to-one name="B" class="com.B" fetch="select">
<column name="b_id" not-null="true" />
</many-to-one>

When I do the following the first level cache does not store the row from the database it stores what I set on the object, for example...

Session s = Session.current();
A a = (A)s.createQuery(from A where id = 12345).uniqueResult();

B b = new B();
b.setId(2);
a.setB(b);

a = (A)s.createQuery(from A where id = 12345).uniqueResult();
b = a.getB();

b.getName(); // this returns null
b.getSS#(); // this returns null


why is b returning null for name and ss#? I created a new B instance and set the id, shouldn't hibernate load the entity associated with id 2 into the cache. It seems hibernate is caching the newly created instance as is, meaning I set the id = 2, but did not set name and ss# which are returning as nulls when I call get.

Thanks for any help.

Just a guess, but B is not a persistent instance. Instead of:

try:

If that doesn't do the trick, you might need to call s.flush() after a.setB().

HTH
Eric

yep, that did the trick. I should have caught that B was a dettached object and either call get or load to atach it to the session. I thought hibernate given the that B's id was set would retrieve the row from the database and cache it.

Thanks!