Re: [eclipselink-users] Failed insert results in invalid cache state

[bryans <panth13@xxxxxxxxx>]

Here's what I've got in my ExceptionHandler:



     public Object handleException(RuntimeException exception) {

		if (retry && exception instanceof DatabaseException) {
			DatabaseException dbe = (DatabaseException) exception;
			if (dbe.getQuery() instanceof InsertObjectQuery) {
				InsertObjectQuery insert = (InsertObjectQuery) dbe.getQuery();
				Object dup = insert.getObject();
				if (dbe.getSession().doesObjectExist(dup)) {
					insert.setModifyRow(null);
					insert.setPrimaryKey(null);
					ObjectBuilder builder = insert.getDescriptor().getObjectBuilder();
					ObjectCopyingPolicy policy = new ObjectCopyingPolicy();
					policy.setDepth(ObjectCopyingPolicy.CASCADE_ALL_PARTS);
					policy.setSession(dbe.getSession());
					policy.setShouldResetPrimaryKey(true);
					Object clone = builder.copyObject(dup, policy);
                                        //Change the next sequence value
					builder.assignSequenceNumber(clone, dbe.getSession());
					insert.setObject(clone);
					try {
						return dbe.getSession().executeQuery(insert);
					} catch	(Throwable t) {
						t.printStackTrace();
                                                throw t;
					}
				}
			}
			
		}
		throw exception;
	}



There really isn't any way of setting the ID to null as that would assume
that I know the object's class and can cast it. My attempt here is generic
to handle any type object, not just predefined ones.

Everything is done via JPA xml specs with Spring's JpaTemplate to handle
transaction management logic.

-B


James Sutherland wrote:
> 
> Definitely a tricky thing to do.  Try not cloning the object, as this will
> violate object identity, just set its id to null and re-execute the query.
> 
> What does your error handler do exactly?
> 
> I assume you are using JPA/UnitOfWork?
> 
> 

-- 
View this message in context: http://www.nabble.com/Failed-insert-results-in-invalid-cache-state-tp25384148p25389872.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.