jsp에서 오라클 쿼리가 잘못되었다고 하는데 어디가 틀린건지 궁금합니다 ㅜㅜ

Question

public ArrayList getList(String lectureDivide, String searchType, String search, int pageNumber){ if(lectureDivide.equals("전체")) { lectureDivide = ""; } ArrayList evaluationList = null; String SQL = ""; Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; try { if(searchType.equals("최신순")) { SQL = "SELECT * FROM(SELECT a.*, ROWNUM rnum FROM EVALUATION WHERE lectureDivide LIKE '%' || ? || '%' AND CONCAT(lectureName, professorName, evaluationTitle, evaluationContent) LIKE '%' || ? || '%' ORDER BY evaluationID DESC)a WHERE rnum >= ? AND rnum <= ?"; } else if(searchType.equals("추천순")) { SQL = "SELECT * FROM(SELECT a.*, ROWNUM rnum FROM EVALUATION WHERE lectureDivide LIKE '%' || ? || '%' AND CONCAT(lectureName, professorName, evaluationTitle, evaluationContent) LIKE '%' || ? || '%' ORDER BY likeCount DESC)a WHERE rnum >= ? AND rnum <= ?"; } conn = DatabaseUtil.getConnection(); pstmt = conn.prepareStatement(SQL); pstmt.setString(1,lectureDivide); pstmt.setString(2,search); pstmt.setInt(3, (pageNumber * 5)); pstmt.setInt(4,((pageNumber *5) + 6)); rs = pstmt.executeQuery(); evaluationList = new ArrayList(); if(rs.next()) { EvaluationDTO evaluation = new EvaluationDTO( rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getInt(5), rs.getString(6), rs.getString(7), rs.getString(8), rs.getString(9), rs.getString(10), rs.getString(11), rs.getString(12), rs.getString(13), rs.getInt(14) ); evaluationList.add(evaluation); } } catch (Exception e) { e.printStackTrace(); } finally { try { if(conn != null) conn.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } try { if(pstmt != null) pstmt.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } try { if(rs != null) rs.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } return evaluationList; // 데이터베이스 오류 } 오류내용은 다음과 같고 ORA-00909: invalid number of arguments 도움이 필요합니다

더미 · Accepted Answer

CONCAT(lectureName, professorName, evaluationTitle, evaluationContent)

okmm · Answer

CONCAT(lectureName, professorName, evaluationTitle, evaluationContent) 이부분이 어떻게 틀린건가요..?

더미 · Answer

2개 인자만 됩니다.이정도는 찾아보세요..

jsp에서 오라클 쿼리가 잘못되었다고 하는데 어디가 틀린건지 궁금합니다 ㅜㅜ

3개의 답변

#rownum 목록