I am using mssql storage procedure. In the procedure, I perform insertion or update operations on 2 tables according to the data received. However, although it appears in the catch blog, rollback does not work.
try{
$params = ['name' => 'abc','surname' =>'xyz, 'pass' => 123456];
$this->entityManager->beginTransaction();
$query = "exec storeProcedureName @name = :name, @surname = :surname, @pass = :pass";
$rsm = new ResultSetMapping;
$nativeQuery = $this->entityManager->createNativeQuery($query, $rsm);
} catch (Throwable $th) {
$this->entityManager->rollback();
throw $th;
}
Revues documentaire/2-Authors/Revues documentaire_2-Authors_2024-04-02_10-46-37.parquet
Revues documentaire/3-Comitments ENG/Revues documentaire_3-Comitments ENG_2024-04-02_10-46-37.parquet
Revues documentaire/4-Comitments PRJ/Revues documentaire_4-Comitments PRJ_2024-04-02_10-46-37.parquet
Table Docs ENG/1-ENG/Table Docs ENG_1-ENG_2024-05-27_08-20-57.parquet
Table Docs PRJ/1-PRJ/Table Docs PRJ_1-PRJ_2024-05-27_08-15-31.parquet
Table Reviews/1-Review/Table Reviews_1-Review_2024-05-27_08-11-57.parquet
Table STAR/1-STAR/Table STAR_1-STAR_2024-05-27_08-16-06.parquet
Table Tasks/1-Task/Table Tasks_1-Task_2024-05-27_08-13-23.parquet
Table Users/1-Users/Table Users_1-Users_2024-05-27_08-20-18.parquet
EPO_REC/dwh_ACTIVITY/dwh_ACTIVITY_2023-10-01_08-00-12.parquet
EPO_REC/dwh_ACTIVITY/dwh_ACTIVITY_2023-10-01_08-00-12.parquet
EPO_REC/dwh_ACTIVITY/dwh_ACTIVITY_2023-10-01_08-00-12.parquet
EPO_REC/dwh_ACTIVITY/dwh_ACTIVITY_2023-10-01_08-00-12.parquet
EPO_REC/dwh_ACTIVITY/dwh_ACTIVITY_2023-10-01_08-00-12.parquet
cables complets janvier 2023 avec tirage aout 2022 sans prix/default_1/cables complets janvier 2023 avec tirage aout 2022 sans prix_default_1_2023-10-24_11-51-19.parquet
=?utf-8?B?RGVtYW5kZSBkZSBkw6ljYWxhZ2UgZGVzIGphbG9uc19WQzE=?=/Demande de décalage/=?utf-8?B?RGVtYW5kZSBkZSBkw6ljYWxhZ2UgZGVzIGphbG9uc19WQzE=?=_Demande de décalage_2024-04-30_14-50-00.parquet
VC1-DFD_Projet de Pyramide des jalons 2024 v0/Tableau de travail/VC1-DFD_Projet de Pyramide des jalons 2024 v0_Tableau de travail_2024-02-28_16-03-33.parquet
Fichier Suivi jalons/Janvier2024/Fichier Suivi jalons_Janvier2024_2024-02-28_11-35-49.parquet
Fichier Suivi jalons/Février 2024/Fichier Suivi jalons_Février 2024_2024-02-28_11-35-49.parquet
Fichier suivi des Jalons 2024/Avril2024/Fichier suivi des Jalons 2024_Avril2024_2024-04-30_16-51-56.parquet
Fichier suivi des Jalons 2024/Mars2024/Fichier suivi des Jalons 2024_Mars2024_2024-04-30_16-51-56.parquet
20240226094938-action2/Sheet1/20240226094938-action2_Sheet1_2024-03-28_09-06-49.parquet
Constat/Sheet1/Constat_Sheet1_2024-03-28_09-04-50.parquet
=?utf-8?B?SGlzdG8gU3RhdHV0IGRlcyBhY3Rpb24gbGnDqWUgYXV4IEZOQw==?=/Feuil1/=?utf-8?B?SGlzdG8gU3RhdHV0IGRlcyBhY3Rpb24gbGnDqWUgYXV4IEZOQw==?=_Feuil1_2024-03-28_09-07-17.parquet
Test Patrice/Actions/Test Patrice_Actions_2024-03-27_14-12-20.parquet
TDB MP DIR-2024/ACTIVITES-24/TDB MP DIR-2024_ACTIVITES-24_2024-04-10_15-25-38.parquet
TDB MP DIR-2024/Commentaires/TDB MP DIR-2024_Commentaires_2024-04-10_15-25-38.parquet
TDB MP DIR-2024/DI 2024 ACTIONS CLOSES/TDB MP DIR-2024_DI 2024 ACTIONS CLOSES_2024-04-10_15-25-38.parquet
TDB MP DIR-2024/DI 2024 ACTIONS EN COURS/TDB MP DIR-2024_DI 2024 ACTIONS EN COURS_2024-04-10_15-25-38.parquet
TDB MP DIR-2024/DI 2024 CONSTATS/TDB MP DIR-2024_DI 2024 CONSTATS_2024-04-10_15-25-38.parquet
TDB MP DIR-2024/FDR 2024/TDB MP DIR-2024_FDR 2024_2024-04-10_15-25-38.parquet
TDB MP DIR-2024/INDICATEURS-24/TDB MP DIR-2024_INDICATEURS-24_2024-04-10_15-25-38.parquet
TDB MP DIR-2024/PCI-AUDIT-24/TDB MP DIR-2024_PCI-AUDIT-24_2024-04-10_15-25-38.parquet
TDB MP DIR-2024/PLANVIEW-24/TDB MP DIR-2024_PLANVIEW-24_2024-04-10_15-25-38.parquet
TDB MP DIR-2024/TCD MP DIR/TDB MP DIR-2024_TCD MP DIR_2024-04-10_15-25-38.parquet
TDB MP DIR-2024/VIS-CODIR-24/TDB MP DIR-2024_VIS-CODIR-24_2024-04-10_15-25-38.parquet
paladin/Sheet1/paladin_Sheet1_2024-01-23_11-03-14.parquet
WO EDV V6 lien 5.x/Feuil1/WO EDV V6 lien 5.x_Feuil1_2024-05-24_15-04-59.parquet
WO EDV V6 lien 5.x/WO/WO EDV V6 lien 5.x_WO_2024-05-24_15-04-59.parquet
EPO_REC/dwh_ACTIVITY/dwh_ACTIVITY_2023-10-01_08-00-12.parquet
FAMS_VF_20240229/Sheet1/FAMS_VF_20240229_Sheet1_2024-03-05_13-39-01.parquet
FAMS_VF_20240331/Sheet1/FAMS_VF_20240331_Sheet1_2024-04-03_09-00-59.parquet
FAMS_VF_20240430/Sheet1/FAMS_VF_20240430_Sheet1_2024-05-03_11-04-06.parquet
CARTO_IN_VF_20231031/Feuil1/CARTO_IN_VF_20231031_Feuil1_2023-11-07_11-04-06.parquet
CARTO_IN_VF_20231129/Feuil1/CARTO_IN_VF_20231129_Feuil1_2023-11-29_16-31-16.parquet
CARTO_IN_VF_20231229/Feuil1/CARTO_IN_VF_20231229_Feuil1_2024-01-03_10-46-51.parquet
CARTO_IN_VF_20240131/Feuil1/CARTO_IN_VF_20240131_Feuil1_2024-02-05_17-18-16.parquet
=?utf-8?B?RVBSMi0gTWF0dXJpdMOpIEfDqW7DqXJhbGUgRVA=?=/Feuil1/=?utf-8?B?RVBSMi0gTWF0dXJpdMOpIEfDqW7DqXJhbGUgRVA=?=_Feuil1_2023-10-17_11-13-05.parquet
FAMS_VF_20230930/Sheet1/FAMS_VF_20230930_Sheet1_2023-10-13_12-28-52.parquet
FAMS_VF_20231031/Sheet1/FAMS_VF_20231031_Sheet1_2023-11-08_09-31-12.parquet
FAMS_VF_20231129/Sheet1/FAMS_VF_20231129_Sheet1_2023-11-29_16-24-41.parquet
FAMS_VF_20240104/Sheet1/FAMS_VF_20240104_Sheet1_2024-01-04_13-22-47.parquet
FAMS_VF_20240131/Sheet1/FAMS_VF_20240131_Sheet1_2024-01-31_12-58-41.parquet
Flux/Flux fonctionnels/Flux_Flux fonctionnels_2024-01-13_19-59-06.parquet
Maturite des processus/Result/Maturite des processus_Result_2023-10-17_14-12-39.parquet
OBEO_Patrimoine Applicatif des Processus/Feuil1/OBEO_Patrimoine Applicatif des Processus_Feuil1_2023-10-12_12-54-39.parquet
Obsolescence/Sheet1/Obsolescence_Sheet1_2024-01-08_15-15-11.parquet
PREVOBS_VF_20230930/Sheet1/PREVOBS_VF_20230930_Sheet1_2023-10-13_13-26-34.parquet
PREVOBS_VF_20230930/Sheet1/PREVOBS_VF_20230930_Sheet1_2023-10-13_12-35-46.parquet
PREVOBS_VF_20231031/Sheet1/PREVOBS_VF_20231031_Sheet1_2023-11-08_09-31-41.parquet
PREVOBS_VF_20231129/Sheet1/PREVOBS_VF_20231129_Sheet1_2023-11-29_16-29-15.parquet
PREVOBS_VF_20231229/Sheet1/PREVOBS_VF_20231229_Sheet1_2024-01-08_13-58-01.parquet
SI-PEDIA/Services/SI-PEDIA_Services_2023-10-12_13-02-50.parquet
SI-PEDIA/Services/SI-PEDIA_Services_2023-10-12_13-21-47.parquet
view_riq_ins_20230930/view_riq_ins_202310121148/view_riq_ins_20230930_view_riq_ins_202310121148_2023-10-13_12-45-16.parquet
view_riq_ins_20231031/view_riq_ins_20231031/view_riq_ins_20231031_view_riq_ins_20231031_2023-11-08_09-34-45.parquet
view_riq_ins_20231129/view_riq_ins/view_riq_ins_20231129_view_riq_ins_2023-12-06_09-41-59.parquet
view_riq_ins_20231231/view_riq_ins/view_riq_ins_20231231_view_riq_ins_2024-01-03_10-51-48.parquet
KPI-Data/Feuil1/KPI-Data_Feuil1_2024-02-13_16-50-46.parquet
PREVOBS_VF_20240131/Sheet1/PREVOBS_VF_20240131_Sheet1_2024-03-13_13-44-56.parquet
PREVOBS_VF_20240229/Sheet1/PREVOBS_VF_20240229_Sheet1_2024-03-13_13-53-07.parquet
PREVOBS_VF_20240331/Sheet1/PREVOBS_VF_20240331_Sheet1_2024-04-03_09-04-15.parquet
PREVOBS_VF_20240430/Sheet1/PREVOBS_VF_20240430_Sheet1_2024-05-03_11-04-42.parquet
AAC-Register/AAC/AAC-Register_AAC_2024-03-28_13-26-07.parquet
Actuals-Database/Actuals/Actuals-Database_Actuals_2024-04-08_16-20-14.parquet
Cost_Type/Cost_Type/Cost_Type_Cost_Type_2024-04-08_16-04-44.parquet
CR-Register/CR/CR-Register_CR_2024-03-28_13-25-27.parquet
CRs/Worksheet/CRs_Worksheet_2024-04-18_15-45-32.parquet
Current-Database/Forecast/Current-Database_Forecast_2024-03-21_13-46-33.parquet
Current-Raw-Database/Current-Row/Current-Raw-Database_Current-Row_2024-04-08_16-19-58.parquet
Current-Row-Database/CF/Current-Row-Database_CF_2024-03-28_09-35-17.parquet
Current-Row-Database/Current-Row/Current-Row-Database_Current-Row_2024-03-28_09-37-32.parquet
Current-Row-Database/Mapping/Current-Row-Database_Mapping_2024-03-28_09-35-17.parquet
Database_Actuals/Actuals/Database_Actuals_Actuals_2024-04-08_15-36-38.parquet
Database_Forecast/Forecast/Database_Forecast_Forecast_2024-04-08_15-37-07.parquet
Database_NotifiedBudget/Notified Budget/Database_NotifiedBudget_Notified Budget_2024-04-08_15-37-32.parquet
Database_TO24/TO-Database/Database_TO24_TO-Database_2024-04-08_15-37-45.parquet
Entities/Entities/Entities_Entities_2024-02-29_15-47-23.parquet
Historical_Forecast/Historical_Forecast/Historical_Forecast_Historical_Forecast_2024-04-22_16-36-33.parquet
Historical_Forecast/Sheet1/Historical_Forecast_Sheet1_2024-04-22_16-25-00.parquet
HPC NI – Actuals 01-2024/Feuil1/HPC NI – Actuals 01-2024_Feuil1_2024-02-26_16-40-18.parquet
HPC NI – Actuals 01-2024/Feuil11/HPC NI – Actuals 01-2024_Feuil11_2024-02-26_16-40-18.parquet
HPC NI – Actuals 01-2024/First Sheet/HPC NI – Actuals 01-2024_First Sheet_2024-02-26_16-40-18.parquet
HPC_NI_Forecast/Forecast/HPC_NI_Forecast_Forecast_2024-02-27_16-47-24.parquet
HPC_NI_Forecast/mapping/HPC_NI_Forecast_mapping_2024-02-27_16-47-24.parquet
HPCLevels/Entities/HPCLevels_Entities_2024-04-08_15-38-03.parquet
HPCLevels/Entities-MA/HPCLevels_Entities-MA_2024-04-08_15-38-03.parquet
HPCLevels/Macro-Topic/HPCLevels_Macro-Topic_2024-04-08_15-38-03.parquet
HPCLevels/OBS-L4/HPCLevels_OBS-L4_2024-04-08_15-38-03.parquet
HPCLevels/OBS-Levels/HPCLevels_OBS-Levels_2024-04-08_15-38-03.parquet
HPC-Niveaux/Entities/HPC-Niveaux_Entities_2024-04-10_15-33-29.parquet
HPC-Niveaux/Entities-MA/HPC-Niveaux_Entities-MA_2024-04-10_15-33-29.parquet
HPC-Niveaux/Macro-Topic/HPC-Niveaux_Macro-Topic_2024-04-10_15-33-29.parquet
HPC-Niveaux/OBS-L4/HPC-Niveaux_OBS-L4_2024-04-10_15-33-29.parquet
HPC-Niveaux/OBS-Levels/HPC-Niveaux_OBS-Levels_2024-04-10_15-33-29.parquet
HPC-Niveaux/SA/HPC-Niveaux_SA_2024-03-25_16-33-53.parquet
Actuals/First Sheet/Actuals_First Sheet_2024-02-13_14-24-13.parquet
Base Forecsat/First Sheet/Base Forecsat_First Sheet_2024-02-13_14-21-51.parquet
MAP_L3L5/MAP EIB/MAP_L3L5_MAP EIB_2024-04-08_15-38-16.parquet
MAP_L3L5/MAP ENT/MAP_L3L5_MAP ENT_2024-04-08_15-38-16.parquet
MAP-EIB/MAP EIB/MAP-EIB_MAP EIB_2024-04-08_16-04-28.parquet
MAP-EIB/MAP OBS/MAP-EIB_MAP OBS_2024-04-08_16-04-28.parquet
Niveaux/DT/Niveaux_DT_2024-02-29_16-56-57.parquet
Niveaux/Feuil3/Niveaux_Feuil3_2024-02-29_16-56-57.parquet
Niveaux/MA/Niveaux_MA_2024-02-29_16-56-57.parquet
Niveaux/MT/Niveaux_MT_2024-02-29_16-56-57.parquet
NNB_Topic/Sheet1/NNB_Topic_Sheet1_2024-04-08_16-04-54.parquet
Notified Budget/Notified Budget/Notified Budget_Notified Budget_2024-04-02_10-58-53.parquet
Sequences/Sheet1/Sequences_Sheet1_2024-04-08_16-05-04.parquet
Test/Sheet1/Test_Sheet1_2024-04-08_15-15-04.parquet
TO24/Database/TO24_Database_2024-03-05_16-58-59.parquet
TO24/Sheet1/TO24_Sheet1_2024-03-05_16-58-59.parquet
TO24-Database/TO-Database/TO24-Database_TO-Database_2024-04-08_16-19-39.parquet
Suivi REX DPFA3/Analyse qualité/Suivi REX DPFA3_Analyse qualité_2024-05-17_10-58-54.parquet
Suivi REX DPFA3/Feuil1/Suivi REX DPFA3_Feuil1_2024-04-10_17-30-44.parquet
Suivi REX DPFA3/Feuil2/Suivi REX DPFA3_Feuil2_2024-05-14_12-39-07.parquet
user22509333 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.