Package java.sql

Examples of java.sql.ResultSet.updateRow()

257
258
259
260
261
262
263
264
265
266
267
      oRnxt = oSnxt.executeQuery();
      bNext = oRnxt.next();
      if (bNext) {
        iNextQuotation = oRnxt.getInt(1);
        oRnxt.updateInt(DB.pg_quotation, ++iNextQuotation);
        oRnxt.updateRow();
      }
      oRnxt.close();
      oRnxt=null;
      oSnxt.close();
      oSnxt=null;
View Full Code Here
635
636
637
638
639
640
641
642
643
644
645
      oRnxt = oSnxt.executeQuery();
      bNext = oRnxt.next();
      if (bNext) {
        iNextDispatch = oRnxt.getInt(1);
        oRnxt.updateInt(DB.pg_despatch, ++iNextDispatch);
        oRnxt.updateRow();
      }
      oRnxt.close();
      oRnxt=null;
      oSnxt.close();
      oSnxt=null;
View Full Code Here
895
896
897
898
899
900
901
902
903
904
905
      oRnxt = oSnxt.executeQuery();
      bNext = oRnxt.next();
      if (bNext) {
        iNextInvoic = oRnxt.getInt(1);
        oRnxt.updateInt(DB.pg_invoice, ++iNextInvoic);
        oRnxt.updateRow();
      }
      oRnxt.close();
      oRnxt=null;
      oSnxt.close();
      oSnxt=null;
View Full Code Here
5116
5117
5118
5119
5120
5121
5122
5123
5124
5125
5126
            Blob blob = res.getBlob(1);
            OutputStream os = blob.setBinaryStream(1);
            copy(is, os);
            os.close();
            res.updateBlob(1, blob);
            res.updateRow();

        } catch (IOException ioe) {
            throw new StoreException(ioe);
        } finally {
            if (res != null)
View Full Code Here
5151
5152
5153
5154
5155
5156
5157
5158
5159
5160
5161
            if (clob != null) {
                Writer writer = clob.setCharacterStream(1);
                copy(reader, writer);
                writer.close();
                res.updateClob(1, clob);
                res.updateRow();
            }

        } catch (IOException ioe) {
            throw new StoreException(ioe);
        } finally {
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
                    lazyLoadedValue.updateValue(resultSet, columnIndex, (String) userValue);
                } else {
                    dataType.setValueToResultSet(resultSet, columnIndex, userValue);
                }

                if (!row.isInsert()) resultSet.updateRow();
            } catch (Exception e) {
                DatasetEditorError error = new DatasetEditorError(getConnectionHandler(), e);

                // error may affect other cells in the row (e.g. foreign key constraint for multiple primary key)
                if (e instanceof SQLException) getRow().notifyError(error, false, !bulk);
View Full Code Here
5080
5081
5082
5083
5084
5085
5086
5087
5088
5089
5090
            Blob blob = res.getBlob(1);
            OutputStream os = blob.setBinaryStream(1);
            copy(is, os);
            os.close();
            res.updateBlob(1, blob);
            res.updateRow();

        } catch (IOException ioe) {
            throw new StoreException(ioe);
        } finally {
            if (res != null)
View Full Code Here
5115
5116
5117
5118
5119
5120
5121
5122
5123
5124
5125
            if (clob != null) {
                Writer writer = clob.setCharacterStream(1);
                copy(reader, writer);
                writer.close();
                res.updateClob(1, clob);
                res.updateRow();
            }

        } catch (IOException ioe) {
            throw new StoreException(ioe);
        } finally {
View Full Code Here
298
299
300
301
302
303
304
305
306
307
308
        println("T1: Read first Tuple:(" + rs.getInt(1) + "," +
                rs.getInt(2) + "," +
                rs.getInt(3) + ")");
        rs.updateInt(2, 3);
        println("T1: updateInt(2, 3);");
        rs.updateRow();
        println("T1: updateRow()");
        rs.last(); // Go to last tuple
        println("T1: Read last Tuple:(" + rs.getInt(1) + "," +
                rs.getInt(2) + "," +
                rs.getInt(3) + ")");
View Full Code Here
306
307
308
309
310
311
312
313
314
315
316
        println("T1: Read last Tuple:(" + rs.getInt(1) + "," +
                rs.getInt(2) + "," +
                rs.getInt(3) + ")");
        rs.updateInt(2, 3);
        println("T1: updateInt(2, 3);");
        rs.updateRow();
        println("T1: updateRow()");
        commit();
        println("T1: commit");
        rs = s.executeQuery("select * from t1");
        println("T3: select * from table");
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.