java insert Blob as ByteArrayOutputStream get ClassCastException

Question

I've to save a pdf file represented as a ByteArrayOutputStream into a Blob SQL field of a table, here's my code:

public boolean savePDF(int version, ByteArrayOutputStream baos) throws Exception{
    boolean completed = false;
    ConnectionManager conn = new ConnectionManager();
    try {
        PreparedStatement statement = conn.getConnection().prepareStatement(INSERT_PDF);
        statement.setLong(1, version);
        statement.setBlob(2, (Blob)baos);           
        statement.execute();
        conn.commit();
        completed = true;
    } catch (SQLException e) {
        conn.rollbackQuietly();
        e.printStackTrace();
        throw e;
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }finally{
        conn.close();
    }                           
    return completed;       
}

But I get a java.lang.ClassCastException:

java.io.ByteArrayOutputStream cannot be cast to java.sql.Blob

How can I manage that? Thanks

Ian Roberts · Accepted Answer · 2012-11-08 17:01:55Z

2

There is a setBlob that takes an InputStream, so

ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
statement.setBlob(2, bais);

answered Nov 8, 2012 at 17:01

Ian Roberts

123k17 gold badges177 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Yogendra Singh · Accepted Answer · 2012-11-08 17:02:40Z

2

You can't cast ByteArrayOutputStream to Blob. Try creating the Blob instance as below:

  SerialBlob blob = new SerialBlob(baos.toByteArray());

and then

  statement.setBlob(2, blob);

answered Nov 8, 2012 at 17:02

Yogendra Singh

34.5k7 gold badges66 silver badges73 bronze badges

Collectives™ on Stack Overflow

java insert Blob as ByteArrayOutputStream get ClassCastException

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related