libs/jdbc-x86/bcprov-jdk15on-1.70.jarBinary files differ
libs/jdbc-x86/kingbase8-8.6.0.jarBinary files differ
libs/jdbc-x86/kingbase8-8.6.0.jre6.jarBinary files differ
libs/jdbc-x86/kingbase8-8.6.0.jre7.jarBinary files differ
libs/jdbc-x86/postgresql-42.2.9.jarBinary files differ
libs/jdbc-x86/postgresql-42.2.9.jre6.jarBinary files differ
libs/jdbc-x86/postgresql-42.2.9.jre7.jarBinary files differ
pom.xml
@@ -153,6 +153,13 @@ <scope>system</scope> <systemPath>${basedir}/libs/jdbc-aarch/kingbase8-8.6.0.jar</systemPath> </dependency> <dependency> <groupId>com.kingbase</groupId> <artifactId>kingbase8</artifactId> <version>8.6.0</version> <scope>system</scope> <systemPath>${basedir}/libs/jdbc-x86/kingbase8-8.6.0.jar</systemPath> </dependency> <!--Mybatis分页插件 --> <dependency> src/main/java/com/genersoft/iot/vmp/gb28181/transmit/cmd/impl/SIPCommanderFroPlatform.java
@@ -598,7 +598,7 @@ SIPRequest notifyRequest = headerProviderPlatformProvider.createNotifyRequest(parentPlatform, catalogXmlContent, subscribeInfo); sipSender.transmitRequest(parentPlatform.getDeviceIp(), notifyRequest); sipSender.transmitRequest(parentPlatform.getDeviceIp(), notifyRequest, errorEvent, okEvent); } private String getCatalogXmlContentForCatalogAddOrUpdate(ParentPlatform parentPlatform, List<DeviceChannel> channels, int sumNum, String type, SubscribeInfo subscribeInfo) { @@ -610,7 +610,7 @@ .append("<CmdType>Catalog</CmdType>\r\n") .append("<SN>" + (int) ((Math.random() * 9 + 1) * 100000) + "</SN>\r\n") .append("<DeviceID>" + parentPlatform.getDeviceGBId() + "</DeviceID>\r\n") .append("<SumNum>1</SumNum>\r\n") .append("<SumNum>"+ channels.size() +"</SumNum>\r\n") .append("<DeviceList Num=\"" + channels.size() + "\">\r\n"); if (channels.size() > 0) { for (DeviceChannel channel : channels) { src/main/java/com/genersoft/iot/vmp/service/impl/GbStreamServiceImpl.java
@@ -250,9 +250,6 @@ if (platform == null) { return ; } if (ObjectUtils.isEmpty(catalogId)) { catalogId = platform.getDeviceGBId(); } if (platformGbStreamMapper.delByPlatformAndCatalogId(platformId, catalogId) > 0) { List<GbStream> gbStreams = platformGbStreamMapper.queryChannelInParentPlatformAndCatalog(platformId, catalogId); List<DeviceChannel> deviceChannelList = new ArrayList<>(); src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformGbStreamMapper.java
@@ -103,6 +103,9 @@ "</script>") void delByAppAndStreamsByPlatformId(@Param("gbStreams") List<GbStream> gbStreams, @Param("platformId") String platformId); @Delete("DELETE from wvp_platform_gb_stream WHERE platform_id=#{platformId} and catalog_id=#{catalogId}") @Delete("<script> "+ "DELETE from wvp_platform_gb_stream WHERE platform_id=#{platformId}" + " <if test='catalogId != null' > and catalog_id=#{catalogId}</if>" + "</script>") int delByPlatformAndCatalogId(@Param("platformId") String platformId, @Param("catalogId") String catalogId); } src/main/java/com/genersoft/iot/vmp/web/gb28181/ApiDeviceController.java
@@ -68,6 +68,7 @@ // if (logger.isDebugEnabled()) { // logger.debug("查询所有视频设备API调用"); // } JSONObject result = new JSONObject(); List<Device> devices; if (start == null || limit ==null) { @@ -80,7 +81,7 @@ } JSONArray deviceJSONList = new JSONArray(); for (Device device : devices) { devices.stream().forEach(device -> { JSONObject deviceJsonObject = new JSONObject(); deviceJsonObject.put("ID", device.getDeviceId()); deviceJsonObject.put("Name", device.getName()); @@ -99,7 +100,7 @@ deviceJsonObject.put("UpdatedAt", ""); deviceJsonObject.put("CreatedAt", ""); deviceJSONList.add(deviceJsonObject); } }); result.put("DeviceList",deviceJSONList); return result; } @@ -114,7 +115,6 @@ @RequestParam(required = false)String q, @RequestParam(required = false)Boolean online ){ JSONObject result = new JSONObject(); List<DeviceChannelExtend> deviceChannels; List<String> channelIds = null; @@ -127,13 +127,19 @@ deviceChannels = allDeviceChannelList; result.put("ChannelCount", deviceChannels.size()); }else { deviceChannels = storager.queryChannelsByDeviceIdWithStartAndLimit(serial,channelIds, null, null, online,start, limit); int total = allDeviceChannelList.size(); result.put("ChannelCount", total); if (start > allDeviceChannelList.size()) { deviceChannels = new ArrayList<>(); }else { if (start + limit < allDeviceChannelList.size()) { deviceChannels = allDeviceChannelList.subList(start, start + limit); }else { deviceChannels = allDeviceChannelList.subList(start, allDeviceChannelList.size()); } } result.put("ChannelCount", allDeviceChannelList.size()); } JSONArray channleJSONList = new JSONArray(); for (DeviceChannelExtend deviceChannelExtend : deviceChannels) { deviceChannels.stream().forEach(deviceChannelExtend -> { JSONObject deviceJOSNChannel = new JSONObject(); deviceJOSNChannel.put("ID", deviceChannelExtend.getChannelId()); deviceJOSNChannel.put("DeviceID", deviceChannelExtend.getDeviceId()); @@ -166,7 +172,7 @@ deviceJOSNChannel.put("StreamID", deviceChannelExtend.getStreamId()); // StreamID 直播流ID, 有值表示正在直播 deviceJOSNChannel.put("NumOutputs ", -1); // 直播在线人数 channleJSONList.add(deviceJOSNChannel); } }); result.put("ChannelList", channleJSONList); return result; } src/main/resources/all-application.yml
@@ -54,9 +54,9 @@ password: root123 hikari: connection-timeout: 20000 # 是客户端等待连接池连接的最大毫秒数 initialSize: 10 # 连接池初始化连接数 initialSize: 50 # 连接池初始化连接数 maximum-pool-size: 200 # 连接池最大连接数 minimum-idle: 5 # 连接池最小空闲连接数 minimum-idle: 10 # 连接池最小空闲连接数 idle-timeout: 300000 # 允许连接在连接池中空闲的最长时间(以毫秒为单位) max-lifetime: 1200000 # 是池中连接关闭后的最长生命周期(以毫秒为单位)