JR37389: THE ODBC CONNECTOR JOBS FAILING WHILE CONNECTING TO MYSQL SERVER AND WHEN THE ARRAYSIZE IS GREATER THAN 1.

APAR status

• Closed as program error.

Error description

• While using the ODBC Connector with the MySQL server, the
  connector jobs are failing with a Fatal exception and logs
  the following message in the job log "Caught unknown exception
  from runLocally()". This happens the arraysize is greater than
  1. The job works fine when the arraysize is set to 1.
  

Local fix

• Use Array Size of 1.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users using ODBC Connector and Connecting to MySQL database.
  ****************************************************************
  PROBLEM DESCRIPTION:
  While using the ODBC Connector with the MySQL server, the
  connector jobs are failing with the a Fatal exception and logs
  the following message in the job log "Caught unknown exception
  from runLocally()". This happens the arraysize is greater than
  1.
  The job works fine when the arraysize is set to 1.
  
  ****************************************************************
  RECOMMENDATION:
  Apply the APAR
  ****************************************************************
  

Problem conclusion

• In the code, at couple of places, the arraysize was hardcoded
  to 1 when the Database Type is MySQL, since the older versions
  of the MySQL drivers did not support the array functionality.
  This was causing the current problem when the Arraysize was set
  to a value greater than 1. After analysing the code, I have
  corrected the code to properly set the arraysize at all the
  relavant places in the code flow. In case customer is using the
  older drivers, they either need to upgrade to the new drivers
  or explicitly set the
  arraysize to 1, if they need to use the old drivers only.
  

Temporary fix

• Set the Arraysize to 1.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• ODBC CC
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP