org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" Position: 45
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
Upgrade the database driver to the latest and check.
<dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId> <version>9.3-1101-jdbc41</version> </dependency>
Replace version with the latest driver version.
- 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 GitHub by seanmmills
, 1 year agovia GitHub by davecramer
, 1 year agovia Stack Overflow by Do Nhu Vy
, 1 year agovia Stack Overflow by juntao liu
, 2 weeks agovia Stack Overflow by user1854959
, 1 year agovia Google Groups by Jack Woehr, 5 months ago
org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" Position: 45
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:305)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:291)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:269)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:236)
at org.postgresql.test.jdbc4.JsonbTest.testJsonb(JsonbTest.java:53)