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. Jean:

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

  2. Thiago M. Ferreira:

    Hey! Thank you very much for this Post! This save my skin!!

  3. Ed Colon:

    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.

  4. komarios:

    I have created a firebird (2.1) Connection Pool for GlassFish 2.1.1 here :

    http://mariosgaee.blogspot.com/2009/12/firebird-connection-pool-in-glassfish.html

    I hope you’ll find it useful.

Leave a comment