following Amad Fida's code:
<!-- in sqlmapconfig.xml-->
<typeAlias alias="ByteArrayHandler" type="MyBlobTypeHandlerCallback" />
<!-- for insert handler. '[B' is byte array class type name -->
<typeHandler javaType="[B" callback="ByteArrayHandler" />
<!-- in your mapping -->
<resultMap id="queryRs">
<rseult property="BlobProp"
column="BlobColumn" typeHandler="ByteArrayHandler"/>
</resultMap>
<select id="query" parameterClass="java.util.HashMap" resultMap="queryRs">
select BlobColumn from table
</select>
i'am using like this.
On Thu, 3 Feb 2005 18:11:33 -0800, Amad Fida <[EMAIL PROTECTED]> wrote:
> This is something i have been using and works fine for me.
>
> public class MyBlobTypeHandlerCallback implements TypeHandlerCallback {
>
> private static final byte BLOB_NULL = 127;
> private static byte[] blobNull = null;
>
> public Object getResult(ResultGetter getter) throws SQLException {
> byte[] bytes = null;
> InputStream is = null;
> ByteArrayOutputStream bos = null;
> try {
> is = getter.getBlob().getBinaryStream();
> if (is != null) {
> bos = new ByteArrayOutputStream();
> byte[] buffer = new byte[1024];
> int bytesRead = is.read(buffer);
> while (bytesRead >= 0) {
> if (bytesRead > 0) {
> bos.write(buffer, 0, bytesRead);
> }
> bytesRead = is.read(buffer);
> }
> bos.flush();
> bytes = bos.toByteArray();
> if (isBlobNull(bytes)) {
> bytes = null;
> }
> }
> }
> catch (Exception ex) {
> throw new SQLException("Unable to read the blob: " +
> ex.toString());
> }
> finally {
> FileUtil.closeStream(is);
> FileUtil.closeStream(bos);
> }
> return bytes;
> }
>
> public void setParameter(ParameterSetter setter, Object parameter)
> throws SQLException {
> byte[] bytes = (byte[])parameter;
> if (bytes == null) {
> bytes = getBlobNull();
> }
> setter.setBinaryStream(new ByteArrayInputStream(bytes), bytes.length);
> }
>
> public Object valueOf(String s) {
> return s;
> }
>
> /**
> * Determines if the blob actually represent a null.
> */
> private boolean isBlobNull(byte[] bytes) {
> return bytes != null && bytes.length == 1 && bytes[0] == BLOB_NULL;
> }
>
> /**
> * Gets the blob that represent a null.
> */
> private byte[] getBlobNull() {
> if (blobNull == null) {
> byte[] bn = new byte[1];
> bn[0] = BLOB_NULL;
> blobNull = bn;
> }
> return blobNull;
> }
>
> }
>
> On Thu, 3 Feb 2005 17:42:54 -0800, Tony Li <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > Hi all â
> >
> >
> >
> > I'm having trouble using the default BLOB/CLOB handlers in 2.0.9 w/ DB2 v
> > 8.1. Using SqlMap, I can read the BLOBs into a byte[] by specifying
> > jdbcType="BLOB", but I can't write that byte[] back out in a mapped INSERT
> > statement.
> >
> >
> >
> > I keep reading in the archives about a solution through the use of custom
> > type handlers. Sounds like something I should try, but I can't access that
> > .zip example (it was removed by Clinton I think) or find any other
> > documentation or better yet, an example of a custom type handler. Can
> > anyone point me in the right direction?
> >
> >
> >
> > Thanks,
> >
> > Tony
>
> --
> Amad Fida
>
--
äåå
[EMAIL PROTECTED]
[EMAIL PROTECTED]
