Thread: weird error while updating row

weird error while updating row

From
miguel angel rojas aquino
Date:
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


Re: weird error while updating row

From
Barry Lind
Date:
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
>