Re: problems with types after update to 8.0 - Mailing list pgsql-general

Jason Tesser wrote:
> 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

I think your previous version should work just fine.

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

Try downgrading to the previous jdbc driver and see if that works around
your problems.

--
   Richard Huxton
   Archonet Ltd