Hi Fabian,
afair Mika referred to situations where it is tried to rollback or close
allready closed connections:
see
org.dspace.core.Context
public void abort()
{
try
{
connection.rollback();
}
catch (SQLException se)
{
log.error(se.getMessage());
se.printStackTrace();
}
finally
{
DatabaseManager.freeConnection(connection);
connection = null;
events = null;
}
}
this might help
public void abort()
{
try
{
if (!connection.isClosed())
connection.rollback();
}
catch (SQLException se)
{
log.error(se.getMessage());
se.printStackTrace();
}
finally
{
try
{
if (!connection.isClosed())
DatabaseManager.freeConnection(connection);
}
catch (Exception ex)
{
ex.printStackTrace();
}
connection = null;
events = null;
}
}
Sunny greetings
Claudia Jürgen
Fabian Smagghe schrieb:
> Hi,
>
> in September 2007 Mika Stenberg reported connection problems:
> "PSQLException: This statement has been closed"
> "LOG: unexpected EOF on client connection"
>
> We have the same problem (we use dspace 1.5.0 + customization) and MANY
> "System Error" with following
> message in the log : "SQLException: This statement has been closed".
>
> To get around this problem, we install 2 classes of version 1.5.1 to
> improved cleanup of database resources:
> org.dspace.storage.rdbms.DatabaseManager.java and
> org.dspace.storage.rdbms.TableRowIterator.java
> ...but the problem remains !
>
> James Rutherford wrote (September 2007) that it was probably indicative
> of sloppy / incorrect use of the Context somewhere.
> Can someone say what "sloppy /incorrect use" does mean
> or how to cleanup database resources
> or how to find the code responsible for the problem ?
>
> Thanks,
>
> Fabian
>
>
>
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
