Insert through a HQL

incarnateX · **Joined:** Thu Oct 06, 2005 9:57 am **Posts:** 5

Hi,

Is there a way to make an entry in a table without using session.save().

Thanks in advance.

From,
Santo.

pkulak · **Joined:** Tue Mar 01, 2005 2:35 pm **Posts:** 60

Yup, but you're going to have to use native SQL:

session.createSQLQuery("INSERT INTO ...").executeUpdate();

pksiv · **Posted:** Thu Oct 06, 2005 11:13 am

incarnateX wrote:

Hi,

Is there a way to make an entry in a table without using session.save().

Thanks in advance.

From,
Santo.

Just curious... if you're using Hibernate, why would you want to insert a row without using the Session.save() method ?

kbaum · **Joined:** Tue Aug 17, 2004 11:27 pm **Posts:** 24

session.saveOrUpdate()

:-)

incarnateX · **Joined:** Thu Oct 06, 2005 9:57 am **Posts:** 5

pksiv wrote:

incarnateX wrote:

Hi,

Is there a way to make an entry in a table without using session.save().

Thanks in advance.

From,
Santo.

Just curious... if you're using Hibernate, why would you want to insert a row without using the Session.save() method ?

The save() method accepts a detached object and persists it to the database. In my case, the object Iam creating needs a lot of child objects to be loaded which results to a lot of overhead which I want to avoid. Just in case you need an example......

Code:

class A{

  /* persistent child*/
  B b;

  public A(B b){

    this.b = b;
  }
}

----------------------------
_b = session.load(...);
A _a = new A(_b);
session.save(_a);

In this case in order to persist "_a" I first need to load "_b" which is something I wish to avoid. That's the reason why I was wanting to INSERT directly through HQL.

steve · **Posted:** Sat Oct 08, 2005 8:08 am

So then use proxies for those "child objects". Then session.load() will not hit the database. So many misconceptions, so little time ;)

In Hibernate3 HQL now has an INSERT-SELECT statement. Currently it is serverely hampered by the fact that it cannot handle associations; that will be rectified before 3.1 goes final though.