<ie:webject name="Send-Blob-Stream" type="ACT">
<ie:param name="ATTRIBUTE" data="attribute_with_blob_data"/>
<ie:param name="BLOB_COUNT" data="number_of_BLOBs"/>
<ie:param name="CLASS" data="tablename"/>
<ie:param name="CONNECTION_ATTEMPT_INTERVAL" data="interval"/>
<ie:param name="CONNECTION_ATTEMPTS" data="attempts"/>
<ie:param name="DBUSER" data="dbuser_name"/>
<ie:param name="FILENAME" data="file_name"/>
<ie:param name="GROUP_OUT" data="group"/>
<ie:param name="INSTANCE" data="instance"/>
<ie:param name="MIMETYPE" data="mimetype"/>
<ie:param name="PASSWD" data="dbpassword"/>
<ie:param name="WHERE" data="where_clause"/>
</ie:webject>

<%@page language="java" errorPage="IEError.jsp"
import="java.util.*,com.infoengine.object.factory.*,
com.infoengine.SAK.*,com.infoengine.object.*" %>
<%@ taglib uri="http://www.ptc.com/infoengine/taglib/core" prefix="ie"%>
<ie:getService varName="vdb"/>
<jsp:useBean id="qa" class="com.infoengine.SAK.ActionWebject">
<% out.clearBuffer();
qa.setService(vdb);
qa.setName("Send-Blob-Stream");
boolean user_input_file_name = true;

boolean user_input_mime_type = false;
String file_name = request.getParameter("filename");

if(file_name != null){
file_name = file_name.trim();
if(!(file_name.startsWith("'") &&
file_name.endsWith("'"))){user_input_file_name = false;}

}else{ file_name ="";user_input_file_name = false;}

String mtype = request.getParameter("mimetype");
if(mtype != null){

mtype = mtype.trim();

if(mtype.startsWith("'") && mtype.endsWith("'"))

user_input_mime_type = true;

}else mtype = "";
StringBuffer name=new StringBuffer("NAME='");
name.append(request.getParameter("name"));
name.append("'");
if(user_input_file_name == false || user_input_mime_type ==
false)
{
/* No value was input by the user for File Name and/or
MIME type; the following webject fetches these from the
database and stores in group "temp" */

%>ie:webject name="Query-Objects" type="OBJ">
<ie:param name="INSTANCE"
data="${@FORM[]instance[]}" default="jdbcAdapter"/>
<ie:param name="CLASS" data="BLOBTEST"/>
<%if(user_input_mime_type == false){%>
<ie:param name="ATTRIBUTE"
data="${@FORM[]mimetype[]}"<%}%>
<%if(user_input_file_name == false){%>
<ie:param name="ATTRIBUTE"
data="${@FORM[]filename[]}"/><%}%>
<ie:param name="WHERE"
data="<%=name.toString()%>"/>
<ie:param name="GROUP_OUT" data="temp"/>
</ie:webject><%

/* Fetch the MIME type and/or file name from the group
"temp" */
IeGroup ie_group = (vdb.getCollection()).getGroup("temp");
Group group = new Group(ie_group);
Enumeration elements = group.getElements();
Element elem = null;
Att att1 = null, att2 = null;
if(elements.hasMoreElements())
{
elem = (Element)elements.nextElement();
att1 = elem.getAtt(mtype);
if(user_input_mime_type == false && att1 != null)
{
mtype = (att1.getValue()).toString();
mtype = "'" + mtype + "'";
}
att2 = elem.getAtt(file_name);
if(user_input_file_name == false && att2 != null)
{
file_name = (att2.getValue()).toString();
}
}
}
StringBuffer fname=new StringBuffer("filename='");
\
fname.append(file_name);
fname.append("'");
qa.addParam("INSTANCE",request.getParameter("instance"));
qa.addParam("ATTRIBUTE","FILECONTENT");
qa.addParam("DBUSER","gbabu");
qa.addParam("PASSWD","gbabu");
qa.addParam("CLASS","BLOBTEST");
qa.addParam("WHERE",name.toString());
qa.addParam("MIMETYPE", mtype);
qa.addParam("FILENAME", file_name);
qa.addParam("GROUP_OUT","SendBlob");
qa.setOutputStream(response.getWriter());
response.addHeader("Content-Disposition",fname.toString());
/* Make sure the single quotes in mtype do not get passed over too
setContentType() */
if(mtype != "" && mtype != null)
response.setContentType(mtype.substring(1,
mtype.length()-1));
qa.invoke(); response.getWriter().close();
%>
</jsp:useBean>