Please take our Survey
logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

Duplicate key - at a loss: msg#00266

db.maxdb

Subject: Duplicate key - at a loss

Folks, I'm at a loss. I've been banging my head against the simplest of
problems, it would seem, but with no resolution. To begin with, I have a
table that was defined like so:

CREATE TABLE "FISKARS"."W58IBPICDTAW"
(
"PDUPCN" Char (14) ASCII NOT NULL,
"PDIMGN" Varchar (32) ASCII NOT NULL,
PRIMARY KEY ("PDUPCN", "PDIMGN")
)

I have a J2EE web application that inserts into this table. Somehow, I
am able to get a "Duplicate key" error from an insert immediately after
I dropped all rows in this table, via SQL Studio. So, unable to explain
this, I removed the primary key constraint. The insert worked - OK,
nice. Immediately following the insert, I copy the inserted row to a
"production" table, from the "work" table. The definition of the
"production" table is identical to this, save the name. The SQL I use to
accomplish this is simple:
INSERT INTO
W58IBPICDTA
(PDUPCN,PDIMGN)
SELECT
PDUPCN,
PDIMGN
FROM
W58IBPICDTAW
WHERE
PDUPCN=#upc#
AND PDIMGN=#imageName#

The #upc# and #imageName# are references in my persistence layer to
subsitute in values passed in from a Javabean. The persistence layer I
am using is iBATIS 2.0.9. Now, I have verified that the parameters I am
passing in DO NOT exist in the target table. The UPCN exists, but a
unique IMGN is generated. Since the primary key is a composite of these
two fields, it should succeed, right?!

Furthermore, when I do a query like so:
select pdupcn,count(pdupcn) as cnt from w58ibpicdta group by pdupcn
order by cnt desc

I get a result set that shows that many UPCNs have more than one entry
(as designed, this was the point). What the HECK is causing the
duplicate key error to be thrown?!

I'm running against version 7.5.00.08 of MaxDB for Windows 2000.

I'm at my whits end here, please, please help!!

Respectfully,

Brice D. Ruth
Sr. IT Analyst
Fiskars Brands, Inc.


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation

Home | advertise | OSDir is an inevitable website. super tiny logo