Subject Firebird pool in Sun Java System Application Server
Author Dmitry Mozheyko
Hi all!
I tried to create connection pool in Sun Java System
Application Server Platform Edition 8.1_02 (build
b06-fcs) and firebird database
FirebirdSS-1.5.2.4731-0.
I use driver FirebirdSQL-1.5.5JDK_1.4.zip.

I made following steps:
1) copy firebirdsql-full.jar into
${com.sun.aas.installRoot}/domains/domain1/lib/
directory
2) change JVM settings of appserver JVM Settings ->
Path Settings -> Classpath Prefix:
${com.sun.aas.installRoot}/domains/domain1/lib/firebirdsql-full.jar
3) Create connection pool:
Datasource Classname:
org.firebirdsql.pool.FBWrappingDataSource (or
org.firebirdsql.pool.FBConnectionPoolDataSource with
same result)
Resource Type: javax.sql.ConnectionPoolDataSource
(or javax.sql.XADataSource or javax.sql.DataSource
with same result)
and add parameters:
- database:
localhost/3050:/opt/firebird/bases/test.gdb
- userName: SYSDBA
- password: masterkey
- type: TYPE4
- charSet: UTF-8
- encoding: UTF-8
- blobBufferSize: 512
- socketBufferSize: 512

And if i ty to use this pool server error log contains
no errors, but timeout exceeded.
if i change type from TYPE4 to TYPE2 error message:
Operation 'pingConnectionPool' failed in 'resources'
Config Mbean. Target exception message: no jaybird in
java.library.path.

What's wrong?


[Non-text portions of this message have been removed]