[jira] [Commented] (NIFI-4352) Add CLOB and NCLOB support to PutSQL and ExecuteSQL
[ https://issues.apache.org/jira/browse/NIFI-4352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16165977#comment-16165977 ] ASF subversion and git services commented on NIFI-4352: --- Commit 1e70e24267351a9c189ea26ee0536fdc8dbd7bd6 in nifi's branch refs/heads/master from [~ijokarumawak] [ https://git-wip-us.apache.org/repos/asf?p=nifi.git;h=1e70e24 ] NIFI-4352: Add CLOB and NCLOB support to PutSQL and ExecuteSQL Signed-off-by: Pierre VillardThis closes #2145. > Add CLOB and NCLOB support to PutSQL and ExecuteSQL > --- > > Key: NIFI-4352 > URL: https://issues.apache.org/jira/browse/NIFI-4352 > Project: Apache NiFi > Issue Type: Improvement > Components: Extensions >Affects Versions: 1.3.0 >Reporter: Mayank Rathi >Assignee: Koji Kawamura >Priority: Minor > > Hello All, > I am passing sql.args.1.type = 2005 and sql.args.1.value as a CLOB value to > PutSQL and it is throwing below error. How do I resolve this error? > 2017-09-04 10:17:24,924 INFO [StandardProcessScheduler Thread-5] > o.a.n.c.s.TimerDrivenSchedulingAgent Scheduled > PutSQL[id=69534f73-821e-1782--fabb94fb] to run with 1 threads > 2017-09-04 10:17:25,009 ERROR [Timer-Driven Process Thread-4] > o.apache.nifi.processors.standard.PutSQL > PutSQL[id=69534f73-821e-1782--fabb94fb] > org.apache.nifi.processors.standard.PutSQL$$Lambda$653/696434096@771333e > failed to process due to > org.apache.nifi.processor.exception.ProcessException: Failed to process > StandardFlowFileRecord[uuid=14895cdd-3eac-4f2a-adae-f014526e24b1,claim=StandardContentClaim > [resourceClaim=StandardResourceClaim[id=1502123289026-125, > container=default, section=125], offset=71441, > length=39],offset=0,name=5936554321553480,size=39] due to > java.lang.ClassCastException: java.lang.String cannot be cast to > oracle.sql.CLOB; rolling back session: {} > org.apache.nifi.processor.exception.ProcessException: Failed to process > StandardFlowFileRecord[uuid=14895cdd-3eac-4f2a-adae-f014526e24b1,claim=StandardContentClaim > [resourceClaim=StandardResourceClaim[id=1502123289026-125, > container=default, section=125], offset=71441, > length=39],offset=0,name=5936554321553480,size=39] due to > java.lang.ClassCastException: java.lang.String cannot be cast to > oracle.sql.CLOB > at > org.apache.nifi.processor.util.pattern.ExceptionHandler.lambda$createOnGroupError$14(ExceptionHandler.java:226) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler.lambda$createOnError$13(ExceptionHandler.java:179) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$11(ExceptionHandler.java:54) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$11(ExceptionHandler.java:54) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler.execute(ExceptionHandler.java:148) > at org.apache.nifi.processors.standard.PutSQL.lambda$new$72(PutSQL.java:283) > at org.apache.nifi.processors.standard.PutSQL.lambda$new$75(PutSQL.java:324) > at > org.apache.nifi.processor.util.pattern.PutGroup.putFlowFiles(PutGroup.java:91) > at org.apache.nifi.processor.util.pattern.Put.onTrigger(Put.java:101) > at > org.apache.nifi.processors.standard.PutSQL.lambda$onTrigger$86(PutSQL.java:544) > at > org.apache.nifi.processor.util.pattern.PartialFunctions.onTrigger(PartialFunctions.java:114) > at > org.apache.nifi.processor.util.pattern.RollbackOnFailure.onTrigger(RollbackOnFailure.java:184) > at org.apache.nifi.processors.standard.PutSQL.onTrigger(PutSQL.java:544) > at > org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1120) > at > org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:147) > at > org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47) > at > org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:132) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:748) > Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to > oracle.sql.CLOB > at >
[jira] [Commented] (NIFI-4352) Add CLOB and NCLOB support to PutSQL and ExecuteSQL
[ https://issues.apache.org/jira/browse/NIFI-4352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16165978#comment-16165978 ] ASF GitHub Bot commented on NIFI-4352: -- Github user asfgit closed the pull request at: https://github.com/apache/nifi/pull/2145 > Add CLOB and NCLOB support to PutSQL and ExecuteSQL > --- > > Key: NIFI-4352 > URL: https://issues.apache.org/jira/browse/NIFI-4352 > Project: Apache NiFi > Issue Type: Improvement > Components: Extensions >Affects Versions: 1.3.0 >Reporter: Mayank Rathi >Assignee: Koji Kawamura >Priority: Minor > > Hello All, > I am passing sql.args.1.type = 2005 and sql.args.1.value as a CLOB value to > PutSQL and it is throwing below error. How do I resolve this error? > 2017-09-04 10:17:24,924 INFO [StandardProcessScheduler Thread-5] > o.a.n.c.s.TimerDrivenSchedulingAgent Scheduled > PutSQL[id=69534f73-821e-1782--fabb94fb] to run with 1 threads > 2017-09-04 10:17:25,009 ERROR [Timer-Driven Process Thread-4] > o.apache.nifi.processors.standard.PutSQL > PutSQL[id=69534f73-821e-1782--fabb94fb] > org.apache.nifi.processors.standard.PutSQL$$Lambda$653/696434096@771333e > failed to process due to > org.apache.nifi.processor.exception.ProcessException: Failed to process > StandardFlowFileRecord[uuid=14895cdd-3eac-4f2a-adae-f014526e24b1,claim=StandardContentClaim > [resourceClaim=StandardResourceClaim[id=1502123289026-125, > container=default, section=125], offset=71441, > length=39],offset=0,name=5936554321553480,size=39] due to > java.lang.ClassCastException: java.lang.String cannot be cast to > oracle.sql.CLOB; rolling back session: {} > org.apache.nifi.processor.exception.ProcessException: Failed to process > StandardFlowFileRecord[uuid=14895cdd-3eac-4f2a-adae-f014526e24b1,claim=StandardContentClaim > [resourceClaim=StandardResourceClaim[id=1502123289026-125, > container=default, section=125], offset=71441, > length=39],offset=0,name=5936554321553480,size=39] due to > java.lang.ClassCastException: java.lang.String cannot be cast to > oracle.sql.CLOB > at > org.apache.nifi.processor.util.pattern.ExceptionHandler.lambda$createOnGroupError$14(ExceptionHandler.java:226) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler.lambda$createOnError$13(ExceptionHandler.java:179) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$11(ExceptionHandler.java:54) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$11(ExceptionHandler.java:54) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler.execute(ExceptionHandler.java:148) > at org.apache.nifi.processors.standard.PutSQL.lambda$new$72(PutSQL.java:283) > at org.apache.nifi.processors.standard.PutSQL.lambda$new$75(PutSQL.java:324) > at > org.apache.nifi.processor.util.pattern.PutGroup.putFlowFiles(PutGroup.java:91) > at org.apache.nifi.processor.util.pattern.Put.onTrigger(Put.java:101) > at > org.apache.nifi.processors.standard.PutSQL.lambda$onTrigger$86(PutSQL.java:544) > at > org.apache.nifi.processor.util.pattern.PartialFunctions.onTrigger(PartialFunctions.java:114) > at > org.apache.nifi.processor.util.pattern.RollbackOnFailure.onTrigger(RollbackOnFailure.java:184) > at org.apache.nifi.processors.standard.PutSQL.onTrigger(PutSQL.java:544) > at > org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1120) > at > org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:147) > at > org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47) > at > org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:132) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:748) > Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to > oracle.sql.CLOB > at > oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8874) > at > oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8396) > at > oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8980) > at >
[jira] [Commented] (NIFI-4352) Add CLOB and NCLOB support to PutSQL and ExecuteSQL
[ https://issues.apache.org/jira/browse/NIFI-4352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16165974#comment-16165974 ] ASF GitHub Bot commented on NIFI-4352: -- Github user pvillard31 commented on the issue: https://github.com/apache/nifi/pull/2145 +1, ran full build with contrib-check and made few tests with provided template. Merging to master, thanks @ijokarumawak > Add CLOB and NCLOB support to PutSQL and ExecuteSQL > --- > > Key: NIFI-4352 > URL: https://issues.apache.org/jira/browse/NIFI-4352 > Project: Apache NiFi > Issue Type: Improvement > Components: Extensions >Affects Versions: 1.3.0 >Reporter: Mayank Rathi >Assignee: Koji Kawamura >Priority: Minor > > Hello All, > I am passing sql.args.1.type = 2005 and sql.args.1.value as a CLOB value to > PutSQL and it is throwing below error. How do I resolve this error? > 2017-09-04 10:17:24,924 INFO [StandardProcessScheduler Thread-5] > o.a.n.c.s.TimerDrivenSchedulingAgent Scheduled > PutSQL[id=69534f73-821e-1782--fabb94fb] to run with 1 threads > 2017-09-04 10:17:25,009 ERROR [Timer-Driven Process Thread-4] > o.apache.nifi.processors.standard.PutSQL > PutSQL[id=69534f73-821e-1782--fabb94fb] > org.apache.nifi.processors.standard.PutSQL$$Lambda$653/696434096@771333e > failed to process due to > org.apache.nifi.processor.exception.ProcessException: Failed to process > StandardFlowFileRecord[uuid=14895cdd-3eac-4f2a-adae-f014526e24b1,claim=StandardContentClaim > [resourceClaim=StandardResourceClaim[id=1502123289026-125, > container=default, section=125], offset=71441, > length=39],offset=0,name=5936554321553480,size=39] due to > java.lang.ClassCastException: java.lang.String cannot be cast to > oracle.sql.CLOB; rolling back session: {} > org.apache.nifi.processor.exception.ProcessException: Failed to process > StandardFlowFileRecord[uuid=14895cdd-3eac-4f2a-adae-f014526e24b1,claim=StandardContentClaim > [resourceClaim=StandardResourceClaim[id=1502123289026-125, > container=default, section=125], offset=71441, > length=39],offset=0,name=5936554321553480,size=39] due to > java.lang.ClassCastException: java.lang.String cannot be cast to > oracle.sql.CLOB > at > org.apache.nifi.processor.util.pattern.ExceptionHandler.lambda$createOnGroupError$14(ExceptionHandler.java:226) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler.lambda$createOnError$13(ExceptionHandler.java:179) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$11(ExceptionHandler.java:54) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$11(ExceptionHandler.java:54) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler.execute(ExceptionHandler.java:148) > at org.apache.nifi.processors.standard.PutSQL.lambda$new$72(PutSQL.java:283) > at org.apache.nifi.processors.standard.PutSQL.lambda$new$75(PutSQL.java:324) > at > org.apache.nifi.processor.util.pattern.PutGroup.putFlowFiles(PutGroup.java:91) > at org.apache.nifi.processor.util.pattern.Put.onTrigger(Put.java:101) > at > org.apache.nifi.processors.standard.PutSQL.lambda$onTrigger$86(PutSQL.java:544) > at > org.apache.nifi.processor.util.pattern.PartialFunctions.onTrigger(PartialFunctions.java:114) > at > org.apache.nifi.processor.util.pattern.RollbackOnFailure.onTrigger(RollbackOnFailure.java:184) > at org.apache.nifi.processors.standard.PutSQL.onTrigger(PutSQL.java:544) > at > org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1120) > at > org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:147) > at > org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47) > at > org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:132) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:748) > Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to > oracle.sql.CLOB > at > oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8874) > at >
[jira] [Commented] (NIFI-4352) Add CLOB and NCLOB support to PutSQL and ExecuteSQL
[ https://issues.apache.org/jira/browse/NIFI-4352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16162433#comment-16162433 ] ASF GitHub Bot commented on NIFI-4352: -- Github user ijokarumawak commented on the issue: https://github.com/apache/nifi/pull/2145 Added followings: - CLOB and NCLOB support to PutSQL - NCLOB support to ExecuteSQL Confirmed it can insert and select CLOB and NCLOB columns. For NCLOB, I've tested Japanese characters are inserted and retrieved successfully. A template is available here in Gist: https://gist.github.com/ijokarumawak/451085b01349c7e6e83bcc42182ecffc ``` CREATE TABLE clob_test ( i INT not null, c CLOB, nc NCLOB, CONSTRAINT clob_test_pk PRIMARY KEY (i) ); ``` > Add CLOB and NCLOB support to PutSQL and ExecuteSQL > --- > > Key: NIFI-4352 > URL: https://issues.apache.org/jira/browse/NIFI-4352 > Project: Apache NiFi > Issue Type: Improvement > Components: Extensions >Affects Versions: 1.3.0 >Reporter: Mayank Rathi >Assignee: Koji Kawamura >Priority: Minor > > Hello All, > I am passing sql.args.1.type = 2005 and sql.args.1.value as a CLOB value to > PutSQL and it is throwing below error. How do I resolve this error? > 2017-09-04 10:17:24,924 INFO [StandardProcessScheduler Thread-5] > o.a.n.c.s.TimerDrivenSchedulingAgent Scheduled > PutSQL[id=69534f73-821e-1782--fabb94fb] to run with 1 threads > 2017-09-04 10:17:25,009 ERROR [Timer-Driven Process Thread-4] > o.apache.nifi.processors.standard.PutSQL > PutSQL[id=69534f73-821e-1782--fabb94fb] > org.apache.nifi.processors.standard.PutSQL$$Lambda$653/696434096@771333e > failed to process due to > org.apache.nifi.processor.exception.ProcessException: Failed to process > StandardFlowFileRecord[uuid=14895cdd-3eac-4f2a-adae-f014526e24b1,claim=StandardContentClaim > [resourceClaim=StandardResourceClaim[id=1502123289026-125, > container=default, section=125], offset=71441, > length=39],offset=0,name=5936554321553480,size=39] due to > java.lang.ClassCastException: java.lang.String cannot be cast to > oracle.sql.CLOB; rolling back session: {} > org.apache.nifi.processor.exception.ProcessException: Failed to process > StandardFlowFileRecord[uuid=14895cdd-3eac-4f2a-adae-f014526e24b1,claim=StandardContentClaim > [resourceClaim=StandardResourceClaim[id=1502123289026-125, > container=default, section=125], offset=71441, > length=39],offset=0,name=5936554321553480,size=39] due to > java.lang.ClassCastException: java.lang.String cannot be cast to > oracle.sql.CLOB > at > org.apache.nifi.processor.util.pattern.ExceptionHandler.lambda$createOnGroupError$14(ExceptionHandler.java:226) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler.lambda$createOnError$13(ExceptionHandler.java:179) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$11(ExceptionHandler.java:54) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler$OnError.lambda$andThen$11(ExceptionHandler.java:54) > at > org.apache.nifi.processor.util.pattern.ExceptionHandler.execute(ExceptionHandler.java:148) > at org.apache.nifi.processors.standard.PutSQL.lambda$new$72(PutSQL.java:283) > at org.apache.nifi.processors.standard.PutSQL.lambda$new$75(PutSQL.java:324) > at > org.apache.nifi.processor.util.pattern.PutGroup.putFlowFiles(PutGroup.java:91) > at org.apache.nifi.processor.util.pattern.Put.onTrigger(Put.java:101) > at > org.apache.nifi.processors.standard.PutSQL.lambda$onTrigger$86(PutSQL.java:544) > at > org.apache.nifi.processor.util.pattern.PartialFunctions.onTrigger(PartialFunctions.java:114) > at > org.apache.nifi.processor.util.pattern.RollbackOnFailure.onTrigger(RollbackOnFailure.java:184) > at org.apache.nifi.processors.standard.PutSQL.onTrigger(PutSQL.java:544) > at > org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1120) > at > org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:147) > at > org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47) > at > org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:132) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at >