8.3. Using Other Application Servers

EspressReport ES deploys as a servlet and JSP collection in an application server. As detailed in Section 1.3.1 - Installing ERES ERES comes bundled with the Tomcat servlet container. Users have the option to install Tomcat (with ERES automatically deployed) when running the installer. This option is recommended for new users and evaluators because ERES will work “out-of-the-box” in this configuration.

However, ERES can also be deployed on most popular application servers. This chapter provides step-by-step setup instructions for Tomcat, Resin, WebLogic, WebSphere, JBoss, Oracle, and Sun servers.

Thorough this chapter, the following naming conventions are used.

<ERES_INSTALL_DIR> :

This is the location where ERES is installed.

<ERES_DEPLOY_DIR> :

This is the final deployment directory of ERES. It might not be the same as your installation directory (<ERES_INSTALL_DIR>).

<ERES_CONTEXT> :

This is the context path used to access ERES web application components.

<ERES_SERVLET_CONTEXT> :

This is the servlet context of ERES. ERES uses servlets for many of the back-end functions. There is a web.xml file under the <ERES_INSTALL_DIR>/WEB-INF directory that maps all the servlet classes packaged with ERES. By default, every servlet is mapped to /servlet/<servlet name>. After deploying ERES, you may need to change the servlet context.

<server> :

This is your application/web server name. It can be the name of the server machine or the IP address.

<port> :

The port number on which your application/web server is listening.

ERES Start Page :

This is the main/home page for ERES. It should be accessed by the following URL: http://<server>:<port>/<ERES_CONTEXT>/index.jsp.

In addition, instructions in this chapter make reference to starting and stopping the ERES server, as well as features/options in the Admin console. If you are using AUTOSTART feature, you need to set correct port in Server Options - Auto-Start in Admin Console page. For details about these actions, please see Section 1.3.2.2 - Starting the Server and Section 1.4 - Administration.

As the result of moving to a different application server, the <ERES_INSTALL_DIR> location may move or the name of the ERES context may be changed. When this happens, you will need to modify the URL mapping in Organizer in order to create/modify/run reports and charts. For more information about setting URL mapping see Section 2.1.5 - URL Mapping.

[Note]Note

These instructions assume you are running ERES with the default (HSQL) database. If you are using a different database, you need to add the JDBC driver classes for your database to your servlet container's classpath. All JAR files are under <ERES_INSTALL_DIR>/WEB-INF/lib, which is used by the servlet container to load classes required by the ERES web application. Therefore, if you are adding JDBC driver that is needed by the ERES web application, you can simply copy the JAR file to <ERES_INSTALL_DIR>/WEB-INF/lib.

You can also deploy ERES as a war file. To make an ERES war file, you must:

Please note that when deploying the war file, the <ERES_INSTALL_DIR> is still being used to store all templates and user files, so it must be valid and accessible. Also, the instructions, given above, must be carried out again when an update is performed on the <ERES_INSTALL_DIR> directory and the newly created war file should be deployed again. Note that certain application servers requires additional files (such as JBoss needing a jboss-web.xml file) before the war file can be successfully deployed.

8.3.1. Tomcat 4.1/5.x/6.0.x/7.0.x

The following instructions show how to deploy EspressReport ES under Tomcat 4.1/5.x/6.0.x/7.0.x. The instructions assume that Tomcat has been installed on the system. The location of the Tomcat installation is referenced as <TOMCAT_INSTALL_DIR>.

For reference, please note that Tomcat's default port is 8080, the default working directory is <TOMCAT_INSTALL_DIR>/bin and the default Web root is <TOMCAT_INSTALL_DIR>/webapps/ROOT.

  1. Modify the <TOMCAT_INSTALL_DIR>/config/server.xml file and add the following entry: <Context path="/ERES" docBase="<ERES_INSTALL_DIR>" debug="0"/>. Path is the context path of ERES web application, and docBase is the absolute path or relative path of the ERES installation. Please substitute <ERES_INSTALL_DIR> with your actual path.

    [Note]Note

    Please use double quotes.

  2. Now start Tomcat from <TOMCAT_INSTALL_DIR>/bin/startup.bat/.sh.

  3. With Tomcat running go to ERES Start page http://<server>:<port>/<ERES_CONTEXT>/index.jsp With the above configuration, ERES_CONTEXT is ERES. Start the ERES Server.

  4. From the ERES Start page, login as the administrator and launch the Admin Console.

  5. From Admin Console page, go to the Setting Info tab. Change the ERES Servlet Context entry to /ERES/servlet. This change requires you to restart the ERES Server. You can also change the webroot entry to <TOMCAT_INSTALL_DIR>/webapps/ROOT, but it is not necessary.

  6. Stop and restart the ERES Server.

8.3.2. Resin

8.3.2.1. Resin 3.x/4.x

Deploying EspressReport ES to Resin 3.x/4.x can be accomplished using the instructions provided below. The location of the Resin installation is referenced as <RESIN_INSTALL_DIR>.

For reference, please note that Resin's default port is 8080, the default working directory is <RESIN_INSTALL_DIR> and the default Web root is <RESIN_INSTALL_DIR>/docs.

  1. You may need to move tools.jar file from your Java development kit to the <RESIN_INSTALL_DIR>/lib directory (for JSP compilation) or add a library path entry for the file.

  2. Modify <RESIN_INSTALL_DIR>/conf/resin.conf. Add the following entry for context path /ERES <web-app id="/ERES" document-directory="<ERES_INSTALL_DIR>"/> between <host-default> and </host-default> tags. The id in the entry is the context path of ERES, and document-directory is the absolute path of the ERES installation. Please substitute <ERES_INSTALL_DIR> with your actual ERES installation directory.

  3. In Resin 3.X, start your Resin server by running <resin-installation-dir>/bin/httpd. In Resin 4.X, first navigate to the <RESIN_INSTALL_DIR> directory and then start the server by running the following command: java -jar lib/resin.jar start.

  4. Now from your web browser browse to the ERES Start page to start the server (http://<server>:<port>/<ERES_CONTEXT>/index.jsp). For the above configuration, the context path is ERES.

  5. From the ERES Start page, login as the administrator and launch the Admin Console.

  6. From Admin Console page, go to the Setting Info tab. Change the ERES Servlet Context entry to /ERES/servlet. You can also change the webroot to <RESIN_INSTALL_DIR>/doc, but it is not necessary.

  7. Stop the ERES Server.

  8. Stop and re-start Resin if necessary.

  9. Go to the ERES Start page and start the ERES server.

8.3.2.2. Resin 2.1.12

The following instructions show how to deploy EspressReport ES under Resin 2.1.12. The instructions assume that Resin has been installed on the system. The location of the Resin installation is referenced as <RESIN_INSTALL_DIR>.

For reference, please note that Resin's default port is 8080, the default working directory is <RESIN_INSTALL_DIR> and the default Web root is <RESIN_INSTALL_DIR>/docs.

  1. You may need to move tools.jar file from your Java development kit to the <RESIN_INSTALL_DIR>/lib directory (for JSP compilation), or add a library path entry for the file.

  2. Modify <RESIN_INSTALL_DIR>/conf/resin.conf. Add the following entry for context path /ERES <web-app id="/ERES" app-dir="<ERES_INSTALL_DIR>"/> Where id is the context path of ERES, and app-dir is the absolute path of the ERES installation. Please substitute <ERES_INSTALL_DIR> with your actual ERES installation directory.

  3. Start your Resin server by running <resin-installation-dir>/bin/httpd.

  4. Now from your web browser, browse to the ERES Start page to start the server (http://<server>:<port>/<ERES_CONTEXT>/index.jsp). For the above configuration, the context path is ERES.

  5. From the ERES Start page, login as the administrator and launch the Admin Console.

  6. From Admin Console page, go to the Setting Info tab. Change the ERES Servlet Context entry to /ERES/servlet. You can also change the webroot to <RESIN_INSTALL_DIR>/doc, but it is not necessary.

  7. Stop the ERES Server.

  8. Stop and re-start Resin if necessary.

  9. Go to the ERES Start page and start the ERES server.

8.3.3. WebLogic Server

8.3.3.1. WebLogic Server 9.2/10.3

The following instructions show how to deploy EspressReport ES under WebLogic Server 9.2/10.3. The instructions assume that you have WebLogic 9.2/10.3 Server installed on the system and will be deploying ERES under the wl_server that comes with WebLogic. The location of the WebLogic installation will be referenced as <WL_INSTALL_DIR>.

For reference the wl_server port number is 7001, and the working directory is <WL_INSTALL_DIR>/samples/domains/wl_server/bin.

  1. Start WebLogic 9.2/10.0 example server by executing <WL_INSTALL_DIR>/samples/domains/wl_server/bin/startWebLogic.cmd (Windows) or startWeblogic.sh (Unix).

  2. When Weblogic Server web is loaded, press the Start the Administration console button in the home page.

  3. Login to the administration console page and select the Deployments node from the Domain Structure panel on the left-hand side. This will bring up the Deployments panel on the right.

  4. To install new application press the Install button from the Deployments panel. This will direct you to the Install Application Assistant.

  5. From the Application Assistant, browse to the exploded application directory of ERES, which in this case will be the installation directory of ERES <ERES_INSTALL_DIR> and then select the radio button to the left of the ERES directory and press the Next button. This will bring you to the following panel. From this panel, select the Install this deployment as an application radio button and press the Next button.

  6. This will bring you to the following panel to specify optional settings of the configuration procedure. From this panel, enter the information for ERES, and press Finish.

  7. If the deployment has been installed and added to the list of pending changes successfully, press the Activate Changes button from the Change Center dialog to activate the pending changes.

  8. Activate the ERES application by checking the checkbox to the left of the ERES link and pressing the "Start" button.

  9. Now go to the ERES Start page http://<server>:<port>/<ERES_CONTEXT>/index.jsp. From the start page, start the ERES server.

  10. From the ERES Start page, login as the administrator and launch the Admin Console.

  11. From Admin Console page, go to the Setting Info tab. Change ERES Servlet Context entry to /<ERES_CONTEXT>/servlet. Please substitute <ERES_CONTEXT> with your actual context for ERES.

  12. Stop and re-start the ERES Server.

8.3.3.1.1. WebLogic Server 8.1

Deploying EspressReport ES to WebLogic Server 8.1 can be accomplished using the same steps as listed in the next two sections for WebLogic Server 7.0. Note that there are a few small file structure and user interface differences between WebLogic Server 7.0 and 8.1. First, the exampleServer for WebLogic Server 8.1 is under the path <WL_INSTALL_DIR>/samples/domains/examples. Also, the sequence of links in step 3 is changed to examples → Deployment → Web Application Modules instead of examples → Deployment → Web Applications, and the link in step 4 is called Deploy a new Web Application Module for WebLogic Server 8.1 instead of Configure a new web application.

Use the following instructions in place of steps 5 and 6:

  • 5. From the right panel, browse to the exploded application directory of ERES, which in this case will be the installation directory of ERES <ERES_INSTALL_DIR> and then click the radio button to the left of the ERES directory and press the Target Module button. This will bring you to the Review your choices and deploy panel. From this panel, enter the information for ERES.

  • 6. Then press the Deploy button to deploy ERES.

8.3.3.1.2. WebLogic Server 7.0

The following instructions show how to deploy EspressReport ES under WebLogic Server 7.0. The instructions assume that you have WebLogic Server 7.0 installed on the system and will be deploying ERES under the exampleServer that comes with WebLogic. The location of the WebLogic Server installation will be referenced as <WL_INSTALL_DIR>

This section uses the administration console to deploy ERES. For quick deployment without using the administration console, please reference Section 8.3.3.1.3 - WebLogic Server 7.0 - Quick Deployment.

For reference the Example Server port number is 7001, and the working directory is <WL_INSTALL_DIR>/samples/server/config/examples

  1. Start WebLogic example server by executing <WL_INSTALL_DIR>/samples/server/config/examples/startExamplesServer.cmd

  2. When Example Server web page is loaded, click the Administration console link in the home page.

  3. Login to the administration console page and click examples → Deployment → Web Applications from the left panel. This will bring up the Web Applications panel on the right.

  4. Click the Configure a new web application link from the above page. This will direct you to install and configure the ERES web application.

  5. From the right panel, browse to the exploded application directory of ERES, which in this case will be the installation directory of ERES <ERES_INSTALL_DIR> and then click the Select link to the left of the ERES directory. This will bring you to the following panel to continue with Steps 3, 4 and 5 of the configuration procedure. From this panel, enter the information for ERES, and choose the targeted server which in this case will be the exampleServer.

  6. Then press the Configure and Deploy button to deploy ERES.

  7. If hot deployment is not enabled in your WebLogic application server, stop and restart the exampleServer.

  8. Now go to the ERES Start page http://<server>:<port>/<ERES_CONTEXT>/index.jsp. From the start page, start the ERES server.

  9. From the ERES Start page, login as the administrator and launch the Admin Console.

  10. From Admin Console page, go to the Setting Info tab. Change ERES Servlet Context entry to /<ERES_CONTEXT>/servlet. Please substitute <ERES_CONTEXT> with your actual context for ERES.

  11. Stop and re-start the ERES Server.

8.3.3.1.3. WebLogic Server 7.0 - Quick Deployment

These instructions will accomplish the same effect - deploying EspressReport ES under the WebLogic exampleServer - as the previous section. This section explains how to deploy ERES without using the WebLogic administration console. Users who are not very familiar with WebLogic should use the instructions in the previous section.

  1. Modify the <WL_INSTALL_DIR>/samples/domains/examples/config.xml file to add the following entry:

    <Application Deployed="true" Name="ERES" Path="<PARENT of ERES_INSTALL_DIR>" TwoPhase="true">

      <WebAppComponent Name="ERES" Targets="examplesServer" URI="ERES"/> 

</Application>

    Path is the parent directory of <ERES_INSTALL_DIR>. Application name is the ERES installation directory name. For example, if you install ERES under C:/ERES, this should be “ERES”. WebAppComponent Name is the name of this component. These instructions show how to deploy ERES with exampleServer. This is declared by the Target attribute in the config.xml file. URI is how to access this web component. This is the context path that will be used to access this web application. “ERES” is used as the default context path.

  2. Start the WebLogic 7.0 exampleServer by executing the following command, <WL_INSTALL_DIR>/samples/server/config/examples/startExamplesServer.cmd

  3. Now go to the ERES Start page http://<server>:<port>/<ERES_CONTEXT>/index.jsp. From the start page, start the ERES server.

  4. From the ERES Start page, login as the administrator and launch the Admin Console.

  5. From Admin Console page, go to the Setting Info tab. Change the ERES Servlet Context entry to /<ERES_CONTEXT>/servlet. Please substitute <ERES_CONTEXT> with your actual context for ERES.

  6. Stop the ERES Server.

  7. Stop and re-start Weblogic if necessary.

  8. Re-start the ERES Server.

8.3.4. WebSphere

8.3.4.1. WebSphere 7.1

While EspressReport ES can be deployed in WebSphere 7.1 using different approaches, the following instructions show how to do so with minimal changes to WebSphere and ERES. The instructions assume WebSphere has been installed, started, and running on the same machine as ERES.

  1. Reinstall ERES under the following directory ERES/ERESApp_war.ear/ERESApp.war (for example, C:\ERES\ERESApp_war.ear\ERESApp.war) and passing in the host name/IP of the WebSphere machine and the port it is running on when prompted in the ERES installer. Leave the default ERES as the servlet context.

  2. In order to deploy ERES under WebSphere you will need to convert the ERES web application into a WAR file, called ERESApp.war, using the Java's JAR tool. To do this, make sure that the java/bin directory is in your path and navigate to <ERES_INSTALL_DIR> in a command window. Then execute the following command: jar -cvf ERESApp.war *

  3. Start the administration console for WebSphere. From the left-hand panel of the administration console, select the Applications node and then click the Install New Applications link.

  4. Select New Enterprise Application and then browse to the war file created (which should be ERES/ERESApp_war.ear/ERESApp.war/ERESApp.war). After selecting ERESApp.war, click on Next.

  5. When asked how to install the application, select Fast Path and click on Next.

  6. Under Directory to install application, enter the path to /ERES. For example, if you installed ERES under c:\ERES\ERESApp_war.ear\ERESApp.war, enter c:\ERES. Click Next.

  7. Under Map modules to application servers, select Module and click on Next.

  8. Under Map virtual hosts for Web modules, select Web module and click on Next.

  9. For Map context root for Web modules, enter /ERES under Context Root and click on Next.

  10. A summary of the installation options is then shown. Click on Finish for WebSphere to now deploy the ERES web application.

  11. If deployment was successful, finish the deployment by clicking the save link on this page.

  12. Expand Applications on the right frame and select WebSphere enterprise applications. Select ERESApp_war and click on Start.

  13. Now go to the ERES Start page http://<server>:<port>/ERES/index.jsp. Note that port is 9080 by default. From the start page, start the ERES server.

8.3.4.2. WebSphere 5.0/6.1

EspressReport ES can be deployed in WebSphere in a number of ways. The following instructions show how to deploy ERES under WebSphere Application Server 5.0 or 6.0/6.1 with minimal configuration changes. The instructions assume that WebSphere Application Server has been installed on the system. The location of the WebSphere installation is referenced as <WS_INSTALL_DIR>. WebSphere is also assumed to be started and running.

  1. Reinstall ERES under the following directory ERES/ERESApp_war.ear/ERESApp.war (for example, c:\ERES\ERESApp_war.ear\ERESApp.war) and passing in the host name/IP of the WebSphere machine and the port it is running on when prompted in the ERES installer. Leave the default ERES as the servlet context.

  2. In order to deploy ERES under WebSphere you will need to convert the ERES web application into a WAR file, called ERESApp.war, using the Java's JAR tool. To do this, make sure that the java/bin directory is in your path and navigate to <ERES_INSTALL_DIR> in a command window. Next, execute the following command: jar -cvf ERESApp.war *

  3. Start the administration console for WebSphere. From the left-hand panel of the administration console, select the Applications node and then click the Install New Applications link.

  4. You will be directed to the following window for preparing the application installation. From the right-hand panel, provide the war file path (which should be ERES/ERESApp_war.ear/ERESApp.war/ERESApp.war). Enter ERES for the context path and click Next. Please note that if you are deploying ERES under WebSphere 6.1, you can skip steps 5 and 6 and continue with step 7.

  5. Select Generate Default Bindings from the next page, in case you do not have binding specified.

  6. Click the Next button.

  7. Click the Continue button. Now you are directed to the step 1 of the installation: Provide options to perform the installation. Under Directory to install application, enter the path to /ERES. For example, if you installed ERES under c:\ERES\ERESApp_war.ear\ERESApp.war, enter c:\ERES.

  8. Click the Next button to go to step 2: Map virtual hosts for web modules. Select Web Modules.

  9. Click the Next button to go to step 3: Map modules to application servers. Select Module.

  10. Click the Next button to go to step 4: Summary of this web application. Please make sure all information is correct. If not, go back to edit the information.

  11. After verifying the information, click the Finish button. WebSphere will now try to deploy the ERES Web application.

  12. If deployment was successful as shown above, save the changes by either clicking the save link from this page or the save link on the top of the administration console. Note that you may have to go under Applications in the right frame, expand Enterprise Applications and start ERESApp_war.

  13. Now go to the ERES Start page http://<server>:<port>/ERES/index.jsp. Note that port is 9080 by default. From the start page, start the ERES server.

8.3.4.3. WebSphere on z/OS

Deploying EspressReport ES to WebSphere for z/OS has a few additional steps:

  1. Download ERES.war and deploy it on WebSphere (see above section for general WebSphere deployment). You will need to use viascii to configure text files that are mentioned in the instructions. Also, since the required jar files are in the WEB-INF/lib directory inside the war file, you can skip the steps for adding them as classpath to your servlet container.

  2. ERES requires Java graphics support to run. See Section 7.9.4.2 - JVM 1.5+ in Headless Mode for more detail about using graphics on headless platform. In brief, if you are running JDK 1.5 or above, the solution is set it to run in headless mode by specifying the -Djava.awt.headless=true flag for the java command that starts your WebSphere. For JDK 1.3 or below, one option is to use PJA graphics emulation. This is discussed in the deployment section of the Programming Guide. However, if using the following flags as suggested by PJA causes Java not to find its fonts:

    -Djava2d.font.usePlatformFont=false -Djava.awt.fonts=TrueTypeFontsPath

    try using this flag instead:

    -Djava2d.font.usePlatformFont=true

    When using Djava2d.font.usePlatformFont=true, you will also need to copy just the Arial*.ttf fonts (can be found in a Windows platform) to the native jre /lib/fonts directory. Also, note that you will not need the flag -Djava.awt.fonts=TrueTypeFontsPath.

  3. Stop and re-start WebSphere if necessary. ERES is now set up and accessible using URL: http://host:port/ERES/index.jsp.

8.3.5. JBoss 3.2.3 (with Tomcat 5.0) / JBoss 4.0.5/6.0.0

The following instructions show how to deploy EspressReport ES under JBoss 3.2.3 with Tomcat 5.0 / JBoss 4.0.5 /6.0.0. The instructions assume you have JBoss installed on the system. The location of the JBoss installation is referenced as <JBOSS_INSTALL_DIR>.

For reference the default port is 8080, and the default working directory is <JBOSS_INSTALL_DIR>/bin.

  1. You need a jboss-web.xml deployment descriptor to deploy ERES. This file should be added to the <ERES_INSTALL_DIR>/WEB-INF directory. This is the same location as the web.xml file. This deployment descriptor is to specify the ERES context. The content should look like this:

    <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jboss-web PUBLIC "-//JBoss//DTD Web Application 2.3//EN" "http://www.jboss.org/j2ee/dtds/jboss-web_3_0.dtd">

<jboss-web>

      <context-root>/ERES</context-root> 

</jboss-web>

  2. Rename the ERES installation directory <ERES_INSTALL_DIR> to ERES.war. Move the entire ERES.war directory to <JBOSS_INSTALL_DIR>/server/default/deploy. This new directory is referenced as <ERES_DEPLOY_DIR>. Next time when JBoss starts, server will automatically deploy the ERES web application.

  3. Open <ERES_DEPLOY_DIR>/WEB-INF/classes/QB.properties file and change the AutoStartServerInstallDir entry to point to <ERES_DEPLOY_DIR>. Example:

    Original entry

    AutoStartServerInstallDir=<ERES_INSTALL_DIR>

    New entry

    AutoStartServerInstallDir=<ERES_DEPLOY_DIR>

    Next, you have to change Database URL. If the DatabaseUrl entry already exists in your QB.properties file, just change it to point to the hsql database under <ERES_DEPLOY_DIR>. Example:

    Original entry

    DatabaseUrl=jdbc\:hsqldb\:<ERES_INSTALL_DIR>/data/quadbasedb

    New entry

    DatabaseUrl=jdbc\:hsqldb\:<ERES_DEPLOY_DIR>/data/quadbasedb

    If the entry does not exist in your file, save the changes and open <ERES_DEPLOY_DIR>/WEB-INF/orguserdb/config.txt file. In the file, modify [database url] entry to point to the hsql database under <ERES_DEPLOY_DIR>. Example:

    Original entry

    [database url] jdbc:hsqldb:<ERES_INSTALL_DIR>/data/quadbasedb

    New entry

    [database url] jdbc:hsqldb:<ERES_DEPLOY_DIR>/data/quadbasedb

  4. Execute run.bat/.sh in the <JBOSS_INSTALL_DIR>/bin directory to start the JBoss Server. The ERES application will be automatically deployed. The deployment information should be printed out on the JBoss console.

  5. Go to the ERES Start page http://<server>:<port>/<ERES_CONTEXT>/index.jsp to start the ERES server. ERES_CONTEXT is defined in your jboss-web.xml file. In this case. it will be ERES.

  6. From the ERES Start page, login as the administrator and launch the Admin Console.

  7. From Admin Console page, go to the Setting Info tab. Change ERES Servlet Context entry to /<ERES_CONTEXT>/servlet . Please substitute <ERES_CONTEXT> with your actual context for ERES.

  8. Stop and re-start the ERES server.

8.3.6. Oracle Containers for J2EE (OC4J) 10g (9.0.4.0/10.1.3.5)

The following instructions show how to deploy EspressReport ES under OC4J 10g (9.0.4.0/10.1.3.5). The instructions assume that you have OC4J installed on the system. The location of the OC4J installation is referenced as <OC4J_INSTALL_DIR>

For reference the default port is 8888, and the default working directory is <OC4J_INSTALL_DIR>/j2ee/home.

  1. The easiest way to deploy ERES is to put ERES under default-web-app. Copy the entire ERES directory <ERES_INSTALL_DIR> to <OC4J_INSTALL_DIR>/j2ee/home/default-web-app. This new directory is referenced as <ERES_DEPLOY_DIR>.

  2. You will need to copy the tools.jar file from your Java development kit to the <OC4J_INSTALL_DIR>/j2ee/home/applib directory (for JSP compilation), or add a library path entry for the file. Check your <OC4J_INSTALL_DIR>/j2ee/home/config/application.xml file. The following entry should exist in the file: <library path="../applib"/>

  3. Open <ERES_DEPLOY_DIR>/WEB-INF/classes/QB.properties file and change the AutoStartServerInstallDir entry to point to <ERES_DEPLOY_DIR>. Example:

    Original entry

    AutoStartServerInstallDir=<ERES_INSTALL_DIR>

    New entry

    AutoStartServerInstallDir=<ERES_DEPLOY_DIR>

    Next, you have to change Database URL. If the DatabaseUrl entry already exists in your QB.properties file, just change it to point to the hsql database under <ERES_DEPLOY_DIR>. Example:

    Original entry

    DatabaseUrl=jdbc\:hsqldb\:<ERES_INSTALL_DIR>/data/quadbasedb

    New entry

    DatabaseUrl=jdbc\:hsqldb\:<ERES_DEPLOY_DIR>/data/quadbasedb

    If the entry does not exist in your file, save the changes and open <ERES_DEPLOY_DIR>/WEB-INF/orguserdb/config.txt file. In the file, modify [database url] entry to point to the hsql database under <ERES_DEPLOY_DIR>. Example:

    Original entry

    [database url] jdbc:hsqldb:<ERES_INSTALL_DIR>/data/quadbasedb

    New entry

    [database url] jdbc:hsqldb:<ERES_DEPLOY_DIR>/data/quadbasedb

  4. Back-up the web.xml file under <OC4J_INSTALL_DIR>/j2ee/home/default-web-app/WEB-INF. Move all directories and files (except for the /orguserdb/ directory) under the <ERES_DEPLOY_DIR>/WEB-INF to the <OC4J_INSTALL_DIR>/j2ee/home/default-web-app/WEB-INF directory. This will make all the class files and servlets accessible from OC4J. If necessary, merge the old web.xml file with the web.xml file for ERES to create a new web.xml file.

  5. Start the Oracle server by executing the command java -jar oc4j.jar in the <OC4J_INSTALL_DIR>/j2ee/home directory.

  6. Go to the ERES Start page http://<server>:<port>/<ERES_CONTEXT>/index.jsp to start the ERES server. The ERES_CONTEXT will be the directory name of <ERES_DEPLOY_DIR>.

  7. From the ERES Start page, login as the administrator and launch the Admin Console.

  8. From Admin Console page, go to the Setting Info tab. Change the ERES Servlet Context entry to /servlet/.

  9. Stop and re-start the ERES server.

8.3.7. Oracle Application Server 10g R3 (10.1.3)

The following instructions show how to deploy EspressReport ES under Oracle Application Server 10g R3. The instructions assume that you have Oracle AS installed on the system with standard installation. The location of the Oracle AS installation is referenced as <O10g_INSTALL_DIR>

  1. Install ERES to the <O10g_INSTALL_DIR>/j2ee/home/default-web-app/ or

  2. Copy the ERES directory to <O10g_INSTALL_DIR>/j2ee/home/default-web-app/.

  3. The new location for the ERES directory is referenced as <ERES_HOME>.

  4. If the database is setup with direct path, open <ERES_HOME>/WEB-INF/classes/QB.properties and modify the database info as shown below.

    DatabaseUrl=jdbc:hsqldb:<ERES_HOME>/data/quadbasedb

  5. Move all directories and files (except for the /orguserdb/ directory) from <ERES_HOME>/WEB-INF to <O10g_INSTALL_DIR>/j2ee/home/default-web-app/WEB-INF/ directory.

  6. Add <ERES_HOME>/lib/ERESServer.jar to the CLASSPATH user variable.

  7. Go to http://<machine>:80/j2ee/ERES and start ERES server.

  8. In the admin console, change the servlet context to /j2ee/servlet.

    Click to view larger image

  9. Restart ERES Server

8.3.8. GlassFish Server 3.0.1

The following instructions show how to deploy EspressReport ES under GlassFish Server 3.0.1. The instructions assume that the application server and ERES are installed on the same machine and that GlassFish is up and running.

  1. Log on the GlassFish Admin Console. Click on Aplications or (in Glasfish v2) expand Applications on the left and then click on Enterprise Applications.

  2. Click on Deploy to deploy a new enterprise application.

  3. Select Browse Folders and select <ERES_INSTALL_DIR>.

  4. Enter ERES under Application Name and select the server under Virtual Server.

  5. Click on OK to finish deployment.

  6. In the Enterprise Application window, select the ERES application you have created and then select Launch. This will enable the enterprise application (i.e., start it) and launch it in a separate browser window. You can now start using ERES.