Trying more, the problem only occurs using OCI driver: Our current release is: Oracle JDBC Driver version - "10.2.0.5.0"
Bye, Denis. > -----Messaggio originale----- > Da: Denis Signoretto (Commented) (JIRA) [mailto:[email protected]] > Inviato: mercoledì 18 aprile 2012 11.39 > A: [email protected] > Oggetto: [jira] [Commented] (SYNCOPE-59) ERROR > org.syncope.core.init.JobInstanceLoader - While loading > NotificationJob > instance - ORA-01002: fetch out of sequence > > > > [ > https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atla ssian.jira.plugin.system.issuetabpanels:comment-> tabpanel&focusedCommentId=13256389#comment-13256389 ] > > Denis Signoretto commented on SYNCOPE-59: > ----------------------------------------- > > Hi Fabio, > > I tryed various combinations and I found that using thin > client and excluding > usage of jdbc/syncopeDataSource connection pool the error disappear. > > Are you able to reproduce the error using OCI and jndi > Connection Pool? > > Thanks, > Denis. > > va.lang.Exception > > > > ERROR org.syncope.core.init.JobInstanceLoader - While > loading NotificationJob instance - ORA-01002: fetch out of sequence > > > -------------------------------------------------------------- > ----------------------------------------------------------- > > > > Key: SYNCOPE-59 > > URL: > https://issues.apache.org/jira/browse/SYNCOPE-59 > > Project: Syncope > > Issue Type: Bug > > Components: core > > Affects Versions: 1.0.0-incubating > > Environment: Oracle 10g, Linux x86_64, > > Reporter: Denis Signoretto > > Priority: Critical > > Labels: oracle > > > > Stracktrace Error on startup: > > 15:51:05.908 ERROR org.syncope.core.init.JobInstanceLoader > - While loading NotificationJob instance > > org.quartz.impl.jdbcjobstore.LockException: Failure > obtaining db row lock: ORA-01002: fetch out of sequence > > {prepstmnt 155276228 SELECT * FROM QRTZ_LOCKS WHERE > LOCK_NAME = ? FOR UPDATE [params=?]} [code=1002, state=72000] > > at > org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(St > dRowLockSemaphore.java:109) ~[quartz-1.8.6.jar:na] > > at > org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphor > e.java:112) ~[quartz-1.8.6.jar:na] > > at > org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStor > eCMT.java:235) ~[quartz-1.8.6.jar:na] > > at > org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(Job > StoreSupport.java:3712) ~[quartz-1.8.6.jar:na] > > at > org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigge > r(JobStoreSupport.java:1059) ~[quartz-1.8.6.jar:na] > > at > org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.ja > va:822) ~[quartz-1.8.6.jar:na] > > at > org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:243 > ) ~[quartz-1.8.6.jar:na] > > at > org.syncope.core.init.JobInstanceLoader.registerJob(JobInstanc > eLoader.java:134) ~[JobInstanceLoader.class:na] > > at > org.syncope.core.init.JobInstanceLoader.registerJob(JobInstanc > eLoader.java:162) ~[JobInstanceLoader.class:na] > > at > org.syncope.core.init.JobInstanceLoader.load(JobInstanceLoader > .java:210) ~[JobInstanceLoader.class:na] > > at > org.syncope.core.init.JobInstanceLoader$$FastClassByCGLIB$$edd > 08387.invoke(<generated>) [cglib-2.2.2.jar:na] > > at > net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) > [cglib-2.2.2.jar:na] > > -- > This message is automatically generated by JIRA. > If you think it was sent incorrectly, please contact your > JIRA administrators: > https://issues.apache.org/jira/secure/ContactAdministrators!de fault.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira
