Examples of java.sql.ResultSet.updateNCharacterStream()

java.sql.ResultSet.updateNCharacterStream()
Updates the designated column with a character stream value, which will have the specified number of bytes. The driver does the necessary conversion from Java character format to the national character set in the database. 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 is 2, ... @param x the new column value @param length the length of the stream @exception SQLException if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set @exception SQLFeatureNotSupportedException if the JDBC driver does not supportthis method @since 1.6

            } catch (SQLFeatureNotSupportedException ex) {


            }


            try {
                rs.updateNCharacterStream(2, null, 0);
            } catch (SQLFeatureNotSupportedException ex) {


            }
            try {
                rs.updateNCharacterStream("NAME", null, 0);

View Full Code Here

                rs.updateNCharacterStream(2, null, 0);
            } catch (SQLFeatureNotSupportedException ex) {


            }
            try {
                rs.updateNCharacterStream("NAME", null, 0);
            } catch (SQLFeatureNotSupportedException ex) {


            }


            try {

View Full Code Here

/*     */   public void updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException
/*     */   {
/* 468 */     ResultSet resultSet = getUnderlyingResultSet();
/*     */     try
/*     */     {
/* 471 */       resultSet.updateNCharacterStream(columnIndex, x, length);
/*     */     }
/*     */     catch (Throwable t)
/*     */     {
/* 475 */       throw checkException(t);
/*     */     }

View Full Code Here

/*     */   public void updateNCharacterStream(int columnIndex, Reader x) throws SQLException
/*     */   {
/* 481 */     ResultSet resultSet = getUnderlyingResultSet();
/*     */     try
/*     */     {
/* 484 */       resultSet.updateNCharacterStream(columnIndex, x);
/*     */     }
/*     */     catch (Throwable t)
/*     */     {
/* 488 */       throw checkException(t);
/*     */     }

View Full Code Here

/*     */   public void updateNCharacterStream(String columnLabel, Reader reader, long length) throws SQLException
/*     */   {
/* 494 */     ResultSet resultSet = getUnderlyingResultSet();
/*     */     try
/*     */     {
/* 497 */       resultSet.updateNCharacterStream(columnLabel, reader, length);
/*     */     }
/*     */     catch (Throwable t)
/*     */     {
/* 501 */       throw checkException(t);
/*     */     }

View Full Code Here

/*     */   public void updateNCharacterStream(String columnLabel, Reader reader) throws SQLException
/*     */   {
/* 507 */     ResultSet resultSet = getUnderlyingResultSet();
/*     */     try
/*     */     {
/* 510 */       resultSet.updateNCharacterStream(columnLabel, reader);
/*     */     }
/*     */     catch (Throwable t)
/*     */     {
/* 514 */       throw checkException(t);
/*     */     }

View Full Code Here

      pstmt1.setNCharacterStream(2, new StringReader("aaa"), 3);
      pstmt1.execute();
      Statement stmt1 = conn1.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
      ResultSet rs1 = stmt1.executeQuery("SELECT c1, c2 FROM testUpdateNCharacterStream");
      rs1.next();
      rs1.updateNCharacterStream("c2", new StringReader("bbb"), 3);
      rs1.updateRow();
      rs1.moveToInsertRow();
      rs1.updateString("c1", "2");
      rs1.updateNCharacterStream("c2", new StringReader("ccc"), 3);
      rs1.insertRow();

View Full Code Here

      rs1.next();
      rs1.updateNCharacterStream("c2", new StringReader("bbb"), 3);
      rs1.updateRow();
      rs1.moveToInsertRow();
      rs1.updateString("c1", "2");
      rs1.updateNCharacterStream("c2", new StringReader("ccc"), 3);
      rs1.insertRow();
      ResultSet rs2 = stmt1.executeQuery("SELECT c1, c2 FROM testUpdateNCharacterStream");
      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 testUpdateNCharacterStream");
      rs3.next();
      try {
          rs3.updateNCharacterStream("c2", new StringReader("bbb"), 3); // field's charset isn't utf8
          fail();
      } catch (SQLException ex) {
          assertEquals("Can not call updateNCharacterStream() when field's character set isn't UTF-8",
                  ex.getMessage());
      }

View Full Code Here

0 1 2

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.