On Wed, 24 Jan 2001, Joseph Shraibman wrote:
> > What was the conclusion of this discussion? Do we leave it static?
> No, it cannot be static.
As I see it we have three possible solutions to this problems.
a) Just stop it being static, each PreparedStatement gets a new
instantiation (I think this is what we've done for now).
b) static ThreadLocal, each Thread gets one instantiation.
c) An Object Pool (possibly using SoftReferences to stop memory bloat),
slightly more difficult to code, a lot less instantiations, much
If people agree that either 'b' or 'c' is a better solution, I'll go ahead
and implement it.
Michael Stephenson mstephenson(at)openworld(dot)co(dot)uk
Developer - Web Applications - Open World
Tel: +44 1225 444 950 Fax: +44 1225 336 738
In response to
pgsql-patches by date
|Next:||From: Dave Page||Date: 2001-01-25 11:23:27|
|Subject: Yet another ODBC patch!|
|Previous:||From: Hiroshi Inoue||Date: 2001-01-25 06:02:11|
|Subject: Re: RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows|
pgsql-interfaces by date
|Next:||From: Dave Page||Date: 2001-01-25 10:40:45|
|Subject: RE: RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows|
|Previous:||From: clemens schmuck||Date: 2001-01-25 08:26:52|
|Subject: all groups a user belongs to|
pgsql-jdbc by date
|Next:||From: Michael Stephenson||Date: 2001-01-25 10:25:59|
|Subject: RE: Re: Postgresql JDBC driver - Support for Scrollable Re
|Previous:||From: Peter T Mount||Date: 2001-01-25 09:26:03|
|Subject: Re: [GENERAL] jdbc driver, error trapping.|