Quick Installation guide for WebsydianExpress™ for Java

This guide will help you through an installation of WebsydianExpress™ for Java with a Microsoft SQL server or System i as your database server and an Apache Tomcat as your servlet engine.

Step 1: Check prerequisites

Microsoft SQL Server

If you plan on using Microsoft SQL Server and do not all ready have one configured we recommend installing the Microsoft SQL 2005 Express Edition.

Make sure that you have your SQL Server listening on a TCP Port in order for the Java JDBC database driver to connect to it.

Servlet Engine

This installation guide requires that you have installed either version 5.x or 6.x of the servlet engine from Apache named Tomcat. The installation program for WebsydianExpress™ includes a packaging tool that will help you move to another servlet engine if required.

The Tomcat servlet engine requires Java version 5 or later. Obtain this at http://www.java.com

Step 2: Obtain the latest version of the WebsydianExpress™ for Java installation program

Make sure that you have the latest version of the WebsydianExpress™ for Windows installation program.

Current version and build is "WebsydianExpress™ v2.1 for Java"

Step 3: Install required files to your PC

Execute the installation program Express_v21_Java.exe. This will copy required files to your PC that will be used to package your WebsydianExpress™ for Java to your servlet engine and also includes the databases.

  1. Press the Next button
  2. Select the location where you which to install WebsydianExpress™
    Press the Next button
  3. Read and accept the license agreement of WebsydianExpress™
    Press the Next button
  4. Press the Install button
  5. Pres the Finish button

Step 4: Create database holding tables, views, and supplied data

Microsoft SQL Server

Execute the database installation program SetupDB.exe located in the subdirectory named \database\MSSQL in the directory where you installed WebsydianExpress™ files in step 3.

  1. Press the Next button
  2. On the database server dialog enter the following information and press the Next button
    • Database server where you would like to install the database
    • Login ID to be used to run SQL scripts
    • Password of the Login ID
    • Keep the database name as is.
      If you change the database name please note the name for later use.
  3. Keep the default settings of the "WebsydianExpress™ Database Options" and press the Next button
  4. Press the Install button.

IBM System i

Execute the database installation program EXPRESS20_JAVA.exe located in the subdirectory named \database\Systemi in the directory where you installed WebsydianExpress™ files in step 3.

  1. Press the Next button
  2. Press the Next button
  3. Enter required information for connecting to your System i. Then press the Next button
    • Host name of your System i
    • User id used to connect to your System i
    • Password used by the user
  4. Press the Next button to start transferring object to your System i
    If library name WXPJ20INST all ready exists you will be asked to overwrite or rename library.
  5. Press the Finish button

Open a System i console and logon with a user allowed to restore objects. Then run the System i Java database installation program as follows:

  1. Add the library WXPJ20INST to your library list
  2. Run the command WXPINST
    This will create the library WXPJ20DB on your System i and copy all required database objects into this library.
  3. At this point you may remove the WXPJ20INST library as this is only used for installation.

Step 5: Configure and deploy WebsydianExpress™ for Java to Tomcat

Execute the packaging tool for WebsydianExpress named pack.exe located in the directory where you installed WebsydianExpress™ files in step 3. The packaging tool helps you configure and package WebsydianExpress for Java instances to be deployed on a servlet engine.

  1. Press the Next button
  2. Press the Next button keeping default settings
  3. Press the Next button keeping default settings
  4. Press the Next button keeping default settings
  5. Now to the tricky part, the database configuration:
    Make sure that the settings are correct for the WebsydianExpress JDBC Database Connection Information. Then press the Next button.

    For Microsoft SQL Server use

    JDBC Driver: net.sourceforge.jtds.jdbc.Driver
    JDBC Datasource: jdbc:jtds:sqlserver://<SQLSERVERHOSTNAME>:<SQLSERVERTCPPORT>/WebsydianExpressForJava
    User: The user used to login to your SQL Server
    Password: The password of the user.

    For System i use

    JDBC Driver: com.ibm.as400.access.AS400JDBCDriver
    JDDB Datasource: jdbc:as400://<SYSTEMIHOSTNAME>/WXPJ20DB
    User: System i user to be used to connect
    Password: The password of the user
     

  6. Press the Next button keeping default settings
  7. Press the Install button
  8. Make sure that you answer Yes to the question of deployment to your local instance of Tomcat.

The packaging tool can be run again and again to redeploy your WebsydianExpress™ instance.

Step 6: Access the WebsydianExpress™ demosite and administration interface

After packaging and deploying your  WebsydianExpress™ for Java please allow time for the Tomcat engine to initiate the packages deployed. Then the supplied demosite can be accessed by entering the following web address in your browser:

http://<HostName>/express21java/site/demosite

Make sure that you replace the '<HostName>' with the host name of your computer

Login with user Customer and password Customer to login to one of the sites and access the administration interface.

The web address used in this example is based on the default settings used by the installation program.

 

In order to access the administration part of the demosite append /admin to the url

http://<HostName>/express21java/site/demosite/admin

Make sure that you replace the '<HostName>' with the host name of your iSeries

Login with user WSADMIN and password ADMIN in order to access the administration interface of the demosite.



 

Obtain a license for your WebsydianExpress™ for Java

By default the WebsydianExpress™ is installed with an unregistered license of the Websydian Server providing 10 concurrent sessions.

You have the option to obtain a registered version for 10 concurrent sessions for free that enables you to find a starting point on the number of concurrent sessions required by your applications.

For pricing on concurrent sessions please contact info@websydian.com.

Uninstalling the WebsydianExpress™ for Java

The following are the steps to complete in order to completely remove WebsydianExpress™ v2.1 for Java from your system

  1. In the Tomcat directory locate the webapps directory and remove the express21java.war file
  2. In the program files directory locate the directory Websydian and delete the directory named "Express v2.1 for Java"
  3. In the SQL Server remove the database "WebsydianExpress21ForJava" on the System i remove the library WXP21DBJVA