java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

Stack Overflow | smith | 5 months ago
  1. 0

    Getting conflict with DD-MON-RR format

    Stack Overflow | 5 months ago | smith
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  2. 0

    ORABPEL-9708 Error while querying workflow task WFTask. Caused by:ORA-00936

    Oracle Community | 6 years ago | 857672
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Catalog search operations give ADF error

    Oracle Community | 7 months ago | Federator
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  5. 0

    Application against Oracle or Postgres in Weblogic, Sequence Fails

    Stack Overflow | 1 year ago | Kumar
    java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected

  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-00936: missing expression

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3637)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
    13 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeQuery
    1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
    1 frame
  4. Hibernate
    Loader.list
    1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
    2. org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
    3. org.hibernate.loader.Loader.doQuery(Loader.java:674)
    4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    5. org.hibernate.loader.Loader.doList(Loader.java:2213)
    6. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    7. org.hibernate.loader.Loader.list(Loader.java:2099)
    7 frames
  5. Hibernate
    QueryImpl.list
    1. org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:912)
    2. org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
    3. org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
    4. org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
    4 frames
  6. com.massivos.dao
    FiledataDaoImpl.getSpikeChartDetails
    1. com.massivos.dao.FiledataDaoImpl.getSpikeChartDetails(FiledataDaoImpl.java:112)
    1 frame
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  8. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    3 frames
  9. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    3 frames
  10. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  11. com.sun.proxy
    $Proxy105.getSpikeChartDetails
    1. com.sun.proxy.$Proxy105.getSpikeChartDetails(Unknown Source)
    1 frame
  12. com.massivos.service
    FiledataServiceImpl.getSpikeChartDetails
    1. com.massivos.service.FiledataServiceImpl.getSpikeChartDetails(FiledataServiceImpl.java:206)
    1 frame
  13. com.massivos.controller
    FiledataController.getSpikeChartDetails
    1. com.massivos.controller.FiledataController.getSpikeChartDetails(FiledataController.java:321)
    1 frame
  14. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  15. Spring
    InvocableHandlerMethod.invokeForRequest
    1. org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
    2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
    2 frames
  16. Spring MVC
    FrameworkServlet.doPost
    1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
    2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
    3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
    4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
    5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
    6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
    7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
    8. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
    8 frames
  17. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    1 frame
  18. Spring MVC
    FrameworkServlet.service
    1. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
    1 frame
  19. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    1 frame
  20. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
    4. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
    5. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3750)
    6. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
    6 frames
  21. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  22. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  23. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
    3 frames
  24. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:252)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames