Re: [Dspace-tech] SQLException how can I see the offending raw SQL

2008-03-04 Thread Bram Luyten
Dear Charlotte, we are working on the same issue on a DSpace 1.3.2 installation. Typically, it occurs during the submission process. When we figure it out, we'll post it here. When you find a solution, we'd also be interested. regards, Bram Luyten On Tue, Mar 4, 2008 at 9:40 AM, Charlotte Poll

Re: [Dspace-tech] SQLException how can I see the offending raw SQL

2008-03-04 Thread Reuben Pasquini
If you're using a postgres database, then you can turn up the logging on the database server. http://www.postgresql.org/docs/8.3/static/runtime-config-logging.html Cheers, Reuben >>> Charlotte Pollock <[EMAIL PROTECTED]> 3/4/2008 2:40 AM >>> Hi I'm getting an the following intermittent er

Re: [Dspace-tech] SQLException how can I see the offending raw SQL

2008-03-04 Thread Claudia Jürgen
Hi Charlotte, if you set your log level to DEBUG, the queries will appear in the dspace log files. In order to do so edit [dspace-source]/config/templates/log4j.properties change the line log4j.rootCategory=INFO, A1 to log4j.rootCategory=DEBUG, A1 then you got to run [dspace]/bin/install-config

Re: [Dspace-tech] SQLException how can I see the offending raw SQL

2008-03-04 Thread James Rutherford
On Tue, Mar 04, 2008 at 08:40:32AM +, Charlotte Pollock wrote: > I'm getting an the following intermittent error > > database_error:org.postgresql.util.PSQLException: ERROR: current transaction > is aborted, commands ignored until end of transaction block > > With no clear pattern as to why >

[Dspace-tech] SQLException how can I see the offending raw SQL

2008-03-04 Thread Charlotte Pollock
Hi I'm getting an the following intermittent error database_error:org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block With no clear pattern as to why What I really would like to do is to see the raw SQL that is causing postgr