1. An error is reported when kettle connects to Oracle database
When kettle connects to Oracle database for the first time, it reports an error “wrong connection to database [Oracle] ”， This is because spoon lacks the jar package corresponding to Oracle. If Oracle or Oracle client is installed, you can copy the corresponding jar file from their installation directory to solve the error problem.
Copy and paste all files starting with ojdbc in Oracle database, such as ojdbc5 and ojdbc6.jar, into the spoon directory, such as D: \ kettle \ data-integration-220.127.116.11-719 \ lib\ Just under the path.
2. An error is reported when kettle connects to MySQL database
The error contents are as follows:
This is caused by the missing jar connection package of MySQL.
You need the jar connection package of MySQL database, such as mysql-connector-java-8.0.11.jar, copy and paste it into the spoon directory, such as D: \ kettle \ data-integration-18.104.22.168-719 \ lib\ Just under the path.
The attachment download link is as follows:
Kettle driver. TXT other document resources CSDN Download
- Could not create connection to database server. Attempted reconnect 3 times. Giving
- Spark SQL startup error: error creating transactional connection factory
- Solve the problem that dbvisualizer cannot connect to mysql8
- invalid connection string format, a valid format is host:ip:port
- pom.xml Depending on the error report, the problem of missing artifact XXX is solved
- Batch error reporting in Java spring
- Zeppelin uses spark to connect to MySQL and reports an error
- Error dropping database can’t rmdir
- ERROR 2000 (HY000): Unknown MySQL error
- MySQL error: error 1010 (HY000) when deleting database
- Solution: PIP install MySQL Python has the following problems
- MySQL startup problem (ERROR 1045 (28000): Access denied for user’ODBC’@’localhost’ (using password: NO))
- mysql ERROR 1050 (42S01): Table already exists
- Navicat VMware failed to connect to the database. Possible causes of error 2003
- EnvironmentError:mysql config not found
- MySQL ERROR 1054 (42S22): Unknown column’password’ in’field list’ error
- [error handling] idea error reporting com.alibaba.druid . pool.DruidDataSource error
- Got an error reading communication packets
- [mysql] “Failed to start MySQL Server” error resolution
- A PHP Error was encountered Severity: Warning Message: mysqli::real_connect(): Headers and client