glassfish
  1. glassfish
  2. GLASSFISH-1129

Container should run IBM JDBC drivers in Type 4 instead of Type 2

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Critical Critical
    • Resolution: Unresolved
    • Affects Version/s: 9.0peur1
    • Fix Version/s: not determined
    • Component/s: admin_gui
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: All

    • Issuezilla Id:
      1,129

      Description

      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.

        Activity

        Hide
        Tom Mueller added a comment -

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

        Show
        Tom Mueller added a comment - Bulk update to change fix version to "not determined" for all issues still open but with a fix version for a released version.
        Hide
        lancea added a comment -

        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

        Show
        lancea added a comment - 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

          People

          • Assignee:
            Anissa Lam
            Reporter:
            jdavidson
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: