0 Replies Latest reply on Nov 6, 2014 3:57 AM by vandamo

    Oracle XA Datasource - is-same-rm-override - usage?

    vandamo

      Hi,

      I've been trying to resolve an issue for a while on one of our applications,

      ...

      [2014-11-04 13:30:30,067] WARN  [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-8] [o.j.j.c.c.l.TxConnectionListener] [] IJ000305: Connection error occured

      ...

      [2014-11-04 13:30:30,095] ERROR [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-8] [o.h.e.j.s.SqlExceptionHelper] [] javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected()

      ...

       

      which got resolved by setting the is-same-rm-override to false


      The issue occurred with a transaction spanning multiple datasources.

      I'd like if possible to be pointed towards documentation explaining why such issue occurs, and how the is-same-rm-override set to false resolves it.


      Best guess I can have is that this would be linked to our datasources using different credentials, and so having different schemas defined, while accessing the same database.


      Any information would be greatly appreciated, as I have a hard time being satisfied in setting a configuration I do not understand.