Bug 253630 - API support to create a transient JDBC connection profile instance based on generic JDBC connection properties
Summary: API support to create a transient JDBC connection profile instance based on g...
Status: RESOLVED FIXED
Alias: None
Product: Data Tools
Classification: Tools
Component: JDBC Conn Profile (show other bugs)
Version: Ganymede   Edit
Hardware: PC Windows 2000
: P3 enhancement (vote)
Target Milestone: 1.7RC1   Edit
Assignee: dtp.connectivity-inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords: plan
Depends on: 253523 253584 253606
Blocks:
  Show dependency tree
 
Reported: 2008-11-03 19:58 EST by Linda Chan CLA
Modified: 2009-05-19 13:43 EDT (History)
0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Linda Chan CLA 2008-11-03 19:58:51 EST 
In the current DTP connection profile framework, a JDBC connection profile instance is expected to get created based on user input and selection of a specific driver definition.  The proposed enhancement is to add the capability to take the basic JDBC connection properties (that may be used with JDBC API to open a connection) and use DTP Connectivity API to create a corresponding, transient connection profile instance that can be used to connect and access the DTP enablement features.

To support the above feature, 3 areas of enhancements are identified.  
In order to systematically map generic JDBC connection properties to a DTP Database connection profile properties, it will need to navigate and identify the corresponding values for these 2 sets of connection profile properties:
* Database vendor and version (specifics in bug #253523)
* Connection profile provider id (specifics in bug #253584)

In addition, a connection profile instance is normally persisted in a repository.  Additional support to create a transient connection profile instance would make it easier for adopters use (specifics in bug #253606).
Comment 1 Brian Fitzpatrick CLA 2009-05-19 07:21:21 EDT 
Linda, can we consider this closed for Galileo?
Comment 2 Linda Chan CLA 2009-05-19 13:43:54 EDT 
Yes, indeed.