sreguna

I see that Windows support is also available through the ConnectEx API. https://learn.microsoft.com/en-us/windows/win32/api/Mswsock/nc-mswsock-lpfn_connectex TCP_FASTOPEN can be enabled on the socket. https://learn.microsoft.com/en-us/windows/win32/winsock/ipproto-tcp-socket-options

Though this works in thick mode, Easy Connect entries in tnsnames.ora is not a documented feature. We will look into adding this support for thin mode.

@boriborm setTimeout may timeout idle but valid connections. I think the correct solution would be a combination of expireTime and callTimeout (https://node-oracledb.readthedocs.io/en/latest/api_manual/connection.html#connection.callTimeout) expireTime would timeout idle connections in the pool...

Hi @mikewang333, Some more details will help us evaluate the request. 1. Will the file content for ewallet.pem and tnsnames.ora ultimately come from user input or an environment variable to...

@flash4174 instead of (enable=broken) which uses system defaults can you use (expire_time=n) under the DESCRIPTION section of the connect string. The value(n) is in minutes.

If possible can you uninstall openldap and run the application? Oracle client libraries come bundled with its own ldap library and there could be some interference with openldap. Could be...

This could be due to a firewall dropping idle connections. Can you set [expireTime](https://node-oracledb.readthedocs.io/en/latest/api_manual/oracledb.html#getconnectiondbattrsexpiretime) to 1 and check?

Please also consider setting the [pooPingTimeout](https://node-oracledb.readthedocs.io/en/latest/api_manual/pool.html#pool.poolPingTimeout) parameter. The default is 5000 msecs. You may want to set it to a lower value. Depending on the number of open connections in...

@shubsaini09 poolPingTimeout will be used when trying to get a connection from the pool using getConnection(). Internally a healthy check(ping) is done if the connection has been idle for more...

@singhlaanshul87 Does this also happen with thick mode? Can you please share the output after setting the environment variable NODE_ORACLEDB_DEBUG_PACKETS to 1(or any value).