portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ate Douma (JIRA)" <jetspeed-...@portals.apache.org>
Subject [jira] Updated: (JS2-666) Clustered Environment: constraint violation if clones are started at the same time
Date Sun, 09 Dec 2007 23:54:43 GMT

     [ https://issues.apache.org/jira/browse/JS2-666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ate Douma updated JS2-666:
--------------------------

    Attachment: jetspeed-JS2-666-patch2.diff

Reviewing the new patch I made myself earlier it turned out I made a few errors when applying
Frank's patch by hand.
After fixing those, this patch tested out very well and definitely provides some improvements
as well as a more robust handling for clustered environments.

So, for the record, I'm attaching a fixed version of the patch I created and then will commit
this to both the 2.2 trunk *and* the 2.1.3 branch to which I actually tested this one out.


> Clustered Environment: constraint violation if clones are started at the same time
> ----------------------------------------------------------------------------------
>
>                 Key: JS2-666
>                 URL: https://issues.apache.org/jira/browse/JS2-666
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Portlet Registry
>    Affects Versions: 2.1
>         Environment: Websphere Application Server 6.0
> Database DB2 8.2
>            Reporter: Frank Stalherm
>            Assignee: Ate Douma
>             Fix For: 2.1.3, 2.2
>
>         Attachments: jetspeed-JS2-666-patch.diff, jetspeed-JS2-666-patch2.diff
>
>
> Clustered Environment: constraint violation if clones are started at the same time.
> Exception thrown:
> com.ibm.websphere.ce.cm.DuplicateKeyException: [IBM][CLI Driver][DB2/6000] SQL0803N 
One or more values in the INSERT statement, UPDATE statement, or foreign key update caused
by a DELETE statement are not valid because the primary key, unique constraint or unique index
identified by "2" constrains table "PORTLET_APPLICATION" from having duplicate rows for those
columns.  SQLSTATE=23505
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java(Compiled
Code))
> 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java(Compiled
Code))
> 	at java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled Code))
> 	at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:502)
> 	at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:545)
> 	at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:902)
> 	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:555)
> 	at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImpl.java:216)
> 	at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:1754)
> 	at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:813)
> 	at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:726)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


Mime
View raw message