View Issue Details

IDProjectCategoryView StatusLast Update
0003457SymmetricDSBugpublic2018-03-12 12:26
Reportermmichalek Assigned Tommichalek  
Status closedResolutionfixed 
Product Version3.9.5 
Target Version3.9.5Fixed in Version3.9.5 
Summary0003457: Oracle geometry/geography type fails to insert if geometry data > 4k
DescriptionA geometry type of 4k will result in the following exception. The fix was to change the JDBC type from OTHER to CLOB.

2018-02-23 16:52:59,149 INFO [store-005] [DefaultDatabaseWriter] [store-005-dataloader-4] Failed to process insert event in batch 000-103 on channel 'item'.
Failed sql was: insert into "SYMMETRIC"."ITEM" ("ITEM_ID", "SHAPE", "NAME") values (?,SYM_WKT2GEOM(?),?)
Failed sql parameters: [123, 'POLYGON ((34.6003519690521 35.7273970428138, 34.599630492562 35.7273919293539, [REDACTED]))']
Failed sql parameters types: [DECIMAL, OTHER, VARCHAR]
Failed sql state and code: 72000 (1461)
Failed row data was: "123","POLYGON ((34.6003519690521 35.7273970428138, 34.599630492562 35.7273919293539, [REDACTED]))"
 StackTraceKey.init [SqlException:1814932067]
org.jumpmind.db.sql.SqlException: ORA-01461: can bind a LONG value only for insert into a LONG column

    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(
    at org.jumpmind.db.sql.JdbcSqlTransaction.addRow(
    at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(
    at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$
    at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$
    at java.util.concurrent.ThreadPoolExecutor.runWorker(
    at java.util.concurrent.ThreadPoolExecutor$
Caused by: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

    at oracle.jdbc.driver.T4CTTIoer.processError(
    at oracle.jdbc.driver.T4CTTIoer.processError(
    at oracle.jdbc.driver.T4C8Oall.processError(
    at oracle.jdbc.driver.T4CTTIfun.receive(
    at oracle.jdbc.driver.T4CTTIfun.doRPC(
    at oracle.jdbc.driver.T4C8Oall.doOALL(
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
    at oracle.jdbc.driver.OraclePreparedStatement.execute(
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(
    at org.jumpmind.db.sql.JdbcSqlTransaction.addRow(
    ... 16 more
TagsNo tags attached.


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 2b49ecff

2018-02-23 17:13:41


Details Diff
0003457: Oracle geometry/geography type fails to insert if geometry data
> 4k
Affected Issues
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/oracle/ Diff File

Issue History

Date Modified Username Field Change
2018-02-23 22:13 mmichalek New Issue
2018-02-23 22:13 mmichalek Status new => assigned
2018-02-23 22:13 mmichalek Assigned To => mmichalek
2018-02-23 22:14 mmichalek Status assigned => resolved
2018-02-23 22:14 mmichalek Resolution open => fixed
2018-02-23 22:14 mmichalek Fixed in Version => 3.9.5
2018-02-23 23:00 mmichalek Changeset attached => SymmetricDS 3.9 2b49ecff
2018-03-12 12:26 chenson Status resolved => closed