List of usage examples for javax.sql.rowset.serial SerialBlob SerialBlob
public SerialBlob(Blob blob) throws SerialException, SQLException
SerialBlob
object that is a serialized version of the given Blob
object. 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; }