Hi friends,

I have to query a table something like this:



How do we write a hibernate equivalent for the above?

I have one more problem - I want to insert an id (id of Y) value in a table say x, as soon as a record is entered into a table Y.
I am confused about these.

Any help/suggestion is much appreciated.

Thanks
Vishal



Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.1

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

Hi h1bernate,

use HQL (closer to SQL). Try this:

chucky

Don't forget to rate if this helps
-------------------------------------

Hi,
>>> I have one more problem - I want to insert an id (id of Y) value in a table say x, as soon as a record is entered into a table Y.

You can use database triggers for the same. ( database should support it )

Using Interceptors is one more option. I have a sample code here,

public class MyInterceptor extends EmptyInterceptor {
@Override
public boolean onSave(Object entity, Serializable id, Object[] state, String[] propertyNames, Type[] types) {
Session session = HibernateUtil.currentSession() ;
X audit = new X() ; // audit table
Y y ; // entity being saved
if (entity instanceof Y) {
y = (Y) entity ;
audit.setId(y.getId()) ;
session.save(y) ;
}
return super.onSave(entity, id, state, propertyNames, types);
}
}

And then, you can use this at session level. ( sample ) // in HibernateUtil.java ( or anything similar )

public synchronized static Session currentSession(Interceptor interceptor) throws HibernateException {
Session s = session.get();
if (s == null) {
s = sessionFactory.openSession(interceptor);
session.set(s);
}
return s;
}

Concerns: ( in the sample )
i) Session is used inside the interceptor code. When session context is bound to Thread, I think, this should not cause problems. I don't know if there are any pit falls. ( Read more and then use it )

You can read more on interceptors at,
http://www.hibernate.org/hib_docs/v3/re ... terceptors

-------------------------------------------------------------------
Rate the reply if you find it helpful

Hi Hi h1bernate,
or if there's a relationship between the to tables, more simple: cascade (can be specified in the mapping file)

Thanks for your responses - let mw go through them.

Thanks
Vishal