From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Péter Kovács <peter(dot)dunay(dot)kovacs(at)gmail(dot)com> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Inserting into time stamp columns |
Date: | 2013-06-26 14:51:33 |
Message-ID: | CADK3HHJ74PGCFvOz=zOEjTmdmduA4xm3oeD65VUqg+kW-v5oEw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
This is more an artifact of the way bound parameters are handled by the
backend. Normally we would bind this to a text type as it is a string. What
you can do is try setting stringtype = unspecified as a connection
parameter in which case it will let the server determine the type.
The docs here have more of an explanation
http://jdbc.postgresql.org/documentation/head/connect.html#connection-parameters
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Wed, Jun 26, 2013 at 10:39 AM, Péter Kovács <peter(dot)dunay(dot)kovacs(at)gmail(dot)com
> wrote:
> Hi,
>
> Consider the following simple table:
>
>
> create table tstest (ts timestamp);
>
> The following code snippet
>
> PreparedStatement pstmt = connection.prepareStatement("insert into
> tstest values(?)");
> pstmt.setObject(1, "1998-06-04 00:00:00+09");
> pstmt.execute();
>
> results in the following error:
>
> Exception in thread "main" org.postgresql.util.PSQLException: ERROR:
> column "ts" is of type timestamp without time zone but expression is of
> type character varying
>
> Hint: You will need to rewrite or cast the expression.
>
>
>
> Do I understand it correctly that it is a limitation of the JDBC driver not to implement the String -> Timestamp implicit conversion listed in Table 8.5 of this document:
>
> http://docs.oracle.com/javase/1.5.0/docs/guide/jdbc/getstart/mapping.html#1034737 ? Or is something missing in my code to get the friendly behavior of plain SQL which works with time stamp strings such as '1998-06-04 00:00:00+09 without explicit conversion?
>
>
> Many thanks
>
>
>
> Peter
>
>
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2013-06-26 15:27:12 | Re: Inserting into time stamp columns |
Previous Message | Péter Kovács | 2013-06-26 14:39:28 | Inserting into time stamp columns |