fail a glue job if the called stored procedure fails

Hi all,

I'm using a glue job that reads CSV files from S3 and injects data to MySQL RDS.

at the end of my pyspark glue script, I call a stored procedure. the issue is the glue job status end by succeeding but the stored procedure execution fails.

is there any way to fail the glue job if the execution of the called stored procedure fails?

when glue script calls myStoredProcedure() it's an async call?

appreciate any help

import pymysql

with conn.cursor() as cur:
   insertQry="CALL myStoredProcedure()"
   cur.execute(insertQry)
   conn.commit()
   cur.close()
   conn.close()
   
job.commit()

************* OR **********************
from py4j.java_gateway import java_import
java_import(sc._gateway.jvm,"java.sql.Connection")
java_import(sc._gateway.jvm,"java.sql.DatabaseMetaData")
java_import(sc._gateway.jvm,"java.sql.DriverManager")
java_import(sc._gateway.jvm,"java.sql.SQLException")

source_jdbc_conf = glueContext.extract_jdbc_conf(glue_connection_name)
conn = sc._gateway.jvm.DriverManager.getConnection(source_jdbc_conf.get('url') + '/' + database_name, source_jdbc_conf.get('user'), source_jdbc_conf.get('password'))

 stmt = conn.createStatement();
 rs = stmt.executeQuery('call ' + stored_proc);
 conn.close()