LI77257: STRING INDEX OUT OF RANGE: -1 ERROR RECEIVED WHILE INSERTING A DATE WITHOUT TIME VALUE TO A DATETIME DB FIELD
Direct links to fixes
Closed as program error.
Inserting a datetime value without time in to a DATETIME type field in to a Oracle table fails with the error message: String index out of range: -1 This issue is seen across all databases. For example: Inserting 2013-02-05 value in to a DATETIME type column in a Oracle table fails with this error.
The workaround is to append the data value with a dummy time string to provide datetime value as an input. For example : Append the date 2013-02-05 with the time string T00:00:00T00:00:00.000Z
Inserting a date value without time in to a DATE type field in to a Oracle table fails with the error message: String index out of range: -1 For example: Inserting 2013-02-05 value in to a DATE type column in a Oracle table fails with this error. This was occurring due to an error when handling the date and date/time formats when performing database update activities.
The WebSphere Cast Iron code has been corrected to handle this operation. The fix has been targeted for WebSphere Cast Iron fix packs 220.127.116.11 and 18.104.22.168 Announcements of new fix packs are made on the WebSphere Cast Iron Support Portal at http://www-947.ibm.com/support/entry/portal/Overview/Software/We bSphere/WebSphere_Cast_Iron_Cloud_integration For planned fixpack maintenance release dates, see the following support announcement: http://www-01.ibm.com/support/docview.wss?uid=swg27036374
Reported component name
WCI HV DEV ENTP
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
WCI HV DEV ENTP
Fixed component ID
Applicable component levels
More support for:
WebSphere Cast Iron Hypervisor Edition Enterprise
Software version: 630
Reference #: LI77257
Modified date: 20 March 2013