Re: setString and timestamps

From: David Goodenough <david(dot)goodenough(at)btconnect(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: setString and timestamps
Date: 2006-02-21 09:55:45
Message-ID: 200602210955.45502.david.goodenough@btconnect.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Monday 20 February 2006 17:42, Kris Jurka wrote:
> On Mon, 20 Feb 2006, David Goodenough wrote:
> > What is the best way of finding the column types in generic code. That
> > is to say if I have a method with no knowledge of a specific table and I
> > am about to do an insert and I wish to get the parameters in the correct
> > format what APIs exist that allow me to find out the type of a named
> > column. I have looked through the JDBC docs without success so far, but
> > it may be that I am looking for the wrong thing. If I need to use a
> > Postgresql only API that is fine.
>
> DatabaseMetaData.getColumns or PreparedStatement.getParameterMetaData are
> probably what you're looking for.
>
> Kris Jurka
PreparedStatement.getParameterMetaData was the one I wanted. My copy of
Java Enterprise in a Nutshell is too old, I must get a new one.

Thank you

David

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Marc Herbert 2006-02-21 10:21:59 Re: PreparedStatement clearParameters
Previous Message Kris Jurka 2006-02-21 01:42:48 Re: PreparedStatement clearParameters