Problem:
I have a Booking object which contains a collection of BookingWeek objects. When i create the booking object and the collection of bookingweek object at one shot, it goes through fine.

But the BookingWeek contains a collection of Bookingweekkscreen objects. When i try to create the Booking, collection of BookingWeek and the collection of BookingWeekScreen object i get an error "Unable to lookup on timestamps"

Hibernate version: 3.0(RC1)


[b]Mapping documents:

1) Booking.hbm.xml:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<!--
Auto-generated mapping file from
the hibernate.org cfg2hbm engine
-->
<class name="com.sony.spe.ifds.domain.Booking" table="BOOKING" schema="DBO_SOA" lazy="false">
<id name="BookingId" type="java.lang.String">
<column name="BOOKING_ID" not-null="true" unique="true" sql-type="VARCHAR2" />
<generator class="sequence" >
<param name="sequence">booking_id_seq</param>
</generator>
</id>

<property name="Updater" type="java.lang.String">
<column name="UPDATER" not-null="true" sql-type="VARCHAR2" />
</property>

<property name="TimeStamp" type="java.util.Date">
<column name="TIME_STAMP" not-null="true" sql-type="DATE" />
</property>

<set name="SetOfBookingWeek" cascade="all">
<key>
<column name="BOOKING_ID" not-null="false" />
</key>
<one-to-many class="com.sony.spe.ifds.domain.BookingWeek" />
</set>
</class>
</hibernate-mapping>

2) BookingWeek.hbm.xml:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<!--
Auto-generated mapping file from
the hibernate.org cfg2hbm engine
-->
<class name="com.sony.spe.ifds.domain.BookingWeek" table="BOOKING_WEEK" schema="DBO_SOA" lazy="false">
<composite-id name="id" class="com.sony.spe.ifds.domain.BookingWeekId">
<key-many-to-one name="Booking" class="com.sony.spe.ifds.domain.Booking">
<column name="BOOKING_ID" not-null="false" />
</key-many-to-one>
<key-property name="BookingWkNumber" type="java.lang.Short">
<column name="BOOKING_WK_NUMBER" not-null="true" sql-type="NUMBER" />
</key-property>
</composite-id>


<set name="SetOfBookingWeekScreen" cascade="all" >
<key>
<column name="BOOKING_ID" not-null="false" />
<column name="BOOKING_WK_NUMBER" not-null="false" />
<column name="SCREEN_ID" not-null="false" />
<column name="EFFECTIVE_START_DATE" not-null="false" />
</key>
<one-to-many class="com.sony.spe.ifds.domain.BookingWeekScreen" />
</set>

</class>
</hibernate-mapping>

3) BookingWeekScreen.hbm.xml:

Code between sessionFactory.openSession() and session.close():

I am just passing the Booking object to the save method. With the mapping construct i expect the bookingWeek and BookingWeekScreen collections to be persisted.

This way, Booking and BookingWeek collection is created properly.

Full stack trace of any exception that occurs:
java.lang.UnsupportedOperationException: cannot perform lookups on timestamps
at org.hibernate.type.TimestampType.getHashCode(TimestampType.java:99)
at org.hibernate.type.AbstractType.getHashCode(AbstractType.java:119)
at org.hibernate.type.ComponentType.getHashCode(ComponentType.java:162)
at org.hibernate.type.EntityType.getHashCode(EntityType.java:350)
at org.hibernate.type.ComponentType.getHashCode(ComponentType.java:162)
at org.hibernate.engine.EntityKey.getHashCode(EntityKey.java:68)
at org.hibernate.engine.EntityKey.<init>(EntityKey.java:41)
at org.hibernate.engine.PersistenceContext.checkUniqueness(PersistenceContext.java:544)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performUpdate(DefaultSaveOrUpdateEventListener.java:
251)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsDetached(DefaultSaveOrUpdateEventListener.ja
va:214)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener
.java:91)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java
:69)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:416)
at org.hibernate.engine.Cascades$5.cascade(Cascades.java:153)
at org.hibernate.engine.Cascades.cascade(Cascades.java:721)
at org.hibernate.engine.Cascades.cascadeCollection(Cascades.java:860)
at org.hibernate.engine.Cascades.cascade(Cascades.java:739)
at org.hibernate.engine.Cascades.cascade(Cascades.java:817)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:361)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:263)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:158)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEv
entListener.java:184)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.j
ava:173)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener
.java:96)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java
:69)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:416)
at org.hibernate.engine.Cascades$5.cascade(Cascades.java:153)
at org.hibernate.engine.Cascades.cascade(Cascades.java:721)
at org.hibernate.engine.Cascades.cascadeCollection(Cascades.java:860)
at org.hibernate.engine.Cascades.cascade(Cascades.java:739)
at org.hibernate.engine.Cascades.cascade(Cascades.java:817)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:361)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:263)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:158)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEv
entListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java
:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.j
ava:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java
:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:429)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:424)
at com.sony.spe.framework.Persistence.DataAccessor.save(DataAccessor.java:199)
at com.sony.spe.framework.Persistence.DataAccessor.create(DataAccessor.java:153)
at com.sony.spe.ifds.dao.BookingDAO.createBooking(BookingDAO.java:37)
at com.sony.spe.ifds.app.business.booking.service.BookingBean.createBooking(BookingBean.java:167)
at com.sony.spe.ifds.app.business.booking.service.BookingService_jtovn_ELOImpl.createBooking(BookingService_jtov
n_ELOImpl.java:585)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.bea.wlw.runtime.core.control.EJBControlImpl.invoke(EJBControlImpl.jcs:665)
at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:377)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:423)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:396)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:248)
at com.bea.wlw.runtime.jcs.container.JcsContainer.invoke(JcsContainer.java:85)
at com.bea.wlw.runtime.core.bean.BaseContainerBean.invokeBase(BaseContainerBean.java:224)
at com.bea.wlw.runtime.core.bean.SLSBContainerBean.invoke(SLSBContainerBean.java:103)
at com.bea.wlwgen.StatelessContainer_ly05hg_ELOImpl.invoke(StatelessContainer_ly05hg_ELOImpl.java:153)
at com.bea.wlwgen.GenericStatelessSLSBContAdpt.invokeOnBean(GenericStatelessSLSBContAdpt.java:62)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.runAsInvoke(BaseDispatcherBean.java:153)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.invoke(BaseDispatcherBean.java:54)
at com.bea.wlw.runtime.core.bean.SyncDispatcherBean.invoke(SyncDispatcherBean.java:168)
at com.bea.wlw.runtime.core.bean.SyncDispatcher_k1mrl8_EOImpl.invoke(SyncDispatcher_k1mrl8_EOImpl.java:100)
at com.bea.wlw.runtime.core.dispatcher.Dispatcher.remoteDispatch(Dispatcher.java:161)
at com.bea.wlw.runtime.core.dispatcher.ServiceHandleImpl.invoke(ServiceHandleImpl.java:436)
at com.bea.wlw.runtime.core.dispatcher.WlwProxyImpl._invoke(WlwProxyImpl.java:326)
at com.bea.wlw.runtime.core.dispatcher.WlwProxyImpl.invoke(WlwProxyImpl.java:315)
at $Proxy9.createBooking(Unknown Source)
at Test.TestingBooking.TestingBookingController.begin(TestingBookingController.jpf:78)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.bea.wlw.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:1507)
at com.bea.wlw.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:1433)
at com.bea.wlw.netui.pageflow.FlowController.internalExecute(FlowController.java:764)
at com.bea.wlw.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:211)
at com.bea.wlw.netui.pageflow.FlowController.execute(FlowController.java:594)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:650)
at com.bea.wlw.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:527)
at com.bea.wlw.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:152)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315)
at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:328)
at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor.superForward(PageFlowRequestProcessor.java:1301)
at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor$DefaultHttpRedirector.forward(PageFlowRequestProcessor.ja
va:1317)
at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor.doForward(PageFlowRequestProcessor.java:1199)
at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:637)
at com.bea.wlw.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:527)
at com.bea.wlw.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:152)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6722)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3764)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2644)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
Name and version of the database you are using:

Oracle 9i

The generated SQL (show_sql=true):

Hibernate: select this_.THEATRE_ID as THEATRE1_2_, this_.SECTION_ID as SECTION2_31_2_, this_.ADDRESS_ID as ADDRESS3_31_2
_, this_.THEATRE_TYPE_ID as THEATRE4_31_2_, this_.TAX_CODE as TAX5_31_2_, this_.STATE_PROVINCE_ID as STATE6_31_2_, this_
.NOTES_TOKEN as NOTES7_31_2_, this_.THEATRE_NAME_LO as THEATRE8_31_2_, this_.THEATRE_NAME_HO as THEATRE9_31_2_, this_.TH
EATRE_SHORT_NAME_LO as THEATRE10_31_2_, this_.THEATRE_SHORT_NAME_HO as THEATRE11_31_2_, this_.THEATRE_ACC_CHECKING_CODE
as THEATRE12_31_2_, this_.THEATRE_GTA_DATE as THEATRE13_31_2_, this_.THEATRE_CHECK_WITH_BRANCH_MGR as THEATRE14_31_2_, t
his_.THEATRE_COD_ACCOUNT as THEATRE15_31_2_, this_.THEATRE_ADVANCE_REQUIRED as THEATRE16_31_2_, this_.THEATRE_OFF_SERVIC
E as THEATRE17_31_2_, this_.THEATRE_CHECKING_CODE as THEATRE18_31_2_, this_.THEATRE_ADVANCE_SHIPPING_DAYS as THEATRE19_3
1_2_, this_.THEATRE_SHIPPING_RETURN_DAYS as THEATRE20_31_2_, this_.THEATRE_OPEN_DT as THEATRE21_31_2_, this_.THEATRE_CLO
SE_DT as THEATRE22_31_2_, this_.NBR_OF_RUN_WEEKS as NBR23_31_2_, this_.PROVINCIAL_LICENSE_NBR as PROVINCIAL24_31_2_, thi
s_.PROVINCIAL_LICENSE_EXPR_DTE as PROVINCIAL25_31_2_, this_.COMM_METH_ID as COMM26_31_2_, this_.ALWAYS_CHECK_IND as ALWA
YS27_31_2_, this_.BLIND_IND as BLIND28_31_2_, this_.EIS_THEATRE_RANKING as EIS29_31_2_, this_.ACCESSORY_THEATRE_RANKING
as ACCESSORY30_31_2_, this_.MISC_THEATRE_RANKING_1 as MISC31_31_2_, this_.MISC_THEATRE_RANKING_2 as MISC32_31_2_, this_.
EDI_THEATRE_RANKING as EDI33_31_2_, this_.LAST_CHECKED_DT as LAST34_31_2_, this_.SORT_ORDER as SORT35_31_2_, this_.RATIN
G as RATING31_2_, this_.CONCESSION_CNT as CONCESSION37_31_2_, this_.LOBBY_DESC_TOKEN as LOBBY38_31_2_, this_.ACCESSORY_D
EPOT_ID as ACCESSORY39_31_2_, this_.EXCL_FROM_EDI_IND as EXCL40_31_2_, this_.MONDAY_SHIP_AHEAD_DAYS as MONDAY41_31_2_, t
his_.TUESDAY_SHIP_AHEAD_DAYS as TUESDAY42_31_2_, this_.WEDNESDAY_SHIP_AHEAD_DAYS as WEDNESDAY43_31_2_, this_.THURSDAY_SH
IP_AHEAD_DAYS as THURSDAY44_31_2_, this_.FRIDAY_SHIP_AHEAD_DAYS as FRIDAY45_31_2_, this_.SATURDAY_SHIP_AHEAD_DAYS as SAT
URDAY46_31_2_, this_.SUNDAY_SHIP_AHEAD_DAYS as SUNDAY47_31_2_, this_.MONDAY_SHIP_RETURN_DAYS as MONDAY48_31_2_, this_.TU
ESDAY_SHIP_RETURN_DAYS as TUESDAY49_31_2_, this_.WEDNESDAY_SHIP_RETURN_DAYS as WEDNESDAY50_31_2_, this_.THURSDAY_SHIP_RE
TURN_DAYS as THURSDAY51_31_2_, this_.FRIDAY_SHIP_RETURN_DAYS as FRIDAY52_31_2_, this_.SATURDAY_SHIP_RETURN_DAYS as SATUR
DAY53_31_2_, this_.SUNDAY_SHIP_RETURN_DAYS as SUNDAY54_31_2_, this_.PERS_GUAR_COLUMBIA as PERS55_31_2_, this_.PERS_GUAR_
TRISTAR as PERS56_31_2_, this_.PERS_GUAR_SPR as PERS57_31_2_, this_.PERS_GUAR_SPC as PERS58_31_2_, this_.MASTER_LIC_OLD_
COLUMBIA as MASTER59_31_2_, this_.MASTER_LIC_NEW_COLUMBIA as MASTER60_31_2_, this_.MASTER_LIC_TRISTAR as MASTER61_31_2_,
this_.MASTER_LIC_SPR as MASTER62_31_2_, this_.MASTER_LIC_SPC as MASTER63_31_2_, this_.CORPORATE_NAME as CORPORATE64_31_
2_, this_.ADDITIONAL_CREDIT_PROFILE as ADDITIONAL65_31_2_, this_.TAX_EXEMPT_IND as TAX66_31_2_, this_.DEFAULT_DEAL as DE
FAULT67_31_2_, this_.BOS_COMMENTS_TOKEN as BOS68_31_2_, this_.PER_CAP_INT_NOTES_TOKEN as PER69_31_2_, this_.THEATRE_PERC
_BO_EXCLUDE_IND as THEATRE70_31_2_, this_.BO_UND_INT_NOTES_TOKEN as BO71_31_2_, this_.UPDATER as UPDATER31_2_, this_.TIM
E_STAMP as TIME73_31_2_, this_.SPE_ENTITY_ID as SPE74_31_2_, section2_.SECTION_ID as SECTION1_0_, section2_.AREA_ID as A
REA2_29_0_, section2_.SECTION_NAME_LO as SECTION3_29_0_, section2_.SECTION_NAME_HO as SECTION4_29_0_, section2_.SORT_ORD
ER as SORT5_29_0_, section2_.COMPETITIVE_IND as COMPETIT6_29_0_, section2_.THEATRE_BUYING_CIRCUIT_CNT as THEATRE7_29_0_,
section2_.UPDATER as UPDATER29_0_, section2_.TIME_STAMP as TIME9_29_0_, section2_.SPE_ENTITY_ID as SPE10_29_0_, address
3_.ADDRESS_ID as ADDRESS1_1_, address3_.ADDRESS_TYPE as ADDRESS2_0_1_, address3_.SHORT_NAME as SHORT3_0_1_, address3_.CO
NTACT_NAME_1 as CONTACT4_0_1_, address3_.CONTACT_NAME_2 as CONTACT5_0_1_, address3_.STREET as STREET0_1_, address3_.CITY
_LO as CITY7_0_1_, address3_.CITY_HO as CITY8_0_1_, address3_.STATE_LO as STATE9_0_1_, address3_.STATE_HO as STATE10_0_1
_, address3_.PROVINCE as PROVINCE0_1_, address3_.POST_CODE as POST12_0_1_, address3_.COUNTRY as COUNTRY0_1_, address3_.P
HONE_NUMBER as PHONE14_0_1_, address3_.EMAIL_ID as EMAIL15_0_1_, address3_.UPDATER as UPDATER0_1_, address3_.TIME_STAMP
as TIME17_0_1_, address3_.SPE_ENTITY_ID as SPE18_0_1_ from DBO_SOA.THEATRE this_ left outer join DBO_SOA.SECTION section
2_ on this_.SECTION_ID=section2_.SECTION_ID left outer join DBO_SOA.ADDRESS address3_ on this_.ADDRESS_ID=address3_.ADDR
ESS_ID where this_.THEATRE_ID=?
Hibernate: select area0_.AREA_ID as AREA1_1_, area0_.MARKET_ID as MARKET2_1_1_, area0_.AREA_NAME_LO as AREA3_1_1_, area0
_.AREA_NAME_HO as AREA4_1_1_, area0_.SORT_ORDER as SORT5_1_1_, area0_.UPDATER as UPDATER1_1_, area0_.TIME_STAMP as TIME7
_1_1_, area0_.SPE_ENTITY_ID as SPE8_1_1_, market1_.MARKET_ID as MARKET1_0_, market1_.LANGUAGE_ID as LANGUAGE2_23_0_, mar
ket1_.BRANCH_ID as BRANCH3_23_0_, market1_.MARKET_NAME_LO as MARKET4_23_0_, market1_.MARKET_NAME_HO as MARKET5_23_0_, ma
rket1_.MARKET_SHORT_NAME_LO as MARKET6_23_0_, market1_.MARKET_SHORT_NAME_HO as MARKET7_23_0_, market1_.PLAY_CODE_ID as P
LAY8_23_0_, market1_.WB_STORES_INDICATOR as WB9_23_0_, market1_.VIDEO_MARKET_INDICATOR as VIDEO10_23_0_, market1_.COOP_L
EVEL as COOP11_23_0_, market1_.ITR_GROUP as ITR12_23_0_, market1_.ITR as ITR23_0_, market1_.NATIONAL_RANK as NATIONAL14_
23_0_, market1_.BRANCH_RANK as BRANCH15_23_0_, market1_.ACTUAL_FILM_RENTAL as ACTUAL16_23_0_, market1_.AVERAGE_FILM_RENT
AL as AVERAGE17_23_0_, market1_.CURRENCY_CODE as CURRENCY18_23_0_, market1_.EXCHANGE_RATE_TO_USD as EXCHANGE19_23_0_, ma
rket1_.EXCHANGE_RATE_FROM_USD as EXCHANGE20_23_0_, market1_.NUMBER_OF_RELEASES as NUMBER21_23_0_, market1_.NUMBER_OF_RUN
S as NUMBER22_23_0_, market1_.MINIMUM_RUNS as MINIMUM23_23_0_, market1_.UPSCALE_RUNS as UPSCALE24_23_0_, market1_.REGULA
R_RUNS as REGULAR25_23_0_, market1_.SATURATION_RUNS as SATURATION26_23_0_, market1_.SUMMER_RUNS as SUMMER27_23_0_, marke
t1_.SUMMER_RUNS_MESSAGE as SUMMER28_23_0_, market1_.STATUS as STATUS23_0_, market1_.UPDATER as UPDATER23_0_, market1_.TI
ME_STAMP as TIME31_23_0_, market1_.SPE_ENTITY_ID as SPE32_23_0_ from DBO_SOA.AREA area0_ left outer join DBO_SOA.MARKET
market1_ on area0_.MARKET_ID=market1_.MARKET_ID where area0_.AREA_ID=?
Hibernate: select branch0_.BRANCH_ID as BRANCH1_1_, branch0_.LANGUAGE_ID as LANGUAGE2_9_1_, branch0_.TERRITORY_ID as TER
RITORY3_9_1_, branch0_.OFFICE_LOCATION_ID as OFFICE4_9_1_, branch0_.BRANCH_NAME_LO as BRANCH5_9_1_, branch0_.BRANCH_NAME
_HO as BRANCH6_9_1_, branch0_.BRANCH_SHORT_NAME_LO as BRANCH7_9_1_, branch0_.BRANCH_SHORT_NAME_HO as BRANCH8_9_1_, branc
h0_.BRANCH_DESCRIPTION_LO as BRANCH9_9_1_, branch0_.BRANCH_DESCRIPTION_HO as BRANCH10_9_1_, branch0_.BRANCH_TIME_ZONE_CO
DE as BRANCH11_9_1_, branch0_.COMM_METH_ID as COMM12_9_1_, branch0_.NOTES_TOKEN as NOTES13_9_1_, branch0_.EXCL_FROM_EDI_
IND as EXCL14_9_1_, branch0_.OPEN_DATE_VENUE_ID as OPEN15_9_1_, branch0_.UPDATER as UPDATER9_1_, branch0_.TIME_STAMP as
TIME17_9_1_, branch0_.SPE_ENTITY_ID as SPE18_9_1_, territory1_.LANGUAGE_ID as LANGUAGE1_0_, territory1_.TERRITORY_ID as
TERRITORY2_0_, territory1_.REGION_ID as REGION3_30_0_, territory1_.ADDRESS_ID as ADDRESS4_30_0_, territory1_.TERRITORY_N
AME_LO as TERRITORY5_30_0_, territory1_.TERRITORY_NAME_HO as TERRITORY6_30_0_, territory1_.TERRITORY_SHORT_NAME_LO as TE
RRITORY7_30_0_, territory1_.TERRITORY_SHORT_NAME_HO as TERRITORY8_30_0_, territory1_.TERRITORY_DESC_LO as TERRITORY9_30_
0_, territory1_.TERRITORY_DESC_HO as TERRITORY10_30_0_, territory1_.NOTES_TOKEN as NOTES11_30_0_, territory1_.COMM_METH_
ID as COMM12_30_0_, territory1_.UPDATER as UPDATER30_0_, territory1_.TIME_STAMP as TIME14_30_0_, territory1_.SPE_ENTITY_
ID as SPE15_30_0_ from DBO_SOA.BRANCH branch0_ left outer join DBO_SOA.TERRITORY territory1_ on branch0_.LANGUAGE_ID=ter
ritory1_.LANGUAGE_ID and branch0_.TERRITORY_ID=territory1_.TERRITORY_ID where branch0_.BRANCH_ID=?
Hibernate: select languagety0_.LANGUAGE_ID as LANGUAGE1_0_, languagety0_.LANGUAGE_DESC_LO as LANGUAGE2_20_0_, languagety
0_.LANGUAGE_DESC_HO as LANGUAGE3_20_0_, languagety0_.ISO_LANGUAGE_CODE as ISO4_20_0_, languagety0_.UPDATER as UPDATER20_
0_, languagety0_.TIME_STAMP as TIME6_20_0_, languagety0_.SPE_ENTITY_ID as SPE7_20_0_ from DBO_SOA.LANGUAGE_TYPE language
ty0_ where languagety0_.LANGUAGE_ID=?
Hibernate: select region0_.REGION_ID as REGION1_1_, region0_.ADDRESS_ID as ADDRESS2_25_1_, region0_.REGION_DESCRIPTION a
s REGION3_25_1_, region0_.UPDATER as UPDATER25_1_, region0_.TIME_STAMP as TIME5_25_1_, region0_.SPE_ENTITY_ID as SPE6_25
_1_, address1_.ADDRESS_ID as ADDRESS1_0_, address1_.ADDRESS_TYPE as ADDRESS2_0_0_, address1_.SHORT_NAME as SHORT3_0_0_,
address1_.CONTACT_NAME_1 as CONTACT4_0_0_, address1_.CONTACT_NAME_2 as CONTACT5_0_0_, address1_.STREET as STREET0_0_, ad
dress1_.CITY_LO as CITY7_0_0_, address1_.CITY_HO as CITY8_0_0_, address1_.STATE_LO as STATE9_0_0_, address1_.STATE_HO as
STATE10_0_0_, address1_.PROVINCE as PROVINCE0_0_, address1_.POST_CODE as POST12_0_0_, address1_.COUNTRY as COUNTRY0_0_,
address1_.PHONE_NUMBER as PHONE14_0_0_, address1_.EMAIL_ID as EMAIL15_0_0_, address1_.UPDATER as UPDATER0_0_, address1_
.TIME_STAMP as TIME17_0_0_, address1_.SPE_ENTITY_ID as SPE18_0_0_ from DBO_SOA.REGION region0_ left outer join DBO_SOA.A
DDRESS address1_ on region0_.ADDRESS_ID=address1_.ADDRESS_ID where region0_.REGION_ID=?
Hibernate: select booking_id_seq.nextval from dual
Hibernate: select bookingwee_.BOOKING_ID, bookingwee_.BOOKING_WK_NUMBER, bookingwee_.TIME_STAMP as TIME3_8_, bookingwee_
.BOOKING_WK_OPEN_DT as BOOKING4_8_, bookingwee_.BOOKING_WK_START_DT as BOOKING5_8_, bookingwee_.BOOKING_WK_END_DT as BOO
KING6_8_, bookingwee_.BOOKING_WK_HOUSE_ALLOWANCE as BOOKING7_8_, bookingwee_.SECOND_FEATURE_DEDUCTION as SECOND8_8_, boo
kingwee_.TOTAL_SCREENS as TOTAL9_8_, bookingwee_.HOLDOVER_IND as HOLDOVER10_8_, bookingwee_.SPLIT_IND as SPLIT11_8_, boo
kingwee_.TOTAL_SEATS as TOTAL12_8_, bookingwee_.TOTAL_PRINTS as TOTAL13_8_, bookingwee_.AD_AGENCY_IND as AD14_8_, bookin
gwee_.BOX_OFFICE_REPORT_IND as BOX15_8_, bookingwee_.NOTES_TOKEN as NOTES16_8_, bookingwee_.RESOLUTION_WEEK_IND as RESOL
UTION17_8_, bookingwee_.ATTEMPT_TO_HOLD_IND as ATTEMPT18_8_, bookingwee_.MOVEOVER_IND as MOVEOVER19_8_, bookingwee_.BILL
ED_IND as BILLED20_8_, bookingwee_.TICKET_PRICE_ADULT as TICKET21_8_, bookingwee_.TICKET_PRICE_DISCOUNT as TICKET22_8_,
bookingwee_.TICKET_PRICE_OTHER as TICKET23_8_, bookingwee_.CURRENCY_CODE as CURRENCY24_8_, bookingwee_.EXCHANGE_RATE_LO_
REP as EXCHANGE25_8_, bookingwee_.EXCHANGE_RATE_HO_REP as EXCHANGE26_8_, bookingwee_.BOX_OFFICE_CHECK_IND as BOX27_8_, b
ookingwee_.LIC_FEE as LIC28_8_, bookingwee_.DISC_LIC_FEE as DISC29_8_, bookingwee_.EST_FLIGHT_QTY as EST30_8_, bookingwe
e_.ACT_FLIGHT_QTY as ACT31_8_, bookingwee_.UPDATER as UPDATER8_, bookingwee_.SPE_ENTITY_ID as SPE33_8_ from DBO_SOA.BOOK
ING_WEEK bookingwee_ where bookingwee_.BOOKING_ID=? and bookingwee_.BOOKING_WK_NUMBER=?


Debug level Hibernate log excerpt:

I don't know where to get this from.

Appreciate your help on this.

Thanks,
Mahesh.