Troubleshooting
Problem
The WebSphere Adapter for JDBC, version 6.0.0.2 supports date fields as primary keys. The WebSphere Adapter for JDBC User Guide, version 6.0 does not describe the date and time format for the object_key column in the event table.
Resolving The Problem
If the key value is of the date or time type for the object_key column in the event table, use the following format:
The date format is yyyy-mm-dd
The time format is hh:mm:ss
To use date and time, the format is yyyy-mm-dd hh:mm:ss
[{"Product":{"code":"SSMKUK","label":"WebSphere Adapters Family"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Adapter for JDBC","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.5;7.0.2;7.0.1;7.0.0.4;7.0.0.3;7.0.0.2;7.0.0.1;7.0;6.2.0.3;6.2.0.2;6.2.0.1;6.2;6.1;6.0.6;6.0.5;6.0.4;6.0.3;6.0.2.3;6.0.2.2;6.0.2.1;6.0.2;6.0.1;6.0.0.2;6.0.0.1;6.0","Edition":"-NA-","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21240920