IO17993: TDI 7.1/7.1.1 - DATABASE CONNECTOR INCORRECT FOR SQL

APAR status

• Closed as program error.

Error description

• Description:
  The protocol specifier of the JDBC URL for MS SQL should use
  'dbc'
  instead of 'jdbc'. The Database Connector is not doing this
  correctly
  when the MS SQL type is selected
  
  Steps to Duplicate:
  I have been able to duplicate the issue by create a test
  assemblyline
  with a Database Connector. I run and break at before
  initialize. I then
  check the value of
  DatabaseConnector.connector.getParam("jdbcSource")
  and it prints out:
  
  DatabaseConnector.connector.getParam("jdbcSource") >>
  dbc:sqlserver://localhost:15001;databaseName=testing
  
  Desired Behavior: The Database connector should be setting the
  jdbcSource to jdbc:sqlserver://......
  
  Environment:TDI 7.1 and 7.1.1
  
  Workaround: The customer can use the JDBC Connector and
  manually set
  the JDBC connection string.
  

Local fix

• 1795
  

Problem summary

• Problem with Database connector when used along with MS SQL
  

Problem conclusion

• This is bug in TDI code and has been fixed, formal fix will be
  made available in 7.1.0-TIV-TDI-FP0008.
  

Temporary fix

Comments

APAR Information

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

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

  IO18092

Fix information

• Fixed component name

  ITDI MULTIPLATF

• Fixed component ID

  5724D9960

Applicable component levels

• R710 PSY

     UP