Thread: Postgres: Transaction Connections
Hi ,
I use postgres database server 8.2.12 with my java application. I was wondering if postgres supports transactions by default or do i have to turn some parameter on to enable transaction support ?
Thanks.
I use postgres database server 8.2.12 with my java application. I was wondering if postgres supports transactions by default or do i have to turn some parameter on to enable transaction support ?
Thanks.
CM J wrote: > Hi , > > > I use postgres database server 8.2.12 with my java > application. I was wondering if postgres supports transactions by > default or do i have to turn some parameter on to enable transaction > support ? Postgres supports transactions by default. Postgres JDBC drivers for Java have two operating modes, autocommit where every statement is its own transaction, and non-autocommit, where you have to explicitly commit or rollback to end a transaction.
John R Pierce, 06.05.2009 07:33: >> I use postgres database server 8.2.12 with my java >> application. I was wondering if postgres supports transactions by >> default or do i have to turn some parameter on to enable transaction >> support ? > > Postgres supports transactions by default. Actually - as with any other sensible RDBMS - you can *not* turn them off. Thomas