Re: problems with types after update to 8.0

HI

<snip?>
>
> Are you sure the issue is the change from PG7.4=>PG8.0, or have you
> upgraded your jdbc package at the same time?

I have upgraded the driver to the version that matched pg 8.0

> > Here is my prepared statment in my java class
> >
> >   private static final String MANUALINSERT =
> >       "insert into pactime (datetimein, pacpayperiodlink, wslink,
> > deptlink, commment, type) " +
> >       "values ?,?,?,?,?,'man') ";
>
> > and here si the way to fix but there are too many queires to have to
> > change them all.
> >
> >   private static final String MANUALINSERT =
> >       "insert into pactime (datetimein, pacpayperiodlink, wslink,
> > deptlink, commment, type) " +
> >       "values (cast(? as timestamp),?,?,?,?,'man') ";
>
> > here is where I am executing the statement in java
> >
> >         stmt = con.prepareStatement(DATEOUTUPDATE);
> >         stmt.setString(1, dateout);
> >         stmt.setString(2, comment);
> >         stmt.setString(3, pactimeid);
>
> Hmm - should this not be something like:
>    stmt.setTimestamp(1,dateout) / stmt.setDateTime(1,dateout)

That would be a better :-)  way to do it but for now I am just trying to
deal with the code that is there :-)