Project

General

Profile

Actions

Bug #92

closed

[API] Station 에러

Added by Deca Park about 1 year ago. Updated 8 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Start date:
08/11/2023
Due date:
% Done:

0%

Estimated time:
Spent time:

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 ?

Actions #1

Updated by bryant bryant about 1 year ago

  • Status changed from New to Resolved
  • Assignee changed from bryant bryant to Deca Park
Actions #2

Updated by Deca Park about 1 year ago

[API] GET /api/near_station_list

1.process (change)

  • add default condition: st_station.smart_order_yn = 'Y'
Actions #3

Updated by Deca Park about 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호선,경의중앙선"

Actions #4

Updated by Deca Park about 1 year ago

  • Subject changed from [API] 에러 to [API] Station 에러
Actions #5

Updated by bryant bryant about 1 year ago

  • Status changed from Feedback to Resolved
  • Assignee changed from bryant bryant to Deca Park
Actions #6

Updated by Deca Park 8 months ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF