|Oracle® interMedia User's Guide
10g Release 2 (10.2)
|PDF · Mobi · ePub|
Oracle interMedia ("interMedia") includes a number of scripts and sample programs that you can use. These consist of SQL, OCI, Java, PL/SQL, and ASP/VBScript sample applications (demos).
On UNIX <ORACLE_HOME>/ord/img/demo/ <ORACLE_HOME>/ord/http/demo/ <ORACLE_HOME>/ord/im/demo/java/ On Windows <ORACLE_HOME>\ord\img\demo\ <ORACLE_HOME>\ord\http\demo\ <ORACLE_HOME>\ord\im\demo\java\
This section describes how to run the interMedia image sample program.
The interMedia image sample files are located in <ORACLE_HOME>
/ord/img/demo on UNIX and <ORACLE_HOME>
\ord\img\demo on Windows where <ORACLE_HOME> is the Oracle home directory.
For interMedia image features, see the
README.txt file at <ORACLE_HOME>
/ord/img/demo (on UNIX), and <ORACLE_HOME>
\ord\img\demo (on Windows), where <ORACLE_HOME> is the Oracle home directory.
imgdemo.c is a sample program that shows how interMedia image features can be used from within a program. The program is written in C and uses OCI, Oracle Call Interface, to access the database and use interMedia image features.
The program operates on
imgdemo.dat, which is a bitmap (BMP) image in the demo directory. Optionally, you can supply an image file name on the command line, provided the file resides in the same directory as the program. In either case, once the image has been manipulated by interMedia, the resulting image is written to the file
imgdemo.out and can then be viewed with common rendering tools that you supply.
When the program is run, it deletes and re-creates a table named
IMGDEMOTAB in the
SCOTT schema of the default database. This table is used to hold the program data. Once the table is created, a reference to the image file is inserted into the table. The data is then loaded into the table and converted to JFIF using the processCopy( ) method of ORDImage.
The image properties are extracted within the database using the setProperties( ) method. An UPDATE statement is issued after the setProperties( ) invocation. This is required to make the object attributes permanent because the setProperties( ) invocation has updated only a local copy of the type attributes.
Next, the process( ) method is used to cut and scale the image within the database. This is followed by an update that commits the change. The program cuts a portion of the image 100 pixels wide by 100 pixels high, starting from pixel location (100,100). This subimage is scaled to twice its original size and the resulting image is written out to the file system in a file named
Upon completion, the program leaves the
imgdemo.out file in the current directory. It also leaves the table
IMGDEMOTAB in the
SCOTT schema of the database.
Execute the program by typing
imgdemo on the command line.
Use the command shown in Example A-1.
$ imgdemo <optional-image-filename>
The program displays a number of messages describing its progress, along with any errors encountered in the event that something was not set up correctly. Expect to see the following messages:
Dropping table IMGDEMOTAB... Creating and populating table IMGDEMOTAB... Loading data into cartridge... Modifying image characteristics... Writing image to file imgdemo.out... Disconnecting from database... Logged off and detached from server. Demo completed successfully.
If the program encounters any errors, it is likely that either interMedia software has not been installed correctly, or the database has not been started. If the program completes successfully, the original image and the resulting image, which has undergone the cutting and scaling described earlier, can be viewed with common image rendering tools.
See Section A.2 for a description of the Java sample application that is provided to help you learn to use the multimedia client-side Java classes so you can build your own applications.
An IMExample Java sample application has been provided to help you learn to use the audio, video, image, and media (ORDDoc) client-side Java classes so you can build your own applications. In this sample application, the sample schema is used to demonstrate the use of the OrdAudio, OrdVideo, OrdImage, and OrdDoc Java objects.
README.txt file in the
/ord/im/demo/java directory on UNIX and
\ord\im\demo\java directory on Windows for requirements and instructions on how to run this Java sample application. See Chapter 4 for a description of this Java sample application. See Oracle Application Server 10g Multimedia Tag Library for JSP User's Guide and Reference for information about using Oracle Application Server 10g Multimedia Tag Library for JSP. (This manual is available in the Oracle Application Server 10g Online Documentation Library.)
The IMExample Java sample application files are located in:
/ord/im/demo/java (on UNIX)
\ord\im\demo\java (on Windows)
/ord/http/demo/servlet (on UNIX)
\ord\http\demo\servlet (on Windows)
/ord/http/demo/jsp (on UNIX)
\ord\http\demo\jsp (on Windows)
Two additional PL/SQL sample application packages are available after installing interMedia. These packages include:
The interMedia PL/SQL Web Toolkit Photo Album application shows how to upload and retrieve image data using the PL/SQL Web Toolkit and PL/SQL Gateway. The SQL scripts and
README.txt file are at:
/ord/http/demo/plsqlwtk (on UNIX)
\ord\http\demo\plsqlwtk (on Windows)
See Section 3.1 in Chapter 3 for more information about installing and using this application.
The interMedia Code Wizard for the PL/SQL Gateway is an example of a tool that lets you create PL/SQL procedures for the PL/SQL Gateway to upload and retrieve media data stored in the database using any of the interMedia object types. The SQL scripts and
README.txt file are at:
/ord/http/demo/plsgwycw (on UNIX)
\ord\http\demo\plsgwycw (on Windows)
See Section 3.3 in Chapter 3 for more information about installing and using this application.
/ord/http/demo/asp (on UNIX)
\ord\http\demo\asp (on Windows)