Subject Re: [Firebird-Java] Can I cache prepared statements in my own pool?
Author Roman Rokytskyy
> Can I make my own pool for statements, keep prepared statements in
> static variables, and execute them in different connections taken from
> that pool?

Prepared statements belong to the connection. You cannot prepare statement
in one connection and use with another. So, you can create your own pool of
statements, but it must also pool connections. But in this case just use the
FBWrappingDataSource or FBConnectionPoolDataSource - that is what you want
to implement. FBDataSource does not pool connections, this is only
implementation of the javax.sql.DataSource interface and is part of the JCA