[fdo][FDO227][New] ODBC Oracle: cannot insert with a FdoDataType_DateTime value

[Barbara Zoladek]

You can view the artifact detail at the following URL:

    https://fdo.osgeo.org/servlets/Scarab/id/FDO227

Type
 Defect

Artifact ID
 FDO227 (ODBC Oracle: cannot insert with a FdoDataType_DateTime value)

Reported by
 Barbara Zoladek
 barbarazoladek (barbara.zoladek at autodesk.com)

New artifact details:
---------------------------------------------------------

- Artifact created
- Description set to new value
  Oracle - Constraints cannot insert with a FdoDataType_DateTime value if the FdoDataType_DateTime is part of unique constraint definition
- Defect Severity set to new value
  Medium
- Summary set to new value
  ODBC Oracle: cannot insert with a FdoDataType_DateTime value
- Artifact Status set to new value
  New
- Steps to Reproduce set to new value
  Create a FeatureClass with a unique constraint on a FdoDataType_DateTime
Insert a feature with a value for the FdoDataType_DateTime property

EXPECTED RESULT: the feature is inserted

ACTUAL RESULT:
FdoCommandException(): ORA-01861: LITERAL DOES NOT MATCH FORMAT STRING

ROW IS : '40', '128', '2006-01-31-10-30-30', '', '', '', '', '', '', '', 24, 0.
ISSUING ROLLBACK TO RECOVER FROM TRANSACTION FAILURE
ROLLBACK COMPLETE

---------------------------------------------------------
This message was automatically generated by Project Tracker.