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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
