Using ABAP (ADBC) and Java (JDBC) to connect to the SAP HANA database

Maintain a record in table Dbcon, pointing to the Hana database. The host name and port number of the Hana database are filled in con_env. such as vmxxxx:30015

Data:ls_new TYPE dbcon.ls_new-con_name = ' HAN '. Ls_new-dbms = ' HDB '. Ls_new-user_name = ' System '. Ls_new-password = ' Sap123 ". Ls_new-con_env = ' vml2018:30015 '.              Call FUNCTION ' dbcon_insert ' exporting Dbcon_workarea = Ls_new EXCEPTIONS dbcon_key_exists          = 1 Secure_store_key_exists = 2 Secure_store_other = 3 OTHERS = 4 .   IF SY-SUBRC = 0. write:/ ' Insert successfully '. ENDIF. Then use the ABAP code to create a new table, insert three entry, read it again, and finally delete Table.TYPES:BEGIN of result_t, key Type I, value type      String, END of result_t.DATA:connection type dbcon-con_name VALUE ' HAN ', stmt_ref type ref to Cl_sql_statement,      Cx_sql_exception type ref to Cx_sql_exception, Lv_text type string, Res_ref type ref to Cl_sql_result_set,      D_ref type ref to DATA, Result_tab type TABLE of result_t, Result_line type result_t, row_cnt type I, Con_ref TYPE ref to Cl_sql_connection.con_ref =Cl_sql_connection=>get_connection (connection). Stmt_ref = Con_ref->create_statement ().   TRY.   Stmt_ref->execute_ddl (' CREATE TABLE i042416_testproc_tab (key INT PRIMARY key, Value NVARCHAR (255)) '.   Stmt_ref->execute_update (' INSERT into I042416_testproc_tab VALUES (1, ' first value ') ').   Stmt_ref->execute_update (' INSERT into I042416_testproc_tab VALUES (2, ' Second value ') ').   Stmt_ref->execute_update (' INSERT into I042416_testproc_tab VALUES (3, ' third value ') ').   Res_ref = Stmt_ref->execute_query (' SELECT * from I042416_testproc_tab ').   GET REFERENCE of Result_tab into D_ref.   Res_ref->set_param_table (D_REF).   row_cnt = Res_ref->next_package (). Stmt_ref->execute_ddl (' DROP TABLE i042416_testproc_tab ').   CATCH cx_sql_exception into Cx_sql_exception.   Lv_text = Cx_sql_exception->get_text (). write:/ ' Error: ', Lv_text. Endtry.   LOOP at Result_tab to Result_line. write:/ ' Key: ', Result_line-key, ' Value: ', Result_line-value. ENdloop.   

Java implementations resemble:

public static void Main (string[] args) {try {class.forname ("Com.sap.db.jdbc.d                    River ");              System.out.println ("Create a Connection ..."); Con = (com.sap.db.jdbc.trace.Connection) drivermanager. getconnection ("Jdbc:sap://

Console print Result: Data can be successfully read from the Hana database through JDBC.

To get more original Jerry's technical articles, please follow the public number "Wang Zixi" or scan the QR code below:

Using ABAP (ADBC) and Java (JDBC) to connect to the SAP HANA database