Disable autocommit on the Postgres RDS level
Is there a way to set autocommit off at the RDS level. Need to do that to make all the Java code written for the Oracle database to work with out major modifications. There are triggers that are fired based on the transaction ID generated at the beginning of the transaction. Since autocommit is on (as a default) triggers are not able to find the transaction.
You can achieve that using init_connect parameter as described here: https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon-rds-for-mysql-part-3-parameters-related-to-security-operational-manageability-and-connectivity-timeout/
Thank you so much for your reply.
I believe init_connection is only available in mySql. I don't see that parameter in Postgres parameters group.
Are you connecting with JDBC? If so, then autocommit is already the default in the JDBC driver and should be set there, like
conn.setAutoCommit(false);. AFAIK this cannot be done on the database level.
Thank you for your response.
I was looking for ways to do that at the database level. Looks like that's not possible. Not sure how the triggers will work in this case. I can't test the triggers from the backend now.
What's the fastest way to move a 2TB Oracle Database to EC2?Accepted Answerasked 2 years ago
Oracle RDS - Applying Patchesasked 2 months ago
Does Amazon Oracle RDS Multi-AZ supports maximum protection mode?Accepted AnswerMODERATORasked 3 years ago
Is it possible too Switch off or change the log level for CodeDeploy Logs?asked 3 months ago
Heterogeneous database links on AWS RDSAccepted Answerasked a year ago
Is there a way to authorize GGv2 core devices to interact with AWS services at the Thing Group level ?Accepted Answerasked 4 months ago
How to restrict database users for RDS Postgres using AWS Managed AD trusted with customer on-prem ADAccepted Answerasked 2 years ago
How to copy RDS database from Account A to Account Basked 2 months ago
RDS Oracle storage redundancyasked 3 years ago
Disable autocommit on the Postgres RDS levelasked 24 days ago