Creating a Service

I have a quick Question not sure if you can or want to help :P, because you not discussing updating to the database in this course

I have created a service and trying to update a subscription
But I am using EntityManager beginTransaction *method within a try and catch just in case if fails it will revert/ rollback all changes.

But I am getting an error saying "There is no active transaction". But it still updated the entity, which makes it confusing.

How looking around to fix this issue but couldn't get a clear anwser.

Should I just remove the BeginTransactio Method...and just manually revert back all changes if there is an error?

Awesome courses at Symfony cast keep it up!

Error:

@id
: 
"/api/errors"
@type
: 
"hydra:Error"
detail
: 
"There is no active transaction."
hydra:description
: 
"There is no active transaction."
hydra:title
: 
"An error occurred"
status
: 
500
title
: 
"An error occurred"
trace
: 
[{file: "/app/vendor/doctrine/dbal/src/Connection.php", line: 1051, function: "new",…},…]

Service

#[AsController]
class CancellUserSubscriptionActionController extends AbstractController
{
public function __invoke(#[MapRequestPayload] CancellSubscription $request)
    {
        $this->denyAccessUnlessGranted(Role::ROLE_USER_STUDENT);

        $response  = new ResponseDto();
        $uuidSub = $request->uuid;
        
        // /** @var User $currentUser */
        $currentUser = $this->getUser();
        
        $datetime = new DateTimeImmutable();
        $currentTimeEvent = $datetime->setTimezone(new DateTimeZone('Europe/Amsterdam'));
        
        try {
            $this->entityManager->beginTransaction();
            // if(!$eventIsNumber) return $response;        
            if(!$this->subscriptionRepo->findOneBy(['uuid' => $uuidSub])) return $response;
            
            /** @var Subscription $subscription */
            $subscription = $this->entityManager->getRepository(Subscription::class)
            ->findOneBy(['uuid' => $uuidSub]);
            
            // dd('got uuid', $subscription);
            $subscription->setStatus(MolliePaymentStatusEnum::CANCELLED);
            $subscription->setUpdatedAt();
            $transferId = $subscription->getTransferId();

            $transaction = $this->entityManager->getRepository(StatusTransfer::class)
            ->findOneBy(['transferId' => $transferId]);

            $customerId = $transaction->getCustomer();

        // try {            
            // $this->entityManager->persist($subscription);
            $this->entityManager->flush();
            $this->entityManager->commit();
            
            $cancellSubscription = $this->mollieApiService->cancelUserSubscription($customerId);
            
            $response->status = 201;
            $response->message = "You have cancelled you subscription !";
            $response->body = $cancellSubscription;
            // $response->message = "You have Updated your address successfully !";
            // $response->message = "You have Updated your address successfully !";
            return $response;
    
        } catch (Throwable $e) {

            $this->entityManager->rollback();
            $this->managerRegister->resetManager();
            $this->entityManager->flush();
            $this->entityManager->commit();
            
            // $this->logger->debug('An error occurred when signin up for a event!', [
            //     'user' => $currentUser->getId(),
            //     'time' => $currentTimeEvent,
            //     'error' => $e->getMessage()
            // ]);

            $response->message = 'Failed cancelling your subscription';
            return $response;
        }        
    }

Update:

I have changed:

• $this->entityManager->beginTransaction()

to :

• $this->entityManager->getConnection()->beginTransaction();
• $this->entityManager->getConnection()->setAutoCommit(false);

Now it works fine