View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004031 | SymmetricDS | Bug | public | 2019-07-02 17:03 | 2019-08-23 16:43 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.21 | ||||
| Target Version | 3.9.22 | Fixed in Version | 3.9.22 | ||
| Summary | 0004031: Oracle Numeric types used to return DECIMAL, but now returns NUMERIC with new driver | ||||
| Description | Oracle 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 Information | Since 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. | ||||
| Tags | No tags attached. | ||||
|
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 |
Affected Issues 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 | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-07-02 17:03 | pmarzullo | New Issue | |
| 2019-07-02 17:03 | pmarzullo | Status | new => assigned |
| 2019-07-02 17:03 | pmarzullo | Assigned To | => pmarzullo |
| 2019-07-02 17:18 | pmarzullo | Status | assigned => resolved |
| 2019-07-02 17:18 | pmarzullo | Resolution | open => fixed |
| 2019-07-02 17:18 | pmarzullo | Fixed in Version | => 3.9.22 |
| 2019-07-02 17:18 | pmarzullo | Note Added: 0001545 | |
| 2019-07-02 18:00 | Changeset attached | => SymmetricDS 3.9 6de0c7d1 | |
| 2019-08-23 16:43 | admin | Status | resolved => closed |