Re: [DBCP] PStmtKey with SQL and catalog but not schema.

2018-06-20 Thread Gary Gregory
On Wed, Jun 20, 2018 at 8:54 AM Gary Gregory wrote: > On Wed, Jun 20, 2018 at 6:04 AM Mark Thomas 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,

Re: [DBCP] PStmtKey with SQL and catalog but not schema.

2018-06-20 Thread Gary Gregory
On Wed, Jun 20, 2018 at 6:04 AM Mark Thomas 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

Re: [DBCP] PStmtKey with SQL and catalog but not schema.

2018-06-20 Thread Mark Thomas
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.