Problem with SRW not closing the database connections

[PaiviR]

Hi!

Our Dspace SRW interface is heavily used. For this reason we started
to get error messages like:
"Cannot get a connection, pool error Timeout waiting for idle object"
or

404: Document not found (No searchRetrieveResponse)

According to instructions found here:
http://www.mail-archive.com/dspac...@lists.sourceforge.net/msg13823.html

we increased the number of db.maxconnections to 500 (in dspace.cfg).
After this we started to get error messages like this:
"FATAL: connection limit exceeded for non-superusers". This was
because our database only accepted max 100 connections. Now I have
been testing the following configuration:

db.maxconnections= 100 (in dspace.cfg)
max.connections allowed by database = 400
resultSetIdleTime=0 in SRWServer.props file

Despite of this after ~100 queries we obtain the same "404: Document
not found (No searchRetrieveResponse)". If one lists the database
processes at that stage, there are ~80 of them, most in the state of
"idle in transaction"-

Any solution for this? Is there a way to make the package to close the
db connections more quicker ? SRU is quite used interface so this has
caused us some troubles. We have checked that we have the latest
version of the code.

Yours sincerely,
PaiviR

[LeVan,Ralph]

Jose Blanco from UMich and I tracked that problem down. I'm afraid I
haven't committed those changes back to the repository yet, but here are
the jars straight out of my development environment. They worked for
Jose.

Ralph

p.s. I'm not positive that Google Groups will pass those attachments
through in the distribution. If not, send an email to le...@oclc.org
and I'll send them to you directly.

Hi!

Yours sincerely,
PaiviR

--
You received this message because you are subscribed to the Google
Groups "oclcsrw" group.
To post to this group, send email to ocl...@googlegroups.com.
To unsubscribe from this group, send email to
oclcsrw+u...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/oclcsrw?hl=en.