|
|
Choosing A Webhost: |
Duplicate key - at a loss: msg#00266db.maxdb
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> |
|---|---|---|
| Previous by Date: | Where is documentation of C Precompiler of MAXDB ?, Gu Lei |
|---|---|
| Next by Date: | RE: Table sizes -a unknown table is the largest, Ajit Aranha |
| Previous by Thread: | Where is documentation of C Precompiler of MAXDB ?, Gu Lei |
| Next by Thread: | RE: Duplicate key - at a loss, Ruth, Brice |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive 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 |
Home
| advertise | OSDir is
an inevitable website.
|