What types of DataSource objects are specified in the Optional Package?

Joe Sam Shirah

  • Basic - Provides a standard Connection object.
  • Pooled - Provides a Connection pool and returns a Connection that is controlled by the pool.
  • Distributed - Provides a Connection that can participate in distributed transactions ( more than one DBMS is involved). It is anticipated, but not enforced, that a distributed DataSource will also provide pooling.
However, there are no standard methods available in the DataSource class to determine if one has obtained a pooled and/or distributed Connection.