express-oracle-session-ts

• Install
• Usage
• Notes

Install

npm install express-oracle-session-ts

Usage

import express from "express";
import eos from "express-oracle-session-ts";
import session from "express-session";

const OracleSessionStore = eos(session);

const sessionStore = new OracleSessionStore({
  user: ORACLE.user,
  password: ORACLE.password,
  connectionString: ORACLE.conStr,
  schema: {
    tableName: "tbl_cloud_session",
  },
});

// Create Express server
const app = express();

app.use(
  session({
    resave: true,
    saveUninitialized: true,
    secret: SESSION_SECRET,
    store: sessionStore,
  })
);

Notes

• this module was largely a port of express-oracle-session to typescript because at that time express-oracle-session failed to work with node oracle 5. But it seems that it has been updated recently probably to address this issue.
• works with lastest node oracle (5+).
• will create new table if the current session table doesn't not exist.
• querying oracle DB, if failed, this module will retry three times. If it can't get the connection it will throw an error and exit the app (process.exit(1)).