Re: EOF and 2 x Database Connections
Re: EOF and 2 x Database Connections
- Subject: Re: EOF and 2 x Database Connections
- From: Andrew Lindesay <email@hidden>
- Date: Sun, 4 Jul 2010 21:18:38 +1200
Hi Mike;
Thanks -- I was looking at the framework "EOAdaptors/JavaERJDBCAdaptor" and missed the "ERExtensions" material! Without jumping through too many hoops, is it necessary to make a new framework to subclass JDBCAdaptor in a usable manner?
cheers
> Actually that's not the part I meant... It does two things. One is that it does a connection pool, but that isn't the patch. The patch is the thing that disconnects the cached context. There's a bug in the superclass that leaves a connection open after a call to typeInfo (and jdbcInfo). It's only about 6 lines of fix in there to prevent the problem.
...
>>> It may be in erxjdbcchannel ........ I don't have the code in front of me at the moment. Search the source for _cachedContext.
...
>> Thanks again Mike; I see from PW code that the solution to this is to subvert EOF's own management of database connections by supplying the system with a connection from a connection pool each time it needs one. Looks good, but requires ERExtensions so I'll probably leave it and put up with the wasted connection per instance for the time-being.
___
Andrew Lindesay
www.silvereye.co.nz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden