String sql = "SELECT u.id, u.name, r.region_name, u.status " FROM TABLE(:id_list)) hosts: db_server + "ORDER BY r.region_name, u.name"; JOIN customers c ON c.customer_id = o.customer_id
+ "FROM users u " ORDER BY o.created_at DESC; become: true try (Connection con = dataSource.getConnection(); WHERE o.order_id IN (SELECT column_value
+ "JOIN regions r ON r.id = u.region_id " tasks: PreparedStatement ps = con.prepareStatement(sql)) { FROM TABLE(:id_list))
+ "LEFT JOIN activity a ON a.user_id = u.id " BEGIN - name: Pakete installieren ps.setString(1, "ACTIVE"); ORDER BY o.created_at DESC;
+ "WHERE u.status = ? AND a.last_seen > ? " DBMS_STATS.GATHER_TABLE_STATS(USER, 'ORDERS'); ansible.builtin.dnf: ps.setTimestamp(2, Timestamp.valueOf(since));
+ "ORDER BY r.region_name, u.name"; END; name: [postgresql-server, postgresql-contrib] try (ResultSet rs = ps.executeQuery()) { BEGIN
try (Connection con = dataSource.getConnection(); / state: present while (rs.next()) { DBMS_STATS.GATHER_TABLE_STATS(USER, 'ORDERS');
PreparedStatement ps = con.prepareStatement(sql)) { CREATE INDEX idx_activity_user_seen - name: Dienst starten long sysNumber = rs.getLong("id"); END;
ps.setString(1, "ACTIVE"); ON activity (user_id, last_seen DESC); ansible.builtin.systemd: if (sysNumber > 0 && rs.getString("name") != null) { /
ps.setTimestamp(2, Timestamp.valueOf(since)); name: postgresql result.add(new DataRow(sysNumber, rs.getString("name"))); CREATE INDEX idx_activity_user_seen
try (ResultSet rs = ps.executeQuery()) { SELECT o.order_id, o.created_at, c.customer_name state: started } ON activity (user_id, last_seen DESC);
while (rs.next()) { FROM orders o enabled: true }
long sysNumber = rs.getLong("id"); JOIN customers c ON c.customer_id = o.customer_id - name: PostgreSQL bereitstellen } SELECT o.order_id, o.created_at, c.customer_name
if (sysNumber > 0 && rs.getString("name") != null) { WHERE o.order_id IN (SELECT column_value hosts: db_server } catch (SQLException e) { FROM orders o
result.add(new DataRow(sysNumber, rs.getString("name"))); FROM TABLE(:id_list)) become: true log.error("Abfrage fehlgeschlagen: {}", e.getMessage()); JOIN customers c ON c.customer_id = o.customer_id
} ORDER BY o.created_at DESC; tasks: throw new DataAccessException(e); WHERE o.order_id IN (SELECT column_value
} - name: Pakete installieren } FROM TABLE(:id_list))
} BEGIN ansible.builtin.dnf: String sql = "SELECT u.id, u.name, r.region_name, u.status " ORDER BY o.created_at DESC;
} catch (SQLException e) { DBMS_STATS.GATHER_TABLE_STATS(USER, 'ORDERS'); name: [postgresql-server, postgresql-contrib] + "FROM users u "
log.error("Abfrage fehlgeschlagen: {}", e.getMessage()); END; state: present + "JOIN regions r ON r.id = u.region_id " BEGIN
throw new DataAccessException(e); / - name: Dienst starten + "LEFT JOIN activity a ON a.user_id = u.id " DBMS_STATS.GATHER_TABLE_STATS(USER, 'ORDERS');
} CREATE INDEX idx_activity_user_seen ansible.builtin.systemd: + "WHERE u.status = ? AND a.last_seen > ? " END;
String sql = "SELECT u.id, u.name, r.region_name, u.status " ON activity (user_id, last_seen DESC); name: postgresql + "ORDER BY r.region_name, u.name"; /
+ "FROM users u " state: started try (Connection con = dataSource.getConnection(); CREATE INDEX idx_activity_user_seen
+ "JOIN regions r ON r.id = u.region_id " SELECT o.order_id, o.created_at, c.customer_name enabled: true PreparedStatement ps = con.prepareStatement(sql)) { ON activity (user_id, last_seen DESC);
+ "LEFT JOIN activity a ON a.user_id = u.id " FROM orders o - name: PostgreSQL bereitstellen ps.setString(1, "ACTIVE");
+ "WHERE u.status = ? AND a.last_seen > ? " JOIN customers c ON c.customer_id = o.customer_id hosts: db_server ps.setTimestamp(2, Timestamp.valueOf(since)); SELECT o.order_id, o.created_at, c.customer_name
+ "ORDER BY r.region_name, u.name"; WHERE o.order_id IN (SELECT column_value become: true try (ResultSet rs = ps.executeQuery()) { FROM orders o
try (Connection con = dataSource.getConnection(); FROM TABLE(:id_list)) tasks: while (rs.next()) { JOIN customers c ON c.customer_id = o.customer_id
PreparedStatement ps = con.prepareStatement(sql)) { ORDER BY o.created_at DESC; - name: Pakete installieren long sysNumber = rs.getLong("id"); WHERE o.order_id IN (SELECT column_value
ps.setString(1, "ACTIVE"); ansible.builtin.dnf: if (sysNumber > 0 && rs.getString("name") != null) { FROM TABLE(:id_list))
ps.setTimestamp(2, Timestamp.valueOf(since)); BEGIN name: [postgresql-server, postgresql-contrib] result.add(new DataRow(sysNumber, rs.getString("name"))); ORDER BY o.created_at DESC;
try (ResultSet rs = ps.executeQuery()) { DBMS_STATS.GATHER_TABLE_STATS(USER, 'ORDERS'); state: present }
while (rs.next()) { END; - name: Dienst starten } BEGIN
long sysNumber = rs.getLong("id"); / ansible.builtin.systemd: } DBMS_STATS.GATHER_TABLE_STATS(USER, 'ORDERS');
if (sysNumber > 0 && rs.getString("name") != null) { CREATE INDEX idx_activity_user_seen name: postgresql } catch (SQLException e) { END;
result.add(new DataRow(sysNumber, rs.getString("name"))); ON activity (user_id, last_seen DESC); state: started log.error("Abfrage fehlgeschlagen: {}", e.getMessage()); /
} enabled: true throw new DataAccessException(e); CREATE INDEX idx_activity_user_seen
} SELECT o.order_id, o.created_at, c.customer_name - name: PostgreSQL bereitstellen } ON activity (user_id, last_seen DESC);
} FROM orders o hosts: db_server String sql = "SELECT u.id, u.name, r.region_name, u.status "
} catch (SQLException e) { JOIN customers c ON c.customer_id = o.customer_id become: true + "FROM users u " SELECT o.order_id, o.created_at, c.customer_name
log.error("Abfrage fehlgeschlagen: {}", e.getMessage()); WHERE o.order_id IN (SELECT column_value tasks: + "JOIN regions r ON r.id = u.region_id " FROM orders o
throw new DataAccessException(e); FROM TABLE(:id_list)) - name: Pakete installieren + "LEFT JOIN activity a ON a.user_id = u.id " JOIN customers c ON c.customer_id = o.customer_id
} ORDER BY o.created_at DESC; ansible.builtin.dnf: + "WHERE u.status = ? AND a.last_seen > ? " WHERE o.order_id IN (SELECT column_value
String sql = "SELECT u.id, u.name, r.region_name, u.status " name: [postgresql-server, postgresql-contrib] + "ORDER BY r.region_name, u.name"; FROM TABLE(:id_list))
+ "FROM users u " BEGIN state: present try (Connection con = dataSource.getConnection(); ORDER BY o.created_at DESC;
+ "JOIN regions r ON r.id = u.region_id " DBMS_STATS.GATHER_TABLE_STATS(USER, 'ORDERS'); - name: Dienst starten PreparedStatement ps = con.prepareStatement(sql)) {
+ "LEFT JOIN activity a ON a.user_id = u.id " END; ansible.builtin.systemd: ps.setString(1, "ACTIVE"); BEGIN
+ "WHERE u.status = ? AND a.last_seen > ? " / name: postgresql ps.setTimestamp(2, Timestamp.valueOf(since)); DBMS_STATS.GATHER_TABLE_STATS(USER, 'ORDERS');
+ "ORDER BY r.region_name, u.name"; CREATE INDEX idx_activity_user_seen state: started try (ResultSet rs = ps.executeQuery()) { END;
try (Connection con = dataSource.getConnection(); ON activity (user_id, last_seen DESC); enabled: true while (rs.next()) { /
PreparedStatement ps = con.prepareStatement(sql)) { - name: PostgreSQL bereitstellen long sysNumber = rs.getLong("id"); CREATE INDEX idx_activity_user_seen
ps.setString(1, "ACTIVE"); SELECT o.order_id, o.created_at, c.customer_name hosts: db_server if (sysNumber > 0 && rs.getString("name") != null) { ON activity (user_id, last_seen DESC);
ps.setTimestamp(2, Timestamp.valueOf(since)); FROM orders o become: true result.add(new DataRow(sysNumber, rs.getString("name")));
try (ResultSet rs = ps.executeQuery()) { JOIN customers c ON c.customer_id = o.customer_id tasks: } SELECT o.order_id, o.created_at, c.customer_name
while (rs.next()) { WHERE o.order_id IN (SELECT column_value - name: Pakete installieren } FROM orders o
Datenbanknahe IT-Systeme // souverän, offen, resilient
Mit 2008 geht ein weiteres erfolgreiches Jahr zu Ende. Dafür möchten wir uns bei allen Kunden und Partnern bedanken und wünschen frohe Weihnachten und einen guten Start ins Neue Jahr.
Dieses Jahr lagen unsere Arbeitsschwerpunkte in den Bereichen:
Trotz Finanzkrise blicken wir sehr optimistisch in das Jahr 2009 und planen bereits einige interessante Neuerungen.
Weitere Beiträge
Interessiert? Sprechen Sie mich gerne an.
Schreiben Sie mir einfach eine kurze E-Mail, und wir finden gemeinsam einen Termin für ein Erstgespräch. Darin klären wir, wo es in Ihrer IT konkret hakt und ob der Modernisierungs-Workshop der passende erste Schritt ist. Eine Stunde per Video oder Telefon, kostenfrei und ohne Verpflichtung.