Il giorno 18/apr/2012, alle ore 13.11, Denis Signoretto (Commented) (JIRA) ha scritto:
> > [ > https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13256443#comment-13256443 > ] > > Denis Signoretto commented on SYNCOPE-59: > ----------------------------------------- > > > Trying more, the problem only occurs using OCI driver: > > Our current release is: Oracle JDBC Driver version - "10.2.0.5.0" > Hi Denis, I cannot reproduce the problem. I made my check by using oracle 11 and the relative instant client. My datasource configuration is the following <Resource name="jdbc/syncopeDataSource" auth="Container" type="javax.sql.DataSource"^M factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" testWhileIdle="true"^M testOnBorrow="true" testOnReturn="true" validationQuery="SELECT 1 FROM DUAL" validationInterval="30000"^M maxActive="150" minIdle="2" maxWait="10000" initialSize="2" removeAbandonedTimeout="10"^M removeAbandoned="true" logAbandoned="true" suspectTimeout="10"^M timeBetweenEvictionRunsMillis="5000" minEvictableIdleTimeMillis="5000"^M jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"^M username="syncope" password="syncope" driverClassName="oracle.jdbc.OracleDriver"^M url="jdbc:oracle:oci:@pioppo:1521:orcl" /> Probably, apart the oracle version, the difference between my configuration and yours in into the jdbc url. Did you use a tnsnames.ora file for your connection? Could you try with a "legacy" jdbc url? Cheers, F. > Bye, > Denis. > > > > ssian.jira.plugin.system.issuetabpanels:comment-> > tabpanel&focusedCommentId=13256389#comment-13256389 ] > fault.jspa > For more information on JIRA, see: http://www.atlassian.com/software/jira > > > > >> 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 >> Assignee: fabio martelli >> 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(StdRowLockSemaphore.java:109) >> ~[quartz-1.8.6.jar:na] >> at >> org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:112) >> ~[quartz-1.8.6.jar:na] >> at >> org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:235) >> ~[quartz-1.8.6.jar:na] >> at >> org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3712) >> ~[quartz-1.8.6.jar:na] >> at >> org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1059) >> ~[quartz-1.8.6.jar:na] >> at >> org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java: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(JobInstanceLoader.java:134) >> ~[JobInstanceLoader.class:na] >> at >> org.syncope.core.init.JobInstanceLoader.registerJob(JobInstanceLoader.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$$edd08387.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!default.jspa > For more information on JIRA, see: http://www.atlassian.com/software/jira > >
