88. (NodeJs) [Mac Os] [Oracle] : oracledb 모듈 사용해 오라클 DB 기본 Connection 연결 수행

---

[개발 환경 설정]

​

개발 툴 : VS CODE

개발 언어 :NodeJs

 

---

[사전) 오라클 모듈 추가 방법]

​

https://blog.naver.com/kkh0977/223328207821

87. (NodeJs) [Mac Os] [Oracle] : oracledb 오라클 데이터베이스 모듈 의존성 추가 방법 설명 - npm install

 

---

[사전) 프로젝트 설정 방법]

​

​

 

---

[app.js : 소스 코드]

​

// ----------------------------------------------------------------------------------------------

// ---------------------------------------
// [모듈 추가]
// ---------------------------------------
const express = require('express')
const app = express()



// ---------------------------------------
// [모듈 추가]
// ---------------------------------------
app.set('view engine', 'ejs') // [Page] : [Render]
app.set('views', './views') // [Page] : [Render]



// ---------------------------------------
// [모듈 추가]
// ---------------------------------------
var bodyParser = require('body-parser'); // [body-parser 사용]

app.use(bodyParser.urlencoded({ extended: true }));
app.use(bodyParser.json());



// ---------------------------------------
// [모듈 추가]
// ---------------------------------------
var nocache = require('nocache'); // [nocache 사용]
app.use(nocache());



// ---------------------------------------
// [모듈 추가]
// ---------------------------------------
const oracledb = require('./db/db'); // [db >> oracle 사용]

// ----------------------------------------------------------------------------------------------

// [Get] : Path = [/] : http://localhost:3000/
app.get('/', function (req, res) {
    console.log("")
    console.log("==============================================================================")
    console.log("[Server] :: [App] :: [Path = /] :: [Start]")
    console.log("==============================================================================")
    console.log("")

    // [Web Return Response]
    res.send('Hello World !!');
})

// ----------------------------------------------------------------------------------------------

// [Server] : [Start]
//*
app.listen(3000, function () {
    console.log("")
    console.log("==============================================================================")
    console.log("[Server] :: [Port = 3000] :: [Start]")
    console.log("==============================================================================")
    console.log("")
})
// */

// ----------------------------------------------------------------------------------------------

 

---

[db.js : 소스 코드]

​

// ---------------------------------------
// [모듈 추가]
// ---------------------------------------
const oracledb = require('oracledb');
oracledb.outFormat = oracledb.OUT_FORMAT_OBJECT


// ---------------------------------------
// [DB 접속 정보]
// ---------------------------------------
const config = {
    user: "ADMIN",
    password: "ADMIN#5412",
    connectString: "105.78.166.115:1521/ORADB"
};


// ---------------------------------------
// [DB ConnectionPool]
// ---------------------------------------
const connection = oracledb.getConnection(config, function (err, conn) {
    if(err){
        console.log("")
        console.log("==============================================================================")
        console.log("[Database] :: [Connection] :: [Error]")
        console.log("--------------------------------------------------------------------------")
        console.log(err)
        console.log("==============================================================================")
        console.log("")
        return;
    }
    console.log("")
    console.log("==============================================================================")
    console.log("[Database] :: [Connection] :: [ORACLE]")
    console.log("==============================================================================")
    console.log("")
});

module.exports = oracledb

 

---

[결과 출력]

​

 

---