Re: problems with types after update to 8.0
От | Jason Tesser |
---|---|
Тема | Re: problems with types after update to 8.0 |
Дата | |
Msg-id | 1119358580.5337.5.camel@jtessermain обсуждение исходный текст |
Ответ на | Re: problems with types after update to 8.0 (Richard Huxton <dev@archonet.com>) |
Ответы |
Re: problems with types after update to 8.0
|
Список | pgsql-general |
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 :-)
В списке pgsql-general по дате отправления: