org.jkiss.dbeaver.model.impl.jdbc.JDBCException: SQL Error: Method not supported

GitHub | cdatta | 3 months ago
  1. 0

    GitHub comment 145#243771178

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

    GitHub comment 145#243554190

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

    Re: [sql-workbench] Connect to hive through JDBC

    Google Groups | 4 years ago | Thomas Kellerer
    java.sql.SQLException: Method not supported
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Method not supported in spark

    Stack Overflow | 1 year ago | Junga Kim
    java.sql.SQLException: Method not supported
  6. 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

    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.createStatement()
    2. org.apache.hive
      HiveConnection.createStatement
      1. org.apache.hive.jdbc.HiveConnection.createStatement(HiveConnection.java:430)
      1 frame
    3. org.jkiss.dbeaver
      AbstractJob.run
      1. org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.createStatement(JDBCConnectionImpl.java:367)
      2. org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.prepareStatement(JDBCConnectionImpl.java:123)
      3. org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.prepareStatement(JDBCConnectionImpl.java:1)
      4. org.jkiss.dbeaver.model.DBUtils.createStatement(DBUtils.java:949)
      5. org.jkiss.dbeaver.model.DBUtils.prepareStatement(DBUtils.java:920)
      6. org.jkiss.dbeaver.model.DBUtils.prepareStatement(DBUtils.java:870)
      7. org.jkiss.dbeaver.model.impl.jdbc.struct.JDBCTable.readData(JDBCTable.java:161)
      8. org.jkiss.dbeaver.ui.controls.resultset.ResultSetDataPumpJob.run(ResultSetDataPumpJob.java:139)
      9. org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:103)
      9 frames
    4. Eclipse Jobs
      Worker.run
      1. org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
      1 frame