View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005062 | SymmetricDS | Bug | public | 2021-07-19 17:59 | 2021-11-04 14:58 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.11 | ||||
| Target Version | 3.12.12 | Fixed in Version | 3.12.12 | ||
| Summary | 0005062: Oracle SDO_GEOMETRY: problem inserting when both BLOB and SDO_GEOMETRY are in the table | ||||
| Description | When sending the insert to a target system with a BLOB and a SDO_GEOMETRY column, the insert fails with: ORA-01461: can bind a LONG value only for insert into a LONG column The problem is with the earlier versions of Oracle (11, 12.1). Need to change how to handle BLOB/CLOB and SDO_GEOMETRY columns, with the Spring DefaultLobHandler configuration. | ||||
| Steps To Reproduce | 1. Create table with BLOB and SDO_GEOMETRY (BLOB needs to have over 4000 bytes). 2. Synch to target. | ||||
| Additional Information | BLOB value needs to have over 4000 bytes. Fix will include a new parameter: oracle.jdbc.lob.handling=plain Possible values are plain, streamlob, createtemporarylob | ||||
| Tags | data type, dialect: oracle | ||||
|
SymmetricDS: 3.12 90a8e963 2021-07-19 19:37:32 Details Diff |
0005062: Oracle SDO_GEOMETRY: problem inserting when both BLOB and SDO_GEOMETRY are in the table |
Affected Issues 0005062 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/ClientSymmetricEngine.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java | Diff File | ||
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/SqlTemplateSettings.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleLobHandler.java | Diff File | ||
|
SymmetricDS: 3.13 85dec636 2021-07-19 19:37:32 Details Diff |
0005062: Oracle SDO_GEOMETRY: problem inserting when both BLOB and SDO_GEOMETRY are in the table |
Affected Issues 0005062 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/ClientSymmetricEngine.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java | Diff File | ||
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/SqlTemplateSettings.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleLobHandler.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-07-19 17:59 | pmarzullo | New Issue | |
| 2021-07-19 17:59 | pmarzullo | Status | new => assigned |
| 2021-07-19 17:59 | pmarzullo | Assigned To | => pmarzullo |
| 2021-07-19 17:59 | pmarzullo | Tag Attached: data type | |
| 2021-07-19 17:59 | pmarzullo | Tag Attached: dialect: oracle | |
| 2021-07-19 19:42 | pmarzullo | Status | assigned => resolved |
| 2021-07-19 19:42 | pmarzullo | Resolution | open => fixed |
| 2021-07-19 19:42 | pmarzullo | Fixed in Version | => 3.12.12 |
| 2021-07-19 20:00 | pmarzullo | Changeset attached | => SymmetricDS 3.12 90a8e963 |
| 2021-07-19 20:00 | pmarzullo | Changeset attached | => SymmetricDS 3.13 85dec636 |
| 2021-11-04 14:58 | admin | Status | resolved => closed |