View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001456SymmetricDSBugpublic2013-10-28 17:192019-04-22 14:15
Reporterszambaux Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.5.10 
Summary0001456: DbImport date problem Oracle 11G
Descriptionsend 0000-00-00 00:00:00 in XML get 30/11/0003 00:00:00,000000000 in Oracle database
Steps To ReproduceTry to execute:
/opt/symmetric/bin/dbimport --format XML --drop-if-exists -p /opt/symmetric/conf/symmetric.properties /liveUpdate/CLIENT.xml

CLIENT.xml:
structure:
<?xml version="1.0" encoding="UTF-8"?><database name="eseason"><table name="CLIENT">
<column name="CLADHESFID" type="TIMESTAMP" size="0" required="false"/>
<column name="CLVALIDFID" type="TIMESTAMP" size="0" required="false"/>
...
<field name="CLADHESFID">0000-00-00 00:00:00</field>
<field name="CLVALIDFID">0000-00-00 00:00:00</field>
...
Tagsdata conversion, dbimport/dbexport

Activities

chenson

2013-10-28 22:26

administrator   ~0000381

Is that even a valid datetime in Oracle? What value should the result be?

szambaux

2013-10-30 16:51

reporter   ~0000383

it's not a valid datetime for Oracle, but maybe it could be better to set null instead of 30/11/0003 00:00:00,000000000

Issue History

Date Modified Username Field Change
2013-10-28 17:19 szambaux New Issue
2013-10-28 22:26 chenson Note Added: 0000381
2013-10-30 16:51 szambaux Note Added: 0000383
2019-04-22 14:15 elong Tag Attached: data conversion
2019-04-22 14:15 elong Tag Attached: dbimport/dbexport