org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Oracle Community | 2839801 | 2 years ago
  1. 0

    Apache Tomcat

    Oracle Community | 2 years ago | 2839801
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  2. 0

    ERROR: ORA-02289: sequence does not exist - org.hibernate.exception.SQLGrammarException: could not extract ResultSet

    Stack Overflow | 2 years ago | user2682305
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  3. 0

    ERROR: ORA-02289: sequence does not exist (Object Relational Mapping forum at JavaRanch)

    coderanch.com | 1 year ago
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Using an Oracle Sequence with Hibernate hbm.xml file

    Stack Overflow | 6 months ago | AHijaouy
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet

  1. rafafviola 1 times, last 1 month ago
  2. wendellpereira 128 times, last 2 months ago
  3. balintn 4 times, last 2 months ago
  4. balintn 3 times, last 3 months ago
  5. pnaranja 2 times, last 4 months ago
1 more registered users
30 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.SQLSyntaxErrorException

    ORA-02289: sequence does not exist

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    8. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    9. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    10. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    11. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    12. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    13. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    14. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)[ojdbc7-12.1.0.1.jar:12.1.0.1.0]
    14 frames
  3. Hibernate
    SessionImpl.save
    1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    2. org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:122)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    3. org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:115)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    4. org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:117)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    5. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    6. org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    7. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    8. org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    9. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    10. org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    11. org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    11 frames
  4. org.hibernate.envers
    AuditProcessManager$1.doBeforeTransactionCompletion
    1. org.hibernate.envers.internal.revisioninfo.DefaultRevisionInfoGenerator.saveRevisionData(DefaultRevisionInfoGenerator.java:89)[hibernate-envers-4.3.5.Final.jar:4.3.5.Final]
    2. org.hibernate.envers.internal.synchronization.AuditProcess.getCurrentRevisionData(AuditProcess.java:132)[hibernate-envers-4.3.5.Final.jar:4.3.5.Final]
    3. org.hibernate.envers.internal.synchronization.AuditProcess.executeInSession(AuditProcess.java:109)[hibernate-envers-4.3.5.Final.jar:4.3.5.Final]
    4. org.hibernate.envers.internal.synchronization.AuditProcess.doBeforeTransactionCompletion(AuditProcess.java:161)[hibernate-envers-4.3.5.Final.jar:4.3.5.Final]
    5. org.hibernate.envers.internal.synchronization.AuditProcessManager$1.doBeforeTransactionCompletion(AuditProcessManager.java:63)[hibernate-envers-4.3.5.Final.jar:4.3.5.Final]
    5 frames
  5. Hibernate
    AbstractTransactionImpl.commit
    1. org.hibernate.engine.spi.ActionQueue$BeforeTransactionCompletionProcessQueue.beforeTransactionCompletion(ActionQueue.java:715)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    2. org.hibernate.engine.spi.ActionQueue.beforeTransactionCompletion(ActionQueue.java:389)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    3. org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:516)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    4. org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:105)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    5. org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:177)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    5 frames
  6. Spring ORM
    HibernateTransactionManager.doCommit
    1. org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:584)[spring-orm-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    1 frame
  7. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    2. org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    3. org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:521)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    4. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    5. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    5 frames
  8. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    2. org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    4. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    4 frames
  9. com.sun.proxy
    $Proxy92.create
    1. com.sun.proxy.$Proxy92.create(Unknown Source)[?:?]
    1 frame
  10. com.kenfook.core
    SystemInitializingROAServiceImpl.noTxAdviceInitData
    1. com.kenfook.core.common.service.SystemInitializingServiceImpl.createAdminRole(SystemInitializingServiceImpl.java:872)[ken-fook-core-lib-0.1.jar:?]
    2. com.kenfook.core.common.service.SystemInitializingServiceImpl.noTxAdviceInitData(SystemInitializingServiceImpl.java:127)[ken-fook-core-lib-0.1.jar:?]
    3. com.kenfook.core.common.service.SystemInitializingROAServiceImpl.noTxAdviceInitData(SystemInitializingROAServiceImpl.java:213)[SystemInitializingROAServiceImpl.class:?]
    3 frames
  11. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[?:1.8.0_45]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)[?:1.8.0_45]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)[?:1.8.0_45]
    4. java.lang.reflect.Method.invoke(Unknown Source)[?:1.8.0_45]
    4 frames
  12. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    3 frames
  13. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    3 frames
  14. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    2. org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    4. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    4 frames
  15. com.sun.proxy
    $Proxy131.noTxAdviceInitData
    1. com.sun.proxy.$Proxy131.noTxAdviceInitData(Unknown Source)[?:?]
    1 frame
  16. com.kenfook.settings
    AppContextLoaderListener.contextInitialized
    1. com.kenfook.settings.PreLoaderROA.loadAllData(PreLoaderROA.java:40)[PreLoaderROA.class:?]
    2. com.kenfook.settings.PreLoaderROA.init(PreLoaderROA.java:27)[PreLoaderROA.class:?]
    3. com.kenfook.settings.AppContextLoaderListener.contextInitialized(AppContextLoaderListener.java:50)[ken-fook-core-lib-0.1.jar:?]
    3 frames
  17. Glassfish Core
    HostConfig$DeployWar.run
    1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4728)[catalina.jar:8.0.20]
    2. org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5162)[catalina.jar:8.0.20]
    3. org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)[catalina.jar:8.0.20]
    4. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)[catalina.jar:8.0.20]
    5. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)[catalina.jar:8.0.20]
    6. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)[catalina.jar:8.0.20]
    7. org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:917)[catalina.jar:8.0.20]
    8. org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1701)[catalina.jar:8.0.20]
    8 frames
  18. Java RT
    Thread.run
    1. java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)[?:1.8.0_45]
    2. java.util.concurrent.FutureTask.run(Unknown Source)[?:1.8.0_45]
    3. java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)[?:1.8.0_45]
    4. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)[?:1.8.0_45]
    5. java.lang.Thread.run(Unknown Source)[?:1.8.0_45]
    5 frames