Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Question Unanswered: Problem in inserting document into database as a blob object in tomcat server

    Hi,
    I am inserting document into database as a blob. It is inserting successfully but we try to download it is not downloading. The insertion itself having some problem

    this code used for tomcat server

    String SQL_GET_BY_PK ="select document_blob from PMS_Documents where documentId="+ pmskey +" for update nowait" ;

    dbBlob = (oracle.sql.BLOB)rs.getBlob(1);

    inStream = new BufferedInputStream(form.getDocumentBlob().getInpu tStream());
    //createDocument(inStream);
    outStream = dbBlob.getBinaryOutputStream();
    while((len = inStream.read()) != -1) {
    outStream.write(len);
    fileSize += len;
    }

    PLEASE HELP ME ASAP

  2. #2
    Join Date
    Jul 2004
    Posts
    1

    try this

    Hi, try this from java forums:

    http://forum.java.sun.com/thread.jsp...&thread=325315

    maybe help, i have a problem to insert a blob in db2, in oracle work fine.
    ever tried ?

    thanks
    Rafael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •