|
Quick Start
Tomcat 6
- Download the rbt archive from www.rbtdata.org and unzip contents
into a work directory - zip file contents are described below:
- rbt.war - web application archive
- rbtapi.jar - api library for customization
- rbtdoc.zip - web files containing rbt documentation
- javadocs.zip - rbtapi javadocs
- examples directory - contains example deployment descriptor, configuration file and database scripts
- dbscripts directory - contains sql scripts to create RBT security tables in Oracle, SQL Server and MySQL
- xmlschemas directory - contains XML schemas defining DBT XML objects
used in the application
- Create and initialize the RBT security tables. SQL file templates for MySQL, Oracle and SQL Server can be found under the dbscripts directory.
- Open the rbt.config.xml file found in the examples directory and configure the security and data datasource entries. There are alot of comments but the basic entries
are similar to what is shown below. There should be 1 security datasource pointing to the database setup from step #2 and 1 or more data datasources
for reporting.
<datasources>
<security>
<jndiName>jdbc/mysecuritydb</jndiName>
<displayName>MySQL Database</displayName>
<catalog></catalog>
<schema>rbt</schema>
<tableTypes>
<tableTypeName>TABLE</tableTypeName>
<tableTypeName>VIEW</tableTypeName>
</tableTypes>
<useCatalog>false</useCatalog>
<dbms>MySQL</dbms>
<quotedFieldChar>`</quotedFieldChar>
</security>
<data>
<jndiName>jdbc/MySQLDB</jndiName>
<displayName>Movie Rentals</displayName>
<catalog>sakila</catalog>
<schema></schema>
<useCatalog>true</useCatalog>
<dbms>MySQL</dbms>
<quotedFieldChar>`</quotedFieldChar>
<tableTypes>
<tableTypeName>TABLE</tableTypeName>
<tableTypeName>VIEW</tableTypeName>
</tableTypes>
</data>
</datasources>
-
Unzip the rbt.war file and modify the web.xml to specify the location where the rbt.config.xml file will be located.
<context-param>
<param-name>rbt.configuration.file.path</param-name>
<param-value>C:/dev/projects/rbtdata/rbtapi/src/main/resources/example/rbt.config.xml</param-value>
</context-param>
- Modify the web.xml to ensure the the datasources setup in the rbt.config.xml file are included as
<resource-ref> entries.
<resource-ref>
<description>MySQL</description>
<res-ref-name>jdbc/MySQLDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<resource-ref>
<description>MySQL Rbt</description>
<res-ref-name>jdbc/mysecuritydb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
- Re-packaged the rbt.war with the configured web.xml
- Ensure that the security and data datasources are correctly configured in the Tomcat Context.xml
- Ensure that the rbt.config.xml file is placed in the location specified in the web.xml
- Start tomcat and drop the rbt.war file into the webapps directory
- Once deployed the RBT applications can be accessed at the following URLs:
- administrator -
http://[your_server_name]/rbt/admin.html
- designer -
http://[your_server_name]/rbt/designer.html
- runner -
http://[your_server_name]/rbt/
- The initial administrator username and password are: admin/admin.
Other Containers
To deploy RBT to other web containers you will follow steps similar to the tomcat configuration described
above; however, container-specific configuration may be required. The rbt.war file contains
the JAX-WS 2.1 libraries which may cause conflicts on containers providing the libraries by default.
To add container-specific configuration files, unzip the rbt.war, add the required configuration files and re-zip the archive.
To resolve library conflicts, unzip rbt.war, pull the duplicate libraries from the WEB-INF/lib directory and re-zip the archive.
|