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();