How do I avoid duplicate inserts in YoutubeFeed table?

[rsheyeah hussain]

I am searching n fetching records from the youtubeapi and populating it in the youtubefeed table. I have a "searchkeywords" table and a" youtubefeed" result table.
In all of the three tables, ID is the primary key, and in youtubefeed table, youtubeid is the unique key.

Many 2 Many relationship
1 keyword can have many results.
1 result can be associated with many keywords
KeywordSearchResult is the link table

When I run a search against the Youtube API,


For the keyword in searchKeywords table
1. kitchen appliances,
I get the result with the following youtubefeedID
1. LMTRE
2. MNTER
3. NOPOK

For the keyword in searchKeywords table
2. kitchen crockery,
I get the reseult with the following youtubefeedID
4. LMTRE
5. MNTER
6. NOPOK
How do I avoid duplicate inserts in YoutubeFeed table?
YoutubefeedID is set to be unique.

Question:
Even if I use saveorUpdate() , insert statements get generated even if the reocord already exists.
Do I check in keywordSearchResult table if the particular keyword and youtubefeedID result already exists and then write the insert logic ???

Searchkeywords.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>
	<class name="com.bmb.model.keywords.SearchKeywordsr" table="searchkeywordsr">
		<id name="searchkeywordsrID" column="searchkeywordsrID">
			<generator class="increment" />
		</id>
		<property name="searchkeywordsr">
			<column name="searchkeywordsr" />
		</property>
		<property name="servicerID">
			<column name="servicerID" />
		</property>
		<!-- <set name="youtubefeedresults" table="keywordsearchresult" cascade="all" inverse="true">
			<key column="searchkeywordsrID" />
			<many-to-many column="searchresultID" class="com.bmb.model.youtube.YouTubeFeedMessage" />
		</set>
		 -->
	</class>
</hibernate-mapping>

 

Youtubefeed.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>
	<class name="com.bmb.model.youtube.YouTubeFeedMessage" table="youtubefeed">
		<id name="id" column="ID">
			<generator class="increment" />
		</id>
		<property name="youtubeID">
			<column name="youtubeID" />
		</property>
		<property name="title">
			<column name="title" />
		</property>
		<property name="urlID">
			<column name="urlID" />
		</property>
		<property name="uploadedBy">
			<column name="uploadedBy" />
		</property>
		<property name="desc">
			<column name="description" />
		</property>
		<property name="category">
			<column name="category" />
		</property>
		<property name="webplayer">
			<column name="webplayer" />
		</property>
		<property name="keywords">
			<column name="keywords" />
		</property>
		<property name="thumbnailID">
			<column name="thumbnailID" />
		</property>
		<property name="mediaID">
			<column name="mediaID" />
		</property>
		<property name="thumbnailTime">
			<column name="thumbnailTime" />
		</property>
		<property name="mediaLoc">
			<column name="mediaLoc" />
		</property>
		<property name="mediaType">
			<column name="mediaType" />
		</property>
		<property name="duration">
			<column name="duration" />
		</property>
		<property name="avgRating">
			<column name="avgRating" />
		</property>
		<property name="viewCount">
			<column name="viewCount" />
		</property>
		<property name="geoLatitude">
			<column name="geoLatitude" />
		</property>
		<property name="geoLongitude">
			<column name="geoLongitude" />
		</property>
		<!-- 
		<set name="studentPhoneNumbers" table="STUDENT_PHONE" cascade="all">
			<key column="STUDENT_ID" />
			<many-to-many column="PHONE_ID" unique="true" class="com.vaannila.student.Phone" />
		</set> -->
		
		<set name="youtubefeedmediadetails" table="ytfeed_ytmediadetails" cascade="all">
			<key column="ID" />
			<many-to-many column="mediaID" unique="true" class="com.bmb.model.youtube.YTMediaDetails" />
		</set>
		<set name="keywordsearchresult" table="keywordsearchresult" cascade="all">
			<key column="searchkeywordsrID" />
			<many-to-many column="searchresultID" class="com.bmb.model.keywords.SearchKeywordsr" />
		</set>
		
	</class>
</hibernate-mapping>

Question:
Even if I use saveorUpdate() , insert statements get generated even if the reocord already exists.
Do I check in keywordSearchResult table if the particular keyword and youtubefeedID result already exists and then write the insert logic ???
SQL:

DROP TABLE IF EXISTS `bmb`.`youtubefeed`;
CREATE TABLE  `bmb`.`youtubefeed` (
  `ID` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `youtubeID` varchar(255) NOT NULL,
  `uploadedBy` varchar(255) default NULL,
  `description` text,
  `category` varchar(255) default NULL,
  `webplayer` varchar(255) default NULL,
  `keywords` text,
  `avgRating` varchar(255) default NULL,
  `viewCount` bigint(20) default NULL,
  `geoLatitude` varchar(255) default NULL,
  `geoLongitude` varchar(255) default NULL,
  `status` varchar(45) default NULL,
  `urlID` varchar(255) default NULL,
  `thumbnailID` int(11) default NULL,
  `mediaID` int(11) default NULL,
  `thumbnailTime` varchar(255) default NULL,
  `mediaLoc` varchar(255) default NULL,
  `mediaType` varchar(255) default NULL,
  `duration` varchar(255) default NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `uc_youtubeurlID` (`youtubeID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;









DROP TABLE IF EXISTS `bmb`.`searchkeywordsr`;
CREATE TABLE  `bmb`.`searchkeywordsr` (
  `searchkeywordsrID` int(10) unsigned NOT NULL auto_increment,
  `searchkeywordsr` varchar(50) default NULL,
  `servicerID` varchar(255) default NULL,
  PRIMARY KEY  (`searchkeywordsrID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `bmb`.`keywordsearchresult`;
CREATE TABLE  `bmb`.`keywordsearchresult` (
  `searchkeywordsID` int(10) unsigned NOT NULL default '0',
  `searchresultID` int(10) unsigned NOT NULL default '0',
  `searchkeywordsrID` int(11) default NULL,
  PRIMARY KEY  (`searchkeywordsID`,`searchresultID`),
  KEY `FK7031D82E8D8FE485` (`searchresultID`),
  KEY `FK7031D82E686DC055` (`searchkeywordsrID`),
  CONSTRAINT `FK7031D82E686DC055` FOREIGN KEY (`searchkeywordsrID`) REFERENCES `youtubefeed` (`ID`),
  CONSTRAINT `FK7031D82E8D8FE485` FOREIGN KEY (`searchresultID`) REFERENCES `searchkeywordsr` (`searchkeywordsrID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 24576 kB; (`serviceID`) REFER `bmb/service`(`se';