[GLASSFISH-1129] Container should run IBM JDBC drivers in Type 4 instead of Type 2 Created: 11/Sep/06  Updated: 06/Mar/12

Status: Open
Project: glassfish
Component/s: admin_gui
Affects Version/s: 9.0peur1
Fix Version/s: not determined

Type: Improvement Priority: Critical
Reporter: jdavidson Assignee: Anissa Lam
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Operating System: All
Platform: All

Issuezilla Id: 1,129


The IBM jdbc drivers can be run in Type 2 (native) or Type 4 (pure Java). By
default, Type 2 seems to be used.

Type 2 is much more restrictive, since native libraries are required. Different
libraries are used for each platform, and certain platforms (e.g., MacOS) appear
not to be supported at all.

The IBM drivers are the only ones that are supported in Type 2.

Unless there are additional mitigating factors, the drivers should be used in
Type 4 by default.

Comment by lancea [ 20/Mar/07 ]

The problem with the type 4 driver is that it does not support XA.

However, that being said, the DataSource should be one of the following
(universal driver) and not com.ibm.db2.jdbc.DB2DataSource:

  • com.ibm.db2.jcc.DB2SimpleDataSource
  • com.ibm.db2.jcc.DB2DataSource
  • com.ibm.db2.jcc.DB2ConnectionPoolDataSource
  • com.ibm.db2.jcc.DB2XADataSource

The driverType property should also be specified and either defaulted to 2 or 4

Comment by Tom Mueller [ 06/Mar/12 ]

Bulk update to change fix version to "not determined" for all issues still open but with a fix version for a released version.

Generated at Sat Mar 28 18:26:41 UTC 2015 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.