Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

237
Views
conn.beginTransaction is not a function

Does someone know, why i get this error: TypeError: conn.beginTransaction is not a function? I've been trying to find how to use transaction with mysql2, but haven't found a good solution yet.

dbConfig.js

const mysql = require('mysql2/promise');

const pool = mysql.createPool({
    host: process.env.DB_HOST,
    user: process.env.DB_USER,
    password: process.env.DB_PASS,
    database: process.env.DB_DATABASE,
    connectionLimit: 10,
});

module.exports = pool;

ProductModel.js

const conn = require('../config/dbConfig');

const productModel = {
    postOrder: async (order) => {
        return await new Promise((resolve, reject) => {
            conn.beginTransaction();
            console.log('Start Tranaction!');
            const insertQuery = conn.query(
                'INSERT INTO `beansome`.`order` (`orderCreated`,`orderFirstname`,`orderLastname`,`orderStreet`,`orderHousenumber`,`orderZipcode`,`orderCity`,`orderTelephone`,`orderEmail`,`orderTotalprice`) VALUES (?,?,?,?,?,?,?,?,?,?);',
                [
                    order.orderCreated,
                    order.orderFirstname,
                    order.orderLastname,
                    order.orderStreet,
                    order.orderHousenumber,
                    order.orderZipcode,
                    order.orderCity,
                    order.orderTelephone,
                    order.orderEmail,
                    order.orderTotalprice,
                ]
            );

            conn.commit();
            console.log('End Tranaction!');
        });
    },
};
module.exports = productModel;
about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!