Subject Re: [Firebird-Java] Java: Cannot get a connection, pool exhausted
Author Roman Rokytskyy
Hi,

> I am trying to connect to my Firebird database from Java, but I get
> the following error message:
>
> org.apache.commons.dbcp.SQLNestedException: Cannot get a connection,
> pool exhausted, cause:
> java.util.NoSuchElementException: Could not create a validated object
> at
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.ja\
> va:851)
> at
> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:1\
> 40)
>
> I am using this driver: org.firebirdsql.jdbc.FBDriver
>
> And this Database URL:
> jdbc:firebirdsql:localhost/3050:C:\\Subfolder\\Subfolder\\THEDB.FDB

I do not know the DBCP behavior in details, so check the following:

- database server is started
- jdbc driver is in the classpath
- database path is correct

In theory there must be bigger stack trace including org.firebirdsql.*
classes, it will contain much more useful information.

Alternatively, post the DBCP configuration/Java code you use to access
the database.

Roman