Examples of java.sql.ResultSet.updateNString()

java.sql.ResultSet.updateNString()
Updates the designated column with a String value. It is intended for use when updating NCHAR,NVARCHAR and LONGNVARCHAR columns. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. @param columnIndex the first column is 1, the second 2, ... @param nString the value for the column to be updated @throws SQLException if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; the result set concurrency is CONCUR_READ_ONLY or if a database access error occurs @exception SQLFeatureNotSupportedException if the JDBC driver does not supportthis method @since 1.6

   public void updateNString(int columnIndex, String string) throws SQLException
   {
      ResultSet resultSet = getUnderlyingResultSet();
      try
      {
         resultSet.updateNString(columnIndex, string);
      }
      catch (Throwable t)
      {
         throw checkException(t);
      }

View Full Code Here

   public void updateNString(String columnLabel, String string) throws SQLException
   {
      ResultSet resultSet = getUnderlyingResultSet();
      try
      {
         resultSet.updateNString(columnLabel, string);
      }
      catch (Throwable t)
      {
         throw checkException(t);
      }

View Full Code Here

      pstmt1.setNString(2, "aaa");
      pstmt1.execute();
      Statement stmt1 = conn1.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
      ResultSet rs1 = stmt1.executeQuery("SELECT c1, c2 FROM testUpdateNString");
      rs1.next();
      rs1.updateNString("c2", "bbb");
      rs1.updateRow();
      rs1.moveToInsertRow();
      rs1.updateString("c1", "2");
      rs1.updateNString("c2", "ccc");
      rs1.insertRow();

View Full Code Here

      rs1.next();
      rs1.updateNString("c2", "bbb");
      rs1.updateRow();
      rs1.moveToInsertRow();
      rs1.updateString("c1", "2");
      rs1.updateNString("c2", "ccc");
      rs1.insertRow();
      ResultSet rs2 = stmt1.executeQuery("SELECT c1, c2 FROM testUpdateNString");
      rs2.next();
      assertEquals("1", rs2.getString("c1"));
      assertEquals("bbb", rs2.getNString("c2"));

View Full Code Here

      pstmt2.execute();
      Statement stmt2 = conn2.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
      ResultSet rs3 = stmt2.executeQuery("SELECT c1, c2 FROM testUpdateNString");
      rs3.next();
      try {
          rs3.updateNString("c2", "bbb"); // field's charset isn't utf8
          fail();
      } catch (SQLException ex) {
          assertEquals("Can not call updateNString() when field's character set isn't UTF-8",
                  ex.getMessage());
      }

View Full Code Here

   public void updateNString(int columnIndex, String string) throws SQLException
   {
      ResultSet resultSet = getUnderlyingResultSet();
      try
      {
         resultSet.updateNString(columnIndex, string);
      }
      catch (Throwable t)
      {
         throw checkException(t);
      }

View Full Code Here

   public void updateNString(String columnLabel, String string) throws SQLException
   {
      ResultSet resultSet = getUnderlyingResultSet();
      try
      {
         resultSet.updateNString(columnLabel, string);
      }
      catch (Throwable t)
      {
         throw checkException(t);
      }

View Full Code Here

            if (spy)
                spyLogger.debugf("%s [%s] updateNString(%s, %s)",
                        jndiName, Constants.SPY_LOGGER_PREFIX_RESULTSET,
                        columnIndex, string);


            resultSet.updateNString(columnIndex, string);
        } catch (Throwable t) {
            throw checkException(t);
        }
    }

View Full Code Here

            if (spy)
                spyLogger.debugf("%s [%s] updateNString(%s, %s)",
                        jndiName, Constants.SPY_LOGGER_PREFIX_RESULTSET,
                        columnLabel, string);


            resultSet.updateNString(columnLabel, string);
        } catch (Throwable t) {
            throw checkException(t);
        }
    }

View Full Code Here

      pstmt1.setNString(2, "aaa");
      pstmt1.execute();
      Statement stmt1 = conn1.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
      ResultSet rs1 = stmt1.executeQuery("SELECT c1, c2 FROM testUpdateNString");
      rs1.next();
      rs1.updateNString("c2", "bbb");
      rs1.updateRow();
      rs1.moveToInsertRow();
      rs1.updateString("c1", "2");
      rs1.updateNString("c2", "ccc");
      rs1.insertRow();

View Full Code Here

0 1

TOP

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.