Subject | Firebird pool in Sun Java System Application Server |
---|---|
Author | Dmitry Mozheyko |
Post date | 2005-09-16T08:03:45Z |
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]
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]