Oracle Multimedia JSP Tag Library provides media upload tags that help multimedia applications to upload media data into the database.
Media upload tags meet the following requirements:
Make it easier to handle multipart form-data requests.
Simplify the storage of media data in the database.
Application developers must be able to specify the following information when attempting to upload media data:
Database connection information through which media data is written to the database
Table, column, and key information that describes where the media data is to be uploaded in the database
See Chapter 2 for a complete description of the sample JSP application that uses tags from the Oracle Multimedia JSP Tag Library to upload media files into a database.
Oracle Multimedia JSP Tag Library contains the following information about the media upload tags that operate on Oracle Multimedia objects:
This section presents reference information about these media upload tags, which operate on Oracle Multimedia objects:
<ord:storeMedia conn = "<%= jspExpression %>" table = "string | <%= jspExpression %>" [ key = "string | <%= jspExpression %>" ] [ keyColumn = "string | <%= jspExpression %>" ] [ rowid = "string | <%= jspExpression %>" ] mediaColumns = "values" mediaParameters = "values" [ otherColumns = "values" ] [ otherValues = "<%= jspExpression %>" ]/> where, values = string | <%=jspExpression%> [, string | <%=jspExpression%>]...
Operates within the body of the uploadFormData tag. The storeMedia tag implicitly uses the form-data object created by the uploadFormData tag through the mediaParameters attribute. This tag loads the uploaded media data from the HTML form into the OrdImage, OrdAudio, OrdVideo, or OrdDoc object in the specified table, row, and column in the database. If the specified row does not exist, a new row is inserted and updated with the loaded data. The transaction commits automatically if autocommit is set to true in the database connection object.
The mediaColumns and mediaParameters attributes enable the uploading of multiple media data specified in an HTML form into multiple columns in a particular row. The otherColumns and otherValues attributes enable the updating of other columns of the table along with the media data.
After loading the media data in the database BLOB, the tag calls the setProperties( ) method to set the media properties within the object. If the media format is not recognized by Oracle Multimedia, this tag sets the mimeType and length properties only.
Note:
In the case when the specified row does not exist and a new row is inserted into the table, any other columns in the table that are not specified in the mediaColumns and otherColumns attributes must permit the null value.The JDBC connection (java.sql.Connection object) used to store the media data.
A String literal or expression that specifies the name of the table containing the media data.
A String literal or expression that specifies the key value to use to fetch the media. The table's primary key is used if the keyColumn attribute is not specified. If the table does not have a primary key, a key column name must be specified with the keyColumn attribute.
A String literal or expression that specifies the column to use to access the media.
A String literal or expression that indicates the ROWID of the media in the specified table. Specifying this attribute is the equivalent of specifying key="rowid-value" keyColumn="rowid".
The names of the columns to be loaded with the uploaded media data.
The names of the parameters used to upload the media data, as specified in the HTML form.
The names of the other columns to be updated or inserted in the table.
The updated or inserted values of the other columns in the table that correspond to the otherColumns attribute. These values must be stored in a java.util.Vector object.
None.
None.
Example 1: Shows how to upload an image to a particular row in the table, and update other columns in that row at the same time.
<ord:uploadFormData formDataId="fd">
<%
java.util.Vector otherValuesVector = new java.util.Vector();
otherValuesVector.add(fd.getParameter("desc"));
otherValuesVector.add(fd.getParameter("loc"));
%>
<ord:storeMedia conn = "<% albumBean.getConnection() %>"
table = "photos"
key = "<%= fd.getParameter( "desc" ) %>"
mediaColumns = "photo"
mediaParameters = "photo"
otherColumns = "Description, Location"
otherValues = "<%= otherValuesVector %>" />
</ord:uploadFormData>
Example 2: Shows how to upload image and audio data into a particular row in a table, at the same time.
<ord:uploadFormData formDataId="fd">
<%
java.util.Vector otherValuesVector = new java.util.Vector();
otherValuesVector.add(fd.getParameter("desc"));
%>
<ord:storeMedia conn = "<% albumBean.getConnection() %>"
table = "photos"
key = "<%= fd.getParameter( "desc" ) %>"
mediaColumns = "photo, music"
mediaParameters = "photo, music"
otherColumns = "Description"
otherValues = "<%= otherValuesVector %>" />
</ord:uploadFormData>
<ord:uploadFile parameter = "string | <%= jspExpression %>" [ mimeType = "string" ] [ length = "string" ] [ fullFileName = "string" ] [ shortFileName = "string" ] [ inputStream = "string" ] > file-information-processing</ord:uploadFile>
Provides access to uploaded file information. This tag uses the object created by the uploadFormData tag implicitly, through the parameter attribute. This tag must be nested within the uploadFormData tag.
The name of the parameter used to upload the file, as specified in the HTML form.
The script variable name for the MIME type of the file.
The script variable name for the length of the file.
The script variable name for the file's full file name.
The script variable name for the file's short file name.
The script variable name for the java.io.InputStream object for the uploaded file.
None.
None.
Use an uploadFile tag nested within an uploadFormData tag to enable access to various file attributes, including the MIME type, length, and name:
<ord:uploadFormData formDataId="fd">
<%
String desc = fd.getParameter( "desc" );
String loc fd.getParameter( "loc" );
<ord:uploadFile parameter = "photo"
mimeType = "photoType"
length = "photoLength"
fullFileName = "photoFullName"
shortFileName = "photoShortName">
inputStream = "photoIn">
The mimeType of the file is <%=photoType%>
The length is <%=photoLength%>
.
.
.
</ord:uploadFile>
%>
</ord:uploadFormData>
where:
photo: is the parameter name of the uploaded file in the HTML form.
photoType: is the name of the variable that contains the MIME type of the media.
photoLength: is the name of the variable that contains the file length of the uploaded file.
photoFullName: is the name of the variable that contains the full file name of the uploaded file.
photoShortName: is the name of the variable that contains the short file name of the uploaded file.
photoIn: is an instance of the java.io.InputStream object for the uploaded file.
<ord:uploadFormData formDataId = "string" [ releaseFormData = "true | false | <%= jspExpression %>" ] [ maxMemory = "number | <%= jspExpression %>" ] [ tempDir = "string | <%= jspExpression %>" ] form-data-processing</ord:uploadFormData>
Parses the multipart/form-data HTTP request to provide access to text-based form parameters and the contents of uploaded files transmitted from a browser to a Web server.
The name of the script variable of type oracle.ord.im.OrdHttpUploadFormData from which the JSP page can obtain text-based form parameters and the contents of the uploaded files.
Attribute used to retain uploaded media for processing after the end of the uploadFormData tag, such as in an included JSP page or a JSP page to which the request is forwarded. By default, the value of this attribute is true, which releases all uploaded media at the end of the tag. To retain the uploaded media, set the value of this attribute to false. Then, call the release( ) method in the OrdHttpUploadFormData object to release the resource when the uploaded media is no longer needed.
Attribute that specifies the maximum amount of memory that can be consumed by the uploaded media for one HTTP POST request before storing the media temporarily on disk. By default, all uploaded media is stored in memory until it is loaded into the database by the application and released at the end of the tag. In cases where users may want to upload large media files, such as large video clips, application developers can choose to store uploaded files temporarily on disk, before they are loaded into the database and released.
Attribute that lets you override the default behavior. If this attribute is not specified, by default, uploaded media that is stored on disk temporarily is stored in one of the two locations identified by the following properties: javax.servlet.context.tempdir and java.io.tmpdir
where:
javax.servlet.context.tempdir, if present, takes precedence over java.io.tmpdir.
Note:
If execution of the JSP page is interrupted before the end of the uploadFormData tag, any temporary files are deleted either during garbage collection or when the user's session ends, whichever occurs sooner.None.
This tag creates the form-data object, which is an object of type oracle.ord.im.OrdHttpUploadFormData. Access to upload form data is provided by the following methods:
String getParameter( String name )
String [ ] getParameterValues( String name )
Enumeration getParameterNames( )
OrdHttpUploadFile getFileParameter( String name )
OrdHttpUploadFile [ ] getFileParameterValues( String name )
Enumeration getFileParameterNames( )
Use the tag uploadFormData to create a form-data object, which the JavaBean called albumBean uses to access the text-based form parameters and the uploaded file content:
<ord:uploadFormData formDataId="fd">
<%
albumBean.setDescription( fd.getParameter( "desc" ) );
albumBean.setLocation( fd.getParameter( "loc" ) );
albumBean.insertNewEntry();
albumBean.fetchRow();
albumBean.loadPhoto( fd.getFileParameter( "photo" ) );
albumBean.updateRow();
albumBean.commit();
%>
</ord:uploadFormData>