title: Autocommit Always Turns On in Oracle SQLDeveloper when Connecting to PostgreSQL
body: <p>I have my Oracle SQL Developer, which is connecting to PostgreSQL database</p>
  
  <p>Following this link : <a href="https://stackoverflow.com/questions/7592519/oracle-sql-developer-and-postgresql">Oracle SQL Developer and PostgreSQL</a>
  I have managed to connect my SQLDeveloper to PostgreSQL (FYI, my SQLDeveloper version is 17.2, and the postgresql in the server  is 9.6)</p>
  
  <p>However, eventhough my autocommit setting is off in my SQLDeveloper (through Tools > Preferences > Database > Advanced), my SQLDeveloper cannot commit  and rollback. When I tried to execute commit/rollback manually (i.e. by typing "COMMIT;" or "ROLLBACK;"), I got the message :</p>
  
  <pre><code>Cannot rollback when autoCommit is enabled.
  </code></pre>
  
  <p>As far as I know, PostgreSQL is always autocommit, and  the autocommit off is  done by the client. For  example, I tried PGAdmin, and  manage to commit  and  rollback manually without autocommit (too bad, PGAdmin is  a little bit slow)</p>
  
  <p>Can anyone help me turning off the autocommit for SQLDeveloper when connecting to PostgreSQL?</p>
  
  <p>Thanks</p>