Kettle Getting Started note (ii) the kettle of the report of the pit Daddy error: the error occured while trying to connect to the database

1 Introduction

The error occured while trying to connect to the database error occurs when developing with kettle, but careful observation of the log causes the errors to vary. This error seems simple, but sometimes the simpler the error is not patient change, especially when busy, accidentally fill in the wrong parameter to cause the error but I feel no problem but run unsuccessfully, this is the most annoying. This time need to calm, may wish to search the Internet, error may be happy to solve. The following is a different occurrence of the more detailed error of this error.

2 Example

There is a very simple ktr script (currently Kettle version 3.0.4), such as:

The table enters normal configuration information as follows:

Kettle Installation file directory is the case of a jar package:

Following the above configuration, the Ktr script can be executed normally.

1 First look at the missing OJDBC jar package Error

Is the case where the OJDBC package was deleted:

Log information:

The point is

Exception while loading class Oracle.jdbc.driver.OracleDriver. Load Class Oracle.jdbc.driver.OracleDriver Exception This is most likely a problem with the jar package.

2 The following is an IP address input error

Error message given by the log:

The IO exception probably means that the network adapter cannot establish a connection.

3 database name error

The situation of the log error:

An error occurred, processing'll be stopped:error occured and trying to connect to the database

2014/11/18 23:34:40-table output. 0-error (version 3.0.4, build from 2008/06/24 18:14:00): Listener refused the connection W ITH the following error:
ORA-12505, Tns:listener does not currently know of SID given in Connect descriptor the Connection descriptor used by the C Lient Was:127.0.0.1:1521:orc

Probably meaning: The listener rejected the connection due to the following error: TNS (Oracle Server and Client Communication protocol) listener does not know the current SID (unique identifier of the database), this SID is given in the connection descriptor, the client using this descriptor is 127.0.0.1:1521:ORC

4 port number is incorrect

Log Status:

The error is the same as an inaccurate IP address:

5 Incorrect user name or password

User name or password error, log information is as follows:

Invalid user name or password, login denied

6 Running the server does not have permission to access the remote database

To ping the remote database machine IP from the running server:

Telnet the remote database port from the running server:

Is all-in, but the table output is this script will error:

Logon rejected refused to log in. The machine running the script does not have permission to access the database to cause this error.

Here is the table output database set the black and white list while running the server is not in its whitelist causing this error

3 Summary

Encounter similar such errors, need to calm and careful observation of the log, using the exclusion method, to quickly locate and solve the problem.

Kettle Getting Started note (ii) the kettle of the report of the pit Daddy error: the error occured while trying to connect to the database