Why transaction does not rollback while inserting row with raw SQL?

[kom24al]

await db.sequelize.transaction(async (transaction) => {
const [orderInfoNew] = await Promise.all([

// Execute the INSERT query
await db.sequelize.query(insertQuery, {
  replacements: orderInfoData,
  type: db.Sequelize.QueryTypes.INSERT
},{ transaction: transaction })

])
})

[ephys]

Transactions roll back when an error is thrown in the transaction callback

[kom24al]

@ephys Can you please tell, what is wrong with the above code that when subsequent transaction fails the it is not getting rollbacked?
Transaction rollback is only working with sequelize.OrderInfo.create method not with RAW query. My database is in Oracle.

[ephys]

You're passing the transaction as a third parameter but this function only takes two parameters: the SQL and the options

[kom24al]

Is there any other way to manage transaction with sequelize.query?

[ephys]

Pass the transaction option in the second parameter:

await sequelize.query(insertQuery, {
  replacements: orderInfoData,
  type: QueryTypes.INSERT,
  transaction,
})