Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] Re: [INTERFACES] Patch for JDBC timestamp problems

From: Michael Stephenson <mstephenson(at)tirin(dot)openworld(dot)co(dot)uk>
To: PostgreSQL jdbc list <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [PATCHES] Re: [INTERFACES] Patch for JDBC timestamp problems
Date: 2001-01-25 09:54:41
Message-ID: Pine.LNX.4.30.0101250949190.20707-100000@tirin.openworld.co.uk (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-jdbcpgsql-patches
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
   better performance.

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

Responses

pgsql-patches by date

Next:From: Dave PageDate: 2001-01-25 11:23:27
Subject: Yet another ODBC patch!
Previous:From: Hiroshi InoueDate: 2001-01-25 06:02:11
Subject: Re: RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows

pgsql-interfaces by date

Next:From: Dave PageDate: 2001-01-25 10:40:45
Subject: RE: RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows
Previous:From: clemens schmuckDate: 2001-01-25 08:26:52
Subject: all groups a user belongs to

pgsql-jdbc by date

Next:From: Michael StephensonDate: 2001-01-25 10:25:59
Subject: RE: Re: Postgresql JDBC driver - Support for Scrollable Re sult Sets
Previous:From: Peter T MountDate: 2001-01-25 09:26:03
Subject: Re: [GENERAL] jdbc driver, error trapping.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group