I have a very specific issue regarding one of my datasources.
- There was an issue with year 1582 in db2 which we solved by adding "setSqljAvoidTimeStampConversion" => this property makes reading all Timestamps as Strings and Db2 is indifferent - returns correct value for String mapping DAO class.
- The problem is with other db - Oracle. There were some tests performed and it shows an error when we try mapping Timestamp to String (I want to have it similar for both datasources). There is an option for replicating columns as CHARS in Oracle but that requires lots of changes and informing other customer - not smooth solution.
Question: Is there something similar to "setSqljAvoidTimeStampConversion" for Oracle? I could in theory put it in connectionProperties so we will always map it to string. Do you know some other way of solving that problem? I need to have both datasources running on the same codebase obviously.