org.postgresql.util.PSQLException: ERROR: syntax error at or near "=" Position: 49

eclipse.org | 3 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

    Eclipse Community Forums: BIRT » problem with output parameters

    eclipse.org | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: The result set is > closed. (Element ID:236) > at > org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237) > > at > org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216) > > at > org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96) > > at > org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62) > > at > org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43) > > at > org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) > > at > org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34) > > at > org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65) > > at > org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92) > > at > org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100) > > at > org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180) > > at > org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77) > > at > org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:937) > > at > org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973) > > at > org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131) > > at > org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90) > > at > org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47) > > at > org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143) > > at > org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  2. 0

    DataException : Error in saving files of data set cache.

    Eclipse Bugzilla | 4 years ago | dhulipudi.purnima
    org.eclipse.birt.report.engine.api.EngineException: There is an error in saving files of data set cache. /apps/GTS/tmp/p_wtydm_wl/ccerrep/cache/DataEngine_698590531_9065/DataSetCacheObject_699656275_5368/data.data (No such file or directory) (Element ID:2026)
  3. 0

    Eclipse Community Forums: BIRT » [BIRT 4.3.1] Dataset does not close idle connections

    eclipse.org | 2 years ago
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, FATAL: remaining connection slots are reserved for non-replication superuser connections.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Bug 385627 – JDBCException: SQL statement does not return a ResultSet object. on SQL Server

    eclipse.org | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: The value is not set for the parameter number 1. (Element ID:3372)
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. org.postgresql.util.PSQLException

    ERROR: syntax error at or near "=" Position: 49

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
    6 frames
  3. org.eclipse.birt
    BidiStatement.getMetaData
    1. org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:477)
    2. org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaUsingDefaultPolicy(Statement.java:388)
    3. org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData(Statement.java:330)
    4. org.eclipse.birt.report.data.oda.jdbc.bidi.BidiStatement.getMetaData(BidiStatement.java:56)
    4 frames
  4. DTP ODA Consumer Helper Component Plug-in
    OdaQuery.getMetaData
    1. org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doGetMetaData(OdaQuery.java:423)
    2. org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.getMetaData(OdaQuery.java:390)
    2 frames
  5. BIRT Data Engine
    QueryResults.getResultIterator
    1. org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:407)
    2. org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:377)
    3. org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.doGetMetaData(PreparedStatement.java:347)
    4. org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:563)
    5. org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:972)
    6. org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:503)
    7. org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1208)
    8. org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)
    9. org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)
    9 frames
  6. org.eclipse.birt
    BirtDocumentProcessor.handleGetPageAll
    1. org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)
    2. org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)
    3. org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:275)
    4. org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1947)
    5. org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
    6. org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
    7. org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
    8. org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
    9. org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
    10. org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
    11. org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
    12. org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
    13. org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:181)
    14. org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
    15. org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:937)
    16. org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)
    17. org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131)
    18. org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
    19. org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
    20. org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
    21. org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183)
    21 frames
  7. 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
  8. org.eclipse.birt
    BirtSoapBindingImpl.getUpdatedObjects
    1. org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
    2. org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
    2 frames
  9. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:606)
    3 frames
  10. Axis Web Services
    AxisServlet.doPost
    1. org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
    2. org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
    3. org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
    4. org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
    5. org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
    6. org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
    7. org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
    8. org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
    9. org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
    9 frames
  11. org.eclipse.birt
    BirtSoapMessageDispatcherServlet.doPost
    1. org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
    1 frame
  12. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
    1 frame
  13. Axis Web Services
    AxisServletBase.service
    1. org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
    1 frame
  14. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
    1 frame
  15. org.eclipse.birt
    BirtSoapMessageDispatcherServlet.service
    1. org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
    1 frame
  16. org.eclipse.equinox
    ProxyServlet.service
    1. org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
    2. org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
    3. org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)
    4. org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
    4 frames
  17. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
    1 frame
  18. Jetty Http Service
    HttpServerManager$InternalHttpServiceServlet.service
    1. org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:386)
    1 frame
  19. Jetty
    AsyncHttpConnection.handle
    1. org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
    2. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:457)
    3. org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:229)
    4. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075)
    5. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384)
    6. org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
    7. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009)
    8. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
    9. org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
    10. org.eclipse.jetty.server.Server.handle(Server.java:368)
    11. org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)
    12. org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)
    13. org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)
    14. org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)
    15. org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
    16. org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
    16 frames
  20. GWT dev
    SelectChannelEndPoint$1.run
    1. org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
    2. org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
    2 frames
  21. Jetty
    QueuedThreadPool$3.run
    1. org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
    2. org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
    2 frames
  22. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:724)
    1 frame