org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL in part [openQuery : get rowinfo]: SELECT * FROM bhu_person_info Error getting row information from database: Method not supported

pentaho.com | 6 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Error retrieving data from Hive DB type [Archive] - Pentaho Community Forums

    pentaho.com | 6 months ago
    org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL in part [openQuery : get rowinfo]: SELECT * FROM bhu_person_info Error getting row information from database: Method not supported
  2. 0

    I using table input step in that I am using Hadoop Hive connection type to connect to hadoop database. i am able to see table list but after selecting table I am unable to fetch fields from table and hence unable to preview rows. Getting error as below: 2012/04/03 18:20:32 - Spoon - Logging goes to file:///C:/Users/SHAILE~1/AppData/Local/Temp/spoon_996f4d4d-7d8b-11e1-b06e-85d398504852.log 2012/04/03 18:20:36 - Version checker - OK 2012/04/03 18:20:36 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10001 2012/04/03 18:20:38 - Spoon - Asking for repository 2012/04/03 18:23:42 - Spoon - The transformation has finished!! 2012/04/03 18:45:23 - C:\Users\shailendrav\Desktop\A.ktr : A - Dispatching started for transformation [C:\Users\shailendrav\Desktop\A.ktr : A] 2012/04/03 18:45:25 - hive - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : ERROR executing query: org.pentaho.di.core.exception.KettleDatabaseException: 2012/04/03 18:45:25 - hive - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Error getting row information from database: 2012/04/03 18:45:25 - hive - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Method not supported 2012/04/03 18:45:25 - hive - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : ERROR in part: openQuery : get rowinfo 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Unexpected error 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : An error occurred executing SQL in part [openQuery : get rowinfo]: 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : SELECT * 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : FROM currency 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Error getting row information from database: 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Method not supported 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1918) 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:223) 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:133) 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40) 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Error getting row information from database: 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Method not supported 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2444) 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1905) 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : ... 4 more 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Caused by: java.sql.SQLException: Method not supported 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.apache.hadoop.hive.jdbc.HiveResultSetMetaData.isSigned(HiveResultSetMetaData.java:275) 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.core.database.Database.getValueFromSQLType(Database.java:2456) 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2437) 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : ... 5 more 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException: 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Error cancelling statement 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Method not supported 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Error cancelling statement 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Method not supported 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.core.database.Database.cancelStatement(Database.java:639) 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.core.database.Database.cancelQuery(Database.java:619) 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:293) 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.trans.Trans.stopAll(Trans.java:1352) 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2244) 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:64) 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Caused by: java.sql.SQLException: Method not supported 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.apache.hadoop.hive.jdbc.HiveStatement.cancel(HiveStatement.java:83) 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : at org.pentaho.di.core.database.Database.cancelStatement(Database.java:633) 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : ... 6 more 2012/04/03 18:45:25 - Table input.0 - Finished reading query, closing connection. 2012/04/03 18:45:25 - Table input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - C:\Users\shailendrav\Desktop\A.ktr : A 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - C:\Users\shailendrav\Desktop\A.ktr : A

    Pentaho BI Platform Tracking | 5 years ago | shailendra vichare
    org.pentaho.di.core.exception.KettleDatabaseException: 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : An error occurred executing SQL in part [openQuery : get rowinfo]: 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : SELECT * 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : FROM currency 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Error getting row information from database: 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Method not supported 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : 2012/04/03 18:45:25 - Table input.0 - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) :
  3. 0

    Hi, I noticed that I am not the only one that ran into trouble while truying to connect to a Hive instance via JDBC in PDI 4.4. I have tried multiple setups but just can't get it to work. I am on PDI 4.4 & CDH3u4 with the standard Cloudera Hive (0.7.1-chd3u4) Hive thrift server running on the cluster side... When I use the standard jdbc jar "hive-jdbc-0.7.0-pentaho-1.0.2.jar" from /plugins/pentaho-big-data-plugin/hadoop-configurations/cdh3u4/lib I get this error message while testing the connection: ############################ Error connecting to database [Hive cHadoop1] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver) Error communicating with Hive org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database ############################# When I tried to use the "hive-jdbc-0.7.0-pentaho-1.0.2.jar" on both end it makes no difference; still this error. So I tried replacing the "hive-jdbc-0.7.0-pentaho-1.0.2.jar" (on the Pentaho side) with a copy of the "hive-jdbc-0.7.1-cdh3u4.jar" from the cluster Now I can connect to Hive and browse tables but when I try to access table contents I get the "Method not supported" error message with this stacktrace: This time I can tell from the Hive logs that the Hive statements is executed; a MR job is being triggered. But when the time comes to stream the results back to Pentaho I get this: (Looks like PDI cannot handle the row results from the Hive query) ##################################### 2012/11/21 12:50:10 - Hive cHadoop1 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ERROR executing query: org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Hive cHadoop1 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error getting row information from database: 2012/11/21 12:50:10 - Hive cHadoop1 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Hive cHadoop1 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ERROR in part: openQuery : get rowinfo 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Unexpected error 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : An error occurred executing SQL in part [openQuery : get rowinfo]: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : SELECT * FROM gsa_log limit 10 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error getting row information from database: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1863) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:233) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at java.lang.Thread.run(Thread.java:662) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error getting row information from database: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2396) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1850) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ... 4 more 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Caused by: java.sql.SQLException: Method not supported 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.apache.hadoop.hive.jdbc.HiveResultSetMetaData.isSigned(HiveResultSetMetaData.java:177) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.getValueFromSQLType(Database.java:2408) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2389) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ... 5 more 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error cancelling statement 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error cancelling statement 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.cancelStatement(Database.java:635) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.cancelQuery(Database.java:615) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:303) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.Trans.stopAll(Trans.java:1563) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2525) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:74) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at java.lang.Thread.run(Thread.java:662) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Caused by: java.sql.SQLException: Method not supported 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.apache.hadoop.hive.jdbc.HiveStatement.cancel(HiveStatement.java:90) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.cancelStatement(Database.java:629) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ... 6 more 2012/11/21 12:50:10 - Table input.0 - Finished reading query, closing connection. ######################################

    Pentaho BI Platform Tracking | 4 years ago | Jasper Knulst
    org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : An error occurred executing SQL in part [openQuery : get rowinfo]: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : SELECT * FROM gsa_log limit 10 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error getting row information from database: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) :
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: No value specified for parameter 1解决办法_IT知识问答_希赛网

    educity.cn | 2 years ago
    java.sql.SQLException: No value specified for parameter 1 代码如下 public boolean login(UserInfo user)throws Exception{ //用户登录 boolean flag=false; int userNo=Integer.parseInt(user.getUserNo()); String password=user.getPassword(); //测试是否从现在的user对象中取到了值 System.out.println(userNo+"我是USER对象的userNo"); System.out.println(password+"我是USER对象的password"); DatabaseConnection dbc=new DatabaseConnection();//取得数据库连接和关闭对象; try{ String sql="SELECT userNo FROM userInfo where userNo= and password= "; this.conn=dbc.getConnection(); this.pst=conn.prepareStatement(sql); //this.pst.setInt(1, userNo);//给sql中参数赋值 this.pst.setLong(1, userNo); this.pst.setString(2, password); ResultSet rs=pst.executeQuery(); if(rs.next()){//传入用户账号和对应的密码都存在时为真 flag=true; System.out.println(rs.getString(userNo)+"我是从数据库里取出来的"); System.out.print(flag+"测试flag");//测试flag,看是否进入了if里面,true则进入了 rs.close(); } }catch(Exception e){ e.printStackTrace(); }finally{ if(this.pst!=null){ this.pst.close(); } this.conn.close(); } return flag; } 报的错误信息如:
  6. 0

    java.sql.SQLException: No suitable driver - Toolbox for IT Groups

    ittoolbox.com | 7 months ago
    java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager .java:545) at java.sql.DriverManager.getConnection(DriverManager .java:171) at com.stc.sql.framework.jdbc.DBConnectionFactory.cre ateConnection(DBConnectionFactory.java:372) at com.stc.sql.framework.jdbc.DBConnectionFactory.get Connection(DBConnectionFactory.java:281) at com.stc.etl.engine.impl.SimpleTask.getConnection(S impleTask.java:254) at com.stc.etl.engine.impl.Extractor.getSelectData(Ex tractor.java:376) at com.stc.etl.engine.impl.Extractor.process(Extracto r.java:190) at com.stc.etl.engine.impl.ETLTaskThread.run(ETLTaskT hread.java:147)

    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.hadoop.hive.jdbc.HiveResultSetMetaData.isSigned()
    2. org.apache.hadoop
      HiveResultSetMetaData.isSigned
      1. org.apache.hadoop.hive.jdbc.HiveResultSetMetaData.isSigned(HiveResultSetMetaData.java:177)
      1 frame
    3. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.database.Database.getValueFromSQLType(Database.java:2474)
      2. org.pentaho.di.core.database.Database.getRowInfo(Database.java:2455)
      3. org.pentaho.di.core.database.Database.openQuery(Database.java:1916)
      4. org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:233)
      5. org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143)
      6. org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
      6 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame