Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

  1. ,
    Expert tip

    Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via Mirth Project by Alex Aitougan, 1 year ago
ERROR: syntax error at or near ")" Position: 185
via Mirth Project by Alex Aitougan, 1 year ago
ERROR: syntax error at or near ")" Position: 185
via Mirth Project by Nick Rupley, 1 year ago
via Mirth Project by Nick Rupley, 1 year ago
via Google Groups by YamilBracho, 2 years ago
ERROR: operator does not exist: character varying # Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 1072
via Google Groups by cweber, 6 months ago
FEHLER: Relation „act_ge_property“ existiert nicht Position: 20
org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
  Position: 185	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:379)	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56)	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)	at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)	at java.lang.reflect.Method.invoke(Method.java:606)	at org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:282)	at com.sun.proxy.$Proxy7.selectList(Unknown Source)	at org.apache.ibatis.session.SqlSessionManager.selectList(SqlSessionManager.java:171)	at com.mirth.connect.server.controllers.DonkeyMessageController.searchText(DonkeyMessageController.java:1065)	at com.mirth.connect.server.controllers.DonkeyMessageController.searchAll(DonkeyMessageController.java:872)	at com.mirth.connect.server.controllers.DonkeyMessageController.searchMessages(DonkeyMessageController.java:641)	at com.mirth.connect.server.controllers.DonkeyMessageController.getMessages(DonkeyMessageController.java:192)	at com.mirth.connect.server.servlets.MessageObjectServlet.doPost(MessageObjectServlet.java:97)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:652)	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:447)	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225)	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1038)	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:374)	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:189)	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:972)	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)	at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)	at org.eclipse.jetty.server.Server.handle(Server.java:363)	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:483)	at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:931)	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:992)	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)	at org.eclipse.jetty.io.nio.SslConnection.handle(SslConnection.java:196)	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:627)	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:51)	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)	at java.lang.Thread.run(Thread.java:744)