View Issue Details

IDProjectCategoryView StatusLast Update
0001752SymmetricDSImprovementpublic2014-06-16 20:27
ReporterwadihkharmaAssigned Tochenson 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version3.5.22 
Target Version3.6.0Fixed in Version3.6.0 
Summary0001752: Date format setting in triggers
DescriptionHowever i am facing the following problem.
All nodes run Oracle databases, most of the client nodes application insert/update data using different Calendar setting (ARABIC HIJRAH).
When DATE columns data is added to SYM_DATA.RAW it is converted to the ARABIC HIJRAH format:
Example: invoice date 07-JUNE-2014 is inserted as 1435-08-09 instead of 2014-06-07
The solution i found is to adjust the triggers on the tables and force the calendar to GREGORIAN
decode((:new."INVDATE",null,'',concat(concat('"',to_char(:new."INVDATE",'YYYY-MM-DD HH24:MI:SS','NLS_CALENDAR=''GREGORIAN''')),'"'))||','||
This works fine but means any change in the triggers i will have to manually readjust it in ALL nodes.
Is there a way to have it done by Symmetric when creating the triggers?
Thanks
Wadih Kharma
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: master cd46d1a6

2014-06-10 09:10:28

chenson

Details Diff
0001752: Date format setting in triggers
0001752
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleTriggerTemplate.java Diff File

Issue History

Date Modified Username Field Change
2014-06-08 15:06 wadihkharma New Issue
2014-06-10 07:26 chenson Target Version => 3.6.0
2014-06-10 07:26 chenson Project SymmetricDS Pro => SymmetricDS
2014-06-10 09:14 chenson Status new => resolved
2014-06-10 09:14 chenson Fixed in Version => 3.6.0
2014-06-10 09:14 chenson Resolution open => fixed
2014-06-10 09:14 chenson Assigned To => chenson
2014-06-10 10:00 Changeset attached => SymmetricDS trunk r8361
2014-06-16 20:27 chenson Status resolved => closed
2015-07-30 21:49 chenson Changeset attached => SymmetricDS master cd46d1a6