Re: [Pgjdbc-commit] By jurka: Add some more synchronization - Mailing list pgsql-jdbc

On Mon, 22 May 2006, Markus Schaber wrote:

>>      // pgname (String) -> java.sql.Types (Integer)
>> -    private Map _pgNameToSQLType;
>> +    private static final Map _pgNameToSQLType;
>
> Are you shure this should be static, and not per connection?
>
> AFAICS, it is possible to have two connections to different databases
> having different extension types installed, leading to conflicting maps.
>

This maps betweeen a pg type name like varchar and a java.sql.Types value
like Types.VARCHAR.  There is a hardcoded list of pg types that the driver
knows about and can assign a Types value.  For types the driver doesn't
know anything about, all it can say is that it is Types.OTHER.  Note also
that in initialization it does:

_pgNameToSQLType = Collections.unmodifiableMap(pgNameToSQLType);

So there's no way it can get bad information into it.

Kris Jurka