Thanks Jens, We are looking into our connection pool settings to see if
there are any necessary tweaks. Right now, we are using the uPortal
out-of-box JNDI pool settings.
As for the statement closure problem, that is somewhat of a needle in a
haystack. Again, this is uPortal framework code, so I'm assuming that
if there is a leaky cursor problem in there, someone else must have run
into it by now. However, we have not ruled this out... still searching.
Thanks Again, Tim
Jens Carlberg wrote:
Timothy Carroll wrote:
<snip>
If anyone has any advise on where to look or what to look for, it
would be greatly appreciated. I hate to call people out, but I did
see Mr. Petro's name on some of the DBCPDataSourceFactory code
comments. I hope he has a notion to comment (Andrew?), because I may
have some additional questions on that piece of the puzzle as well.
We had had this problem too in Java-code. In our case it looked like
this:
1. We created a Connection object that wasn't closed, to save on
overhead in creating the connection.
2. On that connection, we created Statement and PreparedStatement, that
wasn't closed after use but wasn't reused next time.
Those still open Statement objects keeps a cursor open in the database.
How do you fix something like this? There are (at least) 2 strategies
that I recommend implementing both of:
1. Use a Connection pool, get your connection from the pool, close the
connection when you're done. A good pool will close the statements for
you.
2. Find all uses of Statement et.al, and ensure they are closed in a
finally block; try { statement.close(); } catch (Exception ignore) {}
Thanks a bunch everybody...
Tim
///regards,
--
Join your friends and colleagues at JA-SIG 2008 - "Higher Education Solutions: The
Community Source Way!"
April 27th - 30th, 2008 in St. Paul, Minnesota USA
Featuring CAS, DSpace, Fedora, Fluid, Internet2, Kuali, Sakai, uPortal, and
more!
Information/Registration at:
http://www.ja-sig.org/conferences/08spring/index.html
You are currently subscribed to [email protected] as: [EMAIL
PROTECTED]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/uportal-dev
