Hi,

I'm writing an application for displaying timetable. Data are stored in a tiers database. I access data via hibernate. I'm using spring and hibernateTemplate.

I'm trying to get data for two weeks. In database, events are stored with week numbers as a string (a string representing all week for a year, you must have a Y in order to get the event matching a week, for example, for an event matching the two first week of the year, you will have "YYNNNNNNNN....").

in database
---------
| Event |
---------
| - date startHour (9:00)
| - date endHour (11:00)
| - string weeks (YYNYNNNNNNNNNNNNNNNNN...NNNNNNNNNNNNNNNNNNNNNY)*
---------
| transient Calendar selectedWeek**
---------

* meaning first, second and fourth week of year and last week of year)
** week used to query the object, because I do query week by week


In the event class, I added a transient variable selectedWeek of type Calendar in order to store the week I used to query this object. I simplify my life after.

So I need to do two query to get events for the two next weeks. So my code is : select blabla where week like "Y%" and a second with : select blabla where week like "_Y%"

The problem I have is that the two query return the same event (and so the same hibernate object). The first query set the selectedWeek with first week of year, but the second set it with the second week of year.

What I want is that the two query return me the same event but in two different hibernate object (because the same event occurs in two differents weeks).

Is it possible ? Am I clear ?

This is not possible within the same persistent context (session).
If you want to have 2 distinct objects for the same record on the database,
then you must issue the 2 query from 2 distinct sessions.
See http://docs.jboss.org/hibernate/core/4.0/manual/en-US/html/transactions.html#transactions-basics-identity

hum. The problem is that I use the openSessionViewInFilter to get the same hibernate session along the user request (and to be able to access lazy data in my jsp).

Seems like I have to make my application a bit different...