This repo contains two test scripts that reproduce an issue I started experiencing with the node-oracledb driver beginning with version 6.0.0. When attempting to retrieve data from a BLOB on a queue message payload, an exception is encountered in the node-oracledb code that prevents the data from loading. This example shows how the same code worked previously on 5.5.0.
Tested using Node.js 18.16.0 on Windows 11 against an Oracle 19c database.
To set up the environment, run the following scripts in the db folder (in order):
create-schema.sql(run this assysdbato create theblob_issueschema used for this test)create-objects.sql- Creates the supporting objects/types/queuescreate-proc.sql- Create theupload_testprocedure used to send messages to the queue.
Next, run npm install in the 5.5.0 directory, and then again in the 6.0.1 directory.
From the root directory of the repo run: CONNECT_STRING="customer_db/test" node ./5.5.0/index.js to start the queue listener test using v5.5.0 of the node-oracledb driver. Replace customer_db/test with a valid connection string for your database.
After the listener is running, from SQL developer or SQL Plus you will then need to run the db/send_msg.sql script to send a test message to the queue.
You should get output similar to this:
nicholas on work-desktop in /c/git/blob-issue
$ CONNECT_STRING="customer_db/test" node ./5.5.0/index.js
testing with node-oracledb 5.5.0
--------------------------------
waiting for a message...
SUCCESS {
filename: 'test-file.png',
filesize: 101,
mimetype: 'image/png',
data: <Buffer 89 50 4e 47 0d 0a 1a 0a 00 00 00 0d 49 48 44 52 00 00 00 20 00 00 00 20 08 06 00 00 00 73 7a 7a f4 00 00 00 2c 49 44 41 54 78 da ed ce 31 01 00 00 0c ... 51 more bytes>,
orderid: null,
shipid: null,
nameid: 'TESTUSER',
session_id: '1809306'
}
--------------------------------
completedRepeat with the v6.0.1 test CONNECT_STRING="customer_db/test" node ./6.0.1/index.js:
nicholas on work-desktop in /c/git/blob-issue
$ CONNECT_STRING="customer_db/test" node ./6.0.1/index.js
testing with node-oracledb 6.0.1
--------------------------------
waiting for a message...
ERROR: Could not retrieve upload payload data {
name: 'TypeError',
message: "Cannot read properties of undefined (reading '_parentObj')",
cause: undefined,
stack: "TypeError: Cannot read properties of undefined (reading '_parentObj')\n" +
' at LobImpl._getConnImpl (C:\\git\\blob-issue\\6.0.1\\node_modules\\oracledb\\lib\\impl\\lob.js:43:29)\n' +
' at Lob.<anonymous> (C:\\git\\blob-issue\\6.0.1\\node_modules\\oracledb\\lib\\util.js:154:29)\n' +
' at Lob.<anonymous> (C:\\git\\blob-issue\\6.0.1\\node_modules\\oracledb\\lib\\util.js:176:25)\n' +
' at Lob.wrapper (C:\\git\\blob-issue\\6.0.1\\node_modules\\oracledb\\lib\\util.js:123:19)\n' +
' at main (C:\\git\\blob-issue\\6.0.1\\index.js:42:31)'
}
--------------------------------
completedThe BLOB payload in the send_msg.sql script is just a 32x32 pixel PNG file.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent