Java Code Examples for java.sql.ResultSet.getAsciiStream()

'Inserting BLOB Values with SQL INSERT Statements' tutorial was cited in a article in 2018.

The Inserting BLOB Values with SQL INSERT Statements tutorial was cited in a article in 2018.

Subject: Java Code Examples for java.sql.ResultSet.getAsciiStream()
Date: Feb 6, 2018

The following are Jave code examples for showing how to use
getAsciiStream() of the java.sql.ResultSet class. You can vote up the
examples you like. Your votes will be used in our system to get more good

Example 1

protected String getResultAsEscapedString( ResultSet resultSet,
   int index, String columnTypeName ) throws SQLException,
   IOException {

    String value;
    Object valueAsObject = resultSet.getObject(index);
    if (valueAsObject == null) {
        return null;
    if (valueAsObject != null &&
        valueAsObject.getClass().isArray()) {
        if (! (valueAsObject instanceof byte[])) {
            // FIXME other array types might be needed to be tracked
            // in a different way
            log.warn("Array type that needs attention");
        // we have an array of primitive data type
        InputStream is = null;
        try {
            is = resultSet.getAsciiStream(index);
            value = IoUtils.streamToString(is);
        } finally {
    } else if (valueAsObject instanceof Blob) {
        // we have a blob
        log.debug("Blob detected. Will try to dump as hex");
        Blob blobValue = (Blob) valueAsObject;
        InputStream blobInputStream = blobValue.getBinaryStream();
        StringBuilder hexString = new StringBuilder();

        //read the binary data from the stream and convert it to hex
        // according to the sample from
        // - see 3 variants for Oracle, MsSQL and MySQL
        hexString = addBinDataAsHexAndCloseStream
           (hexString, blobInputStream);
        value = hexString.toString();
    } else {

Table of Contents

 About This Book

 Reference Citations in 2020

 Reference Citations in 2019

Reference Citations in 2018

 WSDL (วิสเด้าว์) เอกสารส่งข้อมูลของ Web Service (เว็บ เซอร์วิส)

 Properly using .bind() in React...

 XML 파일 보는 방법

Java Code Examples for java.sql.ResultSet.getAsciiStream()

 Optimized Hybrid Security Model using Base 64 Algorithm

 Locking Rows In MYSQL

 Algoritmat Kriptografike dhe Siguria

 C# (CSharp) RSAPublicKey Examples

 Google Play Games Services works...

 【CTF】SUCTF 2018 部分web writeup

 FISCO-BCOS - client.keystore Generation

 Secure Hashing Algorithm

 DARE Algorithm: A New Security Protocol


 Labeless Part 5: Decrypt Strings in Boleto Banking Malware

 Agregator internetskih radijskih postaja

 openssl 설정 pem 생성 - 프로그래밍 방식으로 SSL 인증서 확인

 security - https - java 서버가 tls 1.2 만 받아들이고

 WSDL 2.0文档示例

 Reference Citations in 2017

 Reference Citations in 2016

 Reference Citations in 2015

 Reference Citations in 2014

 Reference Citations in 2013

 Reference Citations in 2012

 Reference Citations in 2011

 Reference Citations in 2010

 Reference Citations in 2009

 Reference Citations in 2008

 Reference Citations in 2007

 Reference Citations in 2006

 Reference Citations in 2005

 Reference Citations in 2004

 Reference Citations in 2003