Installing the Oracle9i XML Product Catalog Application

• Required Software
• Notations Used
• Extracting the source code
• Configuring the application
  • Creating the Product Catalog Schema
  • Setting up JDK Environmental Variables
  • Setting up OC4J for 9iXML Class Generator and XSQL pages
  • Setup XSQL pages for FOP
• Deploying the sample application in OC4J
  • Simple Deployment
    • Compiling sources with Oracle9i JDeveloper or JDK 1.3
    • Copying and Running the application in OC4J
  • EAR(Enterprise ARchive) Deployment

Notations Used

Extracting the source code

Configuring the application

Creating the Product Catalog Schema

To create the Product Catalog schema follow the steps below :

1. In Sql*Plus, Login to your Oracle9i Database using a user with sysdba privilege. For ex:
   sqlplus> connect sys/change_on_install@db_alias as sysdba;

   
2. Now, create a new user with the required privileges using the following commands in Sql*Plus :
   
   sqlplus> CREATE USER catalog IDENTIFIED BY catalog;
   sqlplus> GRANT connect,resource to catalog;
   sqlplus> GRANT create any index to catalog;
   sqlplus> GRANT query rewrite to catalog;
   
   
3. Then, login as the user created above from Sql*Plus and run the script CreateTables.sql under
   the ProductCatalog/sql directory extracted above. For example :
   
   sqlplus> @<your_directory_path>\ProductCatalog\sql\CreateTables.sql

   This script will create all the tables, constraints, sequence and triggers required for the application.

Setting up JDK Environmental Variables

Note:
=>This application has been certified for Korn Shell in Solaris and Linux. All the instructions for Solaris and Linux
pertains to the Korn shell in it. You can enter into Korn Shell in Solaris and Linux by typing "ksh" on the command prompt.

=> Setting the environmental variables is not required when you are compiling java files with Oracle 9i JDeveloper.

1. Set the JAVA_HOME environment variable.



2. Eg. For Windows - set JAVA_HOME=<JAVA_HOME>
   Eg. For Solaris and Linux - export JAVA_HOME=/usr/java1.3



3. Set the PATH environmental variable
   Eg. For Windows - set PATH=%JAVA_HOME%\bin;%XDK_HOME%/bin
   Eg. For Solaris and Linux - export PATH=$JAVA_HOME/bin:$XDK_HOME/bin:



4. Add ANT to the PATH only for EAR deployment
   Eg. For Windows - set PATH=%JAVA_HOME%\bin;%XDK_HOME%/bin;%ANT_HOME%/bin
   Eg. For Solaris and Linux - export PATH=$JAVA_HOME/bin:$XDK_HOME/bin:
$ANT_HOME/bin


5. Set the CLASSPATH environmental variable. Make sure that classpath visits following jars.
   These files are part of XDK and OC4J.
   XDK_HOME\lib\xmlparserv2.jar
   XDK_HOME\lib\xschema.jar
   XDK_HOME\lib\xsu12.jar
   XDK_HOME\lib\oraclexsql.jar
   OC4J_HOME\j2ee\home\oc4j.jar
   OC4J_HOME\jdbc\lib\classes12dms.jar
   OC4J_HOME\j2ee\home\lib\servlet.jar
   
   Note : In addition to the above jar files, add the current directory to the CLASSPATH environment variable.
   

Eg. For Windows -
set CLASSPATH=%CLASSPATH%; %XDK_HOME%\lib\oraclexsql.jar;
%XDK_HOME%\lib\xmlparserv2.jar;%XDK_HOME%\lib\ xschema.jar;
%OC4J_HOME%\j2ee\home\oc4j.jar;%OC4J_HOME%\jdbc\lib\classes12dms.jar;
%OC4J_HOME%\j2ee\home\lib\servlet.jar;.

Eg. For Solaris and Linux -
export CLASSPATH=$CLASSPATH:$XDK_HOME/lib/oraclexsql.jar:
$XDK_HOME/lib/xmlparserv2.jar:$XDK_HOME/lib/xschema.jar:
$OC4J_HOME/j2ee/home/oc4j.jar:$OC4J_HOME/jdbc/lib/classes12dms.jar:
$OC4J_HOME/j2ee/home/lib/servlet.jar:.

Setting up OC4J for 9iXML Class Generator and XSQL pages

1. Copy the oraclexsql.jar, xmlparserv2.jar, xsu12.jar and xschema.jar archives from
the XDK_HOME\lib directory to the OC4J_HOME\j2ee\home\lib directory.
2. Copy the XSQLConfig.xml file in the XDK_HOME\xdk\admin directory to the OC4J_HOME\j2ee\home\lib directory.
3. Setting up the database connection for XSQL Pages : To setup the database connection,
edit the XSQLConfig.xml file in the OC4J_HOME\j2ee\home\lib directory and replace the
following connection- pool and connection-manager tags in the XSQLConfig.xml file between
<XSQLConfig>...</XSQLConfig> tags :

<connection-pool>
<initial>10</initial>
<increment>1</increment>
<timeout-seconds>60</timeout-seconds>
<dump-allowed>no</dump-allowed>
</connection-pool>

<connection-manager>
<factory>oracle.otnsamples.ProductCatalog.xml.xsql.actions.MyXSQLConnectionManagerFactoryImpl</factory>
</connection-manager>

4. Go to OC4J_HOME\j2ee\home\config directory.
5. Add the following entries to global-web-application.xml to recognize the .xsql pages under

<web-app>...</web-app> tags.

<servlet>
<servlet-name>xsql</servlet-name>
<servlet-class>oracle.xml.xsql.XSQLServlet</servlet-class>
</servlet>

<servlet-mapping>
<servlet-name>xsql</servlet-name>
<url-pattern>/*.xsql</url-pattern>
</servlet-mapping>

6. Go to ProductCatalog/java directory and edit MyXSQLConnectionManagerImpl.java

7. Search for 'connect' method in the file. Replace insn104a.idc.oracle.com:1522:otn9idb in the
connect method with your hostname:port:database_sid and save the file.

Setup XSQL pages for FOP

Apache FOP (Formatting Objects Processor) is a Java utility that reads a formatting object tree and then turns it into a PDF document.

1. Copy the batik.jar from FOP_HOME\lib and fop.jar from the FOP_HOME directory to
   the OC4J_HOME\j2ee\home\lib directory.
2. Copy xsqlserializers.jar from XDK_HOME\lib to OC4J_HOME\j2ee\home\lib directory.
3. Edit XSQLConfig.xml present in OC4J_HOME\j2ee\home\lib directory.
4. Create an alias for FOP serializer by including the following in the file between <XSQLConfig> ... </XSQLConfig> tags.
   

   <serializerdefs>
   <serializer>
   <name>Sample</name>
   <class>oracle.xml.xsql.serializers.XSQLSampleSerializer</class>
   </serializer>
   <serializer>
   <name>FOP</name>
   <class>oracle.xml.xsql.serializers.XSQLFOPSerializer</class>
   </serializer>
   </serializerdefs>

Deploying the sample application in OC4J

EAR(Enterprise ARchive) Deployment