org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 39

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 Sakai JIRA by Pascal-Nicolas Becker, 1 year ago
ERROR: syntax error at or near ")" Position: 39
via Sakai JIRA by Pascal-Nicolas Becker, 1 year ago
ERROR: syntax error at or near ")" Position: 39
via Google Groups by Senthil.R, 2 months ago
ERROR: syntax error at or near ")"
via Google Groups by Kocisky, 2 months ago
org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 39
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1725)
at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:655)
at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:446)
at org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403)
at org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172)
at org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138)
at org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
10 times, 1 year ago
16 times, 3 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

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