On 15-2-2013 20:50, p.bondar wrote:

> Hello!
> Prompt please create conection pool glassfish 3.1.2 server for database firebird 2.5 in netbeans. Pool is created with no errors, the application compile, but at the start and the direct reference to the pool the following error:
> javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: Could not obtain connection during blocking timeout (5000 ms) or
> javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: GDS Exception. 0. Connection string missing.
> Tried different classes of driver jaybird 2.2.1 and configuration. The first version of the error appears when you use classes org.firebirdsql.pool.FBConnectionPoolDataSourceorg.firebirdsql.pool.sun.AppServerConnectionPoolDataSource and resources javax.sql.DataSource; javax.sql.ConnectionPoolDataSource respectively.
> and the second using org.firebirdsql.ds.FBConnectionPoolDataSource and javax.sql.ConnectionPoolDataSource.
>
> Please help me with a question on creating conection pool for firebird on glassfish or tomcat.I will be glad to help.

Don't use the class from org.firebirdsql.pool; they are known to be
broken, especially when used in combination with an Application server
connection pool.

The full stacktrace would have helped to pin the problem down with
org.firebirdsql.ds.FBConnectionPoolDataSource, but with some trying I
can get that error if I don't specify the serverName property.

At minimum you need to specify the following properties:

serverName (with hostname or IP address)
databaseName (with path or alias of the database)
user (Firebird username)
password (Firebird password)

Instead of the properties serverName, portNumber and databaseName you
can also use one property:
database (with <server>[/<port>]:<path-or-alias>, where the
portnumber is optional)

I would advise not to use the "database" property as it is non-standard
(JDBC defines the serverName, databaseName and portNumber properties),
and we might remove it in the future.

Mark
--
Mark Rotteveel