cache connection

Chat2DB-Pro · Chat2DB-Pro · commit 91e384f5ddcd · 2024-05-16T00:00:11.000+08:00
diff --git a/chat2db-server/chat2db-spi/src/main/java/ai/chat2db/spi/sql/ConnectInfo.java b/chat2db-server/chat2db-spi/src/main/java/ai/chat2db/spi/sql/ConnectInfo.java
@@ -556,6 +556,7 @@ public ConnectInfo copy() {
         copy.setDriverConfig(this.getDriverConfig());
         copy.setSid(this.getSid());
         copy.setUrlWithOutDatabase(this.getUrlWithOutDatabase());
+        copy.setLastAccessTime(new Date());
         return copy;
     }
 
diff --git a/chat2db-server/chat2db-spi/src/main/java/ai/chat2db/spi/sql/ConnectionPool.java b/chat2db-server/chat2db-spi/src/main/java/ai/chat2db/spi/sql/ConnectionPool.java
@@ -120,6 +120,7 @@ public static void close(ConnectInfo connectInfo) {
             synchronized (lock) {
                 int n = lock.decrementRefCount();
                 if (n == 0) {
+                    lock.setLastAccessTime(new Date());
                     lock.setConnection(connectInfo.getConnection());
                 } else {
                     connectInfo.close();

Original file line number	Diff line number	Diff line change
`@@ -556,6 +556,7 @@ public ConnectInfo copy() {`
`556`	`556`	`copy.setDriverConfig(this.getDriverConfig());`
`557`	`557`	`copy.setSid(this.getSid());`
`558`	`558`	`copy.setUrlWithOutDatabase(this.getUrlWithOutDatabase());`
	`559`	`+ copy.setLastAccessTime(new Date());`
`559`	`560`	`return copy;`
`560`	`561`	`}`
`561`	`562`