DataNucleus JIRA is now in read-only mode. Raise any new issues in GitHub against the plugin that it applies to. DataNucleus JIRA will remain for the foreseeable future but will eventually be discontinued
Issue Details (XML | Word | Printable)

Type: Bug Bug
Status: Closed Closed
Resolution: Cannot Reproduce
Priority: Testcase Required Testcase Required
Assignee: Unassigned
Reporter: Francis ANDRE
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

DataIntegrityViolationException & java.sql.BatchUpdateException on a invalid/duplicate INSERT

Created: 30/Jul/10 04:36 PM   Updated: 07/Mar/11 05:37 PM   Resolved: 24/Feb/11 05:31 PM
Component/s: None
Affects Version/s: 2.2.0.m1
Fix Version/s: None

File Attachments: 1. Text File insert.log (147 kB)
2. File SimpleFormController.rar (95 kB)

Environment: WXP SP3, Sun Java SDK 1.6.0_20, Postgres 8.4.4, Spring 3.0.3-RELEASE

Datastore: PostgreSQL
Severity: Proof of Concept

 Description  « Hide
Hi Andy

I got an supposed invalid/duplicate INSERT on the persistence of a PC that has a 1-1 relationship. All files are in attachmement with a full Eclipse project. The control flow is:

1/ userForm.jsp displays a form where radiobutton, selectbox values are coming from an Enum, and 2 Daos -- CountryDao and CommunityDao -- (see UserController.referenceData()).

2/ On return from the submit action, the UserController store/makePersistent the PC User where Country has been filled by the underlying Spring, then the invalid INSERT into Country appears.

To reproduce the problem, just rebuild the Eclipse SimpleFormController, upload the 2 tables COUNTRY and COMMUNITY with resources/country.sql and resources/community.sql and launch a browser on http://localhost:8080/SimpleFormController/userRegistration.htm. Fill all fields and press the "submit" button.

Sort Order: Ascending order - Click to sort in descending order
Francis ANDRE added a comment - 30/Jul/10 04:40 PM
insert.log : the full log with level=DEBUG
SimpleFormController.rar: the full Eclipse project

Andy Jefferson added a comment - 20/Sep/10 11:06 AM
No time to process testcases that aren't in the simple format defined in the docs; please reformat to that when you have time.

Andy Jefferson added a comment - 24/Feb/11 05:31 PM
No valid testcase so no way of seeing something. Somebody noticed (and fixed) a possible deadlock condition on JDBC statements but no idea if that is your situation, but then without demonstrating something there is nothing to say