Re: [JDBC] Prepared statement performance... - Mailing list pgsql-general

From Barry Lind
Subject Re: [JDBC] Prepared statement performance...
Date
Msg-id 3D94AE0B.2000200@xythos.com
Whole thread Raw
In response to Prepared statement performance...  (Dmitry Tkach <dmitry@openratings.com>)
Responses Re: [JDBC] Prepared statement performance...
List pgsql-general
Dimtry,



Dmitry Tkach wrote:

> Not realy... You should not be required to know about postgres date
> format, as long as it matches Timestamp.toString () output (and it
> currently does), and I
> see no reason why it would not (you just need to make sure that the
> client and the server are in the same locale, but that's a different
> discussion, because whatever
> JDBC does in setTimestamp () would locale-dependent anyway).

This certainly isn't true for all databases.  Oracle for example where
the database format for dates is DD-MON-YY which is very different from
the Timestamp.toString() method.  And actually the postgres format is
different and incompatible with javas format when you start having to
deal with timezone information.

thanks,
--Barry



pgsql-general by date:

Previous
From: Barry Lind
Date:
Subject: Re: [JDBC] Prepared statement performance...
Next
From: Barry Lind
Date:
Subject: Re: [JDBC] Prepared statement performance...