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