Hi All,

First off, congratulations for your great project!

  I'm experiencing a problem, I'm trying the following query:

    select merchant from merchant in
    class my.project.Merchant,
    store in class my.project.Store
    where merchant.id = ? and store.id = ?
    and store.merchant = merchant

Interesting enough, the generated query looks like this:

  SELECT merchant.oid as x0_0_ FROM store store,
  merchant merchant WHERE (merchant.oid=? )and(store.oid=? )
  and(store.merchant_oid=merchant.oid )

(please note it says merchant.oid and store.oid instead of
merchant.id and store.id).

If I use a property other than "id", i.e:

    select merchant from merchant in
    class my.project.Merchant,
    store in class my.project.Store
    where merchant.name = ? and store.name = ?
    and store.merchant = merchant

then the generated query looks fine. I guess the literal "id" is 
handled in an special way.

BTW, in this case, Hibernate's ids are named "oid", "id" is just 
a regular property.

--Alejandro

PS.- I'm using Hibernate-1.2.2



-------------------------------------------------------
This SF.NET email is sponsored by: A Thawte Code Signing Certificate 
is essential in establishing user confidence by providing assurance of 
authenticity and code integrity. Download our Free Code Signing guide:
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0028en
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel

Reply via email to