weird error while updating row - Mailing list pgsql-jdbc

From miguel angel rojas aquino
Subject weird error while updating row
Date
Msg-id 3ED4F4DE.4050408@mail.flashmail.com
Whole thread Raw
Responses Re: weird error while updating row  (Barry Lind <blind@xythos.com>)
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: Fernando Nasser
Date:
Subject: JDBC: Reinstate autocommit client hack for 7.4
Next
From: Fernando Nasser
Date:
Subject: JDBC: Reinstate autocommit client hack for 7.4