public void fileBug(Connection c, String key, Timestamp when, int id) throws Exception { PreparedStatement insertBugData = c .prepareStatement("UPDATE findbugs_issue SET bugDatabaseKey = ?, firstSeen = ? WHERE id = ?"); int col = 1; insertBugData.setString(col++, key); insertBugData.setTimestamp(col++, when); insertBugData.setInt(col++, id); // missing execute insertBugData.close(); }
String getMode() throws SQLException { if (mode == null) { PreparedStatement prep = prepareStatement( "SELECT VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME=?"); prep.setString(1, "MODE"); ResultSet rs = prep.executeQuery(); rs.next(); mode = rs.getString(1); prep.close(); } return mode; }
private boolean lockViaUpdate(Connection conn, String lockName, String sql) throws SQLException { PreparedStatement ps = conn.prepareStatement(sql); try { ps.setString(1, lockName); getLog().debug("Lock '" + lockName + "' is being obtained: " + Thread.currentThread().getName()); return ps.executeUpdate() >= 1; } finally { ps.close(); } }
private void doTestQueryForListWithArgs(String sql) throws Exception { given(this.resultSet.next()).willReturn(true, true, false); given(this.resultSet.getObject(1)).willReturn(11, 12); List<Map<String, Object>> li = this.template.queryForList(sql, new Object[] {3}); assertEquals("All rows returned", 2, li.size()); assertEquals("First row is Integer", 11, ((Integer) li.get(0).get("age")).intValue()); assertEquals("Second row is Integer", 12, ((Integer) li.get(1).get("age")).intValue()); verify(this.preparedStatement).setObject(1, 3); verify(this.resultSet).close(); verify(this.preparedStatement).close(); }
void f() throws SQLException { PreparedStatement insertFieldAudit = null; try { for (int i = 1; i <= 10; i++) { insertFieldAudit = getConnection().prepareStatement(INSERT_FIELD_AUDIT); insertFieldAudit.executeUpdate(); } } finally { insertFieldAudit.close(); } }
@Test public void testBatchUpdateWithPlainMap() throws Exception { @SuppressWarnings("unchecked") final Map<String, Integer>[] ids = new Map[2]; ids[0] = Collections.singletonMap("id", 100); ids[1] = Collections.singletonMap("id", 200); final int[] rowsAffected = new int[] {1, 2}; given(preparedStatement.executeBatch()).willReturn(rowsAffected); given(connection.getMetaData()).willReturn(databaseMetaData); namedParameterTemplate = new NamedParameterJdbcTemplate(new JdbcTemplate(dataSource, false)); int[] actualRowsAffected = namedParameterTemplate.batchUpdate( "UPDATE NOSUCHTABLE SET DATE_DISPATCHED = SYSDATE WHERE ID = :id", ids); assertTrue("executed 2 updates", actualRowsAffected.length == 2); assertEquals(rowsAffected[0], actualRowsAffected[0]); assertEquals(rowsAffected[1], actualRowsAffected[1]); verify(connection).prepareStatement("UPDATE NOSUCHTABLE SET DATE_DISPATCHED = SYSDATE WHERE ID = ?"); verify(preparedStatement).setObject(1, 100); verify(preparedStatement).setObject(1, 200); verify(preparedStatement, times(2)).addBatch(); verify(preparedStatement, atLeastOnce()).close(); verify(connection, atLeastOnce()).close(); }
@Test public void create_iterator_from_result_set() throws Exception { dbTester.prepareDbUnit(getClass(), "feed.xml"); try (Connection connection = dbTester.openConnection()) { PreparedStatement stmt = connection.prepareStatement("select * from issues order by id"); ResultSet rs = stmt.executeQuery(); FirstIntColumnIterator iterator = new FirstIntColumnIterator(rs); assertThat(iterator.next()).isEqualTo(10); assertThat(iterator.next()).isEqualTo(20); assertThat(iterator.next()).isEqualTo(30); iterator.close(); assertThat(rs.isClosed()).isTrue(); stmt.close(); } }
@Override public String doInConnection(Connection con) throws SQLException { PreparedStatement ps = con.prepareStatement("some SQL"); ps.setFetchSize(10); ps.setMaxRows(20); ps.close(); return "test"; } });
@Test public void readClosesPreparedStatementWhenFinished() throws Exception { setupEmptyResultSet(); Object getKey = "getkey"; handler.read(region, getKey); verify(statement).executeQuery(); verify(statement).setObject(1, getKey); verify(statement).close(); }
private String getMode() throws SQLException { if (mode == null) { PreparedStatement prep = conn .prepareStatement("SELECT VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME=?"); prep.setString(1, "MODE"); ResultSet rs = prep.executeQuery(); rs.next(); mode = rs.getString(1); prep.close(); } return mode; } }
private boolean lockViaUpdate(Connection conn, String lockName, String sql) throws SQLException { PreparedStatement ps = conn.prepareStatement(sql); try { ps.setString(1, lockName); getLog().debug("Lock '" + lockName + "' is being obtained: " + Thread.currentThread().getName()); return ps.executeUpdate() >= 1; } finally { ps.close(); } }
@Test public void testQueryForLongWithArgs() throws Exception { String sql = "SELECT AGE FROM CUSTMR WHERE ID = ?"; given(this.resultSet.next()).willReturn(true, false); given(this.resultSet.getLong(1)).willReturn(87L); long l = this.template.queryForObject(sql, new Object[] {3}, Long.class).longValue(); assertEquals("Return of a long", 87, l); verify(this.preparedStatement).setObject(1, 3); verify(this.resultSet).close(); verify(this.preparedStatement).close(); }
void f2() throws SQLException { PreparedStatement insertFieldAudit = null; try { insertFieldAudit = getConnection().prepareStatement(INSERT_FIELD_AUDIT); insertFieldAudit.executeUpdate(); insertFieldAudit = getConnection().prepareStatement(INSERT_FIELD_AUDIT); insertFieldAudit.executeUpdate(); } finally { insertFieldAudit.close(); } }
@Test public void testBatchUpdateWithSqlParameterSource() throws Exception { SqlParameterSource[] ids = new SqlParameterSource[2]; ids[0] = new MapSqlParameterSource("id", 100); ids[1] = new MapSqlParameterSource("id", 200); final int[] rowsAffected = new int[] {1, 2}; given(preparedStatement.executeBatch()).willReturn(rowsAffected); given(connection.getMetaData()).willReturn(databaseMetaData); namedParameterTemplate = new NamedParameterJdbcTemplate(new JdbcTemplate(dataSource, false)); int[] actualRowsAffected = namedParameterTemplate.batchUpdate( "UPDATE NOSUCHTABLE SET DATE_DISPATCHED = SYSDATE WHERE ID = :id", ids); assertTrue("executed 2 updates", actualRowsAffected.length == 2); assertEquals(rowsAffected[0], actualRowsAffected[0]); assertEquals(rowsAffected[1], actualRowsAffected[1]); verify(connection).prepareStatement("UPDATE NOSUCHTABLE SET DATE_DISPATCHED = SYSDATE WHERE ID = ?"); verify(preparedStatement).setObject(1, 100); verify(preparedStatement).setObject(1, 200); verify(preparedStatement, times(2)).addBatch(); verify(preparedStatement, atLeastOnce()).close(); verify(connection, atLeastOnce()).close(); }
@NoWarning("OBL") void f(Connection con, Integer key) throws SQLException { StringBuffer sql = new StringBuffer("SELECT * FROM xxx WHERE xxx_id = ?"); PreparedStatement ps = con.prepareStatement(sql.toString()); try { ps.setInt(1, key.intValue()); ResultSet rs = ps.executeQuery(); try { rs.next(); int index = 1; Integer firstQuestionId = new Integer(rs.getInt(index++)); String description = rs.getString(index++); Float approvalScore = new Float(rs.getFloat(index++)); } finally { rs.close(); } } finally { ps.close(); } } }
@NoWarning("OBL") void updateResetFailuresToZeroOK2(String ipAddr, Connection conn) throws SQLException { PreparedStatement ps = conn.prepareStatement("UPDATE resetpasswordfailures SET failureCount=0 WHERE IPAddress=?"); try { ps.setString(1, ipAddr); ps.executeUpdate(); } finally { ps.close(); conn.close(); } }
@Test public void testQueryForListWithArgsAndSingleRowAndColumn() throws Exception { String sql = "SELECT AGE FROM CUSTMR WHERE ID < ?"; given(this.resultSet.next()).willReturn(true, false); given(this.resultSet.getObject(1)).willReturn(11); List<Map<String, Object>> li = this.template.queryForList(sql, new Object[] {3}); assertEquals("All rows returned", 1, li.size()); assertEquals("First row is Integer", 11, ((Integer) li.get(0).get("age")).intValue()); verify(this.preparedStatement).setObject(1, 3); verify(this.resultSet).close(); verify(this.preparedStatement).close(); }