org.postgresql.util.PSQLException: ERROR: syntax error at end of input; State=42601; ErrorCode=0

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 adempiere by vpj-cd
, 1 year ago
ERROR: syntax error at end of input; State=42601; ErrorCode=0
via adempiere by fercho_comus
, 1 year ago
ERROR: java.sql.SQLException: Cannot derive a value of class java.sql.Date from an object of class java.sql.Timestamp; State=XX000; ErrorCode=0
via adempiere by fercho_comus
, 1 year ago
ERROR: java.sql.SQLException: Cannot derive a value of class java.sql.Date from an object of class java.sql.Timestamp; State=XX000; ErrorCode=0
via adempiere by bepivin
, 1 year ago
ERROR: Default type java.math.BigDecimal cannot be replaced by int; State=42601; ErrorCode=0
via adempiere by ebucher
, 1 year ago
ERROR: java.lang.ClassNotFoundException: org.compiere.sqlj.Product; State=XX000; ErrorCode=0
via adempiere by purna_budaya
, 1 year ago
ERROR: function bomqtyavailable(numeric, integer, integer) does not exist; State=42883; ErrorCode=0
org.postgresql.util.PSQLException: ERROR: syntax error at end of input; State=42601; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)

Users with the same issue

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

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