Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
AWS re:Postre:Post

Disable autocommit on the Postgres RDS level

0

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.

Themen
DatenbankMigration und Modernisierung
Tags
PostgreSQLOracle nach PostgreSQL
Sprache
English
AWS-User-4620625
gefragt vor 2 Jahren1342 Aufrufe
2 Antworten
0

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
AWS-ADolganov
beantwortet vor 2 Jahren
  • AWS-User-4620625
    vor 2 Jahren

    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.

0

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.

profile pictureAWS
Uwe K
beantwortet vor 2 Jahren
  • AWS-User-4620625
    vor 2 Jahren

    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.

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt