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 | 7 months 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

    Problem with Dspace CRIS 5.5 Oracle database error

    Google Groups | 7 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 | 10 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

    PMEase forum • View topic - exception filtering audit log with qb 6.0.11

    pmease.com | 2 years ago
    java.sql.SQLSyntaxErrorException: ORA-00932: Inkonsistente Datentypen: CHAR erwartet, LONG erhalten
  5. 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
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