LI77217: INSERT OF DATETIME OBJECT TO SQL SERVER MAY NOT ACCURATELY CONVERT MILLISECOND VALUE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When inserting a datetime object into SQL Server 2005 using Cast
    Iron there is some incorrect conversion going on if the DB
    connector expects it to be 3 digits for milliseconds.
    
    The following are some examples.
    
    If we have a datetime xml object 2013-01-28T12:44:12.62 it
    inserts into SQL server as 2013-01-28 12:44:12.063
    If we have a datetime xml object 2013-01-28T12:43:04.87 it
    inserts into SQL server as 2013-01-28 12:43:04.087
    

Local fix

Problem summary

  • When inserting a datetime object into a database using Cast
    Iron, incorrect conversion was occurring on the date/time stamps
    being inserted.
    The following are some examples.
    
    If we have a datetime xml object 2013-01-28T12:44:12.62 it
    inserts into SQL server as 2013-01-28 12:44:12.063
    If we have a datetime xml object 2013-01-28T12:43:04.87 it
    inserts into SQL server as 2013-01-28 12:43:04.087
    
    This was occurring because the Cast Iron database connector
    was incorrectly handling the millisecond values.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    LI77217

  • Reported component name

    WS CASTIRON HV

  • Reported component ID

    5725C1100

  • Reported release

    630

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-14

  • Closed date

    2013-03-20

  • Last modified date

    2013-03-20

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

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

Fix information

  • Fixed component name

    WS CASTIRON HV

  • Fixed component ID

    5725C1100

Applicable component levels

  • R630 PSY

       UP



Document information


More support for:

WebSphere Cast Iron Hypervisor Edition Standard

Software version:

630

Reference #:

LI77217

Modified date:

2013-03-20

Translate my page

Content navigation