Issue Details (XML | Word | Printable)

Key: NUCRDBMS-444
Type: Bug Bug
Status: Closed Closed
Resolution: Cannot Reproduce
Priority: No Testcase No Testcase
Assignee: Unassigned
Reporter: Francis ANDRE
Votes: 0
Watchers: 0
Operations

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.






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

Francis ANDRE made changes - 30/Jul/10 04:40 PM
Field Original Value New Value
Attachment insert.log [ 11232 ]
Attachment SimpleFormController.rar [ 11233 ]
Andy Jefferson made changes - 20/Sep/10 11:06 AM
Project DataNucleus Access Platform [ 10140 ] DataNucleus RDBMS [ 10144 ]
Key NUCACCESS-72 NUCRDBMS-444
Affects Version/s 2.2.0.m1 [ 11000 ]
Affects Version/s 2.2.0.m1 [ 10995 ]
Component/s Software [ 10242 ]
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 made changes - 06/Oct/10 11:11 AM
Priority Major [ 3 ] Incomplete [ 6 ]
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

Andy Jefferson made changes - 24/Feb/11 05:31 PM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Cannot Reproduce [ 5 ]
Andy Jefferson made changes - 07/Mar/11 05:37 PM
Status Resolved [ 5 ] Closed [ 6 ]