Using Kettle5.0.1, install MySQL5.1, JDK1.6, add MySQL JDBC package in \data-integration\lib directory Mysql-connector-java-5.0.8-bin.jar ,
Set up MySQL's various information in the new repository, as follows
Click "Test" to report the following error
Error connecting to database [local MySQL ' Test ' database]: 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)
Java.lang.NullPointerException
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)
Java.lang.NullPointerException
At Org.pentaho.di.core.database.Database.normalConnect (database.java:415)
At Org.pentaho.di.core.database.Database.connect (database.java:353)
At Org.pentaho.di.core.database.Database.connect (database.java:306)
At Org.pentaho.di.core.database.Database.connect (database.java:294)
At Org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport (databasefactory.java:84)
At Org.pentaho.di.core.database.DatabaseMeta.testConnection (databasemeta.java:2459)
At Org.pentaho.ui.database.event.DataHandler.testDatabaseConnection (datahandler.java:541)
At Sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
At Sun.reflect.NativeMethodAccessorImpl.invoke (nativemethodaccessorimpl.java:57)
At Sun.reflect.DelegatingMethodAccessorImpl.invoke (delegatingmethodaccessorimpl.java:43)
At Java.lang.reflect.Method.invoke (method.java:601)
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:121)
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:375)
At Org.pentaho.ui.xul.swt.tags.SwtDialog.show (swtdialog.java:301)
At Org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open (xuldatabasedialog.java:115)
At Org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open (databasedialog.java:62)
At Org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection (spoondbdelegate.java:493)
At Org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection (spoondbdelegate.java:478)
At Org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree (spoon.java:2885)
At org.pentaho.di.ui.spoon.spoon.access$2300 (spoon.java:332)
At org.pentaho.di.ui.spoon.spoon$27.widgetdefaultselected (spoon.java:5657)
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:1227)
At Org.pentaho.di.ui.spoon.Spoon.waitForDispose (spoon.java:7368)
At Org.pentaho.di.ui.spoon.Spoon.start (spoon.java:8673)
At Org.pentaho.di.ui.spoon.Spoon.main (spoon.java:625)
At Sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
At Sun.reflect.NativeMethodAccessorImpl.invoke (nativemethodaccessorimpl.java:57)
At Sun.reflect.DelegatingMethodAccessorImpl.invoke (delegatingmethodaccessorimpl.java:43)
At Java.lang.reflect.Method.invoke (method.java:601)
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)
Java.lang.NullPointerException
At Org.pentaho.di.core.database.Database.connectUsingClass (database.java:540)
At Org.pentaho.di.core.database.Database.normalConnect (database.java:399)
... More
caused by:java.sql.SQLException:java.lang.NullPointerException
At Com.mysql.jdbc.SQLError.createSQLException (sqlerror.java:910)
At Com.mysql.jdbc.ServerPreparedStatement.executeInternal (serverpreparedstatement.java:766)
At Com.mysql.jdbc.PreparedStatement.execute (preparedstatement.java:882)
At Com.mysql.jdbc.Statement.createResultSetUsingServerFetch (statement.java:525)
At Com.mysql.jdbc.Statement.executeQuery (statement.java:1158)
At Com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings (sqlerror.java:710)
At Com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation (mysqlio.java:3183)
At Com.mysql.jdbc.ServerPreparedStatement.serverExecute (serverpreparedstatement.java:1349)
At Com.mysql.jdbc.ServerPreparedStatement.executeInternal (serverpreparedstatement.java:740)
At Com.mysql.jdbc.PreparedStatement.execute (preparedstatement.java:882)
At Com.mysql.jdbc.Statement.createResultSetUsingServerFetch (statement.java:525)
At Com.mysql.jdbc.Statement.executeQuery (statement.java:1158)
At Com.mysql.jdbc.Connection.loadServerVariables (connection.java:4478)
At Com.mysql.jdbc.Connection.initializePropsFromServer (connection.java:4062)
At Com.mysql.jdbc.Connection.createNewIO (connection.java:2789)
At Com.mysql.jdbc.connection.<init> (connection.java:1555)
At Com.mysql.jdbc.NonRegisteringDriver.connect (nonregisteringdriver.java:285)
At Java.sql.DriverManager.getConnection (drivermanager.java:579)
At Java.sql.DriverManager.getConnection (drivermanager.java:221)
At Org.pentaho.di.core.database.Database.connectUsingClass (database.java:524)
... More
Host name: localhost
Port: 3306
Database name: Test
After the experiment, found that the cause of the error is MySQL version of the JDBC package is selected wrong, the use of Mysql-connector-java-5.1.30-bin.jar is no problem
By the right: newly created repository default "account: admin Password: admin" "Account: Guest Password: Guest"
Kettle using MySQL as a repository error resolution method