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-configs and restart your servlet container. Note that running in DEBUG mode will have an impact on performance and the log files will increase in size. hope that helps Claudia Charlotte Pollock schrieb: > 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 > postgres to error > > Does anyone know of a way to debug this error? > > Many thnaks > > Charlotte > > > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > > ------------------------------------------------------------------------ > > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech