Subject | Re: [Firebird-Java] Can I cache prepared statements in my own pool? |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-07-08T05:13:48Z |
> Can I make my own pool for statements, keep prepared statements inPrepared statements belong to the connection. You cannot prepare statement
> static variables, and execute them in different connections taken from
> that pool?
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
code.
Roman