org.postgresql.util.PSQLException: ERROR: syntax error at or near "from"   Position: 34

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

,
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 openxava by shadowdemon
, 1 year ago
ERROR: syntax error at or near "from"   Position: 34
via openxava by archimagealex
, 1 year ago
ERROR: column subject.birthdate does not exist   Position: 89
via Stack Overflow by Judit
, 2 years ago
ERROR: syntax error at or near "mytable" Position: 15
via Stack Overflow by user976426
, 2 years ago
ERROR: syntax error at or near "$2" Position: 61
via Google Groups by ste.buf...@tin.it, 3 months ago
ERROR: syntax error at or near "$1"
via Google Groups by Mike Starov, 2 years ago
ERROR: function function1(bigint) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15
org.postgresql.util.PSQLException: ERROR: syntax error at or near "from"   Position: 34
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.openxava.tab.impl.JDBCTabProvider.nextBlock(JDBCTabProvider.java:238)
at org.openxava.tab.impl.JDBCTabProvider.nextChunk(JDBCTabProvider.java:261)
at org.openxava.tab.impl.EntityTabDataProvider.nextChunk(EntityTabDataProvider.java:35)
at org.openxava.tab.impl.EntityTab.nextChunk(EntityTab.java:298)
at org.openxava.tab.impl.TableModelBean.getRow(TableModelBean.java:120)
at org.openxava.tab.impl.TableModelBean.getObjectAt(TableModelBean.java:149)
at org.openxava.tab.impl.XTableModelDecoratorBase.getObjectAt(XTableModelDecoratorBase.java:55)
at org.openxava.actions.ViewDetailAction.execute(ViewDetailAction.java:60)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:350)
at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:267)
at org.openxava.controller.ModuleManager.execute(ModuleManager.java:231)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
16 times, 3 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
104 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.