java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM klanten [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11010).

Pentaho BI Platform Tracking | Cattel | 8 years ago
  1. 0

    Have a weard issue. Try to read a Paradox , Borland DBE. Contains of 17 (database) files. Most of them I easily can read into source table. But a couple I get error message. Maybee not a real BUG but seems to be strange, since the database comes out of a (working) production environment. So 15 tabels are perfect readilble, but 3 tables I get next message: (I wonder why this can be a driver problem) "An error occurred executing SQL: SELECT * FROM klanten [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11010)." Error details: java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM klanten [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11010). at org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:80) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM klanten [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11010). at org.pentaho.di.core.database.Database.openQuery(Database.java:1782) at org.pentaho.di.core.database.Database.openQuery(Database.java:1706) at org.pentaho.di.core.database.Database.openQuery(Database.java:1701) at org.pentaho.di.core.database.Database.openQuery(Database.java:1688) at org.pentaho.di.core.database.Database.getRows(Database.java:3969) at org.pentaho.di.core.database.Database.getFirstRows(Database.java:4047) at org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:72) ... 1 more Caused by: java.sql.SQLException: [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11010). at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source) at org.pentaho.di.core.database.Database.openQuery(Database.java:1768) ... 7 more ------------------------------------------------------ I'm using the Microsoft Paradox ODBC driver. Maybee someone knows a better one?

    Pentaho BI Platform Tracking | 8 years ago | Cattel
    java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM klanten [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11010).
  2. 0

    Have a weard issue. Try to read a Paradox , Borland DBE. Contains of 17 (database) files. Most of them I easily can read into source table. But a couple I get error message. Maybee not a real BUG but seems to be strange, since the database comes out of a (working) production environment. So 15 tabels are perfect readilble, but 3 tables I get next message: (I wonder why this can be a driver problem) "An error occurred executing SQL: SELECT * FROM klanten [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11010)." Error details: java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM klanten [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11010). at org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:80) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM klanten [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11010). at org.pentaho.di.core.database.Database.openQuery(Database.java:1782) at org.pentaho.di.core.database.Database.openQuery(Database.java:1706) at org.pentaho.di.core.database.Database.openQuery(Database.java:1701) at org.pentaho.di.core.database.Database.openQuery(Database.java:1688) at org.pentaho.di.core.database.Database.getRows(Database.java:3969) at org.pentaho.di.core.database.Database.getFirstRows(Database.java:4047) at org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:72) ... 1 more Caused by: java.sql.SQLException: [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11010). at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source) at org.pentaho.di.core.database.Database.openQuery(Database.java:1768) ... 7 more ------------------------------------------------------ I'm using the Microsoft Paradox ODBC driver. Maybee someone knows a better one?

    Pentaho BI Platform Tracking | 8 years ago | Cattel
    java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM klanten [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11010).
  3. 0

    java jdbc ms access "Syntax error in UPDATE statement"

    Stack Overflow | 3 years ago
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Reading Visual Foxpro Data From Java using ODBC

    Stack Overflow | 4 years ago | user1912404
    java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]Not a table.
  6. 0

    what is the correct syntax to query database from ms access jdbcodbc in java

    Stack Overflow | 4 years ago | Wong Kc
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Undefined function txtIcNo.getText' in expression.

    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

      [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11010).

      at sun.jdbc.odbc.JdbcOdbc.createSQLException()
    2. sun.jdbc.odbc
      JdbcOdbcStatement.executeQuery
      1. sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
      2. sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
      3. sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
      4. sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
      5. sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
      5 frames
    3. org.pentaho.di
      GetPreviewTableProgressDialog$1.run
      1. org.pentaho.di.core.database.Database.openQuery(Database.java:1768)
      2. org.pentaho.di.core.database.Database.openQuery(Database.java:1706)
      3. org.pentaho.di.core.database.Database.openQuery(Database.java:1701)
      4. org.pentaho.di.core.database.Database.openQuery(Database.java:1688)
      5. org.pentaho.di.core.database.Database.getRows(Database.java:3969)
      6. org.pentaho.di.core.database.Database.getFirstRows(Database.java:4047)
      7. org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:72)
      7 frames
    4. JFace
      ModalContext$ModalContextThread.run
      1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
      1 frame