PK problem with Postgre

From: WONDER (mmmmmmmmm5..eb.de)
Date: Thu Apr 20 2006 - 09:43:48 EDT

Next message: Bryan Lewis: "Re: joint prefetching narrows result set"

Previous message: Andrus Adamchik: "Re: Bug in cayenne 1.2B1 and 1.2B2"
Next in thread: Bryan Lewis: "Re: PK problem with Postgre"
Reply: Bryan Lewis: "Re: PK problem with Postgre"
Reply: Lindsay Steele: "Re: PK problem with Postgre"
Reply: Gentry, Michael $Contractor$: "RE: PK problem with Postgre"
Reply: Gentry, Michael $Contractor$: "RE: PK problem with Postgre"
Reply: Gentry, Michael $Contractor$: "RE: PK problem with Postgre"
Reply: Jeff de Vries: "Re: PK problem with Postgre"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

I have problem with PostGreSQL ver 8.1.3 using JDBC ver 8.2dev-501 JDBC 3
and Cayenne 1.2.B2.

I use the Default Strategy to create the PKs using Cayenne. in the DB, i
created the SEQ : pk_TableName. like pk_image for Table image.

Sometimes I get the following error and sometimes it just work.
Till now, I coulding find the logic behind.

Anybody can help?
Thanks.

-------------------------------------------------
Priority : INFO

Class.Method(line):
org.objectstyle.cayenne.access.QueryLogger.logQueryError(QueryLogger.java:43
9)

Message: *** error.

org.postgresql.util.PSQLException: ERROR: duplicate key violates unique
constraint "image_pk"

at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorI
mpl.java:1513)

at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.ja
va:1298)

at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:349)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statem
ent.java:2559)

at
org.objectstyle.cayenne.access.jdbc.BatchAction.runAsBatch(BatchAction.java:
164)

at
org.objectstyle.cayenne.access.jdbc.BatchAction.performAction(BatchAction.ja
va:114)

at
org.objectstyle.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAct
ion.java:95)

at org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:309)

at
org.objectstyle.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFl
ushAction.java:255)

at
org.objectstyle.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAc
tion.java:177)

at
org.objectstyle.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:827)

at
org.objectstyle.cayenne.access.DataDomain$2.transform(DataDomain.java:798)

at
org.objectstyle.cayenne.access.DataDomain.runInTransaction(DataDomain.java:8
53)

at org.objectstyle.cayenne.access.DataDomain.onSync(DataDomain.java:795)

at
org.objectstyle.cayenne.access.DataContext.flushToParent(DataContext.java:12
17)

at
org.objectstyle.cayenne.access.DataContext.commitChanges(DataContext.java:11
21)

at
de.mrer.base.CayenneBaseComponent.commitChanges(CayenneBaseComponent.java:65
)

at ImageEditPage.uploadFile(ImageEditPage.java:99)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)

at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at
KeyValueCodingProtectedAccessor.methodValue(KeyValueCodingProtectedAccessor.
java:54)

at
com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKe
yValueCoding.java:1160)

at
com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey
(NSKeyValueCoding.java:1268)

at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1539)

at
com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCod
ing.java:498)

at
com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.va
lueForKeyPath(NSKeyValueCodingAdditions.java:212)

at
com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1600)

at
com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOK
eyValueAssociation.java:46)

at
com.webobjects.appserver._private.WOSubmitButton.invokeAction(WOSubmitButton
.java:59)

at
com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODyna
micGroup.java:101)

at
com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup
.java:110)

at
com.webobjects.appserver._private.WOComponentContent.invokeAction(WOComponen
tContent.java:31)

at
com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODyna
micGroup.java:101)

at
com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup
.java:110)

at
com.webobjects.appserver._private.WOComponentContent.invokeAction(WOComponen
tContent.java:31)

at
com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODyna
micGroup.java:101)

at
com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup
.java:110)

at
com.webobjects.appserver._private.WOConditional.invokeAction(WOConditional.j
ava:55)

at
com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODyna
micGroup.java:101)

at
com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup
.java:110)

at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:945)

at
com.webobjects.appserver._private.WOComponentReference.invokeAction(WOCompon
entReference.java:104)

at
com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODyna
micGroup.java:101)

at
com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup
.java:110)

at com.webobjects.appserver._private.WOForm.invokeAction(WOForm.java:82)