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:

org.firebirdsql.pool.sun.AppServerDataSource
org.firebirdsql.pool.sun.AppServerConnectionPoolDataSource
org.firebirdsql.pool.sun.AppServerXADataSource

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)

4 Comments

  1. you know what may be this error?
    could not obtain connection during blocking timeout(10000ms)

  2. Hi guys,

    I have spent some time trying to figure out why when I try to define the Database Vendor for Firebird, that one is not available. As I can see, you solved this problem. Could you tell me which database vendor did you use?

    Thanks in advance, and let me tell you that’s a great site.

Leave a Reply

Your email address will not be published. Required fields are marked *

16 − 15 =

This site uses Akismet to reduce spam. Learn how your comment data is processed.