Hi folks

I'm trying to update a BLOB column in this way...

public boolean saveBlob(String pUpdate, String pData)
{
boolean retValue = false;
PreparedStatement stmt = null;
try
{
InputStream in = new ByteArrayInputStream(pData.getBytes());
stmt = connection.prepareStatement(pUpdate);
stmt.setBlob(1,in);
stmt.executeQuery();
retValue = true;
in = null;
}
catch(SQLException e)
{
retValue = false;
System.out.println(e);
}
finally
{
stmt = null;
return retValue;
}
}

I'm calling this method in this way..

d.saveBlob("update table set data = ? where id = 2435", " .... data .....");

I got very rare behavior into the method. When the line statement stmt.setBlob(1,in); is executed the instruction pointer jump to the finally block without an exception. I don't understand what's happening here...

I will appreciate any kind of help about this behavior.

Leo