Problem while inserting into the table

[Praveen Chadichal]

Hi,
I have something teadious issue, i donno how is this happening, The problem is i have overall 4 tables(say A,B,C,D) in which i need to manipulate the data. The thing is i only fetch data from table A insert into table B, then fetch data from B and insert into table C & D. The issue what am facing is that a UPDATE query is getting fired for the table A which actually should not happen atall since i only fetch from this table. Its something that breaking my head. M unable to get why is this happening. Can any one help me on this. I am using hibernate to do this, is it that am missing anything in the hibernate configuration. have anyone came across this issue. quick help is deeply appreciated!
Thanks in advance.

[Paul Sturrock]

Can you show us your code?

[Praveen Chadichal]

Here in the below code my A table is "ApplicationEventInstance" & the table B is "EbizAppEvent" into which it is inserted.

List<ApplicationEventInstance> eventInstanceList =
			this.applicationEventInstanceDAO.getEventInstanceForWeekRange(
				startDate, endDate );
		LOGGER.debug( "The List size of Event Instance table="
			+ eventInstanceList.size() );
		if ( !eventInstanceList.isEmpty() )
		{
			List<EbizAppEvent> rmAppEventList =
				convertEventInstanceToAppEvent(
					eventInstanceList, fiscalWeek, fiscalYear );
			this.appEventDAO.saveOrUpdateAppEvent( rmAppEventList );
			LOGGER
				.info( "Copied APPLICATION_EVENT_INSTANCE table to RM_APP_EVENT table" );
		}

The "convertEventInstanceToAppEvent" method will convert the ApplicationEventInstance pojo to EbizAppEvent pojo object..... here its as below:

private List<EbizAppEvent> convertEventInstanceToAppEvent ( List<ApplicationEventInstance> eventInstanceList,
		Integer fiscalWeek,
		Integer fiscalYear )
	{
		List<EbizAppEvent> appEventList = new ArrayList<EbizAppEvent>();
		LOGGER
			.info( "The number of records to be converted from Event Instance to AppEvent Type="
				+ eventInstanceList.size() );
		
		for ( ApplicationEventInstance eventInstance : eventInstanceList )
		{
			EbizAppEvent rmAppEvent = new EbizAppEvent();
			rmAppEvent.setRmCustAttribute( null );
			rmAppEvent.setApplicationName( eventInstance.getApplicationName() );
			rmAppEvent.setActionName( eventInstance.getActionName() );
			rmAppEvent.setUserId( eventInstance.getUserId() );
			rmAppEvent.setUserTypeId( eventInstance.getUserTypeId() );
			rmAppEvent.setEventTmstmp( eventInstance.getEventTmstmp() );
			rmAppEvent.setEventDetailXml( eventInstance.getEventDetailXml() );
			rmAppEvent.setFiscalWeek( fiscalWeek );
			rmAppEvent.setFiscalYear( fiscalYear );
			RMEvent eventXml = ( RMEvent ) eventInstance.getEventDetailXml();
			rmAppEvent.setGfsCustomerId( eventXml.getPricingCustomerId() );
			rmAppEvent
				.setGfsCustomerTypeCode( RMConstants.CUSTOMER_TYPE_CODE_ZERO );
			rmAppEvent.setLastUpdateTmstmp( new Timestamp( System
				.currentTimeMillis() ) );
			rmAppEvent.setLastUpdateUserId( "BatchUser" );
			
			appEventList.add( rmAppEvent );
		}
		LOGGER
			.info( "List size after converting from Event Instance to App Event="
				+ appEventList.size() );
		return appEventList;
	}

Can you help me out on this please ?