Skip to main content

Search

Welcome to Tibero GTS!

Nodejs Integration Example Query

Document Type | Technical Information

Category | Interface/Integration

Applicable Product Version | 6FS07PS, 7FS02PS

Document Number | TIITI006

 

Overview

This guides queries and CRUD examples for integrating Tibero with Node.js based on ODBC installation. 
 
 
 

Method

Tibero can be integrated with Node.js through ODBC, and you can use two types of connection strings: DSN method and Driver method.
 
Below is example code that executes basic CRUD (Create, Read, Update, Delete) queries after connection setup.
const odbc = require('odbc');

async function connectToDatabase() {


   const connectionString1 = 'dsn=tibero7_odbc' //odbc dsn
   const connectionString2 = 'driver=Tibero 7 ODBC Driver;server=[Server IP];port=[DB port];database=[DB sid];user=[Login user];password=[User password]' //odbc driver and connection info


   odbc.connect([connectionString], (error, connection) => {
       if(error){
           console.log(error)
       }else{
           console.log('Connection Success'); 
           connection.query('SELECT SYSDATE FROM DUAL', (error, result) => {
               if (error) { console.error(error) 
               }else{
                   console.log(result[0].SYSDATE);
               }
           });


       // CREATE statement	
       connection.query('CREATE TABLE TIBERO.TEST (C1 NUMBER(10))', (error, result) => {
           if (error) { console.error(error) 
           }else{
               console.log('DDL Success');
           }
       });
       
       // INSERT statement	
       connection.query('INSERT INTO TIBERO.TEST VALUES (1)', (error, result) => {
           if (error) { console.error(error) 
           }else{
               console.log('DML Success');
           }
       });
       
       // SELECT statement	
       connection.query('SELECT * FROM TIBERO.TEST', (error, result) => {
           if (error) { console.error(error) 
           }else{
               console.log('C1: ' + result[0].C1);
           }
       });
       
       // UPDATE statement
        connection.query('UPDATE TIBERO.TEST SET C1 = 2 WHERE C1 = 1', (error, result) => {
            if (error) {
                console.error(error);
            } else {
                console.log('DML Success (UPDATE)');
            }
        });

        // DELETE statement
        connection.query('DELETE FROM TIBERO.TEST WHERE C1 = 2', (error, result) => {
            if (error) {
                console.error(error);
            } else {
                console.log('DML Success (DELETE)');
            }
        });
        
        connection.commit;
   }

   });
}


connectToDatabase();

 

 

 

 

 

Related to