Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[eclipselink-users] ORA-02261: such unique or primary key already exists in the table 
With output mode 'sql-script', eclipselink generates the following sql
command:

CREATE TABLE CIDSUSER.CID_ADDRESS_VCE#00 (XM_INSTANCE_TGUID VARCHAR2(255)
UNIQUE NOT NULL, ADDR_SUBCODE VARCHAR2(255) NULL, XM_CREATED_BY_PID
VARCHAR2(255) NULL, ADDR_ATTENTION VARCHAR2(255) NULL, STREET VARCHAR2(255)
NULL, ADDR_CODE VARCHAR2(255) NULL, ADD_LAST_NAME VARCHAR2(255) NULL,
XM_INSTANCE_MUT_SEQNR NUMBER(10) NULL, CITY VARCHAR2(255) NULL,
COUNTRY_SUBDIV VARCHAR2(255) NULL, XM_INSTANCE_OCCURRENCE_TYPE VARCHAR2(255)
NULL, POSTAL_CODE VARCHAR2(255) NULL, POBOX VARCHAR2(255) NULL,
NPOSTAL_ADDR_CD VARCHAR2(255) NULL, XM_CREATED_IN_APPLMODULE VARCHAR2(255)
NULL, ADD_FIRST_NAME VARCHAR2(255) NULL, XM_INIT_CREATED_IN_BUID
VARCHAR2(255) NULL, DISTRICT VARCHAR2(255) NULL, ADDR_SALUTATION_CD
VARCHAR2(255) NULL, XM_INSTANCE_LIFECYCLE_STATUS VARCHAR2(255) NULL,
ADDR_CARE_OF VARCHAR2(255) NULL, POSTAL_ADDR_CODE VARCHAR2(255) NULL,
NPOSTAL_ADDR VARCHAR2(255) NULL, CARD_STAMP_LINE VARCHAR2(255) NULL,
XM_CREATED_AT_TSMP TIMESTAMP(6), ADDR_LINE5 VARCHAR2(255) NULL, ADDR_LINE4
VARCHAR2(255) NULL, ADDR_LINE3 VARCHAR2(255) NULL, ADDR_LINE2 VARCHAR2(255)
NULL, ADDR_LINE1 VARCHAR2(255) NULL, SHORT_ADDR_LINE2 VARCHAR2(255) NULL,
SHORT_ADDR_LINE1 VARCHAR2(255) NULL, INT_AREA_CD VARCHAR2(255) NULL,
ADDR_NOTE VARCHAR2(255) NULL, ALTER_SALUTATION VARCHAR2(255) NULL,
IND_TITLE_CD VARCHAR2(255) NULL, HOUSE_ID VARCHAR2(255) NULL,
POSTAL_COUNTRY_CODE VARCHAR2(255) NULL, PRIMARY KEY (XM_INSTANCE_TGUID))

The execution fails with the ORA-02261 error message. If I remove the
keyword unique from the command it works.
http://www.nabble.com/file/p25505144/persistence.xml persistence.xml 

The annotated class (snippet):

@SuppressWarnings("serial")
@Entity
@Table(name = "CID_ADDRESS_VCE#00", schema = "CIDSUSER")
public class Address implements Serializable {

	public Address() {
	}

	/**
	 * primary key
	 */
	@Id
	@GeneratedValue(generator = "uuid-string")
	@Column(name = "XM_INSTANCE_TGUID", unique = true, columnDefinition = "")
	private String uid = null;
...

Thanks 4 help
-- 
View this message in context: http://www.nabble.com/ORA-02261%3A-such-unique-or-primary-key-already-exists-in-the-table-tp25505144p25505144.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.

Back to the top