Re: [OJB-developers] Open prepared statements

[Thomas M. <tho...@ho...>]

Hi Ranjan,

Ranjan Bagchi wrote:

> Hi --
> 
> 	Since I'm new, I want to say that I'm quite impressed by
> objectbridge:  it's certainly easing a lot of the tedium of writing jdbc
> applications.  Congrats, really!
> 


thanks !


<snip> 
> 	Doing some investigation, I found that a prepared statement for
> each E2 was being created, but they weren't being closed.  I put a quick
> patch into ojb.broker.accesslayer.JdbcAccess to cache prepared statements,
> and close them when the RsIterator is cleaning up.
> 
> 	This solves the immediate problem, but it isn't a long term fix.
> 
> 	Has this been experienced before?  


Yes, this is a known bug that is already fixed. Will be contained in the 
next release!

 Can I configure things differently so
> I don't need the code change?
> 



No, there is not much to configure here. OJB just must handle this 
correctly!


HTH,


Thomas