SQL30081N on IBM DB2 with Flex Plan

[akhilruhela]

While storing session in DB2 with a flex plan not a free one we are getting the below error if application is idle for some time.
I have gone through the Db2Store documentation and says that to cleanly close the connection use
sessionStore.close(function(error){
if(error){
// deal with it
return;
}
});

---

Error on Production:
ERR Error: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "...*". Communication function detecting the error: "send". Protocol specific error code(s): "32", "*", "0". SQLSTATE=08001
• Sep 3 02:27:32 cloudfoundry ***-**Prod ERR Error: CLI0600E Invalid connection handle or connection is closed. SQLSTATE=S1000

Here is my code snippet

let session = require('express-session');
var Db2Store = require('connect-db2')(session);
var options = {
host: process.env.DB_HOST,
port: 50001,
user: process.env.DB_USER,
password: process.env.DB_PASSWORD,
database: "BLUDB",
use_ssl: true

};
app.use(session({
resave: false, saveUninitialized: 'true', secret: 'you know nothing', store: sessionStore, cookie: {
secure: true
}
}));

[wallali]

Note: Comments on: #5

It seems that the connection is not held open by the IBM DB2 instance when not used and the library does not check if the connection is still open when it makes the query later. This will need quite a bit of rewriting of the code to instead use the un-documented connection Pool from ibm_db library.

Instead of creating the client in the connect_db2 when initialising the _client the code should instead create a client connection Pool. Then for each query obtain a connection from the pool before making queries. This way the pool will ensure an active connection is returned and it may offer better performance also.

I have very limited time available to make the changes, are you able to submit a pull request?

[wallali]

I have created an initial pull request to get you started.
on branch: https://github.com/wallali/connect-db2/tree/issue-9

Acceptance Criteria:

• Code Review passes
• Test against a real db to see if it works
• Add/Update Unit Tests
• Add/Update Integration Tests
• Check code coverage has not dropped