Image Crashed While Retrive.

[narayanabhilash]

Code for Upload....

        strLegalDocId = strMerchantId + strLegalStruct;
        String strSql = "{call Insert_FileData(?, ?, ?, ?, ?, ?,?)}";
        objCst = objCon.prepareCall(strSql);
        objCst.setString(1, strMId);
        objCst.setString(2, strLS);
        objCst.setString(3, strFieldId);
        objCst.setString(4, strFileName);
        objCst.setString(5, strLDId);
        bFileSize = inpStream.available();
        objCst.setBinaryStream(6, inpStream, bFileSize);
        objCst.registerOutParameter(7, Types.CHAR);
        objCst.executeUpdate();
        strStatus = objCst.getString(7);
        System.out.println("strStatus : " + strStatus);

Code for Download .......

        strSql = "SELECT photo FROM image WHERE photo_Id = '" + strPhotoId + "'";
        refCon = ConnectionManager.getConnection();

        refSt = refCon.createStatement();
        refRS = refSt.executeQuery(strSql);
        String imgLen = "";
        if (refRS.next()) {
            imgLen = refRS.getString("legal_document");
        }
        refRS=null;
        refRS = refSt.executeQuery(strSql);
        if (refRS.next()) {
            int len = imgLen.length();
            byte[] rb = new byte[len];
            InputStream readImg = refRS.getBinaryStream("legal_document");
            int index = readImg.read(rb, 0, len);
            response.reset();
            response.setContentType("image/jpg");
            response.getOutputStream().write(rb, 0, len);
            response.getOutputStream().flush();
        }