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.

주제

데이터베이스 마이그레이션 및 현대화

태그

PostgreSQL 오라클에서 PostgreSQL로

언어

English

AWS-User-4620625

질문됨 2년 전1342회 조회

2개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

Hello,

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/

Regards

AWS-ADolganov

답변함 2년 전

AWS-User-4620625
2년 전
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.

Uwe K

답변함 2년 전

AWS-User-4620625
2년 전
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.

Disable autocommit on the Postgres RDS level

관련 콘텐츠