View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003967 | SymmetricDS | Bug | public | 2019-05-15 19:37 | 2024-08-28 18:00 |
Reporter | hanes | Assigned To | pmarzullo | ||
Priority | normal | ||||
Status | closed | Resolution | duplicate | ||
Product Version | 3.10.2 | ||||
Summary | 0003967: Table with BFILE type in Oracle creates a trigger but unable to extract from the table | ||||
Description | For the following sample table: create table test18 (mybfile bfile, myId varchar(256), primary key (myId)); The trigger creates, but when you try to extract the following exception occurs: [corp-000] - DataExtractorService - Batch 001-257 is not ready for delivery. It is currently scheduled for extraction. [corp-000] - DataExtractorService - Starting request 37 to extract table TEST18 into batches 257 through 257 for node 001. [corp-000] - DataExtractorService - Failed on request 37 to extract table TEST18 into batches 257 through 257 for node 001 [corp-000] - NodeCommunicationService - Failed to execute EXTRACT for node 001 and channel default org.jumpmind.db.sql.SqlException: Failed to execute sql: select "MYID" as x__0,decode(t."MYBFILE", null, '', '"'||replace(replace(t."MYBFILE",'\','\\'),'"','\"')||'"') as x__1 from "HANES"."TEST18" t where 1=1 at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302) at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:120) at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:150) at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:143) at org.jumpmind.db.sql.AbstractSqlTemplate.queryForCursor(AbstractSqlTemplate.java:107) at org.jumpmind.symmetric.service.impl.DataExtractorService$SelectFromTableSource.startNewCursor(DataExtractorService.java:2933) at org.jumpmind.symmetric.service.impl.DataExtractorService$SelectFromTableSource.selectNext(DataExtractorService.java:2844) at org.jumpmind.symmetric.service.impl.DataExtractorService$SelectFromTableSource.next(DataExtractorService.java:2774) at org.jumpmind.symmetric.service.impl.DataExtractorService$SelectFromSymDataSource.next(DataExtractorService.java:2519) at org.jumpmind.symmetric.io.data.reader.ExtractDataReader.nextTable(ExtractDataReader.java:102) at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:169) at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:124) at org.jumpmind.symmetric.service.impl.DataExtractorService.extractOutgoingBatch(DataExtractorService.java:1049) at org.jumpmind.symmetric.service.impl.DataExtractorService.execute(DataExtractorService.java:2078) at org.jumpmind.symmetric.service.impl.NodeCommunicationService$1.run(NodeCommunicationService.java:519) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got FILE at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:866) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1281) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:104) ... 16 more [ | ||||
Tags | data type, dialect: oracle | ||||
related to | 0002304 | new | Add support for the BFILE data type on Oracle |
Date Modified | Username | Field | Change |
---|---|---|---|
2019-05-15 19:37 | hanes | New Issue | |
2019-05-17 23:52 | elong | Tag Attached: data type | |
2019-05-17 23:52 | elong | Tag Attached: dialect: oracle | |
2019-06-10 15:58 | hanes | Status | new => confirmed |
2022-09-09 21:39 | elong | Relationship added | related to 0002304 |
2024-08-28 18:00 | pmarzullo | Assigned To | => pmarzullo |
2024-08-28 18:00 | pmarzullo | Status | confirmed => closed |
2024-08-28 18:00 | pmarzullo | Resolution | open => duplicate |