org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) ResultSet is from UPDATE. No Data.

Pentaho BI Platform Tracking | britebyte | 5 years ago
  1. 0

    After update to PDI 4.2 I cannot connect to MySQL with valid credentials using Test Connection in the Connection Editor or in any step that requires a DB connection. The error message I get is: Error connecting to database [Local MYDB] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) ResultSet is from UPDATE. No Data. org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) ResultSet is from UPDATE. No Data. at org.pentaho.di.core.database.Database.normalConnect(Database.java:374) at org.pentaho.di.core.database.Database.connect(Database.java:323) at org.pentaho.di.core.database.Database.connect(Database.java:285) at org.pentaho.di.core.database.Database.connect(Database.java:275) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2455) at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:511) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123) at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26) at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304) at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:104) at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:51) at org.pentaho.di.ui.trans.step.BaseStepDialog$4.widgetSelected(BaseStepDialog.java:509) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.trans.steps.tableoutput.TableOutputDialog.open(TableOutputDialog.java:916) at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:126) at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7728) at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2744) at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:693) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class org.gjt.mm.mysql.Driver) ResultSet is from UPDATE. No Data. at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:510) at org.pentaho.di.core.database.Database.normalConnect(Database.java:358) ... 50 more Caused by: java.sql.SQLException: ResultSet is from UPDATE. No Data. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7152) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3867) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3404) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2385) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor103.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:490) ... 51 more Hostname : localhost Port : 3306 Database name : mydb

    Pentaho BI Platform Tracking | 5 years ago | britebyte
    org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) ResultSet is from UPDATE. No Data.
  2. 0

    After update to PDI 4.2 I cannot connect to MySQL with valid credentials using Test Connection in the Connection Editor or in any step that requires a DB connection. The error message I get is: Error connecting to database [Local MYDB] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) ResultSet is from UPDATE. No Data. org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) ResultSet is from UPDATE. No Data. at org.pentaho.di.core.database.Database.normalConnect(Database.java:374) at org.pentaho.di.core.database.Database.connect(Database.java:323) at org.pentaho.di.core.database.Database.connect(Database.java:285) at org.pentaho.di.core.database.Database.connect(Database.java:275) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2455) at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:511) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123) at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26) at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304) at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:104) at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:51) at org.pentaho.di.ui.trans.step.BaseStepDialog$4.widgetSelected(BaseStepDialog.java:509) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.trans.steps.tableoutput.TableOutputDialog.open(TableOutputDialog.java:916) at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:126) at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7728) at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2744) at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:693) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class org.gjt.mm.mysql.Driver) ResultSet is from UPDATE. No Data. at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:510) at org.pentaho.di.core.database.Database.normalConnect(Database.java:358) ... 50 more Caused by: java.sql.SQLException: ResultSet is from UPDATE. No Data. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7152) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3867) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3404) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2385) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor103.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:490) ... 51 more Hostname : localhost Port : 3306 Database name : mydb

    Pentaho BI Platform Tracking | 5 years ago | britebyte
    org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) ResultSet is from UPDATE. No Data.
  3. 0

    Error using latest for geSuite

    GitHub | 2 years ago | Kainzo
    java.sql.SQLException: Access denied for user 'username'@'localhost' (using password: YES)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    MySQL Bugs: #77665: JDBC fails to connect with MySQL 5.0

    mysql.com | 6 months ago
    java.sql.SQLException: Unknown system variable 'language'
  6. 0

    Could not load 'plugins/FBasics.jar' in folder 'plugins'

    GitHub | 2 years ago | k3ldon
    org.bukkit.plugin.InvalidPluginException: com.avaje.ebeaninternal.server.lib.sql.DataSourceException: java.sql.SQLException: Access denied for user 'bukkit'@'localhost' (using password: YES)

  1. jshakil 3 times, last 1 month ago
  2. jstrayer 6 times, last 2 months ago
  3. rp 18 times, last 10 months ago
  4. WoodenDoors 2 times, last 9 months ago
  5. tvrmsmith 1 times, last 6 months ago
28 unregistered visitors
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

    ResultSet is from UPDATE. No Data.

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    JDBC4Connection.<init>
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    2. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    5. com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7152)
    6. com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3867)
    7. com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3404)
    8. com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2385)
    9. com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
    10. com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
    11. com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    11 frames
  3. Java RT
    Constructor.newInstance
    1. sun.reflect.GeneratedConstructorAccessor103.newInstance(Unknown Source)
    2. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    3. java.lang.reflect.Constructor.newInstance(Unknown Source)
    3 frames
  4. MySQL jdbc
    NonRegisteringDriver.connect
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    2. com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
    3. com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    3 frames
  5. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(Unknown Source)
    2. java.sql.DriverManager.getConnection(Unknown Source)
    2 frames
  6. org.pentaho.di
    DatabaseMeta.testConnection
    1. org.pentaho.di.core.database.Database.connectUsingClass(Database.java:490)
    2. org.pentaho.di.core.database.Database.normalConnect(Database.java:358)
    3. org.pentaho.di.core.database.Database.connect(Database.java:323)
    4. org.pentaho.di.core.database.Database.connect(Database.java:285)
    5. org.pentaho.di.core.database.Database.connect(Database.java:275)
    6. org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    7. org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2455)
    7 frames
  7. org.pentaho.ui
    DataHandler.testDatabaseConnection
    1. org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:511)
    1 frame
  8. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  9. org.pentaho.ui
    SwtButton$4.widgetSelected
    1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    2. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    3. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    4. org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
    5. org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
    5 frames
  10. RWT
    Display.readAndDispatch
    1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    5 frames
  11. JFace
    Window.open
    1. org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    2. org.eclipse.jface.window.Window.open(Window.java:796)
    2 frames
  12. org.pentaho.ui
    SwtDialog.show
    1. org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378)
    2. org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
    2 frames
  13. org.pentaho.di
    BaseStepDialog$4.widgetSelected
    1. org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:104)
    2. org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:51)
    3. org.pentaho.di.ui.trans.step.BaseStepDialog$4.widgetSelected(BaseStepDialog.java:509)
    3 frames
  14. RWT
    Display.readAndDispatch
    1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    5 frames
  15. org.pentaho.di
    TransGraph.mouseDoubleClick
    1. org.pentaho.di.ui.trans.steps.tableoutput.TableOutputDialog.open(TableOutputDialog.java:916)
    2. org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:126)
    3. org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7728)
    4. org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2744)
    5. org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:693)
    5 frames
  16. RWT
    Display.readAndDispatch
    1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    5 frames
  17. org.pentaho.di
    Spoon.main
    1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169)
    2. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940)
    3. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553)
    3 frames
  18. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  19. org.pentaho.commons
    Launcher.main
    1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    1 frame