From: | "Dave Cramer" <Dave(at)micro-automation(dot)net> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | FW: [HACKERS] Failure in timestamptz of JDBC of 7.2b4 |
Date: | 2002-01-03 13:30:17 |
Message-ID: | 027d01c1945a$c8bc0fa0$8201a8c0@inspiron |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Barry,
Did you take care of this? I recall seeing some messages regarding
timestamps a few days ago
Dave
-----Original Message-----
From: pgsql-hackers-owner(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Ryouichi
Matsuda
Sent: Tuesday, December 25, 2001 3:20 AM
To: pgsql-hackers(at)postgresql(dot)org
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: [HACKERS] Failure in timestamptz of JDBC of 7.2b4
I found a failure in a JDBC driver of 7.2b4.
(1) It does not support timestamptz type
(2) Exception occurs by timestamp without time zone type
I attach a patch correcting the first failure.
You can confirm it in example.psql as follows:
---------------------------------------------------------------------
$ java -cp postgresql-examples.jar:postgresql.jar example.psql
jdbc:postgresql:r-matuda r-matuda pass PostgreSQL psql example v6.3 rev
1
Connecting to Database URL = jdbc:postgresql:r-matuda
Connected to PostgreSQL 7.2b4
[1] select 'now'::timestamp;
timestamptz
No class found for timestamptz.
[1] [1] select 'now'::timestamp with time zone;
timestamptz
No class found for timestamptz.
[1] [1] select 'now'::timestamp without time zone;
timestamp
Exception caught.
java.lang.StringIndexOutOfBoundsException: String index out of range: 26
java.lang.StringIndexOutOfBoundsException: String index out of range: 26
at java.lang.String.charAt(String.java:516)
at
org.postgresql.jdbc2.ResultSet.toTimestamp(ResultSet.java:1653)
at
org.postgresql.jdbc2.ResultSet.getTimestamp(ResultSet.java:398)
at org.postgresql.jdbc2.ResultSet.getObject(ResultSet.java:768)
at example.psql.displayResult(psql.java:137)
at example.psql.processLine(psql.java:96)
at example.psql.<init>(psql.java:62)
at example.psql.main(psql.java:227)
Attachment | Content-Type | Size |
---|---|---|
Connection.java.diff | application/octet-stream | 2.9 KB |
ATT00190.txt | text/plain | 171 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Nick Fankhauser | 2002-01-03 13:41:58 | Re: can't access database from servlet |
Previous Message | Dave Cramer | 2002-01-03 12:30:22 | Re: Unable complie jdbc |