[dtp-connect-dev] Design - DB Connection Factories

[rcernich@xxxxxxxxxx]

Hey all,

I'm getting ready to resurrect the JDBC connection in db.generic.  I'd like
to get your opinion regarding changes to the project structure,
specifically regarding the definition of connection factories and content
extensions for DB connection profiles.

I think db.generic should only contain the connection factory for
java.sql.Connection.  I think the SQL model connection factory should be
moved to sqm.core and I think the SQL model content extension should be
moved to sqm.core.ui.

This will keep the profile and navigator extensions specific to SQL model
confined to the sqm.core plugins.  This will allow users not requiring SQL
model support to use generic DB connection profiles without needing to pull
in all the SQL model plugins (e.g. BIRT runtime).

Here's what the code changes would be:
Move IDBDriverDefinitionConstants from sqm.core to db.generic.
Move the SQL model connection factory from db.generic to sqm.core.
Move the SQL model content extension to the DSE from db.generic to
sqm.core.ui.
Reverse the dependencies between db.generic and sqm.core.

Let me know what you think.

Regards,
Rob