gnodet commented on code in PR #26845:
URL: https://github.com/apache/camel/pull/26845#discussion_r4094736933


##########
components/camel-sql/src/main/java/org/apache/camel/component/sql/SqlComponent.java:
##########
@@ -151,6 +158,56 @@ protected Endpoint createEndpoint(String uri, String 
remaining, Map<String, Obje
         return endpoint;
     }
 
+    @Override
+    public void onSecretRotation(Object source) throws Exception {
+        // Collect all DataSources this component can reach: the one injected 
directly (if any)
+        // plus all DataSource beans registered in the registry. The registry 
beans are typically
+        // not recreated during a route reload, so their connection pools 
still hold connections
+        // that were authenticated with the old credentials.
+        Set<DataSource> dataSources = 
getCamelContext().getRegistry().findByType(DataSource.class);
+        if (this.dataSource != null) {
+            dataSources.add(this.dataSource);
+        }
+
+        for (DataSource ds : dataSources) {
+            evictDataSourceConnections(ds, source);
+        }
+    }
+
+    /**
+     * Evicts stale connections from the given DataSource so that the pool 
rebuilds them with the rotated credentials.
+     * <p/>
+     * HikariCP is tried first via reflection (so camel-sql does not need a 
compile-time dependency on it). Any
+     * DataSource that does not expose {@code getHikariPoolMXBean()} is left 
untouched — the pool will pick up the new
+     * credentials on its own reconnect cycle when existing connections expire.
+     */
+    static void evictDataSourceConnections(DataSource ds, Object source) {

Review Comment:
   Fixed in 7be465732dba53e1bc830d454a65fd8ecf289ecb: extracted the shared 
eviction logic into `DataSourceHelper.evictDataSourceConnections()` in 
`camel-support`. Both `JdbcComponent` and `SqlComponent` now delegate to it.



##########
components/camel-jdbc/src/main/java/org/apache/camel/component/jdbc/JdbcComponent.java:
##########
@@ -114,6 +116,56 @@ public void setConnectionStrategy(ConnectionStrategy 
connectionStrategy) {
         this.connectionStrategy = connectionStrategy;
     }
 
+    @Override
+    public void onSecretRotation(Object source) throws Exception {
+        // Collect all DataSources this component can reach: the one injected 
directly (if any)
+        // plus all DataSource beans registered in the registry. The registry 
beans are typically
+        // not recreated during a route reload, so their connection pools 
still hold connections
+        // that were authenticated with the old credentials.
+        Set<DataSource> dataSources = 
getCamelContext().getRegistry().findByType(DataSource.class);
+        if (this.dataSource != null) {
+            dataSources.add(this.dataSource);

Review Comment:
   Fixed in 7be465732dba53e1bc830d454a65fd8ecf289ecb: replaced the plain 
`HashSet` with `Collections.newSetFromMap(new IdentityHashMap<>())` in both 
components. Same change applied in `SqlComponent.onSecretRotation()`.



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to