Section 1
Introduction

Section 2
Configuring for First Use

Section 3
Changing Admin Password

Section 4
Creating Accounts

Section 5
Global Component Settings

Section 6
Backups

Section 7
Log Files

Section 8
User Interface Settings

Section 9
Database Connections

9.2 Optimizing Hints

9.3 Connecting to a Different Database

9.4 Disabling and Enabling Internal Database

9.5 Registering Database Plugin

9.6 Installing JDBC Drivers

Section 10
Non-Standard Ports

Section 11
Firewalls

Section 12
SSL

Section 13
Tracking and Recipient Profiles

Section 14
Editing INI Files

Section 15
Distributed Components

Section 16
User Interface Branding

Section 17
Evaluation Mode

Section 18
International Character Sets

Appendix A
Standard Default Ports

9.6 Installing JDBC-Drivers for Different Databases

The Maestro User Interface is a Java server application that uses JDBC to connect to the configured database. Therefore, it is necessary to install a compatible JDBC driver for the database. Each database plugin (see Section 9.5 Registering Database Plugins for more information) has been developed to use exactly one JDBC driver. There may be several plugins for the same database, each of which uses a different driver to access that database. The specific plugin to be used depends on the database and the JDBC driver available for that database.

Important Note: After installing a new JDBC driver into LISTSERV Maestro (see descriptions below), it is necessary to restart LISTSERV Maestro to make it aware of the new driver.

The plugins available at the time this document was written support five different drivers for four different databases:

  • L-Soft MySQL JDBC-driver - For connection to the MySQL database 3.23.42 or later. This driver is installed together with LISTSERV Maestro. No special installation is necessary to access this driver or its plugin.
  • IBM JDBC-driver for DB2 V7.2 - To use this driver, first install the DB2 run-time clients (from the runtime folder of the DB2 installation package) on the server(s) where the Maestro User Interface and the Administration Hub are running. Use the client to connect to a database on the DB2 server (see Section 9.1.3 Preparing DB2). It is important to install the clients on the Maestro User Interface server and the Administration Hub server, not on the server where the database is installed (except of course, if both components happen to be on the same server). Next, copy the file “db2java.zip” from the run-time client installation to the LISTSERV Maestro installation (shown for a default installation):

    Copy the file “db2java.zip” from the “java” folder in the DB2 run-time client installation

    \Program Files\IBM\SQLLIB\java

    into the "lib" folder in the LISTSERV Maestro installation

    \Program Files\L-Soft\Application Server\lib

    Where to find the driver: The run-time clients (which in turn include the JDBC-driver file as described above) are included in the installation package for DB2 when a license is purchased. At the time this document was written, a 60-day trial version of the database (including the JDBC-driver) was available at IBM’s website. A valid license for the DB2 database must be purchased from IBM before using its driver or using it together with the Maestro User Interface.
  • Oracle 8i Thin Driver - This driver comes in the form of a file called “classes12.zip”. Simply copy this file into the “lib” folder in the LISTSERV Maestro installation

    \Program Files\L-Soft\Application Server\lib

    Where to find the driver: The driver can be downloaded from the Oracle Technology Network: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html Then follow the link to download the "Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.2.x for NT". After accepting the license agreement, click on the "JDBC-Thin, 100% Java" link in the section "for use with JDK 1.2.x". This should trigger the download of the "classes12.zip" file. This description mirrors the structure of the OTN-Web site at the time this document was written. The location of the pages and the names of the links may have since have changed. A valid license for the Oracle database must be purchased from Oracle before using its driver or using it together with the Maestro User Interface.
  • Microsoft SQL Server 2000 JDBC-driver - Install the driver on any desired computer. It is not important that the driver be installed on the same computer as the Maestro User Interface, but it is important that the following files are copied from the installation folder of the driver to the installation folder of LISTSERV Maestro (shown for a default installation):

    Copy the files "msbase.jar", "mssqlserver.jar" and "msutil.jar" from the "lib" folder in the SQL Server JDBC-driver installation

    \Program Files\Microsoft SQL Server 2000 driver for JDBC\lib

    into the "lib" folder in the LISTSERV Maestro installation

    \Program Files\L-Soft\Application Server\lib

    This driver is published by Microsoft as a driver for SQL Server 2000 only. It will probably not work with SQL Server 7.0. L-Soft has not tested it with SQL Server 7.0 and only recommends using it only with SQL Server 2000. Also, at the time this document was written, the driver was still in a beta stage (L-Soft has tested both Beta 1 and Beta 2 - the final release is announced by Microsoft for spring 2002). L-Soft has not experienced any problems during our tests with the driver. We do recommend waiting until its final release before using it in a production environment.

    Where to find the driver: At the time this document was written, the beta version of the driver was available for download from this URL at Microsoft's website: http://www.microsoft.com/sql/downloads/2000/jdbc.asp

    In case this URL is no longer valid, try the MS SQL Server site, and look for the downloads section: http://www.microsoft.com/sql/

    A valid license for the SQL Server database must be purchased from Microsoft before using it together with the Maestro User Interface.
  • I-net SPRINTA JDBC-driver for MS SQL Server 7.0/2000. From the SPRINTA download/installation, copy the file “Sprinta2000.jar” into the “lib” folder in the LISTSERVMaestro installation

    \Program Files\L-Soft\Application Server\lib

    Where to find the driver: The driver can be purchased from I-net software: http://www.inetsoftware.de/ At the time this document was written, the SPRINTA driver home page could be found at the following location: http://www.inetsoftware.de/English/Produkte/JDBC2/Default.htm The evaluation version of this driver, which is (or was at the time this document was written) available for download, may contain a limitation of the number of concurrent database connections that will make the Maestro User Interface fail during operation. The evaluation version is, therefore, not supported for use with the Maestro User Interface.

    While the SPRINTA driver also supports MS SQL Server 6.5, the Maestro User Interface does not. The Maestro User Interface requires MS SQL Server 7.0 or later. A valid license for the SQL Server database must be purchased from Microsoft before using it together with the Maestro User Interface. Also, a valid license for the SPRINTA driver must be purchased from I-net software before using this driver to access SQL Server.