0

Can someone share the sample code in nodejs for connection pool using hana-client lib module,I am trying to resuse the same in multiple services in a rest api based app Thanks Arun

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
Arunkumar KP
  • 11
  • 2
  • How about SAP's [official documents](https://help.sap.com/viewer/f1b440ded6144a54ada97ff95dac7adf/2.7/en-US/e252ff9b2cb44dd9925901e39025ce77.html) on this? – astentx Feb 27 '21 at 20:47
  • 1
    I went through this, but whenever i create a client and call the connect with pooling true and the mxaPool parameter set to 10, it only opens up one connection for all the client.exc(),even if i call the same from multiple routes from node express app.Reference used https://help.sap.com/viewer/f1b440ded6144a54ada97ff95dac7adf/2.7/en-US/4fe9978ebac44f35b9369ef5a4a26f4c.html – Arunkumar KP Feb 28 '21 at 04:27
  • But this is exactly what pooling is intended for. It will open new connection only when theres no more available connections in the pool. – astentx Feb 28 '21 at 09:10
  • 1
    I mean, its not adding any new connections other than the one opened up at connect method.I can see the queries are just queued up and getting executed sequently through the same connection. – Arunkumar KP Feb 28 '21 at 17:44
  • Any update on this? I am facing the same issue. – Ondrej11 Jan 24 '23 at 16:05
  • If anybody still can't make it work I have posted my solution here: https://stackoverflow.com/a/75231752/4587136 – Ondrej11 Jan 25 '23 at 09:18

0 Answers0