Example usage for javax.sql.rowset.serial SerialBlob SerialBlob

List of usage examples for javax.sql.rowset.serial SerialBlob SerialBlob

Introduction

In this page you can find the example usage for javax.sql.rowset.serial SerialBlob SerialBlob.

Prototype

public SerialBlob(Blob blob) throws SerialException, SQLException 

Source Link

Document

Constructs a SerialBlob object that is a serialized version of the given Blob object.

Usage

From source file:org.xenei.jdbc4sparql.iface.TypeConverter.java

private static <T> T fromNumber(final Object columnObject, final Class<T> resultingClass) throws SQLException {
    final Number n = Number.class.cast(columnObject);
    if (resultingClass == BigDecimal.class) {
        return resultingClass.cast(new BigDecimal(n.toString()));
    }/* w  w w . j  a  v  a2  s.co m*/
    if (resultingClass == BigInteger.class) {
        return resultingClass.cast(new BigInteger(n.toString()));
    }
    if (resultingClass == Byte.class) {
        return resultingClass.cast(new Byte(n.byteValue()));
    }
    if (resultingClass == Double.class) {
        return resultingClass.cast(new Double(n.doubleValue()));
    }
    if (resultingClass == Float.class) {
        return resultingClass.cast(new Float(n.floatValue()));
    }
    if (resultingClass == Integer.class) {
        return resultingClass.cast(new Integer(n.intValue()));
    }
    if (resultingClass == Long.class) {
        return resultingClass.cast(new Long(n.longValue()));
    }
    if (resultingClass == Short.class) {
        return resultingClass.cast(new Short(n.shortValue()));
    }
    if (resultingClass == String.class) {
        return resultingClass.cast(n.toString());
    }
    if (resultingClass == Boolean.class) {
        if (n.byteValue() == 0) {
            return resultingClass.cast(Boolean.FALSE);
        }
        if (n.byteValue() == 1) {
            return resultingClass.cast(Boolean.TRUE);
        }
    }
    if (resultingClass == byte[].class) {
        return resultingClass.cast(n.toString().getBytes());
    }
    if (resultingClass == Blob.class) {
        return resultingClass.cast(new SerialBlob(n.toString().getBytes()));
    }
    if (resultingClass == Clob.class) {
        return resultingClass.cast(new SerialClob(n.toString().toCharArray()));
    }
    return null;
}

From source file:org.xenei.jdbc4sparql.iface.TypeConverter.java

private static <T> T fromString(final Object columnObject, final Class<T> resultingClass) throws SQLException {
    final String val = String.class.cast(columnObject);
    // to numeric casts
    try {//from www  .j a  v  a 2s .  c  o m
        if (resultingClass == BigDecimal.class) {
            return resultingClass.cast(new BigDecimal(val));
        }
        if (resultingClass == BigInteger.class) {
            return resultingClass.cast(new BigInteger(val));
        }
        if (resultingClass == Byte.class) {
            return resultingClass.cast(new Byte(val));
        }
        if (resultingClass == Double.class) {
            return resultingClass.cast(new Double(val));
        }
        if (resultingClass == Float.class) {
            return resultingClass.cast(new Float(val));
        }
        if (resultingClass == Integer.class) {
            return resultingClass.cast(new Integer(val));
        }
        if (resultingClass == Long.class) {
            return resultingClass.cast(new Long(val));
        }
        if (resultingClass == Short.class) {
            return resultingClass.cast(new Short(val));
        }
    } catch (final NumberFormatException e) {
        return null;
    }

    if (resultingClass == Boolean.class) {
        if ("0".equals(val)) {
            return resultingClass.cast(Boolean.FALSE);
        }
        if ("1".equals(val)) {
            return resultingClass.cast(Boolean.TRUE);
        }
    }
    if (resultingClass == byte[].class) {
        return resultingClass.cast(val.getBytes());
    }
    if (resultingClass == Blob.class) {
        return resultingClass.cast(new SerialBlob(val.getBytes()));
    }
    if (resultingClass == Clob.class) {
        return resultingClass.cast(new SerialClob(val.toCharArray()));
    }
    return null;
}

From source file:procuradoria.pdf.util.DocumentsPdf.java

public static Boolean SaveDocument(Uzatdocs docs, InputStream pdfBytes) {
    Boolean exito = false;/*  ww w  .  j  a  v a  2s .  c  o m*/
    try {
        byte[] bFile = IOUtils.toByteArray(pdfBytes);
        java.sql.Blob blob = null;
        blob = new SerialBlob(bFile);
        docs.setUzatdocsArchivo(blob);
        exito = ProcuradoriaMethods.InsertDocs(docs);
    } catch (IOException ex) {
        log.level.info(">> IO PDF: " + ex.getMessage());
    } catch (SQLException ex) {
        log.level.info(">> SQL PDF: " + ex.getMessage());
    }
    return exito;
}

From source file:procuradoria.pdf.util.DocumentsPdf.java

public static Boolean CovertPdfToByteArray(Uzatdocs docs, String Url, InputStream input) {

    FileInputStream in = null;//from w w  w.j ava2s .c o m
    File file = new File(Url);
    byte[] bFile = new byte[(int) file.length()];
    FileInputStream fileInputStream;
    Boolean exito = false;

    try {
        fileInputStream = new FileInputStream(file);
        fileInputStream.read(bFile);
        fileInputStream.close();
        java.sql.Blob blob = null;
        blob = new SerialBlob(bFile);
        docs.setUzatdocsArchivo(blob);
        exito = ProcuradoriaMethods.InsertDocs(docs);

    } catch (FileNotFoundException ex) {
        log.level.info(">> FileNotFoundException " + ex.getMessage());
    } catch (IOException ex) {
        log.level.info(">> IOExceptionn " + ex.getMessage());
    } catch (SQLException ex) {
        log.level.info(">> SQLException " + ex.getMessage());
    }

    return exito;
}

From source file:procuradoria.pdf.util.DocumentsPdf.java

public static Boolean CovertPdfToByteArray(Uzatdocs docs, InputStream in) {
    try {/*from ww w.j  a va 2 s.  c  o m*/
        File file = null;
        byte[] bFile = new byte[(int) file.length()];
        byte[] list = IOUtils.toByteArray(in);
        FileInputStream fileInputStream;
        Boolean exito = false;

        fileInputStream = new FileInputStream(file);
        fileInputStream.read(bFile);
        fileInputStream.close();
        java.sql.Blob blob = null;
        blob = new SerialBlob(bFile);
        docs.setUzatdocsArchivo(blob);
        exito = ProcuradoriaMethods.InsertDocs(docs);

        return exito;

    } catch (IOException ex) {
        log.level.info(">> IOException " + ex.getMessage());
    } catch (SQLException ex) {
        log.level.info(">> SQLException " + ex.getMessage());
    }
    return null;
}

From source file:se.unlogic.hierarchy.foregroundmodules.imagegallery.GalleryModule.java

protected Picture createThumbs(String filename, Gallery gallery) throws SQLException, IOException {

    log.info("Creating thumbs for picture " + filename + " in gallery " + gallery);

    Picture picture = new Picture();

    BufferedImage image = ImageUtils.getImage(gallery.getUrl() + File.separator + filename);

    BufferedImage smallImage = ImageUtils.scaleImage(image, this.smallImageMaxHeight, this.smallImageMaxWidth,
            thumbQuality, BufferedImage.TYPE_INT_RGB);
    BufferedImage mediumImage = ImageUtils.scaleImage(image, this.mediumImageMaxHeight,
            this.mediumImageMaxWidth, thumbQuality, BufferedImage.TYPE_INT_RGB);

    ByteArrayOutputStream smallThumbStream = new ByteArrayOutputStream();

    ImageIO.write(smallImage, "jpg", smallThumbStream);

    byte[] smallThumbByteArray = smallThumbStream.toByteArray();

    ByteArrayOutputStream mediumThumbStream = new ByteArrayOutputStream();

    ImageIO.write(mediumImage, "jpg", mediumThumbStream);

    byte[] mediumThumbByteArray = mediumThumbStream.toByteArray();

    picture.setSmallThumb(new SerialBlob(smallThumbByteArray));
    picture.setMediumThumb(new SerialBlob(mediumThumbByteArray));

    picture.setFilename(filename);/*from  w w  w  .j a va  2s.c  om*/
    picture.setGalleryID(gallery.getGalleryID());

    pictureDao.set(picture);

    return picture;
}