On 9/22/06, Vezina Marie-Helene <
marie-hel...@umontreal.ca> wrote:
...
> Exception in thread "main" java.sql.SQLException: ERROR: parser: parse
> error at or near "s" at character 186
>
> at
> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
> at
> org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
> at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
> at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153)
> at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:141)
> at
> org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
> at
> org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:163)
> at
> org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:227)
> at
> org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1227)
...
Not sure where the "s" is coming from, but "jdbc1" worries me. Are you
sure that you are using JDBC2 or JDBC3? I'm not sure if JDBC1 even
works...
The query itself is being passed to an executed method in
org.dspace.app.statistics.LogAnalyser on line 1227. If you turn on
DEBUG logging, the DatabaseManager method query will log the query
being executed, which might give you more information.
Jonathan