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>

  2. ,
    via stackoverflow.com by Unknown author

    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.

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, 2 years ago
ERROR: syntax error at or near ")" Position: 39
via Google Groups by Senthil.R, 9 months ago
ERROR: syntax error at or near ")"
via Google Groups by Kocisky, 9 months ago
via Google Groups by Kocisky, 9 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.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) 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)