Configuring Sybase Adaptive Server Anywhere Databases

This chapter describes how to configure your Sybase Adaptive Server Anywhere (ASA) database for use with the Novell exteNd Application Server as a SilverMaster or deployment database. It includes these sections:

For more information For the latest information on supported database versions, see the Novell exteNd Application Server Release Notes.

Preparing to use Sybase ASA

Before you can set up Sybase ASA databases for use with the application server, you must:

Install Sybase ASA
Prepare to use the jConnect driver

Installing Sybase ASA

If you don't have a supported version of the Sybase ASA software already installed, you need to obtain it from Sybase and install it yourself.

For more information, go to www.sybase.com.

Preparing to use jConnect

The application server connects to Sybase ASA using jConnect (Sybase's JDBC driver). jConnect is included as part of the Sybase ASA installation.

When you install ASA using the Sybase wizard, the driver is installed in the Sybase Shared directory. To use jConnect, you need to do this one-time setup:

Set AGCLASSPATH (environment variable for the server's classpath) on the machine where your application server is running to include the path to the jConnect 5.5 driver:
```
  AGCLASSPATH=SybaseInstallDir\Shared\jConnect-5_5\classes\jconn2.jar 
```
For example, if you installed ASA in the default location, you would specify this in AGCLASSPATH:
```
  AGCLASSPATH=c:\Program Files\Sybase\Shared\jConnect-5_5\classes\jconn2.jar
```
For more information on listing JDBC driver JARs via AGCLASSPATH, see the chapter on data source configuration in the Administrator's Guide.

Setting up SilverMaster and deployment databases

To set up a Sybase ASA database as a SilverMaster or deployment database, do the following:

Create a database.
Create a user account to be used by the application server.
Configure Sybase ASA to run as a service.
Make the database available to the application server.

The following sections describe these steps.

Step 1: Create a database

To create your ASA database, use Sybase Central. If this will be the SilverMaster database, you must create it before installing the application server.

For more information on creating ASA databases, see the Sybase Central online help.

Step 2: Create user accounts

Sybase ASA provides a default user dba with the password sql. You can use this user name and password pair for your SilverMaster database or any other Sybase ASA database.

However, it is strongly recommended that you set up separate accounts for your SilverMaster and for each deployment database; this way you can easily tell which applications are hitting your database when and how often, and you can more easily troubleshoot performance problems. Make sure these accounts have at least Resource and Connect privileges.

For more information about setting up user accounts, see the Sybase Central online help.

Step 3: Run Sybase ASA as a service

It is recommended that you run your Sybase ASA databases as services to make database use and maintenance easier.

For more information For information about running Sybase ASA as a service, see the Sybase ASA online help. (In that help, select ASA Database Administration Guide. Go to "Running the server outside the current session" in Chapter 1.)

Step 4: Make the database available to the application server

If you're using ASA for the SilverMaster database, you can install the application server and point to your ASA database as SilverMaster (as described in Installing Novell exteNd).

If you're using an ASA database as a deployment database, you can make that database available by adding it to the application server:

Make sure the database is running. If it is not running as a service, you can start it using Sybase Central.
Using the SMC, add the database to the server.

Specify the name of the database, the user name and password, and the JDBC URL for the database, which has the following format:
```
  jdbc:sybase:Tds:hostname:port?SERVICENAME=dbname
```
For example, if your database is named MyDB and you are running it locally at the default ASA port of 2638, your JDBC URL would be:
```
  jdbc:sybase:Tds:localhost:2638?SERVICENAME=MyDB
```

Another way to make a database available to the application server is by defining a JDBC connection pool for it.

For more information on adding databases to the server and defining connection pools, see the chapter on data source configuration in the Administrator's Guide.