When I try to connect to an Oracle database using Node.js in Visual Studio Code, I receive an error message like
const oracledb = require('oracledb');
async function run() {
const connection = await oracledb.getConnection({
user: "user_name",
password: "pwd",
connectString: "host:port/servicename",
sqlnetEncryptionServer: "REQUIRED",
sqlnetCryptoChecksumServer: "REQUIRED",
sqlnetEncryptionTypesServer: "(AES256,AES192,AES128)",
sqlnetCryptoChecksumTypesServer: "(SHA1)",
sqlnetEncryptionClient: "REQUIRED",
sqlnetCryptoChecksumClient: "REQUIRED",
sqlnetEncryptionTypesClient: "(AES256,AES192,AES128)",
sqlnetCryptoChecksumTypesClient: "(SHA1)"
});
const result = await connection.execute(`SELECT * FROM DUAL`);
console.log("Result is:", result.rows);
await connection.close();
}
run();
c:\Users\ASHWINI ANANDH\node_modules\oracledb\lib\thin\sqlnet\ntTcp.js:327
const newErr = errors.getErr(errors.ERR_CONNECTION_CLOSED);
^
Error: NJS-500: connection to the Oracle Database was broken
NJS-521: connection to host --- port 1521 received end-of-file on communication channel. (CONNECTION_ID=PZ7G55SOG3jtx/QkyoztWQ==)
at NTTCP.checkErr (c:\Users\ASHWINI ANANDH\node_modules\oracledb\lib\thin\sqlnet\ntTcp.js:327:29)
at NTTCP.receive (c:\Users\ASHWINI ANANDH\node_modules\oracledb\lib\thin\sqlnet\ntTcp.js:463:12)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async NetworkSession._recvPacket (c:\Users\ASHWINI ANANDH\node_modules\oracledb\lib\thin\sqlnet\networkSession.js:379:22)
at async NetworkSession.recvPacket (c:\Users\ASHWINI ANANDH\node_modules\oracledb\lib\thin\sqlnet\networkSession.js:444:12)
at async ReadPacket.waitForPackets (c:\Users\ASHWINI ANANDH\node_modules\oracledb\lib\thin\protocol\packet.js:294:20)
at async Protocol._decodeMessage (c:\Users\ASHWINI ANANDH\node_modules\oracledb\lib\thin\protocol\protocol.js:70:5)
at async Protocol._processMessage (c:\Users\ASHWINI ANANDH\node_modules\oracledb\lib\thin\protocol\protocol.js:153:9)
at async ThinConnectionImpl.connect (c:\Users\ASHWINI ANANDH\node_modules\oracledb\lib\thin\connection.js:710:9)
at async Object.getConnection (c:\Users\ASHWINI ANANDH\node_modules\oracledb\lib\oracledb.js:661:3) {
code: 'NJS-500'
}
Node.js v20.10.0
help me to solve this issue.Thankyou!!!