View Issue Details

IDProjectCategoryView StatusLast Update
0004027SymmetricDSImprovementpublic2019-08-23 16:46
Reporterpmarzullo Assigned Topmarzullo  
Status closedResolutionfixed 
Product Version3.10.3 
Target Version3.10.4Fixed in Version3.10.4 
Summary0004027: Oracle Numeric types used to return DECIMAL, but now returns NUMERIC with new driver
DescriptionOracle JDBC driver version 12 and higher return NUMERIC jdbc data type for the numeric column types.
Driver version 11 used to return DECIMAL.

This is causing any SymmetricDS tables that have a numeric data type (NUMBER, DECIMAL, TINYINT, etc.) to be altered on every startup of SymmetricDS.

Need to make the OracleDDLReader work no matter what driver is being used.
Additional InformationSince there is no real DECIMAL column type (it is an alias for NUMBER(...)), change the OracleDdlReader to map all DECIMAL meta data return types to NUMERIC.
TagsNo tags attached.



2019-07-02 17:17

developer   ~0001543

3.9.22 - 0004031
3.11 - 0004030

Related Changesets

SymmetricDS: 3.10 0c096d1c

2019-07-02 13:06:32

Philip Marzullo

Details Diff
0004027: Oracle Numeric types used to return DECIMAL, but now returns
NUMERIC with new driver
Affected Issues
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/oracle/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/ Diff File

Issue History

Date Modified Username Field Change
2019-06-26 18:03 pmarzullo New Issue
2019-06-26 18:03 pmarzullo Status new => assigned
2019-06-26 18:03 pmarzullo Assigned To => pmarzullo
2019-07-02 17:17 pmarzullo Status assigned => resolved
2019-07-02 17:17 pmarzullo Resolution open => fixed
2019-07-02 17:17 pmarzullo Fixed in Version => 3.10.4
2019-07-02 17:17 pmarzullo Note Added: 0001543
2019-07-02 18:00 Changeset attached => SymmetricDS 3.10 0c096d1c
2019-08-23 16:46 admin Status resolved => closed