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 :-)