Java Code Examples for java.sql.CallableStatement#getBlob()
The following examples show how to use
java.sql.CallableStatement#getBlob() .
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
| Source File: EXTDTAInputStream.java From gemfirexd-oss with Apache License 2.0 | 6 votes |
|
/**
* Create a new EXTDTAInputStream from a CallableStatement.
*
*
* @param cs
* CallableStatement from which to retrieve the lob
* @param column
* column number
* @param drdaType
* FD:OCA type of object one of
* DRDAConstants.DRDA_TYPE_NLOBBYTES
* DRDAConstants.DRDA_TYPE_LOBBYTES
* DRDAConstants.DRDA_TYPE_NLOBCMIXED
* DRDAConstants.DRDA_TYPE_LOBCMIXED
*/
public static EXTDTAInputStream getEXTDTAStream(CallableStatement cs, int column, int drdaType)
throws SQLException
{
int ndrdaType = drdaType | 1; //nullable drdaType
switch ( ndrdaType )
{
case DRDAConstants.DRDA_TYPE_NLOBBYTES:
Blob blob = cs.getBlob( column );
if ( blob == null ) { return null; }
return new EXTDTAInputStream( blob, ndrdaType );
case DRDAConstants.DRDA_TYPE_NLOBCMIXED:
Clob clob = cs.getClob( column );
if ( clob == null ) { return null; }
return new EXTDTAInputStream( clob, ndrdaType );
default:
badDRDAType( ndrdaType );
return null;
}
}
Example 2
| Source File: EXTDTAInputStream.java From gemfirexd-oss with Apache License 2.0 | 6 votes |
|
/**
* Create a new EXTDTAInputStream from a CallableStatement.
*
*
* @param cs
* CallableStatement from which to retrieve the lob
* @param column
* column number
* @param drdaType
* FD:OCA type of object one of
* DRDAConstants.DRDA_TYPE_NLOBBYTES
* DRDAConstants.DRDA_TYPE_LOBBYTES
* DRDAConstants.DRDA_TYPE_NLOBCMIXED
* DRDAConstants.DRDA_TYPE_LOBCMIXED
*/
public static EXTDTAInputStream getEXTDTAStream(CallableStatement cs, int column, int drdaType)
throws SQLException
{
int ndrdaType = drdaType | 1; //nullable drdaType
switch ( ndrdaType )
{
case DRDAConstants.DRDA_TYPE_NLOBBYTES:
Blob blob = cs.getBlob( column );
if ( blob == null ) { return null; }
return new EXTDTAInputStream( blob, ndrdaType );
case DRDAConstants.DRDA_TYPE_NLOBCMIXED:
Clob clob = cs.getClob( column );
if ( clob == null ) { return null; }
return new EXTDTAInputStream( clob, ndrdaType );
default:
badDRDAType( ndrdaType );
return null;
}
}
Example 3
| Source File: EXTDTAInputStream.java From spliceengine with GNU Affero General Public License v3.0 | 6 votes |
|
/**
* Create a new EXTDTAInputStream from a CallableStatement.
*
*
* @param cs
* CallableStatement from which to retrieve the lob
* @param column
* column number
* @param drdaType
* FD:OCA type of object one of
* DRDAConstants.DRDA_TYPE_NLOBBYTES
* DRDAConstants.DRDA_TYPE_LOBBYTES
* DRDAConstants.DRDA_TYPE_NLOBCMIXED
* DRDAConstants.DRDA_TYPE_LOBCMIXED
*/
public static EXTDTAInputStream getEXTDTAStream(CallableStatement cs, int column, int drdaType)
throws SQLException
{
int ndrdaType = drdaType | 1; //nullable drdaType
switch ( ndrdaType )
{
case DRDAConstants.DRDA_TYPE_NLOBBYTES:
Blob blob = cs.getBlob( column );
if ( blob == null ) { return null; }
return new EXTDTAInputStream( blob, ndrdaType );
case DRDAConstants.DRDA_TYPE_NLOBCMIXED:
Clob clob = cs.getClob( column );
if ( clob == null ) { return null; }
return new EXTDTAInputStream( clob, ndrdaType );
default:
badDRDAType( ndrdaType );
return null;
}
}
Example 4
| Source File: BlobTypeHandler.java From tangyuan2 with GNU General Public License v3.0 | 5 votes |
|
@Override
public byte[] getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
Blob blob = cs.getBlob(columnIndex);
byte[] returnValue = null;
if (null != blob) {
returnValue = blob.getBytes(1, (int) blob.length());
}
return returnValue;
}
Example 5
| Source File: BlobTypeHandler.java From mybaties with Apache License 2.0 | 5 votes |
|
@Override
public byte[] getNullableResult(CallableStatement cs, int columnIndex)
throws SQLException {
Blob blob = cs.getBlob(columnIndex);
byte[] returnValue = null;
if (null != blob) {
returnValue = blob.getBytes(1, (int) blob.length());
}
return returnValue;
}
Example 6
| Source File: BlobTypeHandler.java From mybatis with Apache License 2.0 | 5 votes |
|
@Override
public byte[] getNullableResult(CallableStatement cs, int columnIndex)
throws SQLException {
Blob blob = cs.getBlob(columnIndex);
byte[] returnValue = null;
if (null != blob) {
returnValue = blob.getBytes(1, (int) blob.length());
}
return returnValue;
}
Example 7
| Source File: ProcedureTest.java From spliceengine with GNU Affero General Public License v3.0 | 5 votes |
|
/**
* Test that a call to getBlob() to retrieve the value of a non-BLOB
* parameter fails with the expected SQLException. Used to throw
* ClassCastException, see DERBY-4970.
*/
public void testGetBlobFromIntParameter() throws SQLException {
CallableStatement cs = prepareCall("call int_out(?)");
cs.registerOutParameter(1, Types.INTEGER);
cs.execute();
try {
cs.getBlob(1);
fail("getBlob() on int parameter expected to fail");
} catch (SQLException sqle) {
assertSQLState("22005", sqle);
}
}
Example 8
| Source File: SQLQuery.java From micro-integrator with Apache License 2.0 | 4 votes |
|
private ParamValue getOutparameterValue(CallableStatement cs, String type, int ordinal)
throws DataServiceFault {
try {
Object elementValue;
if (type.equals(DBConstants.DataTypes.STRING)) {
elementValue = cs.getString(ordinal);
return new ParamValue(elementValue == null ? null : elementValue.toString());
} else if (type.equals(DBConstants.DataTypes.DOUBLE)) {
elementValue = cs.getDouble(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Double) elementValue));
} else if (type.equals(DBConstants.DataTypes.BIGINT)) {
elementValue = cs.getLong(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Long) elementValue));
} else if (type.equals(DBConstants.DataTypes.INTEGER)) {
elementValue = cs.getInt(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Integer) elementValue));
} else if (type.equals(DBConstants.DataTypes.TIME)) {
elementValue = cs.getTime(ordinal);
return new ParamValue(elementValue == null ? null
: this.convertToTimeString((Time) elementValue));
} else if (type.equals(DBConstants.DataTypes.DATE)) {
elementValue = cs.getDate(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Date) elementValue));
} else if (type.equals(DBConstants.DataTypes.TIMESTAMP)) {
if (timeConvertEnabled) {
elementValue = cs.getTimestamp(ordinal, calendar);
} else {
elementValue = cs.getTimestamp(ordinal);
}
return new ParamValue(elementValue == null ? null
: this.convertToTimestampString((Timestamp) elementValue));
} else if (type.equals(DBConstants.DataTypes.BLOB)) {
elementValue = cs.getBlob(ordinal);
return new ParamValue(elementValue == null ? null
: this.getBase64StringFromInputStream(((Blob) elementValue)
.getBinaryStream()));
} else if (type.equals(DBConstants.DataTypes.CLOB)) {
elementValue = cs.getClob(ordinal);
return new ParamValue(elementValue == null ? null :
deriveValueFromClob((Clob) elementValue));
} else if (type.equals(DBConstants.DataTypes.STRUCT)) {
elementValue = cs.getObject(ordinal);
return new ParamValue(elementValue == null ? null : (Struct) elementValue);
} else if (type.equals(DBConstants.DataTypes.ARRAY)) {
Array dataArray = cs.getArray(ordinal);
ParamValue paramValue = new ParamValue(ParamValue.PARAM_VALUE_ARRAY);
if (dataArray != null) {
this.processSQLArray(dataArray, paramValue);
}
return paramValue;
} else if (type.equals(DBConstants.DataTypes.NUMERIC)) {
elementValue = cs.getBigDecimal(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((BigDecimal) elementValue));
} else if (type.equals(DBConstants.DataTypes.BIT)) {
elementValue = cs.getBoolean(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Boolean) elementValue));
} else if (type.equals(DBConstants.DataTypes.TINYINT)) {
elementValue = cs.getByte(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Byte) elementValue));
} else if (type.equals(DBConstants.DataTypes.SMALLINT)) {
elementValue = cs.getShort(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Short) elementValue));
} else if (type.equals(DBConstants.DataTypes.REAL)) {
elementValue = cs.getFloat(ordinal);
return new ParamValue(elementValue == null ? null
: ConverterUtil.convertToString((Float) elementValue));
} else if (type.equals(DBConstants.DataTypes.BINARY)) {
elementValue = cs.getBlob(ordinal);
return new ParamValue(elementValue == null ? null
: this.getBase64StringFromInputStream(((Blob) elementValue)
.getBinaryStream()));
} else {
throw new DataServiceFault("Unsupported data type: " + type);
}
} catch (SQLException e) {
throw new DataServiceFault(e, "Error in getting sql output parameter values.");
}
}
Example 9
| Source File: ParameterMappingTest.java From gemfirexd-oss with Apache License 2.0 | 4 votes |
|
/**
* Verify correct mapping of blobs.
*/
public void testBlobMapping() throws Exception
{
Connection conn = getConnection();
PreparedStatement ps;
CallableStatement cs;
Blob outVal;
//
// Blob input parameter
//
ps = chattyPrepare
(
conn,
"create procedure blobIn\n" +
"( in c blob, out result varchar( 100 ) )\n" +
"language java\n" +
"parameter style java\n" +
"no sql\n" +
"external name '" + getClass().getName() + ".blobIn'\n"
);
ps.execute();
ps.close();
cs = chattyPrepareCall( conn, "call blobIn( ?, ? )" );
cs.setBlob( 1, new StringColumnVTI.SimpleBlob( "ghi".getBytes( UTF8 ) ) );
cs.registerOutParameter( 2, Types.VARCHAR );
cs.execute();
assertEquals( "ghi", cs.getString( 2 ) );
cs.close();
//
// Blob output parameter
//
ps = chattyPrepare
(
conn,
"create procedure blobOut\n" +
"( out c blob )\n" +
"language java\n" +
"parameter style java\n" +
"no sql\n" +
"external name '" + getClass().getName() + ".blobOut'\n"
);
ps.execute();
ps.close();
cs = chattyPrepareCall( conn, "call blobOut( ? )" );
cs.registerOutParameter( 1, Types.BLOB );
cs.execute();
outVal = cs.getBlob( 1 );
assertEquals( "abc", getBlobValue( outVal ) );
cs.close();
//
// Blob inout parameter
//
ps = chattyPrepare
(
conn,
"create procedure blobInOut\n" +
"( inout c blob )\n" +
"language java\n" +
"parameter style java\n" +
"no sql\n" +
"external name '" + getClass().getName() + ".blobInOut'\n"
);
ps.execute();
ps.close();
cs = chattyPrepareCall( conn, "call blobInOut( ? )" );
cs.setBlob( 1, new StringColumnVTI.SimpleBlob( "ghi".getBytes( UTF8 ) ) );
cs.registerOutParameter( 1, Types.BLOB );
cs.execute();
outVal = cs.getBlob( 1 );
assertEquals( "ihg", getBlobValue( outVal ) );
Blob inValue = makeBigBlob();
cs.setBlob( 1, inValue );
cs.execute();
Blob outValue = cs.getBlob( 1 );
compareBlobs( inValue, outValue );
cs.close();
}
Example 10
| Source File: ParameterMappingTest.java From gemfirexd-oss with Apache License 2.0 | 4 votes |
|
/**
* Verify correct mapping of blobs.
*/
public void testBlobMapping() throws Exception
{
Connection conn = getConnection();
PreparedStatement ps;
CallableStatement cs;
Blob outVal;
//
// Blob input parameter
//
ps = chattyPrepare
(
conn,
"create procedure blobIn\n" +
"( in c blob, out result varchar( 100 ) )\n" +
"language java\n" +
"parameter style java\n" +
"no sql\n" +
"external name '" + getClass().getName() + ".blobIn'\n"
);
ps.execute();
ps.close();
cs = chattyPrepareCall( conn, "call blobIn( ?, ? )" );
cs.setBlob( 1, new StringColumnVTI.SimpleBlob( "ghi".getBytes( UTF8 ) ) );
cs.registerOutParameter( 2, Types.VARCHAR );
cs.execute();
assertEquals( "ghi", cs.getString( 2 ) );
cs.close();
//
// Blob output parameter
//
ps = chattyPrepare
(
conn,
"create procedure blobOut\n" +
"( out c blob )\n" +
"language java\n" +
"parameter style java\n" +
"no sql\n" +
"external name '" + getClass().getName() + ".blobOut'\n"
);
ps.execute();
ps.close();
cs = chattyPrepareCall( conn, "call blobOut( ? )" );
cs.registerOutParameter( 1, Types.BLOB );
cs.execute();
outVal = cs.getBlob( 1 );
assertEquals( "abc", getBlobValue( outVal ) );
cs.close();
//
// Blob inout parameter
//
ps = chattyPrepare
(
conn,
"create procedure blobInOut\n" +
"( inout c blob )\n" +
"language java\n" +
"parameter style java\n" +
"no sql\n" +
"external name '" + getClass().getName() + ".blobInOut'\n"
);
ps.execute();
ps.close();
cs = chattyPrepareCall( conn, "call blobInOut( ? )" );
cs.setBlob( 1, new StringColumnVTI.SimpleBlob( "ghi".getBytes( UTF8 ) ) );
cs.registerOutParameter( 1, Types.BLOB );
cs.execute();
outVal = cs.getBlob( 1 );
assertEquals( "ihg", getBlobValue( outVal ) );
Blob inValue = makeBigBlob();
cs.setBlob( 1, inValue );
cs.execute();
Blob outValue = cs.getBlob( 1 );
compareBlobs( inValue, outValue );
cs.close();
}
Example 11
| Source File: InnerCallableStatementGetter.java From hasor with Apache License 2.0 | 4 votes |
|
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
| Source File: ParameterMappingTest.java From spliceengine with GNU Affero General Public License v3.0 | 4 votes |
|
/**
* Verify correct mapping of blobs.
*/
public void testBlobMapping() throws Exception
{
Connection conn = getConnection();
PreparedStatement ps;
CallableStatement cs;
Blob outVal;
//
// Blob input parameter
//
ps = chattyPrepare
(
conn,
"create procedure blobIn\n" +
"( in c blob, out result varchar( 100 ) )\n" +
"language java\n" +
"parameter style java\n" +
"no sql\n" +
"external name '" + getClass().getName() + ".blobIn'\n"
);
ps.execute();
ps.close();
cs = chattyPrepareCall( conn, "call blobIn( ?, ? )" );
cs.setBlob( 1, new HarmonySerialBlob( "ghi".getBytes( UTF8 ) ) );
cs.registerOutParameter( 2, Types.VARCHAR );
cs.execute();
assertEquals( "ghi", cs.getString( 2 ) );
cs.close();
//
// Blob output parameter
//
ps = chattyPrepare
(
conn,
"create procedure blobOut\n" +
"( out c blob )\n" +
"language java\n" +
"parameter style java\n" +
"no sql\n" +
"external name '" + getClass().getName() + ".blobOut'\n"
);
ps.execute();
ps.close();
cs = chattyPrepareCall( conn, "call blobOut( ? )" );
cs.registerOutParameter( 1, Types.BLOB );
cs.execute();
outVal = cs.getBlob( 1 );
assertEquals( "abc", getBlobValue( outVal ) );
cs.close();
//
// Blob inout parameter
//
ps = chattyPrepare
(
conn,
"create procedure blobInOut\n" +
"( inout c blob )\n" +
"language java\n" +
"parameter style java\n" +
"no sql\n" +
"external name '" + getClass().getName() + ".blobInOut'\n"
);
ps.execute();
ps.close();
cs = chattyPrepareCall( conn, "call blobInOut( ? )" );
cs.setBlob( 1, new HarmonySerialBlob( "ghi".getBytes( UTF8 ) ) );
cs.registerOutParameter( 1, Types.BLOB );
cs.execute();
outVal = cs.getBlob( 1 );
assertEquals( "ihg", getBlobValue( outVal ) );
Blob inValue = makeBigBlob();
cs.setBlob( 1, inValue );
cs.execute();
Blob outValue = cs.getBlob( 1 );
compareBlobs( inValue, outValue );
cs.close();
}
