Thread: weird error while updating row
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
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 >