Re: weird error while updating row
От | Barry Lind |
---|---|
Тема | Re: weird error while updating row |
Дата | |
Msg-id | 3EDFF0EB.9040702@xythos.com обсуждение исходный текст |
Ответ на | weird error while updating row (miguel angel rojas aquino <mrojas_aquino@mail.flashmail.com>) |
Список | pgsql-jdbc |
Miguel, Is there a test case you could submit that reproduces the problem? Something else you might want to try is to turn on debug logging for the connection to see if any more useful information is produced. You can do this by adding "?loglevel=2" to the end of the jdbc connection URL. thanks, --Barry miguel angel rojas aquino wrote: > hi, i'm getting this exception: > > java.sql.Exception: 1 >= 1 > > while invoking the ResultSet's updateRowMethod. > > this is my code: > -------------------------------------------------------------------------- > rsGlAccount.updateString(GlAccount.getBDescription(), f.getDescription()); > rsGlAccount.updateString(GlAccount.getBShortDesc(), > f.getShortDesc()); > rsGlAccount.updateString(GlAccount.getBType(), f.getType()); > rsGlAccount.updateString(GlAccount.getBDrIndicator(), > (f.getDrIndicator())); > rsGlAccount.updateString(GlAccount.getBCtaMayor(), > (f.getCtaMayor() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBCommable(), > (f.getCommable() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBKeepSaleSt(), > (f.getKeepSaleSt() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBFsCode(), > f.getFsCode()); > rsGlAccount.updateString(GlAccount.getBCategCode(), > f.getCategCode()); > rsGlAccount.updateString(GlAccount.getBValidEntity(), > f.getValidEntity()); > rsGlAccount.updateString(GlAccount.getBAllowAr(), > (f.getAllowAr() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBAllowAp(), > (f.getAllowAp() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBAllowIn(), > (f.getAllowIn() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBAllowFa(), > (f.getAllowFa() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBAllowGl(), > (f.getAllowGl() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBActive(), > (f.getActive() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBAllowAppl1(), > (f.getAllowAppl1() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBAllowAppl2(), > (f.getAllowAppl2() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBAllowAppl3(), > (f.getAllowAppl3() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBAllowAppl4(), > (f.getAllowAppl4() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBAllowAppl5(), > (f.getAllowAppl5() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBAllowCp(), > (f.getAllowCp() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBTransfer(), > (f.getTransfer() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBAllowQty(), > (f.getAllowQty() ? "S" : "N")); > rsGlAccount.updateString(GlAccount.getBConvert(), > (f.getConvert() ? "S" : "N")); > rsGlAccount.updateRow(); > -------------------------------------------------------------------------- > > and bang, it throws the exception, the funny thing is that the record is > updated in the database, i'm trying to figure what is causing the error, > but i've no success, so any help would be greatly appreciated. > > i'm using struts 1.0.2, tomcat 4.1.12 jbuilder 8, postgresql > 7.1.3-4bp.2, the pg73jdbc73.jar on redhat linux 7.2 > > thanks in advance and best regards > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
В списке pgsql-jdbc по дате отправления:
Следующее
От: Barry LindДата:
Сообщение: Re: Bad External Date Representation error for any date which