private void doDeleteUnrelated() throws SQLException {
Connection conn = source.getConnection();
Statement stmt = conn.createStatement();
try {
stmt.executeUpdate(
"delete from THUMBNAILS where DIGOBJEKTID not in (select ID from DIGOBJEKT)");
} finally {
SQLQuery.tryClose(stmt);
}
}
private IterableResult<Thumbnail> doFindMissing() throws SQLException {
Connection conn = source.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = null;
try {
rs = stmt.executeQuery(SQLQuery.getFindMissingThumbnails());
return new ThumbnailResult(rs, stmt);
} finally {
if (rs == null) {
SQLQuery.tryClose(stmt);
}
}
}
private void doInsert(BigDecimal digiObjId, String mimeType, byte[] contents)
throws SQLException {
Connection conn = source.getConnection();
PreparedStatement pstmt =
conn.prepareStatement(
"insert into THUMBNAILS (DIGOBJEKTID, MIME, CONTENTS) values (?, ?, ?)");
try {
pstmt.setBigDecimal(1, digiObjId);
pstmt.setString(2, mimeType);
pstmt.setBytes(3, contents);
pstmt.executeUpdate();
} finally {
SQLQuery.tryClose(pstmt);
}
}
