org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: ORA-00904: "AVALUE2_"."BOOLEANVALUE": invalid identifier

Google Groups | Alejandro Melián | 2 months ago
  1. 0

    Problem with Dspace CRIS 5.5 Oracle database error

    Google Groups | 2 months ago | Alejandro Melián
    org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: ORA-00904: "AVALUE2_"."BOOLEANVALUE": invalid identifier
  2. 0

    java.sql.SQLSyntaxErrorException: ORA-00904: "WAREHOUSE": invalid identifier

    GitHub | 5 months ago | ishanuda
    java.sql.SQLSyntaxErrorException: ORA-00904: "WAREHOUSE": invalid identifier ; State=42000; ErrorCode=904
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Hibernate says invalid identifier even if column is available in db

    Stack Overflow | 2 years ago | sr.praneeth
    java.sql.SQLSyntaxErrorException: ORA-00904: "TABLETYPE0_"."TTPNAME": invalid identifier
  5. 0

    SQLGrammarException with Hibernated and oracle11g

    Stack Overflow | 2 years ago | maximegir
    java.sql.SQLSyntaxErrorException: ORA-02289: la séquence n'existe pas (non existing sequence)
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-00904: "AVALUE2_"."BOOLEANVALUE": invalid identifier

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
    13 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeQuery
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
    1 frame
  4. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor202.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:606)
    3 frames
  5. org.hibernate.engine
    AbstractProxyHandler.invoke
    1. org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
    2. org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
    2 frames
  6. com.sun.proxy
    $Proxy623.executeQuery
    1. com.sun.proxy.$Proxy623.executeQuery(Unknown Source)
    1 frame
  7. Hibernate
    SessionImpl.get
    1. org.hibernate.loader.Loader.getResultSet(Loader.java:1926)
    2. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1727)
    3. org.hibernate.loader.Loader.doQuery(Loader.java:852)
    4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:293)
    5. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:263)
    6. org.hibernate.loader.Loader.loadCollection(Loader.java:2123)
    7. org.hibernate.loader.collection.BatchingCollectionInitializer.initialize(BatchingCollectionInitializer.java:85)
    8. org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:678)
    9. org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:80)
    10. org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1804)
    11. org.hibernate.collection.internal.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:681)
    12. org.hibernate.engine.internal.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:1024)
    13. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:298)
    14. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:263)
    15. org.hibernate.loader.Loader.loadEntity(Loader.java:2006)
    16. org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:82)
    17. org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:72)
    18. org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)
    19. org.hibernate.loader.entity.BatchingEntityLoader.load(BatchingEntityLoader.java:111)
    20. org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3887)
    21. org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:458)
    22. org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:427)
    23. org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:204)
    24. org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:260)
    25. org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:148)
    26. org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1078)
    27. org.hibernate.internal.SessionImpl.access$2000(SessionImpl.java:175)
    28. org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2424)
    29. org.hibernate.internal.SessionImpl.get(SessionImpl.java:974)
    29 frames
  8. it.cilea.osd
    GenericDaoHibernateImpl.read
    1. it.cilea.osd.common.dao.impl.GenericDaoHibernateImpl.read(GenericDaoHibernateImpl.java:85)
    1 frame
  9. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:606)
    4 frames
  10. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    3 frames
  11. it.cilea.osd
    NamedQueryIntroductionAdvisor$1.invoke
    1. it.cilea.osd.common.dao.impl.NamedQueryIntroductionAdvisor$1.invoke(NamedQueryIntroductionAdvisor.java:103)
    1 frame
  12. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    2 frames
  13. com.sun.proxy
    $Proxy110.read
    1. com.sun.proxy.$Proxy110.read(Unknown Source)
    1 frame
  14. it.cilea.osd
    PersistenceService.get
    1. it.cilea.osd.common.service.PersistenceService.get(PersistenceService.java:163)
    1 frame
  15. org.dspace.app
    ApplicationService$$FastClassByCGLIB$$600ec924.invoke
    1. org.dspace.app.cris.service.ApplicationService.get(ApplicationService.java:808)
    2. org.dspace.app.cris.service.ApplicationService.get(ApplicationService.java:850)
    3. org.dspace.app.cris.service.ApplicationService$$FastClassByCGLIB$$600ec924.invoke(<generated>)
    3 frames
  16. IDEA
    MethodProxy.invoke
    1. net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
    1 frame
  17. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    2 frames
  18. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    1 frame
  19. Spring AOP
    Cglib2AopProxy$DynamicAdvisedInterceptor.intercept
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
    2 frames
  20. org.dspace.app
    FormDODynamicMetadataController.formBackingObject
    1. org.dspace.app.cris.service.ApplicationService$$EnhancerByCGLIB$$969d9351.get(<generated>)
    2. org.dspace.app.webui.cris.controller.jdyna.FormDODynamicMetadataController.formBackingObject(FormDODynamicMetadataController.java:174)
    2 frames
  21. Spring MVC
    FrameworkServlet.doGet
    1. org.springframework.web.servlet.mvc.AbstractFormController.getErrorsForNewForm(AbstractFormController.java:361)
    2. org.springframework.web.servlet.mvc.AbstractFormController.showNewForm(AbstractFormController.java:341)
    3. org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:281)
    4. org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
    5. org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
    6. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
    7. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
    8. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
    9. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
    9 frames
  22. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    2 frames
  23. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    2 frames
  24. Tomcat WS
    WsFilter.doFilter
    1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    1 frame
  25. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    2 frames
  26. org.dspace.app
    DSpaceContextCleanupFilter.doFilter
    1. org.dspace.app.webui.cris.filter.DSpaceContextCleanupFilter.doFilter(DSpaceContextCleanupFilter.java:54)
    1 frame
  27. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    2 frames
  28. org.dspace.app
    RegisteredOnlyFilter.doFilter
    1. org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66)
    1 frame
  29. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    2 frames
  30. Spring
    OncePerRequestFilter.doFilter
    1. org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    2. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    2 frames
  31. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    2 frames
  32. DSpace Services Framework :: API and Implementation
    DSpaceWebappServletFilter.doFilter
    1. org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78)
    1 frame
  33. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
    6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
    7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
    9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442)
    10 frames
  34. Grizzly HTTP
    JIoEndpoint$SocketProcessor.run
    1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1082)
    2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:623)
    3. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
    3 frames
  35. Java RT
    ThreadPoolExecutor$Worker.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    2 frames
  36. Tomcat Util
    TaskThread$WrappingRunnable.run
    1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    1 frame
  37. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:724)
    1 frame