023-03-10 03:57:05.836 ERROR 28224 --- [nio-8080-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM ("SELECT A.*, ROWNUM RNUM FROM ( SELECT DISTINCT
nested exception is java.sql.SQLSyntaxErrorException: ORA-00911: invalid character ] with root cause
oracle.jdbc.OracleDatabaseException: ORA-00911: invalid character
Query was like:
("SELECT A.*, ROWNUM RNUM FROM ( SELECT DISTINCT xxxxCD, xxx_NM, xxxx_NM, CREATED_DT, STATUS_CD, PRORATION_CD, ENTERPRISE_DEACTIVATED_DT,\r\n"+ " ("SELECT CONTRACT_NM FROM AGENCyyyyy A WHERE A.AyD=P.AGENCY_yy etc,....
am using spring JDBCTemplate to execute queries. And the code uses RowMapper or RowExtractor.
Now there seems to be some problem while executing a Query which contains a nested query in the FROM clause. When I test the query in the Workbench or Mysql Console, it works perfectly fine.
