[Squirrel-sql-users] Displaying Oracle TIMESTAMPTZ columns

[John B. <Joh...@is...>]

I'm using v2.4, running on Linux w/JDK 1.5 to access an Oracle 9i databas=
e
that has TIMESTAMPTZ columns (declared as "TIMESTAMP WITH TIME ZONE"). Th=
e
results page, however, shows any of these column values as
"<Unknown(-101)>".

When I look at the metadata for the query, the getColumnType is returning
-101 for these, and getColumnTypeName is returning "TIMESTAMPTZ".

I installed the Oracle plugin with SQuirrel SQL, and am using the Oracle
Thin driver for 10g (oracle-jdbc-thin-10.1.0.2-g.jar), the same driver we
are using in our application code to go against this database. I've tried
changing the Global Preferences settings for "Data Type Controls" for the
Timestamp fields, but none seem to have any effect.

Any tips or clues appreciated.
John