Re: [eclipselink-users] What kind of Oracle Real Application Clusters (R

[Gordon Yorke <gordon.yorke@xxxxxxxxxx>]

Hello Sebastien,
    EclipseLink does support retrying queries executed outside of a transaction but inside a transaction EclipseLink will return the SQL Exception to the application so that the transaction can be replayed as EclipseLink EM may not be th only participant in a transaction.
    For a Java SE deployment I can see how it would be useful to recommit an EntityManager transaction but depending on how many flushes occurred and what other application threads were active on the recovery database the transaction may no longer be valid (ie if your changes were in reaction to certain existing state). 
    We could add a feature to support the simple case.

    Also please note that you may need to configure the query retry specifically for RAC as RAC recovery times can be longer than the default recovery timing settings in EclipseLink.  To update these settings currently you will need a Session Customizer to set the values on the Session's DatabaseLogin.
--Gordon

Sebastien Tardif wrote:

What kind of Oracle Real Application Clusters (RAC) support EclipseLink provides?

 

We use RAC so we get failover at DB/connection level, but it will be nice since we exclusively access the DB via EclipseLink, that EclipseLink provide the failover at application level by:

1-       retry query (read) if one RAC DB fail during execution

2-       restart commit phase (write), including previous flush if one RAC DB fail during the commit phase

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users