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
  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 | 4 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 3 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