Pentaho Error Connecting To Database Mysql
Contents |
here for a quick overview of the site org.gjt.mm.mysql.driver download Help Center Detailed answers to any questions you might have Meta
Error Occurred While Trying To Connect To The Database Pentaho
Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn
Org.gjt.mm.mysql.driver Pentaho Download
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping pentaho mysql jdbc driver each other. Join them; it only takes a minute: Sign up Pentaho Data Integration SQL connection up vote 45 down vote favorite 10 I am using Pentaho Data Integration and I am trying to connect to my database via MySQL but when I do I get this error..... Error connecting to database [devdb2] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Exception while loading class org.gjt.mm.mysql.Driver org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Exception while loading class org.gjt.mm.mysql.Driver at org.pentaho.di.core.database.Database.normalConnect(Database.java:368) at org.pentaho.di.core.database.Database.connect(Database.java:317) at org.pentaho.di.core.database.Database.connect(Database.java:279) at org.pentaho.di.core.database.Database.connect(Database.java:269) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2464) at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:533) at sun.reflect.GeneratedMethodAccessor55.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.im
View Site Leaders Advanced Search Forum Pentaho Users org.pentaho.di.core.exception.kettledatabaseexception oracle Pentaho Data Integration [Kettle] Error connecting to MySQL If this is your org.gjt.mm.mysql.driver maven first visit, be sure to check out the FAQ by clicking the link above. You may have to register http://stackoverflow.com/questions/11634181/pentaho-data-integration-sql-connection before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: Error connecting to MySQL Thread Tools http://forums.pentaho.com/showthread.php?50451-Error-connecting-to-MySQL Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-08-2007,08:33 AM #1 ruge75 View Profile View Forum Posts Private Message Visit Homepage Member Join Date Jan 2006 Posts 31 Error connecting to MySQL Since this morning my Spoon worked fine. Now I cannot connect to my MySQL kettle repository, I receive the following error message: Error occured while trying to connect to the database Exception while loading class org.gjt.mm.mysql.Driver be.ibridge.kettle.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Exception while loading class org.gjt.mm.mysql.Driver at be.ibridge.kettle.core.database.Database.connect(Database.java:188) at be.ibridge.kettle.core.dialog.DatabaseDialog.test(DatabaseDialog.java:1228) at be.ibridge.kettle.core.dialog.DatabaseDialog.test(DatabaseDialog.java:1210) at be.ibridge.kettle.core.dialog.DatabaseDialog$4.handleEvent(DatabaseDialog.java:236) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968) at be.ibridge.kettle.core.dialog.DatabaseDialog.open(DatabaseDialog.java:309) at be.ibridge.kettle.repository.dialog.RepositoryDialog$2.widgetSelected(RepositoryDialo
Converter http://devopsny.com/blog/2013/07/09/mysql-connectivity-issues-with-spoon-4-4-1/ Custom Search Friday, February 5, 2016 Spoon pentaho database connection - error connecting error connecting to database Error connecting to database [data analytics] : org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Driver class 'org.gjt.mm.mysql.Driver' could not be found, error connecting to make sure the 'MySQL' driver (jar file) is installed. org.gjt.mm.mysql.Driver org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed. org.gjt.mm.mysql.Driver at org.pentaho.di.core.database.Database.normalConnect(Database.java:459) at org.pentaho.di.core.database.Database.connect(Database.java:357) at org.pentaho.di.core.database.Database.connect(Database.java:328) at org.pentaho.di.core.database.Database.connect(Database.java:318) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:80) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2734) at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:588) 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:313) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141) at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:43) at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:136) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.s
this error message (truncated). Error connecting to database [mysql] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Exception while loading class org.gjt.mm.mysql.Driver Digging around, the full error can be found here: Exception while loading class mysql.Driver The answer is provided in the Jira ticket. You need to download and install the MySQL JDBC connector which can be found here: Download Connector/J I am using the Windows x64 version so I had to place the jar file here: C:\Program Files\pentaho\design-tools\data-integration\libext Now I am able to connect to MySQL. According to Pentaho, they can no longer include the MySQL JDBC connector as it is not compatible with the Apache 4.3 license. Share this:EmailTweetMoreLike this:Like Loading... Author Daniel CassieroPosted on July 9, 2013Categories ETL, PDI, PentahoTags etl, java, kettle, pdi, pentaho, spoon Post navigation Previous Previous post: Install Oracle JDK 8 on Ubuntu ServerNext Next post: Five Great Reasons Why We Should Blog Search for: Search Meta Register Log in Entries RSS Comments RSS WordPress.org Affiliates Production Web Operations.com Web Ops rants Convention Over Configuration how about some information, please? Recent Posts Creating an HTPC Stack With Docker Things, Part 2 Remove all unused Docker images Creating an HTPC Stack With Docker Things rsyslog Debugging a chef-solo deployment. Recent CommentsDaniel Cassiero on Apache2 on Solaris 10Tags.net4.0 13.04 apache2 awk bash debugging development devops docker errors htpc icinga iis7 java linux loadbalancing logresolve logs Magento modsecurity monitoring mssql multitail nagios netscaler networking newrelic redhat redis riaservices sabnzbd+ selenium sickbeard snmp subversion svn synthetictransactions systemadministration tfs ubuntu ubuntu1004 vmware WCF webmonitoring windowsserver2008 CategoriesCategories Select Category .Net .Net 4.0 10.04 12.04 LTS 13.04 14.04 LTS 6.4 Agile Apache2 APM AWK Bash CentOS Chef chef-solo Configuration Debugging Development DevOps dig DNS Docker E Commerce Errors ETL Funtoo git github.com Hadoop HTTP Protocol Hyper-V Icinga IIS7 Java JIRA JRE Linux Load Balancing Log File Management Log File Visualization Magento ModSecurity Monitoring MS SQL Server MySQL Nagios Netscaler Network New Relic OAuth Oracle PDI Pentaho PHP Powershell RedHat Redis RHEL6 rsyslog Selenium SNMP Solaris Solaris 10 Subversion Sun Synthetic Transactions System Administration Tealeaf TeamCity TFS Tools Ubuntu Unca