title: JDBC Auto-Commit Not Working with PostgreSQL 9 Driver
body: <p>I have a spring application with a PostgreSQL DataSource loaded from JDNI:</p>
  
  <pre><code>&lt;jee:jndi-lookup id="dataSource" jndi-name="jdbc/DB" expected-type="javax.sql.DataSource" /&gt;
  </code></pre>
  
  <p>I hooked it up with a JDBCTemplate </p>
  
  <pre><code>// DataSource is Autowired
  jdbcTemplate = new JdbcTemplate(dataSource);
  </code></pre>
  
  <p>and auto-commit is set to true</p>
  
  <pre><code>&lt;Resource name="jdbc/DB" auth="Container" type="javax.sql.DataSource"
            username="postgres" password="localPostgres"
            url="jdbc:postgresql://localhost:5432/postgres"
            driverClassName="org.postgresql.Driver"
            defaultAutoCommit="true"/&gt;
  </code></pre>
  
  <p>When I try to insert an item with a simple SQL insert statement the changes are not committed to the database. </p>
  
  <pre><code>jdbcTemplate.update("INSERT INTO items (name, surname) VALUES ('samantha', 'catania')";
  </code></pre>
  
  <p>Entering the SQL statement directly in the database console the item gets inserted i.e. the SQL is correct.</p>
  
  <p>Any ideas what could be the issue please?</p>