Subject Re: [Firebird-Java] connection pool in a Sun Java System Application Server PE 8.1 2005Q1
Author Mark Rotteveel
I have no idea, on GlassFish v2ur2 (Sun Java System Application Server
9.1_02) it works with the following settings:

Class: org.firebirdsql.pool.FBSimpleDataSource

database : //localhost:3050/D:\Development\AdresBoek\ADDRESSBOOK.FDB
userName : sysdba
password : masterkey

All other settings are default. I would however advise you to use the
property database (not databaseName (deprecated) or url; the property
url does nothing for a datasource).

Also a timeout could indicate that a server is listening on the port
specified, but not responding. Also try instead of localhost,
maybe there is an IPv4 <-> IPv6 problem going on here.

It might be wise to check the appserver logs for the stacktrace of the
exception, because that usually provides more information than the


gongoca wrote:
> Hello.
> I am trying to create a connection pool in a Sun Java System
> Application Server Platform Edition 8.1 2005Q1 over a database Firebird
> 2.1.1 through the Jaybird-2.1.6 driver for the JDK 1.5. The driver is
> referenced in the JVM configuration in the server.
> The SJSAS is working and the Firebird database too.
> The current configuration in the application server is:
> Resource class name ---> org.firebirdsql.pool.FBSimpleDataSource
> Resource type --->javax.sql.DataSource
> url --->
> jdbc:firebirdsql://localhost:3050/C:\Apps\Development\EJB\EJB_DDBB\DDBB.\
> DatabaseName --->
> //localhost:3050/C:\Apps\Development\EJB\EJB_DDBB\DDBB.GDB
> UserName ---> sysdba
> Password ---> masterkey
> The rest of values are by default and, when I ping the server, I
> retrieved errors. The last one is a "Could not obtain connection during
> blocking timeout (5000 ms)"
> I have tried to use alias in the url and DatabaseName properties, to
> use
> the org.firebirdsql.pool.sun.AppServerDataSource resource class, to
> change the conexión string to the all allowed ones, to use in the
> DatabaseName properties the path without host and port, with the same
> result.
> Please, I will be grateful for any contribution.
> Thanks.

Mark Rotteveel <Avalanche1979@...>