Auto Generator in composite key

[Sakthi Ramasamy]

Hi,

Could you please let me know how to make the CAMPAIGN_ID in the composite key to be auto generated [Sequence starting from 1000 and thereby incremented by 1]. I have a MySQL query for Sequence generation.

The problem is, whenever i create a campaign, after 2, its getting updated instead of insert. Is it because of hbm files or is it because of some session updation in java code.

I couldn't come to conclusion why it is behaving so.

 <?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>

	<class name="com.oem.dlms.campaign.dto.CampaignDetails"
		table="CAMPAIGNS">
		<composite-id name="campaignKey"
			class="com.oem.dlms.campaign.dto.CampaignKey">
			<key-property name="campaignId" column="CAMPAIGN_ID"
				type="int" />
			<key-property name="version" column="VERSION_NO" type="int" />
		</composite-id>

		<property name="campaignName" column="NAME" />
		<property name="campaignDesc" column="DESCRIPTION" />
		<property name="startDate" column="START_DATE" />
		<property name="endDate" column="END_DATE" />
		<property name="estimatedLeads" column="EST_LEAD_COUNT" />
		<property name="campStatus" column="CAMPAIGN_STATUS_E" />
		<property name="createdBy" column="CREATED_BY" />
		<property name="approverId" column="APPROVER_ID" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="deleted" column="DELETED" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="rejComments" column="REJ_COMMENTS" />
		<property name="countryId" column="COUNTRY_ID" />
		<property name="campaignTypee" column="CAMPAIGN_TYPE_E" />
		<property name="taskOwnerId" column="TASK_OWNER_ID" />
		<property name="campaignNo" column="CAMPAIGN_NUMBER" />
		<property name="creatorByName"
			formula="(select USER_INFORMATION.FIRST_NAME from USER_INFORMATION where USER_INFORMATION.USER_ID = CREATED_BY)" />
		<property name="campaignStatusName"
			formula="(select CAMPAIGN_STATUS_ENUM.NAME from CAMPAIGN_STATUS_ENUM where CAMPAIGN_STATUS_ENUM.ID = CAMPAIGN_STATUS_E)" />
		<property name="campaignTypeName"
			formula="(select CAMPAIGN_TYPE_ENUM.NAME from CAMPAIGN_TYPE_ENUM where CAMPAIGN_TYPE_ENUM.ID = CAMPAIGN_TYPE_E)" />

		<bag name="model" cascade="all" lazy="false" inverse="true"
			table="CAMPAIGN_MODELS">
			<key>
				<column name="CAMPAIGN_ID" />
				<column name="VERSION_NO" />
			</key>
			<one-to-many
				class="com.oem.dlms.campaign.dto.selectedModel" />
		</bag>

		<bag name="region" cascade="all" lazy="false" inverse="true"
			table="CAMPAIGN_REGION_MAP">
			<key>
				<column name="CAMPAIGN_ID" />
				<column name="VERSION_NO" />
			</key>
			<one-to-many
				class="com.oem.dlms.campaign.dto.selectedRegion" />
		</bag>

		<bag name="welcomeClosing" cascade="all" lazy="false"
			inverse="true" table="CAMPAIGN_DETAILS">
			<key>
				<column name="CAMPAIGN_ID" />
				<column name="VERSION_NO" />
			</key>
			<one-to-many
				class="com.oem.dlms.campaign.dto.WelcomeClosingDetails" />
		</bag>

		<bag name="image" cascade="all" lazy="false" inverse="true">
			<key>
				<column name="CAMPAIGN_ID" />
				<column name="VERSION_NO" />
			</key>
			<one-to-many class="com.oem.dlms.campaign.dto.Image" />
		</bag>
		<bag name="questions" cascade="all" lazy="false" inverse="true"
			table="CAMPAIGN_QUESTIONS">
			<key>
				<column name="CAMPAIGN_ID" />
				<column name="VERSION_NO" />
			</key>
			<one-to-many
				class="com.oem.dlms.campaign.dto.CampaignQuestion" />
		</bag>
		<bag name="styles" cascade="all" lazy="false" inverse="true"
			table="CAMPAIGN_BG_STYLES">
			<key>
				<column name="CAMPAIGN_ID" />
				<column name="VERSION_NO" />
			</key>
			<one-to-many
				class="com.oem.dlms.campaign.dto.StyleSheetTemplate" />
		</bag>
		<bag name="leads" cascade="none" lazy="true" inverse="true"
			table="LEAD_INFO">
			<key>
				<column name="CAMPAIGN_ID" />
				<column name="VERSION_NO" />
			</key>
			<one-to-many class="com.oem.dlms.common.dto.LeadInfo" />
		</bag>
		<bag name="duplicateleads" cascade="none" lazy="true" inverse="true"
			table="LEAD_INFO">
			<key>
				<column name="CAMPAIGN_ID" />
				<column name="VERSION_NO" />
			</key>
			<one-to-many class="com.oem.dlms.common.dto.LeadInfo" />
		</bag>
		<bag name="templates" cascade="all" lazy="false" inverse="true"
			table="CAMPAIGN_TEMPLATES">
			<key>
				<column name="CAMPAIGN_ID" />
				<column name="VERSION_NO" />
			</key>
			<one-to-many
				class="com.oem.dlms.campaign.dto.CampaignTemplates" />
		</bag>
	</class>

	<class name="com.oem.dlms.campaign.dto.selectedModel"
		table="CAMPAIGN_MODELS">

		<id name="campModelId" column="CAMP_MODEL_ID" type="int">
			<generator class="increment" />
		</id>

		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="modelId" column="MODEL_ID" />

		<many-to-one name="campdetailsreference" cascade="none">
			<column name="CAMPAIGN_ID" />
			<column name="VERSION_NO" />
		</many-to-one>

		<bag name="type" cascade="all" lazy="false">
			<key column="CAMP_MODEL_ID" not-null="true" />
			<one-to-many class="com.oem.dlms.campaign.dto.selectedType" />
		</bag>

		<many-to-one name="model" cascade="none" column="MODEL_ID"
			insert="false" update="false" class="com.oem.dlms.common.dto.Model"
			lazy="false" />
	</class>

	<class name="com.oem.dlms.campaign.dto.selectedType"
		table="CAMPAIGN_MODEL_TYPES">

		<id name="campTypeId" column="CAMP_TYPE_ID" type="int">
			<generator class="increment" />
		</id>

		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="typeId" column="TYPE_ID" />
		<many-to-one name="modelreference" column="CAMP_MODEL_ID"
			not-null="true" insert="false" update="false" cascade="none" />

		<bag name="option" cascade="all" lazy="false">
			<key column="CAMP_TYPE_ID" not-null="true" />
			<one-to-many
				class="com.oem.dlms.campaign.dto.selectedOption" />
		</bag>
		<bag name="color" cascade="all" lazy="false">
			<key column="CAMP_TYPE_ID" not-null="true" />
			<one-to-many
				class="com.oem.dlms.campaign.dto.selectedColor" />
		</bag>
		<many-to-one name="type" cascade="none" column="TYPE_ID"
			insert="false" update="false" class="com.oem.dlms.common.dto.Type"
			lazy="false" />
	</class>


	<class name="com.oem.dlms.campaign.dto.selectedOption"
		table="CAMPAIGN_TYPE_OPTIONS">

		<id name="campOptionId" column="CAMP_OPTION_ID" type="int">
			<generator class="increment" />
		</id>

		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="optionId" column="OPTION_ID" />
		<many-to-one name="typereference" insert="false" update="false"
			cascade="none">
			<column name="CAMP_TYPE_ID" not-null="true" />
		</many-to-one>
		<many-to-one name="option" cascade="none" column="OPTION_ID"
			insert="false" update="false" class="com.oem.dlms.common.dto.Option"
			lazy="false" />
	</class>


	<class name="com.oem.dlms.campaign.dto.selectedColor"
		table="CAMPAIGN_TYPE_COLORS">

		<id name="campColorId" column="CAMP_COLOUR_ID" type="int">
			<generator class="increment" />
		</id>

		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="colorId" column="COLOUR_ID" />
		<many-to-one name="typereference" insert="false" update="false"
			cascade="none">
			<column name="CAMP_TYPE_ID" not-null="true" />
		</many-to-one>
		<many-to-one name="color" cascade="none" column="COLOUR_ID"
			insert="false" update="false" class="com.oem.dlms.common.dto.Color"
			lazy="false" />
	</class>

	<class name="com.oem.dlms.campaign.dto.WelcomeClosingDetails"
		table="CAMPAIGN_DETAILS">
		<id name="campDetId" column="CAMP_DET_ID" type="int">
			<generator class="increment" />
		</id>
		<property name="headerContent" column="HEADER_CONTENT" />
		<property name="footerContent" column="FOOTER_CONTENT" />
		<property name="urlLink" column="URL_LINK" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="createdBy" column="CREATED_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="campaignPagee" column="CAMPAIGN_PAGE_E" />
		<many-to-one name="campdetailsreference">
			<column name="CAMPAIGN_ID" not-null="true" />
			<column name="VERSION_NO" not-null="true" />
		</many-to-one>
	</class>


	<class name="com.oem.dlms.campaign.dto.Image"
		table="CAMPAIGN_IMAGES">
		<id name="imageId" column="IMAGE_ID" type="int">
			<generator class="increment" />
		</id>
		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="imageContentAsBlob" column="IMAGE_CONTENT" />
		<property name="imageName" column="IMAGE_NAME" />
		<property name="imageExt" column="IMAGE_EXTENSION" />
		<property name="imageTypee" column="CAMPAIGN_IMAGE_TYPE_E" />
		<many-to-one name="campdetailsreference">
			<column name="CAMPAIGN_ID" not-null="true" />
			<column name="VERSION_NO" not-null="true" />
		</many-to-one>
	</class>



	<class name="com.oem.dlms.campaign.dto.selectedRegion"
		table="CAMPAIGN_REGION_MAP">

		<id name="campRegionId" column="CAMP_REG_ID" type="int">
			<generator class="increment" />
		</id>
		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="regionId" column="REGION_ID" />

		<many-to-one name="campdetailsreference" cascade="none">
			<column name="CAMPAIGN_ID" />
			<column name="VERSION_NO" />
		</many-to-one>

		<bag name="state" cascade="all" lazy="false">
			<key column="CAMP_REG_ID" not-null="true" />
			<one-to-many
				class="com.oem.dlms.campaign.dto.selectedState" />
		</bag>
		<many-to-one name="region" cascade="none" column="REGION_ID"
			insert="false" update="false" class="com.oem.dlms.common.dto.Region"
			lazy="false" />
	</class>


	<class name="com.oem.dlms.campaign.dto.selectedState"
		table="CAMPAIGN_REGION_STATE_MAP">

		<id name="campStateId" column="CAMP_STATE_ID" type="int">
			<generator class="increment" />
		</id>
		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="stateId" column="STATE_ID" />
		<many-to-one name="regionreference" column="CAMP_REG_ID"
			not-null="true" insert="false" update="false" cascade="none" />
		<bag name="city" cascade="all" lazy="false">
			<key column="CAMP_STATE_ID" not-null="true" />
			<one-to-many class="com.oem.dlms.campaign.dto.selectedCity" />
		</bag>
		<many-to-one name="state" cascade="none" column="STATE_ID"
			insert="false" update="false" class="com.oem.dlms.common.dto.State"
			lazy="false" />
	</class>


	<class name="com.oem.dlms.campaign.dto.selectedCity"
		table="CAMPAIGN_STATE_CITY_MAP">

		<id name="campCityId" column="CAMP_CITY_ID" type="int">
			<generator class="increment" />
		</id>

		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="cityId" column="CITY_ID" />
		<many-to-one name="stateReference" column="CAMP_STATE_ID"
			not-null="true" insert="false" update="false" cascade="none" />
		<many-to-one name="city" cascade="none" column="CITY_ID"
			insert="false" update="false" class="com.oem.dlms.common.dto.City"
			lazy="false" />
	</class>


	<class name="com.oem.dlms.campaign.dto.CampaignQuestion"
		table="CAMPAIGN_QUESTIONS">
		<id name="campQuestionId" column="CAMP_QUES_ID" type="int">
			<generator class="increment" />
		</id>
		<property name="questionId" column="QUESTION_ID" />
		<property name="type" column="QUESTION_TYPE_E" />
		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="mandatory" column="ISMANDATORY" />
		<property name="questionOrder" column="ORDER_NO" />

		<many-to-one name="campdetailsreference">
			<column name="CAMPAIGN_ID" />
			<column name="VERSION_NO" />
		</many-to-one>

		<many-to-one name="questionnaire" cascade="none"
			column="QUESTION_ID" insert="false" update="false"
			class="com.oem.dlms.campaign.dto.Questionnaire" lazy="false" />

	</class>



	<class name="com.oem.dlms.campaign.dto.Questionnaire"
		table="QUESTIONNAIRES">
		<id name="questionId" column="QUESTION_ID" type="int">
			<generator class="increment" />
		</id>

		<property name="description" column="DESCRIPTION" />
		<property name="validationComments"
			column="VALIDATION_COMMENTS" />
		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="scale" column="SCALE" />
		<property name="rowCount" column="ROW_COUNT" />
		<property name="columnCount" column="COLUMN_COUNT" />
		<property name="multipleSelection" column="MULTIPLE_SELECTION" />
		<property name="referenceName" column="REFERENCE_NAME" />
		<property name="isAllowSpecialChars"
			column="IS_ALLOW_SPL_CHARS" />
		<property name="rejComments" column="REJ_COMMENTS" />
		<property name="approverId" column="APPROVER_ID" />
		<property name="taskOwnerId" column="TASK_OWNER_ID" />

		<property name="questionTypeE" column="QUESTION_TYPE_E" />
		<property name="dataTypeE" column="DATA_TYPE_E" />
		<property name="questionStatusE" column="QUESTION_STATUS_E" />
		<property name="answerFormatId" column="ANSWER_FORMAT_E" />
		<property name="isMandatory" column="ISMANDATORY"/>

		<bag name="answers" cascade="all" lazy="false">
			<key column="QUESTION_ID" not-null="true" />
			<one-to-many class="com.oem.dlms.campaign.dto.Answer" />
		</bag>


		<many-to-one name="answerFormatEnum" cascade="none"
			column="ANSWER_FORMAT_E" insert="false" update="false"
			class="com.oem.dlms.campaign.dto.AnswerFormatEnum" lazy="false" />

		<many-to-one name="questionFormat" column="QUESTION_TYPE_E"
			insert="false" update="false"
			class="com.oem.dlms.admin.dto.QuestionFormat" not-null="true"
			cascade="none" />

		<many-to-one name="questionStatus" column="QUESTION_STATUS_E"
			insert="false" update="false"
			class="com.oem.dlms.admin.dto.QuestionStatus" not-null="true"
			cascade="none" />

		<many-to-one name="dataTypeObj" column="DATA_TYPE_E"
			insert="false" update="false" class="com.oem.dlms.admin.dto.DataType"
			not-null="true" lazy="false" />

	</class>

	<class name="com.oem.dlms.admin.dto.DataType"
		table="DATA_TYPE_ENUM">
		<id name="id" column="ID" />
		<property name="name" column="NAME" />
	</class>

	<class name="com.oem.dlms.campaign.dto.CampaignTypeEnum"
		table="CAMPAIGN_TYPE_ENUM">
		<id name="id" column="ID" />
		<property name="name" column="NAME" />
		<bag name="campaignTemplates" cascade="none" lazy="false"
			inverse="true">
			<key column="TEMPLATE_TYPE_E" not-null="false" />
			<one-to-many
				class="com.oem.dlms.campaign.dto.CampaignTemplates" />
		</bag>

	</class>

	<class name="com.oem.dlms.campaign.dto.CampaignStatusEnum"
		table="CAMPAIGN_STATUS_ENUM">
		<id name="id" column="ID" />
		<property name="name" column="NAME" />
	</class>

	<class name="com.oem.dlms.campaign.dto.AnswerFormatEnum"
		table="ANSWER_FORMAT_ENUM">
		<id name="Id" column="ID" type="int" />

		<property name="answerFormatName" column="NAME" insert="false"
			update="false" />

		<bag name="questionnaire" cascade="none" lazy="false"
			inverse="true">
			<key column="ANSWER_FORMAT_E" not-null="false" />
			<one-to-many
				class="com.oem.dlms.campaign.dto.Questionnaire" />
		</bag>
	</class>

	<class name="com.oem.dlms.campaign.dto.Answer" table="ANSWERS">
		<id name="answerId" column="ANSWER_ID" type="int">
			<generator class="increment" />
		</id>

		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModBy" column="LAST_MOD_BY" />
		<property name="lastModDate" column="LAST_MOD_DATE" />
		<property name="value" column="VALUE" />
		<property name="isDefault" column="IS_DEFAULT" />
		<property name="orderNo" column="ORDER_NO" />

		<many-to-one name="questionnaire" insert="false" update="false"
			cascade="all">
			<column name="QUESTION_ID" not-null="true" />
		</many-to-one>

	</class>

	<class name="com.oem.dlms.campaign.dto.StyleSheetTemplate"
		table="CAMPAIGN_BG_STYLES">
		<id name="styleId" column="STYLE_ID" type="int">
			<generator class="increment" />
		</id>

		<property name="fileName" column="FILE_NAME" />
		<property name="filePath" column="FILE_PATH" />
		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModifiedBy" column="LAST_MOD_BY" />
		<property name="lastModifiedDate" column="LAST_MOD_DATE" />
		<property name="fileExt" column="FILE_EXTENSION" />
		<property name="styleTypee" column="STYLE_TYPE_E" />

		<many-to-one name="campdetailsreference">
			<column name="CAMPAIGN_ID" not-null="true" />
			<column name="VERSION_NO" not-null="true" />
		</many-to-one>
	</class>

	<class name="com.oem.dlms.campaign.dto.CampaignTemplates"
		table="CAMPAIGN_TEMPLATES">
		<id name="templateId" column="TEMPLATE_ID">
			<generator class="increment" />
		</id>
		<property name="fileName" column="FILE_NAME" />
		<property name="filePath" column="FILE_PATH" />
		<property name="createdBy" column="CREATED_BY" />
		<property name="createdDate" column="CREATED_DATE" />
		<property name="lastModBy" column="LAST_MOD_BY" />
		<property name="lastModDate" column="LAST_MOD_DATE" />
		<property name="fileExtension" column="FILE_EXTENSION" />
		<property name="templateTypeE" column="TEMPLATE_TYPE_E" />
		<property name="creatorByName"
			formula="(select USER_INFORMATION.FIRST_NAME from USER_INFORMATION where USER_INFORMATION.USER_ID = CREATED_BY)" />

		<many-to-one name="campaign">
			<column name="CAMPAIGN_ID" />
			<column name="VERSION_NO" />
		</many-to-one>

		<many-to-one name="campaignTypeEnum" cascade="none"
			column="TEMPLATE_TYPE_E" insert="false" update="false"
			class="com.oem.dlms.campaign.dto.CampaignTypeEnum" lazy="false" />
	</class>
</hibernate-mapping>  

Thanks in advance for your time.