wood burning stoves
The moose likes Oracle/OAS and the fly likes Regarding duplicate insert problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Regarding duplicate insert problem" Watch "Regarding duplicate insert problem" New topic

Regarding duplicate insert problem

vijay jamadade
Ranch Hand

Joined: May 12, 2008
Posts: 241
Hi Ranchers,

I am inserting the csv data through java in oracle.I want to check the whether the data I am inserting already exists in
table or not in insert query itself. Can I do that.

Because checking through select query before inserting the data is making the application heavy.

thanks in advance.

Regards, Vijay Jamadade.
( Nothing is Impossible.)
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33130

There are two approaches:
1) Do a select first
2) Insert it anyway and fail on duplicate constraint

Which one you choose depends on the likelyhood of a duplicate occurring.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
vijay jamadade
Ranch Hand

Joined: May 12, 2008
Posts: 241
Insert any way does not work here because when exception occurs while inserting records one by one the code goes out of loop afterwards in java. And select first I think making the application heavy as for every insert it needs to be fire a query. How to handle that.
I agree. Here's the link: http://aspose.com/file-tools
subject: Regarding duplicate insert problem
It's not a secret anymore!