查询语句自动多执行一边
同代码同编译器 在我这里查询结果昙花一现 别的电脑不管win7win8 ie版本都上可以正确显示
我这的记录
Got 19 records.
=[2013-11-25 11:04:05,863] DEBUG
Fetching JDBC Connection from DataSource
=[2013-11-25 11:04:05,866] DEBUG
Query by the PreparedStatementCreator[sql={ SELECT COUNT(1) FROM (SELECT T_AREA.CFBZ,T_AREA.JCDID,T_AREA.DQMC FROM T_AREA WHERE 1=1 ) T}:params={[]}]
=[2013-11-25 11:04:08,442] DEBUG
SQL对象["SELECT T_AREA.CFBZ,T_AREA.JCDID,T_AREA.DQMC FROM T_AREA WHERE 1=1 and jcdid = '370300'"] 编译完成
=[2013-11-25 11:04:08,443] DEBUG
Fetching JDBC Connection from DataSource
=[2013-11-25 11:04:08,445] DEBUG
Fetching JDBC Connection from DataSource
=[2013-11-25 11:04:08,448] DEBUG
Query by the PreparedStatementCreator[sql={SELECT * FROM ( SELECT ROW_.*, ROWNUM ROWNUM_ FROM ( SELECT T_AREA.CFBZ,T_AREA.JCDID,T_AREA.DQMC FROM T_AREA WHERE 1=1 and jcdid = '370300' ) ROW_ WHERE ROWNUM <= ?) WHERE ROWNUM_ > ?}:params={[200, 0]}]
=[2013-11-25 11:04:08,450] DEBUG
Query with static sql[SELECT CODE CODE ,NAME NAME FROM DIC_DQMC WHERE 1=1 ]
=[2013-11-25 11:04:08,453] DEBUG
Got 1 records.
=[2013-11-25 11:04:08,453] DEBUG
Fetching JDBC Connection from DataSource
=[2013-11-25 11:04:08,455] DEBUG
Query by the PreparedStatementCreator[sql={ SELECT COUNT(1) FROM (SELECT T_AREA.CFBZ,T_AREA.JCDID,T_AREA.DQMC FROM T_AREA WHERE 1=1 and jcdid = '370300') T}:params={[]}]
=[2013-11-25 11:04:08,953] DEBUG
SQL对象["SELECT T_AREA.CFBZ,T_AREA.JCDID,T_AREA.DQMC FROM T_AREA WHERE 1=1 "] 编译完成
=[2013-11-25 11:04:08,953] DEBUG
Fetching JDBC Connection from DataSource
=[2013-11-25 11:04:08,956] DEBUG
Query by the PreparedStatementCreator[sql={SELECT * FROM ( SELECT ROW_.*, ROWNUM ROWNUM_ FROM ( SELECT T_AREA.CFBZ,T_AREA.JCDID,T_AREA.DQMC FROM T_AREA WHERE 1=1 ) ROW_ WHERE ROWNUM <= ?) WHERE ROWNUM_ > ?}:params={[200, 0]}]
=[2013-11-25 11:04:08,959] DEBUG
Got 19 records.
=[2013-11-25 11:04:08,959] DEBUG
Fetching JDBC Connection from DataSource
=[2013-11-25 11:04:08,960] DEBUG
Query by the PreparedStatementCreator[sql={ SELECT COUNT(1) FROM (SELECT T_AREA.CFBZ,T_AREA.JCDID,T_AREA.DQMC FROM T_AREA WHERE 1=1 ) T}:params={[]}]
=[2013-11-25 11:04:13,383] DEBUG
SQL对象["SELECT MSG_ID,DELIVERY_MODE FROM LIVE_MESSAGE_TEMP M WHERE SEND_TIME < '20131125 11:04:13' AND M.STAT = '1'"] 编译完成
=[2013-11-25 11:04:13,383] DEBUG
Fetching JDBC Connection from DataSource
=[2013-11-25 11:04:13,385] DEBUG
Query by the PreparedStatementCreator[sql={SELECT * FROM ( SELECT ROW_.*, ROWNUM ROWNUM_ FROM ( SELECT MSG_ID,DELIVERY_MODE FROM LIVE_MESSAGE_TEMP M WHERE SEND_TIME < '20131125 11:04:13' AND M.STAT = '1' ) ROW_ WHERE ROWNUM <= ?) WHERE ROWNUM_ > ?}:params={[10, 0]}]
=[2013-11-25 11:04:13,397] WARN
Translating SQLException with SQLState '42000' and errorCode '942' and message [ORA-00942: 表或视图不存在
]; SQL was [sql={SELECT * FROM ( SELECT ROW_.*, ROWNUM ROWNUM_ FROM ( SELECT MSG_ID,DELIVERY_MODE FROM LIVE_MESSAGE_TEMP M WHERE SEND_TIME < '20131125 11:04:13' AND M.STAT = '1' ) ROW_ WHERE ROWNUM <= ?) WHERE ROWNUM_ > ?}:params={[10, 0]}] for task [使用PreparedStatementCreator查询出错]
查询?sql? ,求解
分享到:
[解决办法]