Is there a way to prompt Express to acknowledge a mistake encountered during my Teradata database query?

Question

Is there a way to prompt Express to acknowledge a mistake encountered during my Teradata database query?

My current setup involves using Express to connect to my Teradata database, and everything works perfectly when there are no errors.

However, when an error occurs during a Teradata call, I can see the output in my console window but I'm unsure how to set up an error handler.

Although this seems like a basic issue, I am new to Express and would greatly appreciate any assistance.

Here is the code for the Express call:

router.post('/sp_run', function (req, res) {
    var sql = "CALL DB.STORED_PROC1(1,P_ERROR_CODE,P_MSG);";
    console.log(sql);
  return teradata.read(sql)
      .then((x) => {
        console.log(x);
   res.send(x);
      });
  });

This is the error information displayed in my console:

CALL DB.STORED_PROC1(1,P_ERROR_CODE,P_MSG);
express_1  | 2019-6-27 21:07:10 - error: [Teradata] Unable to execute query: CALL DB.STORED_PROC1(1,P_ERROR_CODE,P_MSG);
express_1  | Unhandled rejection Error: Error running instance method
express_1  | java.sql.SQLException: [Teradata Database] [TeraJDBC 16.20.00.10] [Error 7627] [SQLState HY000] STORED_PROC1:SELECT-INTO returned more than one row.

In case of an error, I want to send an email notification and provide a response to the frontend promptly instead of waiting indefinitely.

javascript sql express teradata

Answer 1

Answer №1

To avoid sending promises from this point, simply respond with a status variable of type boolean. Then, apply a condition on the frontend.

 router.post('/sp_run', function (req, res) {
     var sql = "CALL DB.STORED_PROC1(1,P_ERROR_CODE,P_MSG);";
     console.log(sql);

     return teradata.read(sql)
       .then((x) => {
          return res.json({
                   status: true,
                  message: 'All work fine',
                  result: x
              })
        }).catch(error => {
         //send email about failure
          return res.json({
                 status: false,
                 message: 'Failed',
                 error: error.message
           })
       });
    });

Alternatively, you can send a response with a status code and handle it using try/catch.

On the front end:

const getData = () => {
    // Here axios is used to call an API, you can use fetch or anything else.
    axios.post('/sp_run', {}).then(data => {
        if(!data.status) {
            alert(data.error)
        } else {
        // Work with the data
        }
    })

}

Answer 2

To avoid sending promises from this point, simply respond with a status variable of type boolean. Then, apply a condition on the frontend.

 router.post('/sp_run', function (req, res) {
     var sql = "CALL DB.STORED_PROC1(1,P_ERROR_CODE,P_MSG);";
     console.log(sql);

     return teradata.read(sql)
       .then((x) => {
          return res.json({
                   status: true,
                  message: 'All work fine',
                  result: x
              })
        }).catch(error => {
         //send email about failure
          return res.json({
                 status: false,
                 message: 'Failed',
                 error: error.message
           })
       });
    });

Alternatively, you can send a response with a status code and handle it using try/catch.

On the front end:

const getData = () => {
    // Here axios is used to call an API, you can use fetch or anything else.
    axios.post('/sp_run', {}).then(data => {
        if(!data.status) {
            alert(data.error)
        } else {
        // Work with the data
        }
    })

}

Is there a way to prompt Express to acknowledge a mistake encountered during my Teradata database query?

Answer №1

Similar questions

What is the best way to turn off ajax functionality when detecting IE8?

Exploring Three.js: The challenge of loading multiple material objects

Expanding a div's size with CSS to fill the remaining space

Customize the default SQL generation in EF 6 according to the entity type

Issue with Google Maps API fetching data is resolved

What is the recommended value for the auto-incremented ID field when using the POST method in Node.js?

Implementing a feature in React where the active class is applied only to the next element upon clicking

Implementing a color filter on a camera using Three.js

Stop Element-UI from automatically applying the list-item style to li elements

Inconsistencies with Handlebars adding forward slashes "/" to page addresses are causing confusion among users

Can dependency injection be implemented while utilizing the new operator?

Retrieving data from a <div> element within an HTML string using jQuery and AJAX

Unpredictable term pulled from the Javascript/Ajax content

Implement the insertion of JSON items in real-time by leveraging the power of Angular JS and

Encountering an isObject issue while using the @material/core package

Adapting the colors of various elements throughout the entire webpage

Obtain JSON information from a Javascript response using Puppeteer:

Tips for generating numerous queries within one GET request

Update breadcrumbs dynamically by clicking on each horizontal panel

Mastering NodeJS Promises: Efficiently Handling Multiple http.get Requests