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

Properties:
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 127.0.0.1 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
errormessage.

Regards,
Mark

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.\
> GDB
>
> 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@...>