On Wed, Jun 20, 2018 at 6:04 AM Mark Thomas <ma...@apache.org> wrote:

> On 20/06/18 01:43, Gary Gregory wrote:
> > The PStmtKey class keys off of a SQL statement, catalog but not the
> schema.
> >
> > Since a catalog is usually a collection of schema, shouldn't we use the
> > schema as part of this key?
>
> If only the relationship was that simple. And consistent across vendors.
>
> There is a good summary here on SO:
>
> https://stackoverflow.com/questions/7942520/relationship-between-catalog-schema-user-and-database-instance
>
> > (Java 7 added supported for getSchema() on a Connection.)
>
> Assuming that the SO information is correct (I have no reason to think
> otherwise apart from cynicism) then including the schema in the key
> makes sense to me.
>

Tracking here: https://issues.apache.org/jira/browse/DBCP-508

Gary


>
> Mark
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscr...@commons.apache.org
> For additional commands, e-mail: dev-h...@commons.apache.org
>
>

Reply via email to