In order to get you up and running in the shortest amount of time I
have included the Jetty J2EE server in the download.
This is really useful for checking out the integration, for test and
development environments. Typically in production environments, you
would rather deploy it in your J2EE server of choice, i.e. Weblogic,
Glassfish, Tomcat, OC4J, etc. If you want to do that, follow the
regular installation procedure here.
Now that we have the J2EE application working, we can install the
PL/SQL API in the database. The database objects required for the
integration will be installed
into each application schema that you want to use with the
integration.
The installation instructions will refer to the application schema (in which you install the software) as [application schema]. The password for the application schema will be referred to as [application schema password].
Thus when I use an instruction like sqlplus [application schema]/[application schema password]@[database] please replace that with the actual values of your local installation. For example, if you want to install the integration kit into the schema HR with the password hr1 into your local XE instance (having a TNS entry named xe) then this instruction translates to:
sqlplus hr/hr1@xe
First of all we need to grant the required privileges to the Oracle user who will own the packages for the integration.