Java Code Examples for java.sql.CallableStatement#getBytes()

The following examples show how to use java.sql.CallableStatement#getBytes() . These examples are extracted from open source projects. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
/**
 * test the BLOBGETBYTES stored procedure which will
 * be used in the implementation of Blob.getBytes.
 * @throws UnsupportedEncodingException 
 *
 * @throws a SQLException.
 */
public void testBlobGetBytesSP() throws SQLException, UnsupportedEncodingException {
    // This string represents the substring that is got from the
    // stored procedure
    String testSubStr = testStr.substring(0, 10);
    byte [] testSubBytes = testSubStr.getBytes("US-ASCII");

    //create a callable statement and execute it to call the stored
    //procedure BLOBGETBYTES that will get the bytes
    //inserted into the Blob in the setup method.
    CallableStatement cs  = prepareCall
        ("? = CALL SYSIBM.BLOBGETBYTES(?,?,?)");
    cs.registerOutParameter(1, java.sql.Types.VARBINARY);
    cs.setInt(2, 1);
    cs.setLong(3, 1);
    //set the length of the bytes returned as 10.
    cs.setInt(4, 10);
    cs.executeUpdate();
    byte [] retVal = cs.getBytes(1);

    for (int i=0;i<10;i++){
        assertEquals
            ("The Stored procedure SYSIBM.BLOBGETBYTES " +
            "returns the wrong bytes"
            , testSubBytes[i], retVal[i]);
    }
    cs.close();
}
 
Example 2
/**
 * test the BLOBGETBYTES stored procedure which will
 * be used in the implementation of Blob.getBytes.
 * @throws UnsupportedEncodingException 
 *
 * @throws a SQLException.
 */
public void testBlobGetBytesSP() throws SQLException, UnsupportedEncodingException {
    // This string represents the substring that is got from the
    // stored procedure
    String testSubStr = testStr.substring(0, 10);
    byte [] testSubBytes = testSubStr.getBytes("US-ASCII");

    //create a callable statement and execute it to call the stored
    //procedure BLOBGETBYTES that will get the bytes
    //inserted into the Blob in the setup method.
    CallableStatement cs  = prepareCall
        ("? = CALL SYSIBM.BLOBGETBYTES(?,?,?)");
    cs.registerOutParameter(1, java.sql.Types.VARBINARY);
    cs.setInt(2, 1);
    cs.setLong(3, 1);
    //set the length of the bytes returned as 10.
    cs.setInt(4, 10);
    cs.executeUpdate();
    byte [] retVal = cs.getBytes(1);

    for (int i=0;i<10;i++){
        assertEquals
            ("The Stored procedure SYSIBM.BLOBGETBYTES " +
            "returns the wrong bytes"
            , testSubBytes[i], retVal[i]);
    }
    cs.close();
}
 
Example 3
@Override
public void setJetel(CallableStatement statement) throws SQLException {
          byte[] i = statement.getBytes(fieldSQL);
          if (statement.wasNull()) {
              ((ByteDataField) field).setValue((Object)null);
          } else {
              ((ByteDataField) field).setValue(i);
          }
      }
 
Example 4
/**
 * test the BLOBGETBYTES stored procedure which will
 * be used in the implementation of Blob.getBytes.
 * @throws UnsupportedEncodingException 
 *
 * @throws a SQLException.
 */
public void testBlobGetBytesSP() throws SQLException, UnsupportedEncodingException {
    // This string represents the substring that is got from the
    // stored procedure
    String testSubStr = testStr.substring(0, 10);
    byte [] testSubBytes = testSubStr.getBytes("US-ASCII");

    //create a callable statement and execute it to call the stored
    //procedure BLOBGETBYTES that will get the bytes
    //inserted into the Blob in the setup method.
    CallableStatement cs  = prepareCall
        ("? = CALL SYSIBM.BLOBGETBYTES(?,?,?)");
    cs.registerOutParameter(1, java.sql.Types.VARBINARY);
    cs.setInt(2, 1);
    cs.setLong(3, 1);
    //set the length of the bytes returned as 10.
    cs.setInt(4, 10);
    cs.executeUpdate();
    byte [] retVal = cs.getBytes(1);

    for (int i=0;i<10;i++){
        assertEquals
            ("The Stored procedure SYSIBM.BLOBGETBYTES " +
            "returns the wrong bytes"
            , testSubBytes[i], retVal[i]);
    }
    cs.close();
}
 
Example 5
@Override
public Byte[] getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
	byte[] bytes = cs.getBytes(columnIndex);
	return getBytes(bytes);
}
 
Example 6
@Override
public byte[] getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
	return cs.getBytes(columnIndex);
}
 
Example 7
/**
 * Tests the stored procedure SYSIBM.BLOBSETBYTES
 * @throws UnsupportedEncodingException 
 *
 * @throws SQLException.
 */
public void testBlobSetBytes() throws SQLException, UnsupportedEncodingException {
    String newString = "123456789012345";
    byte [] newBytes = newString.getBytes("US-ASCII");
    //initialize the locator to a default value.
    int locator = -1;
    //call the stored procedure to return the created locator.
    CallableStatement cs  = prepareCall
        ("? = CALL SYSIBM.BLOBCREATELOCATOR()");
    cs.registerOutParameter(1, java.sql.Types.INTEGER);
    cs.executeUpdate();
    locator = cs.getInt(1);
    cs.close();

    //use this new locator to test the SETBYTES function
    //by inserting the new bytes and testing whether it has
    //been inserted properly.

    //Insert the new substring.
    cs  = prepareCall("CALL SYSIBM.BLOBSETBYTES(?,?,?,?)");
    cs.setInt(1, locator);
    cs.setLong(2, 1L);
    cs.setInt(3, newString.length());
    cs.setBytes(4, newBytes);
    cs.execute();
    cs.close();

    //check the new locator to see if the value has been inserted correctly.
    cs  = prepareCall("? = CALL " +
        "SYSIBM.BLOBGETBYTES(?,?,?)");
    cs.registerOutParameter(1, java.sql.Types.VARBINARY);
    cs.setInt(2, locator);
    cs.setLong(3, 1);
    cs.setInt(4, newString.length());
    cs.executeUpdate();
    byte [] retVal = cs.getBytes(1);
    //compare the new bytes and the bytes returned by the stored
    //procedure to see of they are the same.
    for (int i=0;i<newString.length();i++){
        assertEquals
            ("The Stored procedure SYSIBM.BLOBGETBYTES " +
            "returns the wrong bytes"
            , newBytes[i], retVal[i]);
    }
    cs.close();
}
 
Example 8
@Override
public Byte[] getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
  byte[] bytes = cs.getBytes(columnIndex);
  return getBytes(bytes);
}
 
Example 9
Source Project: mybaties   File: ByteArrayTypeHandler.java    License: Apache License 2.0 4 votes vote down vote up
@Override
public byte[] getNullableResult(CallableStatement cs, int columnIndex)
    throws SQLException {
  return cs.getBytes(columnIndex);
}
 
Example 10
/**
 * Tests the stored procedure SYSIBM.BLOBSETBYTES
 * @throws UnsupportedEncodingException 
 *
 * @throws SQLException.
 */
public void testBlobSetBytes() throws SQLException, UnsupportedEncodingException {
    String newString = "123456789012345";
    byte [] newBytes = newString.getBytes("US-ASCII");
    //initialize the locator to a default value.
    int locator = -1;
    //call the stored procedure to return the created locator.
    CallableStatement cs  = prepareCall
        ("? = CALL SYSIBM.BLOBCREATELOCATOR()");
    cs.registerOutParameter(1, java.sql.Types.INTEGER);
    cs.executeUpdate();
    locator = cs.getInt(1);
    cs.close();

    //use this new locator to test the SETBYTES function
    //by inserting the new bytes and testing whether it has
    //been inserted properly.

    //Insert the new substring.
    cs  = prepareCall("CALL SYSIBM.BLOBSETBYTES(?,?,?,?)");
    cs.setInt(1, locator);
    cs.setLong(2, 1L);
    cs.setInt(3, newString.length());
    cs.setBytes(4, newBytes);
    cs.execute();
    cs.close();

    //check the new locator to see if the value has been inserted correctly.
    cs  = prepareCall("? = CALL " +
        "SYSIBM.BLOBGETBYTES(?,?,?)");
    cs.registerOutParameter(1, java.sql.Types.VARBINARY);
    cs.setInt(2, locator);
    cs.setLong(3, 1);
    cs.setInt(4, newString.length());
    cs.executeUpdate();
    byte [] retVal = cs.getBytes(1);
    //compare the new bytes and the bytes returned by the stored
    //procedure to see of they are the same.
    for (int i=0;i<newString.length();i++){
        assertEquals
            ("The Stored procedure SYSIBM.BLOBGETBYTES " +
            "returns the wrong bytes"
            , newBytes[i], retVal[i]);
    }
    cs.close();
}
 
Example 11
public static Object getValue(final CallableStatement cs, final int index, Class<?> requiredType) throws SQLException {
    Object value = null;
    boolean wasNullCheck = false;
    if (requiredType == null) {
        return cs.getObject(index);
    }
    requiredType = primitiveToWrapper(requiredType);
    // Explicitly extract typed value, as far as possible.
    if (String.class.equals(requiredType)) {
        value = cs.getString(index);
    } else if (Integer.class.equals(requiredType)) {
        value = cs.getInt(index);
        wasNullCheck = true;
    } else if (Double.class.equals(requiredType)) {
        value = cs.getDouble(index);
        wasNullCheck = true;
    } else if (Boolean.class.equals(requiredType)) {
        value = cs.getBoolean(index) ? Boolean.TRUE : Boolean.FALSE;
        wasNullCheck = true;
    } else if (java.sql.Date.class.equals(requiredType)) {
        value = cs.getDate(index);
    } else if (java.sql.Time.class.equals(requiredType)) {
        value = cs.getTime(index);
    } else if (java.sql.Timestamp.class.equals(requiredType)) {
        value = cs.getTimestamp(index);
    } else if (java.util.Date.class.equals(requiredType)) {
        value = new java.util.Date(cs.getTimestamp(index).getTime());
    } else if (Byte.class.equals(requiredType)) {
        value = cs.getByte(index);
        wasNullCheck = true;
    } else if (Short.class.equals(requiredType)) {
        value = cs.getShort(index);
        wasNullCheck = true;
    } else if (Long.class.equals(requiredType)) {
        value = cs.getLong(index);
        wasNullCheck = true;
    } else if (Float.class.equals(requiredType)) {
        value = cs.getFloat(index);
        wasNullCheck = true;
    } else if (Number.class.equals(requiredType)) {
        value = cs.getDouble(index);
        wasNullCheck = true;
    } else if (byte[].class.equals(requiredType)) {
        value = cs.getBytes(index);
    } else if (java.math.BigDecimal.class.equals(requiredType)) {
        value = cs.getBigDecimal(index);
    } else if (java.sql.Blob.class.equals(requiredType)) {
        value = cs.getBlob(index);
    } else if (java.sql.Clob.class.equals(requiredType)) {
        value = cs.getClob(index);
    } else if (java.net.URL.class.equals(requiredType)) {
        value = cs.getURL(index);
    } else {
        // Some unknown type desired -> rely on getObject.
        value = cs.getObject(index);
    }
    // Perform was-null check if demanded (for results that the JDBC driver returns as primitives).
    if (wasNullCheck && value != null && cs.wasNull()) {
        value = null;
    }
    return value;
}
 
Example 12
@Override
public Object getDbValue(CallableStatement statement)
		throws SQLException {
          byte[] i = statement.getBytes(fieldSQL);
	return statement.wasNull() ? null : i;
}
 
Example 13
@Override
public Byte[] getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
  byte[] bytes = cs.getBytes(columnIndex);
  return getBytes(bytes);
}
 
Example 14
Source Project: mybatis   File: ByteArrayTypeHandler.java    License: Apache License 2.0 4 votes vote down vote up
@Override
public byte[] getNullableResult(CallableStatement cs, int columnIndex)
    throws SQLException {
  return cs.getBytes(columnIndex);
}
 
Example 15
/**
 * Tests the stored procedure SYSIBM.BLOBSETBYTES
 * @throws UnsupportedEncodingException 
 *
 * @throws SQLException.
 */
public void testBlobSetBytes() throws SQLException, UnsupportedEncodingException {
    String newString = "123456789012345";
    byte [] newBytes = newString.getBytes("US-ASCII");
    //initialize the locator to a default value.
    int locator = -1;
    //call the stored procedure to return the created locator.
    CallableStatement cs  = prepareCall
        ("? = CALL SYSIBM.BLOBCREATELOCATOR()");
    cs.registerOutParameter(1, java.sql.Types.INTEGER);
    cs.executeUpdate();
    locator = cs.getInt(1);
    cs.close();

    //use this new locator to test the SETBYTES function
    //by inserting the new bytes and testing whether it has
    //been inserted properly.

    //Insert the new substring.
    cs  = prepareCall("CALL SYSIBM.BLOBSETBYTES(?,?,?,?)");
    cs.setInt(1, locator);
    cs.setLong(2, 1L);
    cs.setInt(3, newString.length());
    cs.setBytes(4, newBytes);
    cs.execute();
    cs.close();

    //check the new locator to see if the value has been inserted correctly.
    cs  = prepareCall("? = CALL " +
        "SYSIBM.BLOBGETBYTES(?,?,?)");
    cs.registerOutParameter(1, java.sql.Types.VARBINARY);
    cs.setInt(2, locator);
    cs.setLong(3, 1);
    cs.setInt(4, newString.length());
    cs.executeUpdate();
    byte [] retVal = cs.getBytes(1);
    //compare the new bytes and the bytes returned by the stored
    //procedure to see of they are the same.
    for (int i=0;i<newString.length();i++){
        assertEquals
            ("The Stored procedure SYSIBM.BLOBGETBYTES " +
            "returns the wrong bytes"
            , newBytes[i], retVal[i]);
    }
    cs.close();
}