The scenario is:

I have 3 tables STORE, FISCAL_PERIOD, and STORE_DETAIL. The STORE_DETAIL has two columns store_id (pk for STORE table) and fiscal_period_id (pk for FISCAL_PERIOD table). These two columns form a unique constraint in STORE_DETAIL table

I have a class Store that has getStoreDetails() that returns a set. However, I'd like to get storeDeatils for a specific fiscal_period_id. I was hoping that using Artifact Generation, the unique constraint would automatically be created providing me a method to getStoreDetailsByFiscalPeriod(FiscalPeriod fp). It is a mjor performance hit to first getStoreDetails and then using createFilter (that actually creates a copy) to get the list by FiscalPeriod.

Is that true, if not, am I missing something, do I have to write custom code in the generated POJOs to provide this, if so, how would that change the *.hbm.xml

Thanks in advance!

Atul




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

Hibernate version:

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:

you are asking for a DAO finder based on a unique key. Don't know if we can deduce that sensible everytime but maybe it would make sense.

Put usecase in jira

Thank you so much, Max. I will add a use case in JIRA.

Can you point me to a DAO finder sample that is similar to my scenario?

Again, thank you for reply. I really appreciate it.

Atul

its in the junit tests.

if you have a named query we create finders for it.

or use a Hibernate3 dynamic filter

Thanks Steve! However the documentation in section 5.4 for Hibernate 3.0.5 says

"Note that the following features are currently considered experimental and may change in the near future."

I believe Dynamic models/filters is one and the same, right?


Atul

no.

http://www.hibernate.org/hib_docs/v3/reference/en/html/filters.html

Thank you! This is really useful.

Atul