java.sql.SQLException: Method not supported

Stack Overflow | ozw1z5rd | 2 months ago
  1. 0

    Nifi putSQL processor raises exception on HIVE on simple insert

    Stack Overflow | 2 months ago | ozw1z5rd
    java.sql.SQLException: Method not supported
  2. 0

    Method not supported in spark

    Stack Overflow | 1 year ago | Junga Kim
    java.sql.SQLException: Method not supported
  3. 0

    When trying to use Instaview with our Hadoop distro @ 10.100.9.42 and table fact_sales_1998, I get the following exception while executing the MonetDB population transformation. It seems that the populator tries to stop transformation after 100k rows. This can also be reproduced by firing up the attached transformation with its table input step and hitting stop after the rows have started to flow. ----------------------------------------------------------------- 2013/09/24 13:15:19 - Spoon - Transformation opened. 2013/09/24 13:15:19 - Spoon - Launching transformation [Untitled 2]... 2013/09/24 13:15:19 - Spoon - Started the transformation execution. 2013/09/24 13:15:20 - Untitled 2 - Dispatching started for transformation [Untitled 2] 2013/09/24 13:16:12 - Input.0 - linenr 50000 2013/09/24 13:16:12 - Do Not Edit.0 - linenr 50000 2013/09/24 13:16:40 - Input.0 - linenr 100000 2013/09/24 13:16:41 - Do Not Edit.0 - linenr 100000 2013/09/24 13:16:41 - Untitled 2 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException: 2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException: 2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 - 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelStatement(Database.java:664) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelQuery(Database.java:646) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:303) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.Trans.stopAll(Trans.java:1729) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2605) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.BaseStep.putRow(BaseStep.java:1093) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:204) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2013/09/24 13:16:41 - Untitled 2 - at java.lang.Thread.run(Thread.java:724) 2013/09/24 13:16:41 - Untitled 2 - Caused by: java.sql.SQLException: Method not supported 2013/09/24 13:16:41 - Untitled 2 - at org.apache.hadoop.hive.jdbc.HiveStatement.cancel(HiveStatement.java:85) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2013/09/24 13:16:41 - Untitled 2 - at java.lang.reflect.Method.invoke(Method.java:606) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.hadoop.shim.common.DriverProxyInvocationChain$CaptureResultSetInvocationHandler.invoke(DriverProxyInvocationChain.java:461) 2013/09/24 13:16:41 - Untitled 2 - at com.sun.proxy.$Proxy138.cancel(Unknown Source) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelStatement(Database.java:659) 2013/09/24 13:16:41 - Untitled 2 - ... 8 more 2013/09/24 13:16:41 - Input.0 - Finished reading query, closing connection. 2013/09/24 13:16:41 - Do Not Edit.0 - Finished processing (I=0, O=0, R=100107, W=100107, U=0, E=0) 2013/09/24 13:16:41 - Untitled 2 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 - 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelStatement(Database.java:664) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelQuery(Database.java:646) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:303) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.Trans.stopAll(Trans.java:1729) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2605) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.processRow(MonetDBBulkLoader.java:216) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2013/09/24 13:16:41 - Untitled 2 - at java.lang.Thread.run(Thread.java:724) 2013/09/24 13:16:41 - Untitled 2 - Caused by: java.sql.SQLException: Method not supported 2013/09/24 13:16:41 - Untitled 2 - at org.apache.hadoop.hive.jdbc.HiveStatement.cancel(HiveStatement.java:85) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2013/09/24 13:16:41 - Untitled 2 - at java.lang.reflect.Method.invoke(Method.java:606) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.hadoop.shim.common.DriverProxyInvocationChain$CaptureResultSetInvocationHandler.invoke(DriverProxyInvocationChain.java:461) 2013/09/24 13:16:41 - Untitled 2 - at com.sun.proxy.$Proxy138.cancel(Unknown Source) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelStatement(Database.java:659) 2013/09/24 13:16:41 - Untitled 2 - ... 7 more 2013/09/24 13:16:41 - Output.0 - Finished processing (I=0, O=100000, R=100001, W=100000, U=0, E=0) 2013/09/24 13:16:41 - Input.0 - Finished processing (I=100208, O=0, R=0, W=100206, U=0, E=0) 2013/09/24 13:16:41 - Spoon - The transformation has finished!!

    Pentaho BI Platform Tracking | 3 years ago | Curtis Boyden
    org.pentaho.di.core.exception.KettleDatabaseException: Error cancelling statement Method not supported
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 145#243554190

    GitHub | 3 months ago | cdatta
    org.jkiss.dbeaver.model.impl.jdbc.JDBCException: SQL Error: Method not supported

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Method not supported

      at org.apache.hive.jdbc.HiveConnection.commit()
    2. org.apache.hive
      HiveConnection.commit
      1. org.apache.hive.jdbc.HiveConnection.commit(HiveConnection.java:614)[na:na]
      1 frame
    3. Commons DBCP
      PoolingDataSource$PoolGuardConnectionWrapper.commit
      1. org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)[na:na]
      2. org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211)[na:na]
      2 frames
    4. org.apache.nifi
      TimerDrivenSchedulingAgent$1.run
      1. org.apache.nifi.processors.standard.PutSQL.onTrigger(PutSQL.java:371)[nifi-standard-processors-1.0.0.jar:1.0.0]
      2. org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:27)[nifi-api-1.0.0.jar:1.0.0]
      3. org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1064)[nifi-framework-core-1.0.0.jar:1.0.0]
      4. org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:136)[nifi-framework-core-1.0.0.jar:1.0.0]
      5. org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47)[nifi-framework-core-1.0.0.jar:1.0.0]
      6. org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:132)[nifi-framework-core-1.0.0.jar:1.0.0]
      6 frames
    5. Java RT
      Thread.run
      1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[na:1.8.0_101]
      2. java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)[na:1.8.0_101]
      3. java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)[na:1.8.0_101]
      4. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)[na:1.8.0_101]
      5. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)[na:1.8.0_101]
      6. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_101]
      7. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[na:1.8.0_101]
      8. java.lang.Thread.run(Thread.java:745)[na:1.8.0_101]
      8 frames