cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "WONDER" <mmmmmmmm...@web.de>
Subject PK problem with Postgre
Date Thu, 20 Apr 2006 13:43:48 GMT
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.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)

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.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.WOComponent.invokeAction(WOComponent.java:945)

at com.webobjects.appserver.WOSession.invokeAction(WOSession.java:1168)

at
com.webobjects.appserver.WOApplication.invokeAction(WOApplication.java:1375)

at
com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPre
paredPage(WOComponentRequestHandler.java:196)

at
com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPre
paredSession(WOComponentRequestHandler.java:287)

at
com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPre
paredApplication(WOComponentRequestHandler.java:322)

at
com.webobjects.appserver._private.WOComponentRequestHandler._handleRequest(W
OComponentRequestHandler.java:358)

at
com.webobjects.appserver._private.WOComponentRequestHandler.handleRequest(WO
ComponentRequestHandler.java:432)

at
com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:13
06)

at
com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java
:173)

at
com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:254
)

at java.lang.Thread.run(Thread.java:595)


-------- 

Priority : FATAL

Class.Method(line):
de.mrer.base.BaseComponent.validationFailedWithException(BaseComponent.java:
104)

Message: de.mrer.exceptor.CustomException: [v.1.2B2 April 17 2006] Commit
Exception

========================

de.mrer.exceptor.CustomException: [v.1.2B2 April 17 2006] Commit Exception

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

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.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)

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.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.WOComponent.invokeAction(WOComponent.java:945)

at com.webobjects.appserver.WOSession.invokeAction(WOSession.java:1168)

at
com.webobjects.appserver.WOApplication.invokeAction(WOApplication.java:1375)

at
com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPre
paredPage(WOComponentRequestHandler.java:196)

at
com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPre
paredSession(WOComponentRequestHandler.java:287)

at
com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPre
paredApplication(WOComponentRequestHandler.java:322)

at
com.webobjects.appserver._private.WOComponentRequestHandler._handleRequest(W
OComponentRequestHandler.java:358)

at
com.webobjects.appserver._private.WOComponentRequestHandler.handleRequest(WO
ComponentRequestHandler.java:432)

at
com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:13
06)

at
com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java
:173)

at
com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:254
)

at java.lang.Thread.run(Thread.java:595)

-------------------------------------------------


Mime
View raw message