Bug #92
closed[API] Station 에러
Description
[API] /api/point_station_list?latitude=37.541&longitude=126.986
- server error happens
2023-08-11 19:15:33,325 ERROR [com.stoneitgt.user.controller.StationController]
### Error querying database. Cause: java.sql.SQLException: Out of range error: Latitude should be [-90,90] in function ST_Distance_Sphere.
### The error may exist in file [/home/korail_store_api/webapp/WEB-INF/classes/egovframework/mapper/user/StationMapper.xml]
### The error may involve com.stoneitgt.user.mapper.StationMapper.selectPagination-Inline
### The error occurred while setting parameters
### SQL: SELECT station.* , (SELECT GROUP_CONCAT(cc.code_name SEPARATOR ', ') FROM st_code_dtl cc WHERE cc.grp_code = 'SL' AND FIND_IN_SET(cc.code, station.station_lines)) AS stationLinesName , ST_Distance_Sphere( point(?, ?), point(station.longitude, station.latitude) ) AS distance FROM st_station station WHERE station.smart_order_yn = ? AND station.longitude IS NOT NULL AND station.latitude IS NOT NULL ORDER BY distance ASC LIMIT ? OFFSET ?
Updated by bryant bryant over 1 year ago
- Status changed from New to Resolved
- Assignee changed from bryant bryant to Deca Park
Updated by Deca Park over 1 year ago
[API] GET /api/near_station_list
1.process (change)
- add default condition: st_station.smart_order_yn = 'Y'
Updated by Deca Park over 1 year ago
- Status changed from Resolved to Feedback
- Assignee changed from Deca Park to bryant bryant
[API] GET /api/point_station_list
1.API spec
- refer to Station sheet on #32 - 20230819
2.Response
1) Add 2 fields
station_lines string 역노선코드 (Code: SL)
station_lines_name string 역노선코드명
ex) station_lines : "I4101,I4108"
station_lines_name : "수도권 1호선,경의중앙선"
Updated by Deca Park over 1 year ago
- Subject changed from [API] 에러 to [API] Station 에러
Updated by bryant bryant over 1 year ago
- Status changed from Feedback to Resolved
- Assignee changed from bryant bryant to Deca Park