ora-00001_开发者

ORA-00001: unique constraint (DEV.X_PK) violated

I have a java code that sends data to a web service, and a portlet that uses that data. Data sent by java agent gets placed in TMP table, and merge procedure merges it into MAIN table used by portle[详细]

2023-03-28 04:46 分类：问答

Problem with the trigger created(Fro primary key sequence)

I have created a sequence starting with 1 with no max value I have created a trigger for primary key insertion automatically which is below[详细]

2023-03-07 10:17 分类：问答

What is the proper way to catch and handle ORA-00001 SQLException with JDBC?

I\'m creating a simple form that stores entered data in an extremely simple Oracle database table via a Java Servlet using JDBC.That table is using the email address as a primary key.If a user submits[详细]

2023-02-26 19:13 分类：问答

Force Hibernate to issue DELETEs prior to INSERTs to avoid unique constraint violations?

Background: http://jeffkemponoracle.com/2011/03/11/handling-unique-constraint-violations-by-hibernate[详细]

2023-02-15 23:53 分类：问答

Oracle unique constraint error when inserting

INSERT INTO SS_ALERT_EVENTS (ALERT_ID, EVENT_ID, TIME_DURATION, ALERT_EVENT_EFFECT, DATASET_ASSIGN_RULE, KEY_FIELDS_ASSIGN_RULE, SIDE, ALERT_VALIDATION_RULE, UNIQUE_ID ) VALUES ( \'test1\', 7 ,0, 1 ,N[详细]

2023-02-15 12:36 分类：问答

Seam / Hibernate - getting ORA message text

try { if (schId != null) { log.info(\">>&开发者_开发问答gt; save\"); schedule = em.merge(schedule);[详细]

2023-02-01 05:14 分类：问答

Duplicate id using JPA2 and testing

I\'m a bit confused right now :-S I\'m working on a project that uses JPA2, Spring 3.0.5, Hibernate 3.6.0 Final. We have the following code (only relevant classes)[详细]

2023-01-30 17:07 分类：问答

In Oracle, can I do an "insert or update values into TABLE"

I have 开发者_StackOverflow中文版a table with two number columns, and a unique constraint over them both. I would like to insert a new pair of values UNLESS the pair already exists. What is the simple[详细]

2023-01-19 10:05 分类：问答

How to find the offending insertion from a BatchUpdateException?

When I have a BatchUpdateException as the result of a unique constraint violation is there a way for me to determine which record in the batch insert is in violation?For example let\'s say I\'m perfor[详细]

2023-01-15 08:21 分类：问答

1->1/1->N relationship in Oracle?

I have 2 tables T_Foo foo_id fooHeader T_FooBodys foo_id foobody foo_id are primary key for both of their respective tables. In second table, foo_id is foreign key to first table. I generate the P[详细]

2023-01-14 08:13 分类：问答