attiya/ebike-plus
SHA256
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

sql修复、检测配置

Browse Source
This commit is contained in:
attiya 2025-12-25 16:57:00 +08:00
parent 6b69e31ac7
commit f761db3047
2 changed files with 13 additions and 15 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

10
ebike-gather/src/main/java/org/cdzy/gather/mqtt/MqttConnectionPool.java
View File

@ -48,14 +48,16 @@ public class MqttConnectionPool implements DisposableBean, InitializingBean {
config.setBlockWhenExhausted(true); // 必须设置为 true
config.setMaxWaitMillis(5000); // 等待5秒，不能无限等待
// 禁用空闲连接维护
// config.setTimeBetweenEvictionRuns(Duration.ofMillis(-1));
// 启用空闲连接维护
config.setTimeBetweenEvictionRuns(Duration.ofMinutes(5));
config.setSoftMinEvictableIdleTime(Duration.ofMinutes(30));
config.setMinEvictableIdleTime(Duration.ofMinutes(30));
// config.setSoftMinEvictableIdleTime(Duration.ofMinutes(30)); //开启则会驱逐（定期销毁空闲）
// config.setMinEvictableIdleTime(Duration.ofMinutes(30));
config.setNumTestsPerEvictionRun(-1);
config.setTestOnBorrow(false);
config.setTestOnReturn(false);
config.setTestOnBorrow(true);
config.setTestOnReturn(true);
config.setTestWhileIdle(true); // 空闲时验证（保持连接健康）
connectionPool = new GenericObjectPool<>(mqttConnectionFactory, config);

16
ebike-operations/src/main/resources/mapper/EbikeRegionMapper.xml
View File

@ -21,16 +21,12 @@
<select id="findAllRegionsOrderByDistance" resultType="com.cdzy.operations.model.entity.EbikeRegion">
SELECT
ebike_region.*,
ST_Distance(
region_polygon::geography,
ST_SetSRID(ST_MakePoint(#{lng}, #{lat}), 4326)::geography
) AS distance_meters,
ST_Contains(
region_polygon,
ST_SetSRID(ST_MakePoint(#{lng}, #{lat}), 4326)
) AS is_within_region
FROM ebike_region
WHERE is_deleted IS NOT TRUE
ST_Distance ( region_polygon::geometry, ST_SetSRID ( ST_MakePoint ( #{lng}, #{lat}), 4326 ) :: geography ) AS distance_meters,
ST_Contains ( ST_SetSRID(region_polygon::geometry, 4326), ST_SetSRID ( ST_MakePoint ( #{lng}, #{lat}), 4326 ) ) AS is_within_region
FROM
ebike_region
WHERE
is_deleted IS NOT TRUE
ORDER BY
is_within_region DESC,
distance_meters