Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var mysql = require('mysql');
- var db_connect = (function () {
- function db_connect() {
- mysqlConnConfig = {
- host: "localhost",
- user: "username",
- password: "password",
- database: "db_name"
- };
- }
- db_connect.prototype.unitOfWork = function (sql) {
- mysqlConn = mysql.createConnection(mysqlConnConfig);
- try {
- sql(mysqlConn);
- } catch (ex) {
- console.error(ex);
- } finally {
- mysqlConn.end();
- }
- };
- return db_connect;
- })();
- exports.db_connect = db_connect;
- var query1 = "SELECT * FROM table1";
- sql.query(query1,function(error,response){
- if(error){
- console.log(error);
- }
- else{
- console.log(response);
- }
- })
- forever start app.js
- "stack": ["Error: Connection lost: The server closed the connection.", " at Protocol.end (/path/to/my/file/node_modules/mysql/lib/protocol/Protocol.js:109:13)", " at Socket.<anonymous> (/path/to/my/file/node_modules/mysql/lib/Connection.js:102:28)", " at emitNone (events.js:72:20)", " at Socket.emit (events.js:166:7)", " at endReadableNT (_stream_readable.js:913:12)", " at nextTickCallbackWith2Args (node.js:442:9)", " at process._tickDomainCallback (node.js:397:17)"],
- "level": "error",
- "message": "uncaughtException: Connection lost: The server closed the connection.",
- "timestamp": "2017-09-13T21:22:25.271Z"
- var db_config = {
- host: 'localhost',
- user: 'root',
- password: '',
- database: 'example'
- };
- var connection;
- function handleDisconnect() {
- connection = mysql.createConnection(db_config); // Recreate the connection, since
- // the old one cannot be reused.
- connection.connect(function(err) { // The server is either down
- if(err) { // or restarting (takes a while sometimes).
- console.log('error when connecting to db:', err);
- setTimeout(handleDisconnect, 2000); // We introduce a delay before attempting to reconnect,
- } // to avoid a hot loop, and to allow our node script to
- }); // process asynchronous requests in the meantime.
- // If you're also serving http, display a 503 error.
- connection.on('error', function(err) {
- console.log('db error', err);
- if(err.code === 'PROTOCOL_CONNECTION_LOST') { // Connection to the MySQL server is usually
- handleDisconnect(); // lost due to either server restart, or a
- } else { // connnection idle timeout (the wait_timeout
- throw err; // server variable configures this)
- }
- });
- }
- handleDisconnect();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement