SQL语句缺少空格

[清山云上]

21-Sep-2016 10:33:08.782 SEVERE [http-nio-80-exec-10] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [spring] in context with path [] threw exception [Request processing failed; nested exception is com.github.ltsopensource.store.jdbc.exception.JdbcException: Select SQL Error:
SELECT TIMESTAMP ,AVG(DAEMON_THREAD_COUNT) AS DAEMON_THREAD_COUNT ,AVG(THREAD_COUNT) AS THREAD_COUNT ,AVG(TOTAL_STARTED_THREAD_COUNT) AS TOTAL_STARTED_THREAD_COUNT ,AVG(DEAD_LOCKED_THREAD_COUNT) AS DEAD_LOCKED_THREAD_COUNT ,AVG(PROCESS_CPU_TIME_RATE) AS PROCESS_CPU_TIME_RATE FROM LTS_ADMIN_JVM_THREAD WHERE (TIMESTAMP BETWEEN ? AND ? ) GROUP BY TIMESTAMP ] with root cause
java.sql.SQLException: ORA-00904: "TIMESTAMPETWEEN": 标识符无效
Query: SELECT TIMESTAMP ,AVG(DAEMON_THREAD_COUNT) AS DAEMON_THREAD_COUNT ,AVG(THREAD_COUNT) AS THREAD_COUNT ,AVG(TOTAL_STARTED_THREAD_COUNT) AS TOTAL_STARTED_THREAD_COUNT ,AVG(DEAD_LOCKED_THREAD_COUNT) AS DEAD_LOCKED_THREAD_COUNT ,AVG(PROCESS_CPU_TIME_RATE) AS PROCESS_CPU_TIME_RATE FROM LTS_ADMIN_JVM_THREAD WHERE (TIMESTAMP BETWEEN ? AND ? ) GROUP BY TIMESTAMP Parameters: [1474414388000, 1474425188000]


打印出来的SQL是正确的，但不知道怎么报 "TIMESTAMPETWEEN": 标识符无效，我看全部SQL也只有 (TIMESTAMP BETWEEN ? AND ? 才有可能拼接成上面错误的SQL样子，但明明是有空格的 打了3-4个空格。 求解啊，调试到执行时 SQL都是正确的。 但报错却拼接在一起了

[快溜]

TIMESTAMPETWEEN是什么。。。用sql监视器监控一下看看

[清山云上]

[quote=引用 楼主 JiaLin_He 的回复:] TIMESTAMP BETWEEN 其实是这样的 你看上面日志打印的SQL 都是分开的， 但执行时却报 java.sql.SQLException: ORA-00904: "TIMESTAMPETWEEN": 标识符无效, 日志打印都是分开的。而且我调试到执行SQL时 都是分开的， 不知道怎么变了。

[清山云上]

已解决 oracle函数中有不足位数补空格的函数 LPAD和RPAD分别是左补位和右补位 repalce(lpad(字段名，共几位)，‘ ’，‘0’) 如运行 select replace(lpad('123',5),' ','0') from dual 结果是00123 即补足五位