[
https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13256536#comment-13256536
]
fabio martelli commented on SYNCOPE-59:
---------------------------------------
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.
> 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
