View Issue Details

IDProjectCategoryView StatusLast Update
0004030SymmetricDSBugpublic2019-07-02 13:17
ReporterpmarzulloAssigned Topmarzullo 
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.11.0 
Target Version3.11.0Fixed in Version3.11.0 
Summary0004030: 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.

Activities

pmarzullo

2019-07-02 13:17

developer   ~0001544

3.9.22 - 0004031
3.10.4 - 0004027

Issue History

Date Modified Username Field Change
2019-07-02 13:01 pmarzullo New Issue
2019-07-02 13:01 pmarzullo Status new => assigned
2019-07-02 13:01 pmarzullo Assigned To => pmarzullo
2019-07-02 13:01 pmarzullo Description Updated View Revisions
2019-07-02 13:02 pmarzullo Additional Information Updated View Revisions
2019-07-02 13:17 pmarzullo Status assigned => resolved
2019-07-02 13:17 pmarzullo Resolution open => fixed
2019-07-02 13:17 pmarzullo Fixed in Version => 3.11.0
2019-07-02 13:17 pmarzullo Note Added: 0001544