b_localhost airbis May 28, 2015 5:02:48 PM org.apache.catalina.core.StandardWrapperValve invoke
mb_localhost airbis SEVERE: Servlet.service() for servlet [SLY Rest Application Servlet] in context with path [/rest] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT *
mb_localhost airbis FROM (
mb_localhost airbis SELECT
mb_localhost airbis sub.*,
mb_localhost airbis ROWNUM rn
mb_localhost airbis FROM
mb_localhost airbis (
mb_localhost airbis SELECT
mb_localhost airbis d.SERIAL AS serial,
mb_localhost airbis e.DT_CREATE AS dateCreated,
mb_localhost airbis a.NAME AS abonentName,
mb_localhost airbis a.PHONE AS abonentPhone,
mb_localhost airbis s.STATE_LEVEL AS stateName,
mb_localhost airbis s.STATE_NUM AS stateOrdinal,
mb_localhost airbis d.REPOSTS AS reposts,
mb_localhost airbis ss.SOCIAL AS social,
mb_localhost airbis ss.URL AS socialUrl,
mb_localhost airbis d.INITIATOR AS initiator,
mb_localhost airbis d.INITIATOR_INFO AS initiatorInfo,
mb_localhost airbis n.rn AS ordinal
mb_localhost airbis FROM EVENT_P_DATA d
mb_localhost airbis INNER JOIN EVENT e ON e.ID_EVENT = d.ID_EVENT
mb_localhost airbis INNER JOIN ABON a ON a.ID_ABON = e.ID_ABON
mb_localhost airbis INNER JOIN P_TMPL_STATE s ON s.ID = d.ID_STATE
mb_localhost airbis INNER JOIN (SELECT
mb_localhost airbis ROWNUM rn,
mb_localhost airbis ID_EVENT
mb_localhost airbis FROM (
mb_localhost airbis SELECT
mb_localhost airbis e.ID_EVENT,
mb_localhost airbis e.DT_CREATE
mb_localhost airbis FROM EVENT_P_DATA d
mb_localhost airbis INNER JOIN EVENT e ON e.ID_EVENT = d.ID_EVENT
mb_localhost airbis WHERE d.PASS_SERIAL IS NOT NULL
mb_localhost airbis AND e.ID_ACCOUNT = ?
mb_localhost airbis AND d.ID_PTMPL = ?
mb_localhost airbis ORDER BY e.DT_CREATE ASC
mb_localhost airbis )) n ON n.ID_EVENT = e.ID_EVENT
mb_localhost airbis LEFT JOIN SOCIAL_PROFILE ss ON ss.ID_SOCIAL_PROFILE = d.ID_SOCIAL_PROFILE
mb_localhost airbis WHERE d.PASS_SERIAL IS NOT NULL
mb_localhost airbis AND e.ID_ACCOUNT = ?
mb_localhost airbis AND d.ID_PTMPL = ? ORDER BY bonusNumber ASC
mb_localhost airbis ) sub
mb_localhost airbis WHERE ROWNUM <= ?
mb_localhost airbis ) sub2
mb_localhost airbis WHERE sub2.rn > ?]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: "BONUSNUMBER": invalid identifier
mb_localhost airbis ] with root cause
mb_localhost airbis java.sql.SQLSyntaxErrorException: ORA-00904: "BONUSNUMBER"