Spoon kettle fails to connect to the database. Solution: spoonkettle

Spoon kettle fails to connect to the database. Solution: spoonkettle

Driver class 'oracle. jdbc. driver. OracleDriver 'could not be found, make sure the 'oracle' driver (jar file) is installed.
Oracle. jdbc. driver. OracleDriver

I just downloaded spoon and prepared to write a simple example to test it. I encountered this error when logging on to the database. The error description means that the corresponding oracle driver cannot be found. If you have installed oracle, you can find the driver locally. Search for "jdbc". The following files are usually visible, such as ojdbc5.jar and ojdbc5_g.jar.

 

	Ojdbc5.jar (1,996,228 bytes)-class for JDK 1.5. It contains JDBC driver classes, but does not include classes that support NLS in Oracle Object and Collection types.
	Ojdbc5_g.jar (3,081,328 bytes)-similar to ojdbc5.jar, except for classes that are compiled by javac-g and contain tracing code.

Specific instructions can refer to the oralce official site description: http://www.oracle.com/technetwork/cn/articles/oem/jdbc-112010-094555-zhs.html

 

My solution is to put the locally found ojdbc. the jar file is stored under data-integration \ libswt \ win32. Of course, it can also be stored in a location that can be found by data-integration \ lib or another program. You can also modify the environment variables of the system, so that the driver can be found

 

Remember to restart spoon, or you will report an error no matter how hard it is.

Kettle 42 database connection error, help,

It should be a problem with Mysql database configuration. there are corresponding liberation methods on the Internet, such:
Solution:
1. Change the table. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysql on the computer of localhost, and change the "host" entry in the "user" table in the "mysql" database to "%" from "localhost"
Mysql-u root-pvmwaremysql> use mysql; mysql> update user set host = '%' where user = 'root'; mysql> select host, user from user;
2. Authorization method. For example, if you want myuser to use mypassword to connect to the mysql server from any host.
This is not a Kettle issue.

Kettle database connection problems

Are you using the new kettle version? If yes, select the database connection in the table input. If no table information is obtained, write the select statement on your own.