Firebird connection pool with SJSAS

To use a connection pool datasource with the Sun Java System Application server you must copy the Firebird JDBC driver “Jaybird” in the directory ${com.sun.aas.instanceRoot}/lib/ext of your application server. The variable ${com.sun.aas.instanceRoot} stands for the application server instance directory, e.g. c:\sun\appserver\domains\domain1 for the default instance under windows environment.

The jaybird driver includes the following special classes for sun application servers:


Use the following properties to configure the datasource:

userName      FireBird username
password      FireBird password
databaseName  FireBird database URL (host:<database path>)
encoding      Database charset
loginTimeout  Login timeout (seconds)

PostgreSQL backup

PostgreSQL databases are dumped with the pg_dump command. A simple shell script to do the backup job could be as follows:

pg_dump -h <hostname> -U <user> -f <dumpfile> -Z 9 <dbname>

Passwords cannot be transfered to the pg_dump as a parameter, you must create a file .pgpass in the home directory of the calling user with the following content: