View Issue Details

IDProjectCategoryView StatusLast Update
0005062SymmetricDSBugpublic2021-07-19 20:00
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.12.11 
Target Version3.12.12Fixed in Version3.12.12 
Summary0005062: Oracle SDO_GEOMETRY: problem inserting when both BLOB and SDO_GEOMETRY are in the table
DescriptionWhen 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 Reproduce1. Create table with BLOB and SDO_GEOMETRY (BLOB needs to have over 4000 bytes).
2. Synch to target.
Additional InformationBLOB value needs to have over 4000 bytes.

Fix will include a new parameter:
oracle.jdbc.lob.handling=plain

Possible values are plain, streamlob, createtemporarylob
Tagsdata type, dialect: oracle

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 90a8e963

2021-07-19 19:37:32

pmarzullo

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

pmarzullo

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

Issue History

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