write a bytearray to an oracle db

[snoofle]

hello all,

i have a function to generate a pdf with the pdflib

byte[] bytebuffer=null;
try {
pdflib pdf = new pdflib();
pdf.open_file("");
pdf.begin_page(842,595);
PDFlibHelper.PDF_set_information(pdf);
PDFlibHelper.PDF_draw_pageheader(pdf,"","");
pdf.end_page();
pdf.close();
bytebuffer = pdf.get_buffer();

} catch (Exception e) {
e.printStackTrace();
}

then i want to store the bytebuffer = pdf.get_buffer(); into an oracle database with this script:

public final static int writeBytetoBlob(
        byte [] bytedata,
        String contenttype,
        String filename) {
        try {
     Connection connection = DataSourceConnection.getConnection("");
            connection.setAutoCommit(false);
            Blob blob = null;
            Statement statement = connection.createStatement();
            OracleResultSet resultset = null;
            OutputStream outputstream = null;
            
     statement.executeUpdate(
                "INSERT INTO MEDIA values ('1','test.pdf','application/pdf','test.pdf',empty_blob()) ");
            
                (OracleResultSet) statement.executeQuery(
                    "SELECT DATA FROM MEDIA WHERE ID='1' FOR UPDATE");
            
            resultset.next();
            BLOB blobdata = resultset.getBLOB("DATA");
            outputstream = blobdata.getBinaryOutputStream();
            outputstream.write(bytedata);
            outputstream.flush();
            outputstream.close();
            connection.commit();
            connection.setAutoCommit(true);
            connection.close();
        } catch (Exception e) {
        log4jcategory.error("sqlqueryhelper::writebytetoblob:"+e.toString());
        }
return 0;
}

when i then try to display the result with this

servlet then i get no pdf file
    public void performTask(
        javax.servlet.http.HttpServletRequest request,
        javax.servlet.http.HttpServletResponse response)
        throws javax.servlet.ServletException, IOException {
        InputStream in = null;
        Blob blob = null;
        java.sql.Connection connection = null;
        try {
            connection = DataSourceConnection.getConnection();
            Statement stmt = connection.createStatement();
            ResultSet rs =
                stmt.executeQuery("SELECT DATA,CONTENTTYPE FROM MEDIA WHERE ID=1");
            
            if (rs.next()) {
                blob = rs.getBlob(1);
                in = blob.getBinaryStream();
                response.setContentType(rs.getString(2));
            }
            OutputStream out = response.getOutputStream();
            int bufferSize = ((oracle.sql.BLOB) blob).getBufferSize();
            byte[] b = new byte[bufferSize];
            int count = in.read(b, 0, (int) bufferSize);
            int pos = 0;
            while (count != -1) {
                out.write(b, 0, count);
                pos += count;
                count = in.read(b, 0, (int) bufferSize);
            }
            out.close();
            out.flush();
            connection.close();
        } catch (Exception e) {
        } finally {
            in.close();
        }
    }

i get no pdf file displayed
has anybody an idea where my error is ?
tia
andreas spiessl

[snoofle]

hello all,
sorry wrong forum ...
should be in Oracle / OAS
andreas spiessl