[DBCP-152] [DBCP] add a socketFactory attribute to BasicDataSource (to allow SSL "thread"-safe)

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 1.2
• Fix Version/s: 1.3

Environment

Operating System: All
Platform: Other

• Bugzilla Id: 38603
• Assignee: Unassigned
• Reporter: Ralf Hauser
• Created: 10/Feb/06 16:45
• Updated: 23/Jul/07 19:06
• Resolved: 23/Jul/07 19:06

Description

An app that accesses 2 datasources at two different places with different
security policies via SSL (different set of permitted ciphers) currently is out
of luck (http://lists.mysql.com/java/8689).

The basic datasource should be enhanced with

String socketFactory = "";

and the corresponding getter and setter method, etc.

org.apache.commons.dbcp.DriverConnectionFactory.createConnection() could then
hand-over this full className via its Properties argument to enable different
SSL policies per datasource (so, since the application programmer doesn't have
the thread under her control, I guess it should rather be called "dataSource-safe").

The jdbc driver implementation can then use this to take the appropriate socket
factory when creating a connection.

See also http://lists.mysql.com/java/8695