476477478479480481482483484485486
logger.trace("inserted " + inserted + " rows"); } } catch(SQLException e) { logger.error("",e); throw new WorkspaceDatabaseException(e); } finally { try { if (pstmt != null) { pstmt.close(); }
515516517518519520521522523524525
pstmt.executeUpdate(); } } catch(SQLException e) { logger.error("",e); throw new WorkspaceDatabaseException(e); } finally { try { if (pstmt != null) { pstmt.close(); }
550551552553554555556557558559560
logger.trace("deleted " + deleted + " rows"); } } catch(SQLException e) { logger.error("",e); throw new WorkspaceDatabaseException(e); } finally { try { if (pstmt != null) { pstmt.close(); }
580581582583584585586587588589590
pstmt = c.prepareStatement(SQL_UPDATE_CURSOR_POSITION); pstmt.setLong(1, filepos); pstmt.executeUpdate(); } catch(SQLException e) { logger.error("",e); throw new WorkspaceDatabaseException(e); } finally { try { if (pstmt != null) { pstmt.close(); }
617618619620621622623624625626627
return rs.getLong(1); } catch(SQLException e) { logger.error("",e); throw new WorkspaceDatabaseException(e); } finally { try { if (rs != null) { rs.close(); }
677678679680681682683684685686687
pstmt = null; } } catch(SQLException e) { logger.error("",e); throw new WorkspaceDatabaseException(e); } finally { try { if (pstmt != null) { pstmt.close(); }
696697698699700701702703
private Connection getConnection() throws WorkspaceDatabaseException { try { return this.dataSource.getConnection(); } catch (SQLException e) { throw new WorkspaceDatabaseException(e); } }