org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.

Terracotta | sslavic | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    MSSQL and selectWithLockSQL

    Terracotta | 6 years ago | sslavic
    org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.
  2. 0

    Error doing update/insert on SQLServer 2000

    jtds | 1 decade ago | hiberbear
    java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.
  3. 0

    'last_insert_id' is not a recognized function name

    Stack Overflow | 5 years ago | ZAJ
    com.kaizen.gate.service.ServiseException: Services level, can't save order - Order: (id=0, visitorId=2, status=A, customerId=528/nOrderDetail:(id=0, orderId=0, productId=124, amount=2)/n)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Entity inheritance: central table with common values + extended father entity

    Stack Overflow | 5 years ago | Nimchip
    java.sql.SQLException: Invalid column name 'ACTUAL_SITUATION'.
  6. 0

    JDBC Exception

    experts-exchange.com | 1 year ago
    com.kaizen.gate.service.ServiseException: Services level, can't save order - Order: (id=0, visitorId=12, status=A, customerId=1021/nOrderDetail:(id=0, orderId=0, productId=158, amount=70)/nOrderDetail:(id=0, orderId=0, productId=3, amount=40)/n)

  1. ruifung 1 times, last 7 months ago
12 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.

    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
  2. jTDS
    JtdsPreparedStatement.executeQuery
    1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)[jtds-1.2.4.jar:1.2.4]
    2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)[jtds-1.2.4.jar:1.2.4]
    3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)[jtds-1.2.4.jar:1.2.4]
    4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)[jtds-1.2.4.jar:1.2.4]
    5. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)[jtds-1.2.4.jar:1.2.4]
    6. net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:778)[jtds-1.2.4.jar:1.2.4]
    6 frames
  3. Commons DBCP
    DelegatingPreparedStatement.executeQuery
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)[commons-dbcp-1.4.jar:1.4]
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)[commons-dbcp-1.4.jar:1.4]
    2 frames
  4. quartz
    StdScheduler.start
    1. org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:85)[quartz-2.0.0.jar:na]
    2. org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:117)[quartz-2.0.0.jar:na]
    3. org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3174)[quartz-2.0.0.jar:na]
    4. org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3783)[quartz-2.0.0.jar:na]
    5. org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.initialize(JobStoreSupport.java:3770)[quartz-2.0.0.jar:na]
    6. org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:653)[quartz-2.0.0.jar:na]
    7. org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:507)[quartz-2.0.0.jar:na]
    8. org.quartz.impl.StdScheduler.start(StdScheduler.java:143)[quartz-2.0.0.jar:na]
    8 frames
  5. Spring Context Support
    SchedulerFactoryBean.start
    1. org.springframework.scheduling.quartz.SchedulerFactoryBean.startScheduler(SchedulerFactoryBean.java:651)[spring-context-support-3.1.0.M1.jar:3.1.0.M1]
    2. org.springframework.scheduling.quartz.SchedulerFactoryBean.start(SchedulerFactoryBean.java:714)[spring-context-support-3.1.0.M1.jar:3.1.0.M1]
    2 frames
  6. Spring Context
    AbstractApplicationContext.refresh
    1. org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:166)[spring-context-3.1.0.M1.jar:3.1.0.M1]
    2. org.springframework.context.support.DefaultLifecycleProcessor.access$1(DefaultLifecycleProcessor.java:154)[spring-context-3.1.0.M1.jar:3.1.0.M1]
    3. org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:335)[spring-context-3.1.0.M1.jar:3.1.0.M1]
    4. org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:143)[spring-context-3.1.0.M1.jar:3.1.0.M1]
    5. org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:108)[spring-context-3.1.0.M1.jar:3.1.0.M1]
    6. org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:913)[spring-context-3.1.0.M1.jar:3.1.0.M1]
    7. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:458)[spring-context-3.1.0.M1.jar:3.1.0.M1]
    7 frames
  7. Spring
    ContextLoaderListener.contextInitialized
    1. org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:294)[spring-web-3.1.0.M1.jar:3.1.0.M1]
    2. org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:215)[spring-web-3.1.0.M1.jar:3.1.0.M1]
    3. org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)[spring-web-3.1.0.M1.jar:3.1.0.M1]
    3 frames
  8. Glassfish Core
    StandardContext$1.call
    1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4681)[catalina.jar:7.0.11]
    2. org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5184)[catalina.jar:7.0.11]
    3. org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5179)[catalina.jar:7.0.11]
    3 frames
  9. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)[na:1.6.0_24]
    2. java.util.concurrent.FutureTask.run(FutureTask.java:138)[na:1.6.0_24]
    3. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)[na:1.6.0_24]
    4. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)[na:1.6.0_24]
    5. java.lang.Thread.run(Thread.java:662)[na:1.6.0_24]
    5 frames