Initially, my service using express and webpack ran smoothly. However, I started encountering an issue where the server would hang with no message code being received, as shown in the server message screenshot (server message screenshot). This problem kept recurring.
Below is my app.js code:
var express = require('express');
var path = require('path');
var favicon = require('serve-favicon');
var logger = require('morgan');
var cookieParser = require('cookie-parser');
var bodyParser = require('body-parser');
var index = require('./routes/index');
var users = require('./routes/users');
var app = express();
var mysql = require('mysql');
var generals = require('./routes/generals');
// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'jade');
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
app.use(cookieParser());
app.use('/generals', generals);
app.use(express.static(path.join(__dirname, 'public')));
app.use('/', index);
app.use('/users', users);
// handle 404 errors
app.use(function(req, res, next) {
var err = new Error('Not Found');
err.status = 404;
next(err);
});
// error handler
app.use(function(err, req, res, next) {
res.locals.message = err.message;
res.locals.error = req.app.get('env') === 'development' ? err : {};
res.status(err.status || 500);
res.render('error');
});
module.exports = app;The route file generals.js:
var express = require('express');
var bodyParser = require('body-parser');
var router = express.Router();
var pool = require('./connections');
router.get('/dropDownValue/', function(req, res, next) {
pool.getConnection(function(err, connection) {
connection.query("select * from drop_down_value order by id desc", function(err, rows) {
if (!err && rows.length > 0) {
res.json(rows);
} else {
res.json([]);
}
});
});
});var mysql = require('mysql');
var pool = mysql.createPool({
host: 'xxx',
user: 'xxx',
password: 'xxx',
database: 'xxx'
});
exports.getConnection = function (callback) {
pool.getConnection(callback);
};