in Firebird |

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)

Published

Write a Comment

Comment

15 − six =

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

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

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

  3. 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.