PreparedStatement buildPreparedStatement() { return buildPreparedStatement(true); }
public ResultSetIterableBase() { try { start = System.currentTimeMillis(); logExecution(); rs = buildPreparedStatement().executeQuery(); afterExecQuery = System.currentTimeMillis(); } catch (SQLException ex) { throw new Sql2oException("Database error: " + ex.getMessage(), ex); } }
/** * Adds a set of parameters to this <code>Query</code> * object's batch of commands. <br/> * * If maxBatchRecords is more than 0, executeBatch is called upon adding that many * commands to the batch. <br/> * * The current number of batched commands is accessible via the <code>getCurrentBatchRecords()</code> * method. */ public Query addToBatch(){ try { buildPreparedStatement(false).addBatch(); if (this.maxBatchRecords > 0){ if(++this.currentBatchRecords % this.maxBatchRecords == 0) { this.executeBatch(); } } } catch (SQLException e) { throw new Sql2oException("Error while adding statement to batch", e); } return this; }
public Object executeScalar() { long start = System.currentTimeMillis(); logExecution(); try (final PreparedStatement ps = buildPreparedStatement(); final ResultSet rs = ps.executeQuery()) { if (rs.next()) { Object o = getQuirks().getRSVal(rs, 1); long end = System.currentTimeMillis(); logger.debug("total: {} ms; executed scalar [{}]", new Object[]{ end - start, this.getName() == null ? "No name" : this.getName() }); return o; } else { return null; } } catch (SQLException e) { this.connection.onException(); throw new Sql2oException("Database error occurred while running executeScalar: " + e.getMessage(), e); } finally { closeConnectionIfNecessary(); } }
public Connection executeUpdate(){ long start = System.currentTimeMillis(); try{ logExecution(); PreparedStatement statement = buildPreparedStatement(); this.connection.setResult(statement.executeUpdate()); this.connection.setKeys(this.returnGeneratedKeys ? statement.getGeneratedKeys() : null); connection.setCanGetKeys(this.returnGeneratedKeys); } catch(SQLException ex){ this.connection.onException(); throw new Sql2oException("Error in executeUpdate, " + ex.getMessage(), ex); } finally { closeConnectionIfNecessary(); } long end = System.currentTimeMillis(); logger.debug("total: {} ms; executed update [{}]", new Object[]{ end - start, this.getName() == null ? "No name" : this.getName() }); return this.connection; }
public Connection executeBatch() throws Sql2oException { long start = System.currentTimeMillis(); try { logExecution(); PreparedStatement statement = buildPreparedStatement(); connection.setBatchResult(statement.executeBatch()); this.currentBatchRecords = 0; try { connection.setKeys(this.returnGeneratedKeys ? statement.getGeneratedKeys() : null); connection.setCanGetKeys(this.returnGeneratedKeys); } catch (SQLException sqlex) { throw new Sql2oException("Error while trying to fetch generated keys from database. If you are not expecting any generated keys, fix this error by setting the fetchGeneratedKeys parameter in the createQuery() method to 'false'", sqlex); } } catch (Throwable e) { this.connection.onException(); throw new Sql2oException("Error while executing batch operation: " + e.getMessage(), e); } finally { closeConnectionIfNecessary(); } long end = System.currentTimeMillis(); logger.debug("total: {} ms; executed batch [{}]", new Object[]{ end - start, this.getName() == null ? "No name" : this.getName() }); return this.connection; }
PreparedStatement buildPreparedStatement() { return buildPreparedStatement(true); }
PreparedStatement buildPreparedStatement() { return buildPreparedStatement(true); }
public ResultSetIterableBase() { try { start = System.currentTimeMillis(); logExecution(); rs = buildPreparedStatement().executeQuery(); afterExecQuery = System.currentTimeMillis(); } catch (SQLException ex) { throw new Sql2oException("Database error: " + ex.getMessage(), ex); } }
public ResultSetIterableBase() { try { start = System.currentTimeMillis(); logExecution(); rs = buildPreparedStatement().executeQuery(); afterExecQuery = System.currentTimeMillis(); } catch (SQLException ex) { throw new Sql2oException("Database error: " + ex.getMessage(), ex); } }
/** * Adds a set of parameters to this <code>Query</code> * object's batch of commands. <br/> * <p> * If maxBatchRecords is more than 0, executeBatch is called upon adding that many * commands to the batch. <br/> * <p> * The current number of batched commands is accessible via the <code>getCurrentBatchRecords()</code> * method. */ public Query addToBatch() { try { buildPreparedStatement(false).addBatch(); if (this.maxBatchRecords > 0) { if (++this.currentBatchRecords % this.maxBatchRecords == 0) { this.executeBatch(); } } } catch (SQLException e) { throw new Sql2oException("Error while adding statement to batch", e); } return this; }
/** * Adds a set of parameters to this <code>Query</code> * object's batch of commands. <br/> * * If maxBatchRecords is more than 0, executeBatch is called upon adding that many * commands to the batch. <br/> * * The current number of batched commands is accessible via the <code>getCurrentBatchRecords()</code> * method. */ public Query addToBatch(){ try { buildPreparedStatement(false).addBatch(); if (this.maxBatchRecords > 0){ if(++this.currentBatchRecords % this.maxBatchRecords == 0) { this.executeBatch(); } } } catch (SQLException e) { throw new Sql2oException("Error while adding statement to batch", e); } return this; }
public Object executeScalar() { long start = System.currentTimeMillis(); try { logExecution(); ResultSet rs = buildPreparedStatement().executeQuery(); if (rs.next()) { Object o = getQuirks().getRSVal(rs, 1); if (Anima.of().isEnableSQLStatistic() && log.isDebugEnabled()) { long end = System.currentTimeMillis(); log.debug("total: {} ms; executed scalar [{}]", end - start, this.getName() == null ? "No name" : this.getName()); } return o; } else { return null; } } catch (SQLException e) { this.connection.onException(); throw new Sql2oException("Database error occurred while running executeScalar: " + e.getMessage(), e); } finally { closeConnectionIfNecessary(); } }
public Connection executeUpdate() { long start = System.currentTimeMillis(); try { logExecution(); PreparedStatement statement = buildPreparedStatement(); this.connection.setResult(statement.executeUpdate()); this.connection.setKeys(this.returnGeneratedKeys ? statement.getGeneratedKeys() : null); connection.setCanGetKeys(this.returnGeneratedKeys); } catch (SQLException ex) { this.connection.onException(); throw new Sql2oException("Error in executeUpdate, " + ex.getMessage(), ex); } finally { closeConnectionIfNecessary(); } if (Anima.of().isEnableSQLStatistic() && log.isDebugEnabled()) { long end = System.currentTimeMillis(); log.debug("total: {} ms; executed update [{}]", end - start, this.getName() == null ? "No name" : this.getName()); } return this.connection; }
public Object executeScalar() { long start = System.currentTimeMillis(); logExecution(); try (final PreparedStatement ps = buildPreparedStatement(); final ResultSet rs = ps.executeQuery()) { if (rs.next()) { Object o = getQuirks().getRSVal(rs, 1); long end = System.currentTimeMillis(); logger.debug("total: {} ms; executed scalar [{}]", new Object[]{ end - start, this.getName() == null ? "No name" : this.getName() }); return o; } else { return null; } } catch (SQLException e) { this.connection.onException(); throw new Sql2oException("Database error occurred while running executeScalar: " + e.getMessage(), e); } finally { closeConnectionIfNecessary(); } }
public Connection executeBatch() throws Sql2oException { long start = System.currentTimeMillis(); try { logExecution(); PreparedStatement statement = buildPreparedStatement(); connection.setBatchResult(statement.executeBatch()); this.currentBatchRecords = 0; try { connection.setKeys(this.returnGeneratedKeys ? statement.getGeneratedKeys() : null); connection.setCanGetKeys(this.returnGeneratedKeys); } catch (SQLException sqlex) { throw new Sql2oException("Error while trying to fetch generated keys from database. If you are not expecting any generated keys, fix this error by setting the fetchGeneratedKeys parameter in the createQuery() method to 'false'", sqlex); } } catch (Throwable e) { this.connection.onException(); throw new Sql2oException("Error while executing batch operation: " + e.getMessage(), e); } finally { closeConnectionIfNecessary(); } if (Anima.of().isEnableSQLStatistic() && log.isDebugEnabled()) { long end = System.currentTimeMillis(); log.debug("total: {} ms; executed batch [{}]", end - start, this.getName() == null ? "No name" : this.getName()); } return this.connection; }
public Connection executeUpdate(){ long start = System.currentTimeMillis(); try{ logExecution(); PreparedStatement statement = buildPreparedStatement(); this.connection.setResult(statement.executeUpdate()); this.connection.setKeys(this.returnGeneratedKeys ? statement.getGeneratedKeys() : null); connection.setCanGetKeys(this.returnGeneratedKeys); } catch(SQLException ex){ this.connection.onException(); throw new Sql2oException("Error in executeUpdate, " + ex.getMessage(), ex); } finally { closeConnectionIfNecessary(); } long end = System.currentTimeMillis(); logger.debug("total: {} ms; executed update [{}]", new Object[]{ end - start, this.getName() == null ? "No name" : this.getName() }); return this.connection; }
public Connection executeBatch() throws Sql2oException { long start = System.currentTimeMillis(); try { logExecution(); PreparedStatement statement = buildPreparedStatement(); connection.setBatchResult(statement.executeBatch()); this.currentBatchRecords = 0; try { connection.setKeys(this.returnGeneratedKeys ? statement.getGeneratedKeys() : null); connection.setCanGetKeys(this.returnGeneratedKeys); } catch (SQLException sqlex) { throw new Sql2oException("Error while trying to fetch generated keys from database. If you are not expecting any generated keys, fix this error by setting the fetchGeneratedKeys parameter in the createQuery() method to 'false'", sqlex); } } catch (Throwable e) { this.connection.onException(); throw new Sql2oException("Error while executing batch operation: " + e.getMessage(), e); } finally { closeConnectionIfNecessary(); } long end = System.currentTimeMillis(); logger.debug("total: {} ms; executed batch [{}]", new Object[]{ end - start, this.getName() == null ? "No name" : this.getName() }); return this.connection; }