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