How can I perfectly work with Oracle DB in my Node.js project

Question

I am currently working on a web site using Angular, Node.Js, express and an Oracle database.

I'm still not familiar with all this technologies and I'm doing my best! My problem is the Oracle database connection can't be exported. I searched about this and I think it's a promise thing. The only solution I found is to connect to the database every time I use a new SQL query which is impossible for me because the project is big.

Is there any method I can use to make the database connection in a separate file and export it when I need it?

if you are saying that you want to store the connection string or authentication details of your database yes you can do that easily. Use environment_variable. — Mohak Gupta
– Mohak Gupta, Commented Jun 2, 2021 at 23:14
i want to put all the connection config in one file .js then i just import the connection made and use it with execute function in other files. — Rebhi Khalil
– Rebhi Khalil, Commented Jun 3, 2021 at 15:38

Christopher Jones · Accepted Answer · 2021-06-04 07:11:33Z

3

With a multi-user app, you should use a connection pool. You open it at app start, and then access it as needed - you don't have to pass anything around.

If you open the connection pool in your initialization routine:

await oracledb.createPool({
  user: dbConfig.user,
  password: dbConfig.password,
  connectString: dbConfig.connectString
});
console.log('Connection pool started');

then any other module that needs a connection can simply do:

conn = await oracledb.getConnection();
result = await conn.execute(statement, binds, opts);
await conn.close();

Read up on connection pools and sizing and threads in the node-oracledb documentation on Connection Pooling.

Also see the series Build REST APIs for Node.js and its code https://github.com/oracle/oracle-db-examples/tree/master/javascript/rest-api. In particular, look at database.js.

edited Jun 4, 2021 at 7:11

answered Jun 4, 2021 at 0:20

Christopher Jones

11.1k7 gold badges32 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I perfectly work with Oracle DB in my Node.js project

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related