Installing the Oracle9i XML Product Order Application

Creating the Product Order Schema

To create the Product Order 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 orderuser IDENTIFIED BY orderuser;
   sqlplus> GRANT connect,resource TO orderuser;



3. Then, login as the user created above from Sql*Plus and run the script CreateTables.sql under
   the ProductOrder/sql directory extracted above. For example :
   
   sqlplus> @<your_directory_path>\ProductOrder\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\classgen.jar
   XDK_HOME\lib\oraclexsql.jar
   OC4J_HOME\j2ee\home\oc4j.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;
%XDK_HOME%\lib\classgen.jar;%OC4J_HOME%\j2ee\home\oc4j.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:$XDK_HOME/lib/classgen.jar:$OC4J_HOME/j2ee/home/oc4j.jar:
$OC4J_HOME/j2ee/home/lib/servlet.jar:.

Setting up OC4J for XML9i Class Generator and XSQL pages

1. Copy the classgen.jar from the XDK_HOME\lib directory to the OC4J_HOME\j2ee\home\lib directory.
2. Copy the oraclexsql.jar, xmlparserv2.jar, xschema.jar and xsu12.jar archives from the XDK_HOME\lib
   directory to the OC4J_HOME\j2ee\home\lib directory.
3. Copy the XSQLConfig.xml file in the XDK_HOME\xdk\admin directory to the OC4J_HOME\j2ee\home\lib directory.
4. Setting up the database connection for XSQL Pages : To setup the database connection,
   
   a) Edit the XSQLConfig.xml file in the j2ee\home\lib directory and add the following connection
   information within the <connectiondefs>...</connectiondefs> tags :
   <connection name="otn9i">
   <username>orderuser</username>
   <password>orderuser</password>
   <dburl>jdbc:oracle:thin:@hostname:port:sid</dburl>
   <driver>oracle.jdbc.driver.OracleDriver</driver>
   </connection>
   
   where,
   username - is the name of the database user created above i.e orderuser
   password - is the password of the orderuser user i.e orderuser
   hostname - is the hostname of the machine where Oracle9i database is running.
   port - is the port on the hostname where the database listener is listening to.
   sid - is the sid of your database.
   Note: Do not change the connection name 'otn9i' used above since all the XSQL pages use this to
   make the database connection.
   
   b) Make sure that in the same XSQLConfig.xml file edited in step a, the value for the <factory> tag inside
   <connection-manager>...</connection-manager> tags is set to the default
   value i.e oracle.xml.xsql.XSQLConnectionManagerFactoryImpl.
   
5. Go to OC4J_HOME\j2ee\home\config directory.
6. 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>

Using ORACG utility

The 'ORACG' command line utility of Oracle9i XDK is used to generate java classes as below.
Make sure that you have XDK_HOME/bin is in your PATH.

• Go to ProductOrder/xml directory. At the command prompt do the following:
  java oracle.xml.classgen.oracg -comment -schema ProductOrder.xsd -package oracle.otnsamples.ProductOrder
  
  
• This will create .java files for the ProductOrder.xsd under ProductOrder/xml inside the directory "oracle".
  The .java files created will be: Customer.java, Products.java, ProductOrder.java.

 

Note:
=> Ensure that you have downloaded and installed “ANT” tool (refer required software).
=> Ensure that you have JDK 1.3 or higher installed as it is required for compilation of the .java sources which builds the EAR file
=> ANT_HOME\bin is in the PATH.

1. Go to ProductOrder/xml directory where you have extracted the sample.
2. Move the oracle directory to ProductOrder/java directory. Make sure that ProductOrder/xml does not have oracle directory.
3. Delete all .class files if you have them when doing the simple deployment.
4. Go to the root ProductOrder directory and type ant.
5. ANT generates ProductOrder.ear file and places it under “build” directory.

Running the application

1. Move ProductOrder.ear file under OC4J_HOME\j2ee\home\applications directory.
2. Go to OC4J_HOME\j2ee\home\config directory
3. Edit http-web-site.xml file.
4. Add following entry under <web-site ……….> tag
   <web-app application="ProductOrder" name="ProductOrder"   root="/ProductOrder"/>
5. Save this file
6. Open server.xml file and add the following entry
   <application name="ProductOrder" path="../applications/ProductOrder.ear" />
7. Re-start the OC4J Server.
8. Then, access the Application using the URL :
   
   http://<oc4jserver>:<port-no>/ProductOrder/jsps/Welcome.jsp

where,
<oc4jserver> - is the hostname / ip-address of the machine where OC4J is installed.
<port-no> - is the port number on which oc4j server is listening. Default port is 8888.