public void setBytes(String parameterName, byte[] x) throws SQLException { checkOpen(); try { ((CallableStatement) _stmt).setBytes(parameterName, x); } catch (SQLException e) { handleException(e); } }
public void setBytes(String parameterName, byte[] x) throws SQLException { checkOpen(); try { _stmt.setBytes(parameterName, x); } catch (SQLException e) { handleException(e); } }
private static void test5116(Connection conn) throws Throwable { System.out.println("=============================================="); System.out.println("TESTING FIX OF 5116 -- VAR BIT VARYING INPUT"); System.out.println("==============================================\n"); Statement stmt = conn.createStatement(); stmt.executeUpdate( "CREATE TABLE ACTIVITY_INSTANCE_T (" + "AIID char(16) for bit data NOT NULL ," + "KIND INTEGER NOT NULL ," + "PIID char(16) for bit data NOT NULL ," + "PTID char(16) for bit data NOT NULL ," + "ATID char(16) for bit data NOT NULL ," + "RUN_MODE INTEGER NOT NULL ," + "FINISHED TIMESTAMP ," + "ACTIVATED TIMESTAMP ," + "STARTED TIMESTAMP ," + "LAST_MODIFIED TIMESTAMP ," + "LAST_STATE_CHANGE TIMESTAMP ," + "STATE INTEGER NOT NULL ," + "TRANS_COND_VALUES VARCHAR(66) FOR BIT DATA NOT NULL ," + "NUM_CONN_ACT_EVA INTEGER NOT NULL ," + "NUMBER_OF_ITERATIONS INTEGER NOT NULL ," + "NUMBER_OF_RETRIES INTEGER NOT NULL ," + "HAS_CUSTOM_ATTRIBUTES SMALLINT NOT NULL ," + "NON_BLOCK_PTID char(16) for bit data NOT NULL ," + "NON_BLOCK_PIID char(16) for bit data NOT NULL ," + "EXPIRES TIMESTAMP ," + "TASK_ID VARCHAR(254) ," + "UNHANDLED_EXCEPTION BLOB(3993600) ," + "SUB_PROCESS_PIID char(16) for bit data ," + "OWNER VARCHAR(32) ," + "USER_INPUT VARCHAR(130) FOR BIT DATA ," + "DESCRIPTION VARCHAR(254) ," + "VERSION_ID SMALLINT NOT NULL ," + "PRIMARY KEY ( AIID ) )"); stmt.execute( "CREATE PROCEDURE doInsertion(IN P1 VARCHAR(2) FOR BIT DATA) " + "EXTERNAL NAME '" + CLASS_NAME + "doInsertion'" + " MODIFIES SQL DATA LANGUAGE JAVA PARAMETER STYLE JAVA"); CallableStatement cs = conn.prepareCall("call doInsertion (?)"); cs.setNull(1, java.sql.Types.VARBINARY); cs.execute(); byte[] b = new byte[2]; b[0] = 1; b[1] = 2; cs.setBytes(1, b); cs.execute(); cs.close(); stmt.executeUpdate("DROP PROCEDURE doInsertion"); stmt.close(); }
/** Sets the bytes */ @Override public void setBytes(String parameterName, byte[] x) throws SQLException { try { _cstmt.setBytes(parameterName, x); } catch (SQLException e) { onSqlException(e); throw e; } catch (RuntimeException e) { onRuntimeException(e); throw e; } }
/** @see java.sql.PreparedStatement#setBytes(int, byte[]) */ public void setBytes(int parameterIndex, byte[] x) throws SQLException { original.setBytes(parameterIndex, x); }
/** @see java.sql.CallableStatement#setBytes(java.lang.String, byte[]) */ public void setBytes(String parameterName, byte[] x) throws SQLException { original.setBytes(parameterName, x); }
private static void callSetMethod(CallableStatement cs, int arg, int type, StringBuilder strbuf) throws Throwable { switch (type) { case Types.BIT: case Types.BOOLEAN: strbuf.append("setBoolean(" + arg + ", true)"); cs.setBoolean(arg, true); break; case Types.TINYINT: strbuf.append("setByte(" + arg + ", 6)"); cs.setByte(arg, (byte) 6); break; case Types.SMALLINT: strbuf.append("setShort(" + arg + ", 66)"); cs.setShort(arg, (short) 66); break; case Types.INTEGER: strbuf.append("setInt(" + arg + ", 666)"); cs.setInt(arg, 666); break; case Types.BIGINT: strbuf.append("setLong(" + arg + ", 666)"); cs.setLong(arg, 666); break; case Types.FLOAT: case Types.REAL: strbuf.append("setFLoat(" + arg + ", 666)"); cs.setFloat(arg, 666); break; case Types.DOUBLE: strbuf.append("setDouble(" + arg + ", 666)"); cs.setDouble(arg, 666); break; case Types.DECIMAL: case Types.NUMERIC: strbuf.append("setBigDecimal(" + arg + ", 666.666)"); BigDecimalHandler.setBigDecimalString(cs, arg, "666.666"); break; case Types.CHAR: case Types.VARCHAR: case Types.LONGVARCHAR: strbuf.append("setString(" + arg + ", \"Set via setString()\")"); cs.setString(arg, "Set via setString()"); break; case Types.BINARY: case Types.VARBINARY: case Types.LONGVARBINARY: strbuf.append("setBytes(" + arg + ", byte[])"); byte[] myarray = new byte[16]; myarray[0] = (byte) 255; cs.setBytes(arg, myarray); break; case Types.DATE: strbuf.append("setDate(" + arg + ", Date.valueOf(1999-09-09))"); cs.setDate(arg, Date.valueOf("1999-09-09")); break; case Types.TIME: strbuf.append("setTime(" + arg + ", Time.valueOf(09:09:09))"); cs.setTime(arg, Time.valueOf("09:09:09")); break; case Types.TIMESTAMP: strbuf.append("setTimestamp(" + arg + ", Timestamp.valueOf(1999-09-09 09:09:09.999))"); cs.setTimestamp(arg, Timestamp.valueOf("1999-09-09 09:09:09.999")); break; case Types.OTHER: strbuf.append("setObject(" + arg + ", new BigInteger(666))"); cs.setObject(arg, new BigInteger("666")); break; default: throw new Throwable("TEST ERROR: unexpected type " + type); } }
public void setBytes(String parameterName, byte x[]) throws SQLException { passThru.setBytes(parameterName, x); }