write a bytearray to an oracle db

[snoofle]

hello all,
i have a big problem with writing a bytearray to an oracle db and display it via a servlet
i have a function to generate a pdf with the pdflib

  
byte[] bytebuffer=null;
try {
pdflib pdf = new pdflib();
pdf.open_file("tt.pdf");
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 displayed

  
    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();
        }
    }

has anybody an idea where my error is ?
tia
andreas spiessl

[Rene Larsen]

Hi
You can read this post: https://coderanch.com/t/297456/JDBC/java/Retreiving-image-JDBC
/Rene

[snoofle]

hello rene, hello all
i have tried it with the code and no pdf file is displayed.
i have test my loading servlet with the database an i function, so now i think the error must be in

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;
}

has anybody an idea
tia
andreas spiessl
[ June 19, 2002: Message edited by: andreas spiessl ]

[Beksy Kurian]

Could you insert the pdf files in the database successfully?
Try to get the size of the blob and match it with the actual file and make sure that it is loaded properly.
What version of adobe acrobat are you using? I had several problems displaying the pdf files on the browser, especially with some versions of IE. Have you tried to refresh the browser? I am using bfiles instead of blob to store the pdf files. If you like I can give my code to display the pdf files in the browser.
Regards
Beksy
[ June 19, 2002: Message edited by: Beksy Kurian ]

[Rene Larsen]

Hi
This is the way I saves a byte[] in a Blob:

Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery("select .......");
BLOB writeBlob = null;
if (rs.next()) {
   writeBlob = (BLOB) rs.getBlob(1);
}
byte[] data = ObjectConverter.toByteArray(askTreeBean);
OutputStream outStream = writeBlob.getBinaryOutputStream();
outStream.write(data);
outStream.close();
outStream = null;
con.commit();

I do not use the Oracle Blob (getBLOB() is from Oracle and getBlob() is standard) and OracleResultSet, but the one from the standard JDBC API
/Rene
[ June 19, 2002: Message edited by: Rene Larsen ]

[snoofle]

hello beksy,
i am using ie 4/5 and acrobat 5.
the insert doesn't work correctly,
(maybe the pdflib get_buffer function has an error)
i don't know where my error is ...
i would be nice if i can have a look at your code for insert and displying pdf files
tia
andreas spiessl
[ June 19, 2002: Message edited by: andreas spiessl ]

[Rene Larsen]

Hi
You have to change the way you generate your pdf-doc.
I have tested your implementation and it is not working, but this code is:

int form, page;
float width, height;
String infile = "C:\\java\\test.pdf";
pdflib pdf = new pdflib();
pdf.open_file("");
form = pdf.open_pdi(infile, "", 0);
page = pdf.open_pdi_page(form, 1, "");
/* get the dimensions of the imported form */
width = pdf.get_pdi_value("width", form, page, 0);
height = pdf.get_pdi_value("height", form, page, 0);
pdf.begin_page(width, height);
pdf.place_pdi_page(page, 0, 0, 1, 1);
pdf.close_pdi_page(page);
/* insert contents into new pdf-doc */
pdf.end_page();
pdf.close();
pdf.close_pdi(form);
byte[] buf = pdf.get_buffer();

Saving and loading the pdf-doc is the way shown earlier.
Hope this helps
/Rene
[ June 20, 2002: Message edited by: Rene Larsen ]

[snoofle]

hello rene,
you've been right
pdf.close() and after that pdf.get_buffer() was the error
thanks a lot
andreas spiessl