View Issue Details

IDProjectCategoryView StatusLast Update
0004031SymmetricDSBugpublic2019-08-23 12:43
ReporterpmarzulloAssigned Topmarzullo 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.21 
Target Version3.9.22Fixed in Version3.9.22 
Summary0004031: 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:18

developer   ~0001545

3.11 - 0004030
3.10.4 - 0004027

Related Changesets

SymmetricDS: 3.9 6de0c7d1

2019-07-02 13:04:56

Philip Marzullo

Details Diff
0004031: Oracle Numeric types used to return DECIMAL, but now returns
NUMERIC with new driver

0004031
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlBuilder.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlReader.java Diff File

Issue History

Date Modified Username Field Change
2019-07-02 13:03 pmarzullo New Issue
2019-07-02 13:03 pmarzullo Status new => assigned
2019-07-02 13:03 pmarzullo Assigned To => pmarzullo
2019-07-02 13:18 pmarzullo Status assigned => resolved
2019-07-02 13:18 pmarzullo Resolution open => fixed
2019-07-02 13:18 pmarzullo Fixed in Version => 3.9.22
2019-07-02 13:18 pmarzullo Note Added: 0001545
2019-07-02 14:00 Changeset attached => SymmetricDS 3.9 6de0c7d1
2019-08-23 12:43 admin Status resolved => closed