Query by Example and primary key

shmonder · **Joined:** Wed Jan 14, 2004 3:21 am **Posts:** 2

Hey!

I am trying to write a query by example, but i faced the following problem.
If am passing an example object, with a primary key field initialized, then i get back the list of all records in my table.

of course one of the possibilities is to write own implementation of PropertySelector. but i would like to write fetch methods that can be used with any persistent object.

Here is my example

Code:

  public Object getObjectByExample(Object object) throws HibernateException {
    List objectList = this.getObjectListByExample(object);

    object = (objectList.isEmpty() ? null : objectList.get(0));

    return object;
  }


  public List getObjectListByExample(Object object) throws HibernateException {
    Session session = DaoSession.open();

    Example example = Example.create(object);

    List objectList = session.createCriteria(object.getClass()).add(example)
                             .list();

    return objectList;
  }

Thanks!

shmonder · **Joined:** Wed Jan 14, 2004 3:21 am **Posts:** 2

i have found in the documentation the following line

Quote:

Version propeties, identifiers and associations are ignored

Why it is so?
And what is a defualt implementation of PropertySelector interface used when i create new Example instance by passing only example object?

emmanuel · **Posted:** Wed Jan 14, 2004 6:07 am

version is a technical tool, requesting by version has no business meaning.
If you know the identity, then you know the object, just do load(class, pk).
Example query is done to do a "looks like" query, not an exact query.

Bertrand Donnet · **Joined:** Mon Aug 22, 2005 3:42 am **Posts:** 1

Hello,

I am facing the same problem with key properties included in the key.

I have this kind of mapping

<class name="com.real.aof.to.db.BWFF" table="AOFSQL_6.AOFBWFF" lazy="false">

<composite-id>
<key-property name="jobNumber" column="BFJBNR" />
<key-property name="archiveNumber" column="BFINNR" />
<key-property name="documentNumber" column="BFDONR" />
<key-property name="sequenceNumber" column="BFSEQ" />
</composite-id>

<property name="fromFolderID" column="BFFIIF" />
<property name="documentName" column="BFDONM" />
<property name="toFolderID" column="BFFIIT" />
<property name="yesFolderID" column="BFFIIY" />
<property name="noFolderID" column="BFFIIN" />
<property name="approbationRequired" column="BFAPRQ" />
<property name="triggeredProgram" column="BFPGM" />
<property name="text" column="BFTEXT" />

</class>

I would like to make QBE with only a part of the composed-key (5 fields for instance) and it is easier to use QBE than declare a cunch of queries for each combination of properties.

Do you have a suggestion ? Which class to extend to enable this ?
Thanks a lot