oracle / oracle/node-oracledb

Make autoCommit, maxRows, outFormat, etc. connection attributes rather than global properties

Open
#361 9 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement
Dominant language
JavaScript
Stars
2.4k
Forks
1.1k
PR merge metrics
No merged PRs in 30d

Description

This is enhancement request to make the various SQL execution properties such as autoCommit, maxRows, or outFormat attributes of a connection whether directly established or acquired from a pool, and not global constants on the oracledb object itself.

I maintain an internal library for our developers that wraps around node-oracledb to provide a variety of conveniences like multiple named Oracle connections from external config, promisification, etc. I have had to do a measurable amount of extra engineering to work around the fact that something like autoCommit is a global property rather than a connection specific one.

Off the top of my head, I think this per connection configurability could be something many developers might like to use and not just myself. If I recall right, the Java JDBC driver works in this way where these behaviors are per connection and not at the global driver level.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No files or tests are named. Start by tracing how connection and pool APIs currently expose autoCommit, maxRows, and outFormat, then compare direct and pooled connections. Done means these execution properties can be configured per connection rather than only as global oracledb properties, with behavior covered for both acquisition paths.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript, node.js
Domain
api, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.