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) Unknown database 'fruit_veg'

Pentaho BI Platform Tracking | Raghavendra J | 5 years ago
  1. 0

    Error connecting to database [Fruits and Vegetables] : 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) Unknown database 'fruit_veg' 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) Unknown database 'fruit_veg' 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.GeneratedMethodAccessor13.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.pms.ui.MetaEditor.newConnection(MetaEditor.java:2794) at org.pentaho.pms.ui.MetaEditor$47.handleEvent(MetaEditor.java:1675) 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.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:851) at org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3589) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class org.gjt.mm.mysql.Driver) Unknown database 'fruit_veg' at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:510) at org.pentaho.di.core.database.Database.normalConnect(Database.java:358) ... 33 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'fruit_veg' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.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.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4116) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370) 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.GeneratedConstructorAccessor23.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) ... 34 more Hostname : localhost Port : 3306 Database name : fruit_veg

    Pentaho BI Platform Tracking | 5 years ago | Raghavendra J
    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) Unknown database 'fruit_veg'
  2. 0

    Error connecting to database [Fruits and Vegetables] : 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) Unknown database 'fruit_veg' 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) Unknown database 'fruit_veg' 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.GeneratedMethodAccessor13.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.pms.ui.MetaEditor.newConnection(MetaEditor.java:2794) at org.pentaho.pms.ui.MetaEditor$47.handleEvent(MetaEditor.java:1675) 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.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:851) at org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3589) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class org.gjt.mm.mysql.Driver) Unknown database 'fruit_veg' at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:510) at org.pentaho.di.core.database.Database.normalConnect(Database.java:358) ... 33 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'fruit_veg' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.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.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4116) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370) 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.GeneratedConstructorAccessor23.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) ... 34 more Hostname : localhost Port : 3306 Database name : fruit_veg

    Pentaho BI Platform Tracking | 5 years ago | Raghavendra J
    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) Unknown database 'fruit_veg'
  3. 0

    Error connecting to database: (using class org.gjt.mm.mysql.Driver) Access denied for user 'clickedu'@'localhost'

    Stack Overflow | 5 months ago | Guifré Ballester
    org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) Access denied for user 'clickedu'@'localhost' to database 'clickedu'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    PermissionEx will not start with MySQL

    GitHub | 3 years ago | OctopusPlaya
    java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'clientDB_2077'@'%' to database 'clientdb_2077'
  6. 0

    Problem to retrieve data on connection

    GitHub | 2 years ago | Mice73
    org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.SQLGrammarException: Could not open connection

  1. linxiaolong 2 times, last 1 month ago
  2. tvrmsmith 1 times, last 5 months ago
  3. DoktorDoener666 9 times, last 1 month ago
  4. tvrmsmith 4 times, last 3 months ago
  5. fima 1 times, last 3 months ago
27 more registered users
66 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. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Unknown database 'fruit_veg'

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    4. java.lang.reflect.Constructor.newInstance(Unknown Source)
    4 frames
  3. MySQL jdbc
    JDBC4Connection.<init>
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    2. com.mysql.jdbc.Util.getInstance(Util.java:386)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
    6. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935)
    7. com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4116)
    8. com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300)
    9. com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337)
    10. com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
    11. com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
    12. com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
    13. com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    13 frames
  4. Java RT
    Constructor.newInstance
    1. sun.reflect.GeneratedConstructorAccessor23.newInstance(Unknown Source)
    2. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    3. java.lang.reflect.Constructor.newInstance(Unknown Source)
    3 frames
  5. 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
  6. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(Unknown Source)
    2. java.sql.DriverManager.getConnection(Unknown Source)
    2 frames
  7. 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
  8. org.pentaho.ui
    DataHandler.testDatabaseConnection
    1. org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:511)
    1 frame
  9. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    3. java.lang.reflect.Method.invoke(Unknown Source)
    3 frames
  10. 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
  11. 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
  12. 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
  13. 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
  14. org.pentaho.di
    DatabaseDialog.open
    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)
    2 frames
  15. org.pentaho.pms
    MetaEditor$47.handleEvent
    1. org.pentaho.pms.ui.MetaEditor.newConnection(MetaEditor.java:2794)
    2. org.pentaho.pms.ui.MetaEditor$47.handleEvent(MetaEditor.java:1675)
    2 frames
  16. RWT
    Display.readAndDispatch
    1. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    2. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    3. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    4. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    4 frames
  17. org.pentaho.pms
    MetaEditor.main
    1. org.pentaho.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:851)
    2. org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3589)
    2 frames