sql = SELECT fs_chain_store.customer_no,
fs_customer.customer_name,
sum(pos_store_daily_sale.sale_num),
sum(pos_store_daily_sale.sale_money),
sum(pos_store_daily_sale.finally_money),
sum(pos_store_daily_sale.cost_money),
round(sum(isnull(pos_store_daily_sale.finally_money,0)-isnull(pos_store_daily_sale.cost_money,0)),2),
0.0,
round(sum(isnull(pos_store_daily_sale.finally_money,0)-isnull(pos_store_daily_sale.cost_money,0)),2)
FROM fs_chain_store,
fs_customer,
pos_store_daily_sale
WHERE ( fs_chain_store.customer_no = fs_customer.customer_no ) and
( fs_chain_store.store_no = pos_store_daily_sale.store_no )
GROUP BY fs_chain_store.customer_no,
fs_customer.customer_name
ORDER BY fs_chain_store.customer_no ASC st = context.getConnection().createStatement();
datars = st.executeQuery(sql);不是每次都返回错误 java.sql.sqlexception :JZOr2:该查询无结果集
偶尔会有这个错误
如果我把 group by去掉,也是没有问题的
我估计是jconnet2的问题,不知道有没有高手遇到过这个问题,不吝赐教
fs_customer.customer_name,
sum(pos_store_daily_sale.sale_num),
sum(pos_store_daily_sale.sale_money),
sum(pos_store_daily_sale.finally_money),
sum(pos_store_daily_sale.cost_money),
round(sum(isnull(pos_store_daily_sale.finally_money,0)-isnull(pos_store_daily_sale.cost_money,0)),2),
0.0,
round(sum(isnull(pos_store_daily_sale.finally_money,0)-isnull(pos_store_daily_sale.cost_money,0)),2)
FROM fs_chain_store,
fs_customer,
pos_store_daily_sale
WHERE ( fs_chain_store.customer_no = fs_customer.customer_no ) and
( fs_chain_store.store_no = pos_store_daily_sale.store_no )
GROUP BY fs_chain_store.customer_no,
fs_customer.customer_name
ORDER BY fs_chain_store.customer_no ASC st = context.getConnection().createStatement();
datars = st.executeQuery(sql);不是每次都返回错误 java.sql.sqlexception :JZOr2:该查询无结果集
偶尔会有这个错误
如果我把 group by去掉,也是没有问题的
我估计是jconnet2的问题,不知道有没有高手遇到过这个问题,不吝赐教
建议先优化数据库性能,不行再延长等待时间(maxWait="5000")。
欢迎交流:bbs.htok.net
加上参数试试