[Logo] Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
[Expert]
Couldn't store job: ORA-22990: LOB locators cannot span transactions  XML
Forum Index -> Quartz
Author Message
nraveen

neo

Joined: 08/07/2014 15:27:10
Messages: 1
Offline

While trying to schedule jobs, quartz is throwing this exception.

Couldn't store job: ORA-22990: LOB locators cannot span transactions

Two quartz schedulers are running in two boxes in a clustered fashion pointing to the same DB. The quartz version used is 2.1.7.

I suspect the error is coming from

ps = conn.prepareStatement(rtp(UPDATE_ORACLE_JOB_DETAIL_BLOB));
ps.setBlob(1, dbBlob);
ps.setString(2, job.getKey().getName());
ps.setString(3, job.getKey().getGroup());

in OracleDelegate

Web search doesn't indicate any others have encountered the issue. Any help is greatly appreciated.

 
Forum Index -> Quartz
Go to:   
Powered by JForum 2.1.7 © JForum Team