node-oracledb/test
Sharad Chandran R e1a3e09c67 Final commits for 6.6 release 2024-07-25 12:16:41 +05:30
..
opts Test case updates for the latest features 2024-07-23 17:07:14 +05:30
.editorconfig Add test editorconfig 2016-05-16 09:35:54 +10:00
README.md Test case updates for 6.5.1 2024-05-22 16:26:52 +05:30
accessPropertiesOnClosedObjects.js Refactor and add tests 2023-02-21 15:04:16 +11:00
aq1.js More test cases to increase the test coverage 2024-06-09 18:05:26 +05:30
aq2.js More test cases to increase the test coverage 2024-06-09 18:05:26 +05:30
aq3.js More test cases to increase the test coverage 2024-06-09 18:05:26 +05:30
aq4.js More test cases to increase the test coverage 2024-06-09 18:05:26 +05:30
aq5.js More test cases to increase the test coverage 2024-06-09 18:05:26 +05:30
aq6.js More test cases to increase the test coverage 2024-06-09 18:05:26 +05:30
aq7.js More test cases to increase the test coverage 2024-06-09 18:05:26 +05:30
aq8.js More test cases to increase the test coverage 2024-06-09 18:05:26 +05:30
aq9.js More test cases to increase the test coverage 2024-06-09 18:05:26 +05:30
aq10.js More test cases to increase the test coverage 2024-06-09 18:05:26 +05:30
aq11.js More test cases to increase the test coverage 2024-06-09 18:05:26 +05:30
asyncStack.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
autoCommit.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
autoCommit4nestedExecutes.js Thin mode support and new examples 2023-05-23 19:50:06 +05:30
autoCommitForSelect.js Minor code refactoring 2023-08-17 13:41:49 +05:30
bigInt.js Documentation and test case updates for recent enhancements 2024-05-02 21:38:29 +05:30
bindTimestamp.js Update Timestamp tests for daylight savings adjustment 2024-03-11 12:33:34 +05:30
binding.js Fixed issue which throws an error, when the same SELECT SQL statement is run for the second time with a different bind type. (Issue #1669) 2024-05-22 16:07:30 +05:30
binding_DMLInsert.js Minor code refactoring 2023-08-17 13:41:49 +05:30
binding_DMLReturningInto.js Modify test cases to ensure they do not run in unsupported DB versions 2023-10-12 20:44:17 +05:30
binding_buffer_string.js More refactoring and test file changes 2023-03-14 12:37:21 +05:30
binding_defaultBindIn.js Minor code refactoring 2023-08-17 13:41:49 +05:30
binding_defaultBindInout.js Complete update of documentation, test cases and other non-code files for 6.5 release 2024-05-02 22:03:06 +05:30
binding_functionBindIn.js Minor code refactoring 2023-08-17 13:41:49 +05:30
binding_functionBindInout.js More refactoring and test file changes 2023-03-14 12:37:21 +05:30
binding_functionBindOut.js Minor code refactoring 2023-08-17 13:41:49 +05:30
binding_procedureBindIn.js Minor code refactoring 2023-08-17 13:41:49 +05:30
binding_procedureBindInout.js Minor code refactoring 2023-08-17 13:41:49 +05:30
binding_procedureBindOut.js Minor code refactoring 2023-08-17 13:41:49 +05:30
blobDMLBindAsBuffer.js Update a few test cases and move to 6.5.1 dev 2024-05-10 15:59:33 +05:30
blobDMLReturningMultipleRowsAsBuffer.js Minor code refactoring 2023-08-17 13:41:49 +05:30
blobDMLReturningMultipleRowsAsStream.js Minor code refactoring 2023-08-17 13:41:49 +05:30
blobPlsqlBindAsBuffer_bindin.js Minor code refactoring 2023-08-17 13:41:49 +05:30
blobPlsqlBindAsBuffer_bindinout.js Minor code refactoring 2023-08-17 13:41:49 +05:30
blobPlsqlBindAsBuffer_bindout.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
blobStream.js More test refactoring 2023-03-14 12:04:05 +05:30
booleanBind.js Modify test cases to ensure they do not run in unsupported DB versions 2023-10-12 20:44:17 +05:30
callTimeout.js More test and documentation updates for Oracle Database 23ai 2024-05-02 21:59:03 +05:30
changePassword.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
clobDMLBindAsString.js Update a few test cases and move to 6.5.1 dev 2024-05-10 15:59:33 +05:30
clobDMLReturningMultipleRowsAsStream.js More test refactoring 2023-03-14 12:04:05 +05:30
clobDMLReturningMultipleRowsAsString.js More test refactoring 2023-03-14 12:04:05 +05:30
clobPlsqlBindAsString_bindin.js Add/Update Test files 2023-05-03 19:20:20 +05:30
clobPlsqlBindAsString_bindinout.js Add/Update Test files 2023-05-03 19:20:20 +05:30
clobPlsqlBindAsString_bindout.js Added new env variable and automatic AQ table and queue for examples and test updates 2023-10-31 10:05:56 +05:30
clobPlsqlString.js Minor code refactoring 2023-08-17 13:41:49 +05:30
clobStream.js Refactor tests 2023-02-21 17:53:18 +11:00
clobexample.txt Update URL to reflect changed OTN hierarchy 2015-11-15 08:28:11 +11:00
columnMetadata.js Remove intermittent errors while fetching Large CLOBs 2024-03-11 12:39:35 +05:30
connClose.js Add support for vector datatype with test case and formatting updates 2024-03-11 12:22:40 +05:30
connHealthy.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
connProps.js Update documentation for the latest features and minor updates in the connection properties for edge cases 2023-10-30 20:43:49 +05:30
connection.js Test case updates for 6.5.1 2024-05-22 16:26:52 +05:30
connectionClass.js Prefer forcing pools closed immediately 2023-02-21 17:53:18 +11:00
constants.js Add DB_TYPE_XMLTYPE for XMLTYPE db column 2023-12-05 16:00:31 +05:30
currentSchema.js Documentation and Test case updates for the latest code changes 2023-09-22 16:16:39 +05:30
dataTypeAssist.js Fix a bug in Thick mode which inserted invalid value if an unacceptable out of bound number is given (Issue #1659) 2024-04-20 11:41:16 +05:30
dataTypeBinaryDouble.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeBinaryFloat.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeBlob.js Enhanced lob.getData() method to accept offset and amount arguments (Issue #1643) 2024-03-11 17:19:45 +05:30
dataTypeChar.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
dataTypeClob.js Enhanced lob.getData() method to accept offset and amount arguments (Issue #1643) 2024-03-11 17:19:45 +05:30
dataTypeDate.js Minor test case fix for 12.1 Date datatype 2023-12-21 11:49:45 +05:30
dataTypeFloat.js Test files refactored 2023-03-14 12:03:48 +05:30
dataTypeFloat2.js Test files refactored 2023-03-14 12:03:48 +05:30
dataTypeJson.js Minor optimization for binary vectors 2024-07-23 17:04:07 +05:30
dataTypeLong.js Refactor and add tests 2023-02-21 17:53:18 +11:00
dataTypeLongRaw.js Add/Update Test files 2023-05-03 19:20:20 +05:30
dataTypeNchar.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeNclob.js Enhanced lob.getData() method to accept offset and amount arguments (Issue #1643) 2024-03-11 17:19:45 +05:30
dataTypeNumber.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
dataTypeNumber2.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeNvarchar2.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeRaw.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
dataTypeRowid.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeTimestamp1.js Documentation, Test and Example updates for 6.6 release 2024-06-21 17:36:23 +05:30
dataTypeTimestamp2.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeTimestamp3.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeTimestamp4.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeTimestamp5.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeTimestamp6.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeUrowid.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeVarchar2.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dataTypeVector1.js Final commits for 6.6 release 2024-07-25 12:16:41 +05:30
dataTypeVector2.js Improve test cases and update to 6.6.0-dev 2024-06-20 12:31:27 +05:30
dataTypeVector3.js Add code and test changes for the upcoming Oracle Database 23ai release 2024-05-02 21:56:12 +05:30
dataTypeVector4.js Improve test cases and update to 6.6.0-dev 2024-06-20 12:31:27 +05:30
dataTypeVector5.js Test case updates for the latest features 2024-07-23 17:07:14 +05:30
dataTypeXML.js Documentation and test updates 2024-05-22 16:05:11 +05:30
dbObject1.js Add support to fetch XML as a String in Thin mode 2023-12-05 16:06:50 +05:30
dbObject2.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
dbObject3.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
dbObject4.js Test and Documentation updates for 6.3 features 2023-12-21 10:46:36 +05:30
dbObject5.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
dbObject6.js Modify test cases to ensure they do not run in unsupported DB versions 2023-10-12 20:44:17 +05:30
dbObject7.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dbObject8.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
dbObject9.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dbObject10.js Add DB Support objects and Pipelined Table tests 2023-05-23 21:31:55 +05:30
dbObject11.js Add DB Support objects and Pipelined Table tests 2023-05-23 21:31:55 +05:30
dbObject12.js Fixed bug in reading PLS_INTEGER type when used in PL/SQL records 2024-01-30 16:40:22 +05:30
dbObject13.js Fix for GitHub Issue #1616 2023-11-09 17:29:24 +05:30
dbObject14.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
dbObject15.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dbObject16.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
dbObject17.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
dbObject18.js Test case updates 2024-05-09 15:15:23 +05:30
dbObject19.js Add DB Support objects and Pipelined Table tests 2023-05-23 21:31:55 +05:30
dbObject20.js Added capability to read XMLType data in DbObject in Thin mode 2024-06-20 12:34:38 +05:30
dbObjectOutBind.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dbObjectsNestedTable.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
dbSchema.js Added new env variable and automatic AQ table and queue for examples and test updates 2023-10-31 10:05:56 +05:30
dbType01.js More example and test updates 2023-06-05 18:14:13 +05:30
dbType02.js Refactor and add tests 2023-02-21 15:04:16 +11:00
dbType03.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dbType04.js Add code and test changes for the upcoming Oracle Database 23ai release 2024-05-02 21:56:12 +05:30
dbconfig.js Test case updates for 6.5.1 2024-05-22 16:26:52 +05:30
devnull.js Refactor tests 2023-02-21 17:53:18 +11:00
dmlReturning.js Fixed issue which throws an error, when the same SELECT SQL statement is run for the second time with a different bind type. (Issue #1669) 2024-05-22 16:07:30 +05:30
driverName.js Thin mode support and new examples 2023-05-23 19:50:06 +05:30
dupColNames1.js Minor code refactoring 2023-08-17 13:41:49 +05:30
dupColNames2.js Minor code refactoring 2023-08-17 13:41:49 +05:30
editionTest.js Documentation, Test and Example updates for 6.6 release 2024-06-21 17:36:23 +05:30
embedded_oid.js Final set of test and document updates for all the new features 2024-03-11 19:11:33 +05:30
end2endTracing.js Minor code refactoring 2023-08-17 13:41:49 +05:30
errorOffset.js Refactor and add tests 2023-02-21 15:04:16 +11:00
errorUrl.js Update and add new test cases 2023-09-15 13:56:42 +05:30
examineOwnedProperties.js Test case updates 2024-05-09 15:15:23 +05:30
examples.js Create a flag oldJsonColumnAsObj inside a new future object for ensuring backward compatibility before converting the IS JSON type column values to JSON object 2023-12-05 16:03:57 +05:30
executeMany1.js Optimization with PL/SQL usage in executeMany with Implicit Connection Pooling 2024-04-18 18:12:18 +05:30
executeMany2.js Refactor and add tests 2023-02-21 15:04:16 +11:00
executeQueue.js Minor code refactoring 2023-08-17 13:41:49 +05:30
externalAuth.js Allow non null username for external proxy authentication and non-token authentication - Issue #1628 2023-12-19 16:38:11 +05:30
externalProxyAuth.js Allow non null username for external proxy authentication and non-token authentication - Issue #1628 2023-12-19 16:38:11 +05:30
fetchArraySize1.js Minor code refactoring 2023-08-17 13:41:49 +05:30
fetchArraySize2.js Minor code refactoring 2023-08-17 13:41:49 +05:30
fetchArraySize3.js Test case updates 2024-05-09 15:15:23 +05:30
fetchArraySize4.js Minor code refactoring 2023-08-17 13:41:49 +05:30
fetchArraySize5.js Minor code refactoring 2023-08-17 13:41:49 +05:30
fetchArraySize6.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
fetchArraySize7.js Minor code refactoring 2023-08-17 13:41:49 +05:30
fetchArraySize8.js Minor code refactoring 2023-08-17 13:41:49 +05:30
fetchArraySize9.js Minor code refactoring 2023-08-17 13:41:49 +05:30
fetchAs.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
fetchAsStringWithRefCursor.js Minor code refactoring 2023-08-17 13:41:49 +05:30
fetchBinaryTypesAsString.js Minor code refactoring 2023-08-17 13:41:49 +05:30
fetchBlobAsBuffer1.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
fetchBlobAsBuffer2.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
fetchBlobAsBuffer3.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
fetchBlobAsBuffer4.js Minor code refactoring 2023-08-17 13:41:49 +05:30
fetchClobAsString1.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
fetchClobAsString2.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
fetchClobAsString3.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
fetchClobAsString4.js Minor code refactoring 2023-08-17 13:41:49 +05:30
fetchLobAsStrBuf.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
fetchNClobAsString.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
fetchRawAsString.js Refactor tests 2023-02-21 14:53:53 +11:00
fetchRowidAsString.js Refactor tests 2023-02-21 14:53:53 +11:00
fetchTimestampAsString.js Thin mode support and new examples 2023-05-23 19:50:06 +05:30
fetchTypeHandler.js Create a flag oldJsonColumnAsObj inside a new future object for ensuring backward compatibility before converting the IS JSON type column values to JSON object 2023-12-05 16:03:57 +05:30
fetchUrowidAsString.js Added support for usage with extension of Array.prototype methods(Issue #1653) 2024-05-02 21:16:06 +05:30
fetchUrowidAsString_indexed.js Minor code refactoring 2023-08-17 13:41:49 +05:30
fuzzydinosaur.jpg Update tests for new functionality 2015-08-17 16:19:36 +10:00
getDataOfLob.js Minor code refactoring 2023-08-17 13:41:49 +05:30
getStmtInfo.js Minor Test case updates 2024-02-05 15:33:09 +05:30
hooks.js Minor code refactoring 2023-08-17 13:41:49 +05:30
implicitResults.js Documentation and Test updates for the latest changes and feature additions 2024-03-11 16:56:28 +05:30
indexedTables01.js Minor code refactoring 2023-08-17 13:41:49 +05:30
insertAll.js Minor code refactoring 2023-08-17 13:41:49 +05:30
insertNaNToNumber.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
instanceof1.js Test case cleanup and documentation update for the JsonId class 2024-05-02 21:21:47 +05:30
invalidNumber.js Fixed exponent check condition for out-of-bounds number(Issue #1659) 2024-05-10 13:28:34 +05:30
jsObjectGetter1.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
jsObjectGetter2.js Minor code refactoring 2023-08-17 13:41:49 +05:30
jsonBind1.js Create a flag oldJsonColumnAsObj inside a new future object for ensuring backward compatibility before converting the IS JSON type column values to JSON object 2023-12-05 16:03:57 +05:30
jsonBind2.js Create a flag oldJsonColumnAsObj inside a new future object for ensuring backward compatibility before converting the IS JSON type column values to JSON object 2023-12-05 16:03:57 +05:30
jsonDualityViews1.js Documentation, Test and Example updates for 6.6 release 2024-06-21 17:36:23 +05:30
jsonDualityViews2.js Documentation, Test and Example updates for 6.6 release 2024-06-21 17:36:23 +05:30
jsonDualityViews3.js Improve test cases and update to 6.6.0-dev 2024-06-20 12:31:27 +05:30
jsonDualityViews4.js Improve test cases and update to 6.6.0-dev 2024-06-20 12:31:27 +05:30
jsonDualityViews5.js Improve test cases and update to 6.6.0-dev 2024-06-20 12:31:27 +05:30
jsonDualityViews6.js Improve test cases and update to 6.6.0-dev 2024-06-20 12:31:27 +05:30
jsonDualityViews7.js Improve test cases and update to 6.6.0-dev 2024-06-20 12:31:27 +05:30
keepInStmtCache.js Test case updates for 6.5.1 2024-05-22 16:26:52 +05:30
lastRowid.js Minor code refactoring 2023-08-17 13:41:49 +05:30
list.txt Test case updates for the latest features 2024-07-23 17:07:14 +05:30
listIndexes.js Tighten test cases and examples 2024-07-15 12:14:40 +05:30
lobBind1.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
lobBind2.js Fixed bug that throws the NJS-111 internal error, on the second SELECT call issued after the first SELECT call on an empty table with LOBs 2023-07-06 13:10:16 +05:30
lobBindAsStringBuffer.js Add/Update Test files 2023-05-03 19:20:20 +05:30
lobClose.js Throw NJS-003 error instead of NJS-108 when attempting a LOB operation on a closed connection 2024-03-11 12:35:53 +05:30
lobProperties1.js Refactor tests 2023-02-21 14:27:04 +11:00
lobProperties2.js Refactor tests 2023-02-21 14:27:04 +11:00
lobResultSet.js More refactoring and test file changes 2023-05-03 16:02:09 +05:30
longDMLBind.js Fix test refactor merges 2023-02-21 18:02:10 +11:00
longProcedureBind_in.js More test refactoring 2023-03-14 12:04:05 +05:30
longProcedureBind_inout.js Fix test refactor merges 2023-02-21 18:02:10 +11:00
longProcedureBind_out.js More test refactoring 2023-03-14 12:04:05 +05:30
longrawDMLBind.js More refactoring and test file changes 2023-05-03 16:02:09 +05:30
longrawProcedureBind_in.js More refactoring and test file changes 2023-03-14 12:37:21 +05:30
longrawProcedureBind_inout.js Minor code refactoring 2023-08-17 13:41:49 +05:30
longrawProcedureBind_out.js More refactoring and test file changes 2023-03-14 12:37:21 +05:30
maxRows.js Minor code refactoring 2023-08-17 13:41:49 +05:30
methodName.js Re-license as dual Apache 2.0 or UPL 1.0 2023-02-21 12:43:43 +11:00
multipleLobInsertion.js Minor code refactoring 2023-08-17 13:41:49 +05:30
nclobDMLBindAsString.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
nestedCursor01.js Refactor and add tests 2023-02-21 15:04:16 +11:00
nestedCursor02.js Minor code refactoring 2023-08-17 13:41:49 +05:30
nestedCursor03.js Refactor and add tests 2023-02-21 15:04:16 +11:00
nestedCursor04.js More refactoring and test file changes 2023-05-03 16:02:09 +05:30
nestedCursor05.js Minor Test case updates 2024-02-05 15:33:09 +05:30
nullColumnValues.js More test and documentation updates for Oracle Database 23ai 2024-05-02 21:59:03 +05:30
optimisticLock.js Final commits for 6.6 release 2024-07-25 12:16:41 +05:30
passwordExpiryWarning.js Complete update of documentation, test cases and other non-code files for 6.5 release 2024-05-02 22:03:06 +05:30
pipelinedTables.js Added new env variable and automatic AQ table and queue for examples and test updates 2023-10-31 10:05:56 +05:30
plsqlBindCursorsIN.js Fixed issue which throws an error, when the same SELECT SQL statement is run for the second time with a different bind type. (Issue #1669) 2024-05-22 16:07:30 +05:30
plsqlBindIndexedTable1.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
plsqlBindIndexedTable2.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
plsqlBindList.js Add/Update Test files 2023-05-03 19:20:20 +05:30
plsqlBindScalar.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
plsqlRowtype.js Fixed bug which throws an NJS-130 error when fetching a DbObjectClass with an object type name containing %ROWTYPE 2024-06-20 12:29:56 +05:30
plsqlWarnings.js Added SUCCESS_WITH_INFO support for PL/SQL functions used in executeMany() 2024-01-30 16:24:24 +05:30
pool.js Fixed bug which threw an error when a pool is created with SYSDBA privilege (Issue #1657) 2024-05-22 16:10:59 +05:30
poolCache.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
poolClose.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
poolDrain.js Throw NJS-003 error instead of NJS-108 when attempting a LOB operation on a closed connection 2024-03-11 12:35:53 +05:30
poolExpansion.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
poolPing.js Added poolPingTimeout parameter to connection pool and global configuration (Issue #1626) 2024-01-30 16:37:37 +05:30
poolReconfigure.js Pool reconfiguration support in Thin mode 2024-05-02 21:39:25 +05:30
poolShrinkage.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
poolTimeout.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
prefetchRows.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
procAndFuncs.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
properties.js Added poolPingTimeout parameter to connection pool and global configuration (Issue #1626) 2024-01-30 16:37:37 +05:30
random.js Test case updates 2024-05-09 15:15:23 +05:30
resultSet1.js Documentation and Test updates for the latest changes and feature additions 2024-03-11 16:56:28 +05:30
resultSet2.js Test case updates for 6.5.1 2024-05-22 16:26:52 +05:30
resultSetClose.js Minor code refactoring 2023-08-17 13:41:49 +05:30
resultsetToStream.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
rowidDMLBindAsString.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
rowidFunctionBindAsString_bind.js More test refactoring 2023-03-14 12:04:05 +05:30
rowidFunctionBindAsString_bindinout.js More test refactoring 2023-03-14 12:04:05 +05:30
rowidProcedureBindAsString_bindin.js Thin mode support and new examples 2023-05-23 19:50:06 +05:30
rowidProcedureBindAsString_bindinout.js More test refactoring 2023-03-14 12:04:05 +05:30
rowidProcedureBindAsString_bindout.js More test refactoring 2023-03-14 12:04:05 +05:30
rsGetAllRows1.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
rsGetAllRows2.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
runCQN.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
sessionTag.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
soda1.js More test and documentation updates for Oracle Database 23ai 2024-05-02 21:59:03 +05:30
soda2.js More refactoring and test file changes 2023-05-03 16:02:09 +05:30
soda3.js Minor code refactoring 2023-08-17 13:41:49 +05:30
soda4.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
soda5.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
soda6.js Test case updates for SODA in Oracle Database 23c 2023-08-17 16:58:23 +05:30
soda7.js More test and documentation updates for Oracle Database 23ai 2024-05-02 21:59:03 +05:30
soda8.js More test and documentation updates for Oracle Database 23ai 2024-05-02 21:59:03 +05:30
soda9.js Test case updates for SODA in Oracle Database 23c 2023-08-17 16:58:23 +05:30
soda10.js Test case updates for SODA in Oracle Database 23c 2023-08-17 16:58:23 +05:30
soda11.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
soda12.js Minor code refactoring 2023-08-17 13:41:49 +05:30
soda13.js Minor code refactoring 2023-08-17 13:41:49 +05:30
soda14.js Minor code refactoring 2023-08-17 13:41:49 +05:30
sodaInstanceof.js Minor code refactoring 2023-08-17 13:41:49 +05:30
sodaMetaDataCache.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
sodaOpLock.js Update a few test cases and move to 6.5.1 dev 2024-05-10 15:59:33 +05:30
sodaOverwrite.js Minor code refactoring 2023-08-17 13:41:49 +05:30
sodaUtil.js Minor code refactoring 2023-08-17 13:41:49 +05:30
sodahint.js Test case updates for SODA in Oracle Database 23c 2023-08-17 16:58:23 +05:30
sql.js More refactoring and test file changes 2023-03-14 12:37:21 +05:30
sqlParser.js Copyright updates, documentation and test case additions 2024-03-11 12:46:16 +05:30
sqlWithWarnings.js Initial test and documentation updates 2024-01-03 11:59:40 +05:30
stream1.js Minor code refactoring 2023-08-17 13:41:49 +05:30
stream2.js Minor code refactoring 2023-08-17 13:41:49 +05:30
streamErrorEvent.js Minor code refactoring 2023-08-17 13:41:49 +05:30
testsUtil.js Add support for binary vector (Oracle Database 23ai feature) and eslint fixes in code 2024-07-15 13:05:18 +05:30
tpc.js Test case updates for the latest features 2024-07-23 17:07:14 +05:30
tpcResume.js Optimize test cases 2023-05-24 00:14:20 +05:30
tree.jpg Sync tests and fix missed merges 2017-06-14 11:54:45 +10:00
uninitializedLob.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
urowidDMLBindAsString1.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
urowidDMLBindAsString2.js Final commits for 6.6 release 2024-07-25 12:16:41 +05:30
urowidFunctionBindAsString1.js More test refactoring 2023-03-14 12:04:05 +05:30
urowidFunctionBindAsString2.js More test refactoring 2023-03-14 12:04:05 +05:30
urowidFunctionBindAsString3.js Minor code refactoring 2023-08-17 19:27:09 +05:30
urowidFunctionBindAsString4.js Minor code refactoring 2023-08-17 19:27:09 +05:30
urowidProcedureBindAsString1.js Thin mode support and new examples 2023-05-23 19:50:06 +05:30
urowidProcedureBindAsString2.js More test refactoring 2023-03-14 12:04:05 +05:30
urowidProcedureBindAsString3.js More test refactoring 2023-03-14 12:04:05 +05:30
urowidProcedureBindAsString4.js Minor code refactoring 2023-08-17 19:27:09 +05:30
urowidProcedureBindAsString5.js Minor code refactoring 2023-08-17 19:27:09 +05:30
urowidProcedureBindAsString6.js Minor code refactoring 2023-08-17 19:27:09 +05:30
userName.js Update eslint config and files to follow space after colon rule with object properties 2023-10-30 20:17:16 +05:30
writableProperties1.js Prefer forcing pools closed immediately 2023-02-21 17:53:18 +11:00

README.md

Test node-oracledb

This software is dual-licensed to you under the Universal Permissive License (UPL) 1.0 as shown at https://oss.oracle.com/licenses/upl and Apache License 2.0 as shown at https://www.apache.org/licenses/LICENSE-2.0. You may choose either license.

If you elect to accept the software under the Apache License, Version 2.0, the following applies:

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

https://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Contents

  1. Preparations
  2. Run tests
  3. Enable tests that require extra configuration
  4. Contribute New Tests
  5. Troubleshoot

1. Preparations

See INSTALL for installation details.

On macOS, run a command like:

ln -s $HOME/Downloads/instantclient_19_8/libclntsh.dylib $(npm root)/oracledb/build/Release

Note: the test suite is on GitHub.

1.1 Create a working directory

mkdir <some-directory>
cd <some-directory>

1.2 Clone node-oracledb from GitHub

Clone the project repository:

cd <some-directory>
git clone https://github.com/oracle/node-oracledb.git

1.3 Build

cd <some-directory>/node-oracledb
npm install

Running npm install within the node-oracledb/ directory will recompile oracledb and install all its dependent modules. These are listed in the devDependencies field of package.json file. Thus, 'mocha', and 'eslint' modules are installed by this command.

The test suite uses mocha.

1.4 Configure Database credentials

Set the following environment variables to provide credentials for the test suite.

  • NODE_ORACLEDB_USER provides the username of the schema user which you used for testing. Use the parameter createUser specified in test/dbconfig.js to create a new user within the test suite. Test suite does create such users.

  • NODE_ORACLEDB_PASSWORD provides the password of the schema user which you used for testing. if you're generating a password for the user, use the predefined function testsUtil.generateRandomPassword.

  • NODE_ORACLEDB_CONNECTIONSTRING provides the connection string that points to your database's location.

  • NODE_ORACLEDB_EXTERNALAUTH provides the options for external authentication tests. Setting this environment variable to "true" will enable the tests that require external authentication. To ensure external authentication tests works, firstly make sure the Oracle external authentication service is correctly configured. See Documentation for External Authentication for details.

  • NODE_ORACLEDB_DBA_PRIVILEGE provides the options for DBA privilege. Setting this environment variable to "true" will enable the tests and utilities that require DBA privilege.

  • NODE_ORACLEDB_DBA_USER provides the username of the DBA user which you used for testing, disabled if NODE_ORACLEDB_DBA_PRIVILEGE is not true.

  • NODE_ORACLEDB_DBA_PASSWORD provides the password of the DBA user which you used for testing, disabled if NODE_ORACLEDB_DBA_PRIVILEGE is not true.

  • NODE_ORACLEDB_PROXY_SESSION_USER provides the username of a schema user that can connect through the schema user which you used for testing using proxy authentication. Setting this environment variable will enable the tests that require proxy authentication.

  • NODE_ORACLEDB_QA. This boolean environment variable serves as the toggle switch of certain tests. Some tests, such as callTimeout.js, use hard-coded variables as assertion condition. The test results may be inconsistent in different network situations.

  • NODE_ORACLEDB_DRCP provides an option for skipping the test run when DRCP is enabled. Setting this environment variable to true will skip certain test case runs due to DRCP restrictions.

  • NODE_ORACLEDB_IMPLICIT_POOL provides an option for skipping the test run when Implicit connection pooling is enabled. Setting this environment variable to true will skip certain test case runs due to Implicit connection pooling restrictions.

  • NODE_ORACLEDB_DRIVER_MODE provides an option to set the 'Thin' or 'Thick' modes of node-oracledb. Setting this environment variable to thick will enable Thick mode. Setting it to thin will retain the Thin mode. The default mode is Thin.

  • NODE_ORACLEDB_WALLET_LOCATION provides the local directory name for the wallets that may be required for mutual TLS (mTLS) connections, especially to Oracle Cloud Autonomous Databases optionally. The wallet location can also be provided as a part of the database connect string.

  • NODE_ORACLEDB_WALLET_PASSWORD provides the password for the wallets that may be required for mutual TLS (mTLS) connections, especially to Oracle Cloud Autonomous Databases.

  • NODE_ORACLEDB_CLIENT_LIB_DIR provides an optional path for the Oracle Client libraries to be used in Windows and macOS platforms, when using Thick mode in node-oracledb.

Note: the test suite requires the schema to have these privileges: CREATE TABLE, CREATE SESSION, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TRIGGER, and CREATE TYPE.

1.5 Set NODE_PATH

export NODE_PATH=<some-directory>/node-oracledb/lib

2. Run tests

See mochajs.org for more information on running tests with mocha.

2.1 Run the complete test suite

cd node-oracledb
npm test

2.2 Run specified tests

cd node_oracledb
./node_modules/.bin/mocha test/<test-names>

3. Enable tests that requires extra configuration

The following test(s) are automatically skipped if their required environment variable(s) are not properly set.

3.1 externalProxyAuth.js

This test aims to test the combined usage of external authentication and proxy authentication. To run this test, you need to complete the following prerequisite setups.

  • Enable external authentication on the schema user which you used for testing. See Documentation for External Authentication for more information on external authentication. Then use the following command to enable external authentication in the test suite.

    export NODE_ORACLEDB_EXTERNALAUTH true
    
    
  • Enable proxy authentication on another schema user specified by environment variable NODE_ORACLEDB_PROXY_SESSION_USER that connects through the schema user which you used for testing. See Documentation for Pool Proxy Authentication for more information on proxy authentication. Then use the following command to enable proxy authentication in the test suite.

    export NODE_ORACLEDB_PROXY_SESSION_USER "Your_Proxy_Authenticating_User"
    
    

3.2 SODA tests

To execute SODA tests, Oracle Database users require the SODA_APP role granted to them by a DBA. If SODA_APP is not granted, SODA tests will be skipped.

To grant the SODA_APP role to a Oracle Database user, typically a DBA would execute:

```
grant SODA_APP to <Oracle Database user>

```

4. Contribute New Tests

See CONTRIBUTING for general information on contribution requirements.

For easy correlation between results and test code, each test is assigned a number. The Test List shows the numbering of tests.

In order to include your tests in the suite, add each new test file name to test/opts/mocha.opts.

5. Troubleshoot

You may encounter some troubles when running the test suite. These troubles might be caused by the concurrency issue of Mocha framework, network latencies, or database server issues. This section gives some issues that we ever saw and our solutions.

5.1 ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

This error occurs when Node.js programs try to change database objects which hold locks. The workaround would be:

(1) Use unique DB object names for each test to avoid interference between test files. (2) Try not to use 'beforeEach' blocks for object operations to avoid the interference between cases.

5.2 ORA-00018: maximum number of sessions exceeded

This error occurs when the test suite takes up more sessions than the configured limit. You can alter the session limit on the database server side. If you do not have access to change the database session setting, you could use the below script to deliberately add an interval between tests.

arr=$(ls test/*js)
for case in ${arr[@]}
do
  var="$NODE_PATH/../node_modules/.bin/mocha --timeout 10000 $case"
  eval $var
  sleep 1
done

5.3 ORA-28865: SSL connection closed

You may encounter this error when the test suite sends more connection requests per second than the database is configured to handle.

There are two solutions:

  • Solution 1: Change database RATE_LIMIT configuration. This parameter defines the connection count allowed per second. See RATE_LIMIT for more information.

  • Solution 2: Set the RETRY_COUNT and RETRY_DELAY parameters in connectString.

For example, below is the connectString which could be defined in tnsnames.ora file.

dbaccess = (description=(RETRY_COUNT=20)(RETRY_DELAY=3)
          (address=(protocol=tcps)(port=1521)(host=<db-host>))
          (connect_data=(service_name=<service-name>))
          (security=(my_wallet_directory=<wallet-location>)(ssl_server_cert_dn=<ssl-server-cert-dn>))
       )

5.4 ORA-03114: not connected to ORACLE

We first encountered this error with test/callTimeout.js. It uses some hard-coded variables as assertion conditions, which may lead to assertion fails in slow networks.

The solution is to comment out the line sqlnet.recv_timeout=<minutes> from the sqlnet.ora file.