A purist question (session.createQuery or session.find)?

nerotnt · **Joined:** Wed Oct 08, 2003 10:31 am **Posts:** 247

Being a purist in terms of performance, sql generated code, etc., which method is the better:

Method 1

Code:

Query query = session.createQuery("from pt.Xpto as x where x.ref like upper(:ref)");
query.setParameter("ref", "%" + vref + "%");
List res = query.list();

Method 2

Code:

List res = session.find("from pt.Xpto as x where x.ref like upper(?)", ref, Hibernate.STRING);

They look the same...

Thanks in advance.

christian · **Posted:** Tue Jan 27, 2004 7:52 am

One is using named parameters and the other positional parameters. They evaluate to the same SQL, of course. The difference in usage should be clear if you look at it.

nerotnt · **Joined:** Wed Oct 08, 2003 10:31 am **Posts:** 247

christian wrote:

One is using named parameters and the other positional parameters. They evaluate to the same SQL, of course. The difference in usage should be clear if you look at it.

Sorry... I think I didn't explain my point correctly.
Visualy they don't look the same, of course. I ment in terms of functionality and generated code.

In terms of performance, are they the same?

PS: thanks for the quick reply christian (as usual).

christian · **Posted:** Tue Jan 27, 2004 8:00 am

They are the same.

nerotnt · **Joined:** Wed Oct 08, 2003 10:31 am **Posts:** 247

christian wrote:

They are the same.

Thanks.