The DBServer runs on any server that
supports the JRE version 1.1.8. DBServer
maintains persistent connections to the chosen
database. DBServer uses JDBC drivers to connect
to the database. The configuration of DBServer
has the following steps :
- Selecting which
database drivers to use, currently we support
Oracle, Sybase, and mySql. We plan on adding SQL
Server in the near future.
- Where the database is
located and which username and password to use
to connect to the database.
- Name which DB's to
connect to and how many persistent connections
to that database.
- Which port that DBServer should listen
to for client connections.
The SQL Editor
The SQL Editor is a client program that
can run on any machine that supports the JRE
1.1.8 and has net access. With SQLEditor
you enter your SQL (Structured Query Lanquage)
statements, the values that will need to be
passed into the SQL statement from your templates
and the database that they should be run on.
The SQLEditor will connect to the DBServer
and store your SQL statement there making it
available for all developers to use on their
When designing your templates, developers can
refer to these SQL statements using tags by
specifying the ID number used in storing your
The Template Maker
The Template Maker is the work horse
tool for the developers. With this client tool
a developer can create new templates, and save
them on the DBServer, making that template
available for other developers to enhance, use
or copy. The TemplateMaker interacting
with DBServer has source code control
built in. Two developers cannot work on the
same template at the same time.
The TemplateMaker is where developers
tie SQL (Structured Query Language) statements
to a particular template. The SQL statements
are identified by their ID number given in the
SQLEditor. This is where the format or
style of the result set returned from the SQL
statement is specified. The developer can choose
from many HTML styles such as tables, select
lists, radio buttons, check boxes, and edit
forms. On tables you can specify alternating
Typically a developer would create an HTML
page using whatever tool they prefer, adding
the necessary images, frames, multimedia, whatever,
then open it up in the TemplateMaker
to add the necessary database interactions.
This allows XLiRAD to be compatible with
any other HTML commands.