JDBC Engine Usage

If you want to use the JDBC EngineConn on your server, you need to prepare the JDBC connection information, such as the connection address, user name and password of the MySQL database, etc.

The JDBC EngineConn does not need to be compiled by the user, and the compiled JDBC EngineConn plug-in package can be used directly. Drivers that have been provided include MySQL, PostgreSQL, etc.

2.2 JDBC EngineConn deployment and loading

Here you can use the default loading method to use it normally, just install it according to the standard version.

Here you can use the default dml.sql to insert it and it can be used normally.

Ready to operate

Figure 3-1 JDBC configuration information

You can also specify in the RuntimeMap of the submitted task

Linkis provides a client method to call jdbc tasks. The call method is through the SDK provided by LinkisClient. We provide java and scala two ways to call, the specific usage can refer to JAVA SDK Manual. If you use Hive, you only need to make the following changes:

3.2 How to use Linkis-cli

The specific usage can refer to Linkis CLI Manual.

The way to use is the simplest. You can go directly to Scriptis, right-click the directory and create a new JDBC script, write JDBC code and click Execute.

The execution principle of JDBC is to load the JDBC Driver and submit sql to the SQL server for execution and obtain the result set and return.

JDBC user settings are mainly JDBC connection information, but it is recommended that users encrypt and manage this password and other information.