Inserting and exporting files from PostgreSQL

Hello,

I'm creating a web-app in Netbeans using Tomcat/JSP (with CachedRowSets for manipulating data) and the PostgreSQL database. So, I want to to create a page where I import some data in a specific table of the database and then export them during a query in another page. I also want to store an image in the database and after googling a little I found that you can do that in PostgreSQL using the bytea datatype. So the code goes as following:

 CachedRowSet crs = PDFInsertProvider.getCachedRowSet();
        try {
            crs.execute();  // unless it's already been executed.
            crs.moveToInsertRow();
            crs.updateInt("titlesid", new Integer(32423));
            crs.updateString("titles", getTextField1().getText().toString());
            UploadedFile file2 = getFileUpload2().getUploadedFile();
            UploadedFile file1 = getFileUpload2().getUploadedFile();
               
            crs.setBinaryStream(3, file2.getInputStream(), file2.getInputStream().available());
            crs.setBinaryStream(4, file1.getInputStream(), file1.getInputStream().available());
} catch (Exception e) {e.printStackTrace()}
            crs.insertRow();
            crs.moveToCurrentRow();
            crs.acceptChanges();
            info("Row Inserted via CachedRowSet");
            crs.release(); // release rowset memory

where UploadedFile -> org.apache.myfaces.custom.fileupload. So rows 3, 4 in the database are bytea datatype. This executes normally with a message: Row Inserted via CachedRowSet.

First question: If I psql to 'postgres' and do a 'select * from files' (where files is the table's name) . Then I can see the data for the first two columns but not for the last two.. Is this correct? Should the DOS prompt display them?

The code for retrieving the object goes as following:

            ResultSet set = deliveryBooksProvider.getCachedRowSet().getOriginal();
            set.first();
            InputStream stream1 = set.getBinaryStream("thumbimage");
            InputStream stream2 = set.getBinaryStream("pdffile");

where deliveryBooksProvider is of CachedRowSetDataProvider class. But stream1, stream2 result in null.

Any ideas?