Re: Failure in timestamptz of JDBC of 7.2b4

From: Ryouichi Matsuda <r-matuda(at)sra(dot)co(dot)jp>
To: barry(at)xythos(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Failure in timestamptz of JDBC of 7.2b4
Date: 2002-01-15 10:41:31
Message-ID: 20020115192158.771C.R-MATUDA@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

I wrote:
> In addition, I found an error of time type.
>
> Statement st = db.createStatement();
> ResultSet rs = st.executeQuery("SELECT 'now'::time");
> rs.next();
> Time t = rs.getTime(1);
> System.out.println(t);
>
> This becomes string index out of bounds exception.

An attached patch corrects this error.

But time is always local time zone.
In this patch, time zone does not look.

Attachment Content-Type Size
TimeTest.java application/octet-stream 1.7 KB
jdbc1.ResultSet.java.diff application/octet-stream 1.7 KB
jdbc2.ResultSet.java.diff application/octet-stream 1.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin Sherry 2002-01-15 10:44:02 Re: FATAL 1: Relation 'pg_shadow' does not exist
Previous Message Peter Galbavy 2002-01-15 10:14:19 Ignorance time: when is 7.2 due ?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Alaric B. Snell 2002-01-15 10:42:30 Explicit typing of numeric types
Previous Message Vianen, Jeroen van 2002-01-15 08:49:52 Re: Problem with getImportedKeys / getExportedKeys