[dtp-dev] Question Concerning Statically vs. Dynamically Defined DB Meta

[rcernich@xxxxxxxxxx]

Hey all,

There are a couple of defects open against the connectivity framework
regarding the use of information in the DatabaseDefinition.  One is
concerned with version information
(https://bugs.eclipse.org/bugs/show_bug.cgi?id=166526) and the other is
concerned with quoted identifiers
(https://bugs.eclipse.org/bugs/show_bug.cgi?id=169307).

The first issue is related to using the version returned by the connection
to resolve a DatabaseDefinition as opposed to the information defined
within the driver definition.

The second issue is related to using the quote character defined by the
DatabaseDefinition as opposed to the character returned by
DatabaseMetaData.getIdentifierQuoteString().

The bigger issue is how should we handle cases where the DatabaseDefinition
(or driver definition) says one thing, but the actual connection says
something else?  I would propose we use the information on the connection,
defaulting to the statically defined information in the event the
information cannot be derived directly from the connection.

Any opinions?

Thanks,
Rob Cernich
DTP Connectivity Project Lead