[OpenCA-Devel] Bug #1206894, OpenCA::DBI sth caching problem (too many open cursors)

[Martin B. <vc...@cy...>]

Hi,

we were having DB problems when recreating the OpenSSL index.txt file,
Oracle would complain about "too many open cursors".

After looking at the code I found out that the DBI module caches
the STH handles for DB connections in a private array, but only the
last value of this array is actually used.
The remaining entries seem to allocate a DB handle each, which leads
to problems at least for the Oracle DB implementation.

Locally I removed the code from the DBI module and replaced the STH
caching with one single member variable which works properly for me,
as far as I can tell.

Question: should I check in the fix to CVS head and 0.9.2 branch?

Michael is on holidays, but I think the fix should be OK.

cheers

Martin