Subject Re: [Firebird-Java] Does that Tutorial good to create FB Connection Pool in Glassfish ?
Author Mark Rotteveel
On Fri, 24 May 2013 09:41:37 -0000, "fb_database" <fb_database@...>
wrote:
> Hi to all :)
>
>
> I am able to connect to database from Java.
> But I cannot create a connection pool for FB in Glassfish...

Please be more specific: describe the problem or errors.

> The tutorial is for Firebird 2.1 And GlassFish Server 3.1
> * Here the link :
>
http://h-acosta.blogspot.fr/2011/11/how-to-create-jdbc-connection-pools.html
>
> * I have tried on Windows, with Glassfish 3.1.2.2 and
> jaybird-full-2.2.3.jar

Don't use jaybird-full with an application server, use jaybird-2.2.3.jar.
The jaybird-full jar contains files that are also part of you application
server and this could give conflicts.

> I use Firebird-2.5.2.26540_0
> * but if I am not wrong this tutorial not seems to work... ??**
> * Please what are the correct settings ?
> Because I am unable to ping the Server from the Domain Admin Console of
> Glassfish.
>
>
> * I have added the Jar :
> jaybird-full-2.2.3.jar
>
> in folder :
> /glassfish-3.1.2.2/glassfish/domains/domain1/lib/
>
> * I have manually set these parameters :
>
> Datasource Classname:
> org.firebirdsql.pool.sun.AppServerDataSource

Don't use this class. Use (for example)
org.firebirdsql.ds.FBConnectionPoolDataSource with resource type
javax.sql.ConnectionPoolDataSource

The properties specified in the tutorial are incorrect. I will respond in
more detail on Sunday, I don't know the exact config by heart.

Mark