NutzCN Logo
问答 用dao sql聚合函数 报错
发布于 2345天前 作者 少年不再年少 1405 次浏览 复制 上一个帖子 下一个帖子
标签:
---------111[ActivatingQuantity [id=600, apkId=1, deviceId=109, createtime=2017-11-22 15:02:33.0, time=1], ActivatingQuantity [id=640, apkId=1, deviceId=109, createtime=2017-11-22 15:11:34.0, time=2], ActivatingQuantity [id=641, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=642, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=643, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=644, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=645, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=646, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=647, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=648, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=649, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=650, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=651, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=652, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=653, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=654, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=655, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=656, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=657, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=658, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=659, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=660, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=661, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=662, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=663, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=664, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=665, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=666, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=667, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=668, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=669, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=670, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=671, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=672, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=673, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=674, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=675, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=2], ActivatingQuantity [id=676, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=3], ActivatingQuantity [id=677, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=4], ActivatingQuantity [id=678, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=5], ActivatingQuantity [id=679, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=2], ActivatingQuantity [id=680, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=3], ActivatingQuantity [id=681, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=4], ActivatingQuantity [id=682, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=5], ActivatingQuantity [id=683, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=684, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=685, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=686, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=687, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=688, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=689, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=690, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=691, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=692, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=693, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=694, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=695, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=696, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=697, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=698, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=699, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=700, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=701, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=702, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=703, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=704, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=705, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=706, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=707, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=708, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=709, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=710, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=711, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=712, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=713, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=714, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=715, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=716, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=717, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=718, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=719, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=720, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=721, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=722, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=723, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=724, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=725, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=726, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=727, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=728, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=729, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=730, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=731, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=732, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=733, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=734, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=735, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=736, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=737, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=738, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=739, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=740, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=741, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=742, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=743, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=744, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=745, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=746, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=747, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=748, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=749, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=750, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=751, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=752, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=753, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=754, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=755, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=756, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=757, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=758, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=759, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=760, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=761, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=762, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=763, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=764, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=765, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=766, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=767, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=768, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=769, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=770, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=771, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=772, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=773, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=774, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=775, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=776, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=777, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=778, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=779, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=780, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=781, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=782, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=783, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=784, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=785, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=786, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=787, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=788, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=789, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=790, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=791, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=792, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=793, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=794, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=795, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=796, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=797, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=798, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=799, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=800, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=801, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=802, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=803, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=804, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=805, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=806, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=807, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=808, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=809, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=810, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=811, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=812, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=813, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=814, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=815, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=816, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=817, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=818, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=819, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=820, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=821, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=822, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=823, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=824, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=825, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=826, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=827, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=828, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=829, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=830, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=831, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=832, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=833, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=834, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=835, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=836, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=837, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=838, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=839, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=840, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=841, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=842, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=843, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=844, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=845, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=846, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=847, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=848, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=849, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=850, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=851, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=852, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=853, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=854, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=855, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=856, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=857, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=858, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=859, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=860, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=861, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=862, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=863, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=864, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=865, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=866, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=867, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=868, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=869, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=870, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=871, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=872, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=873, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=874, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=875, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=876, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=877, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=878, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=879, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=880, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=881, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=882, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=883, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=884, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=885, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=886, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=887, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=888, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=889, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=890, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=891, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=892, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=893, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=894, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=895, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=896, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=897, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=898, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=899, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=900, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=901, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=902, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=903, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=904, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=905, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=906, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=907, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=908, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=909, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=910, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=911, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=912, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=913, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=914, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=915, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=916, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=917, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=918, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=919, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=920, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=921, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=922, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=923, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=924, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=925, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=926, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=927, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=928, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=929, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=930, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=931, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=932, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=933, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=934, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=935, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=936, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=937, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=938, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=939, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=940, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=941, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=942, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=943, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=944, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=945, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=946, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=947, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=948, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=949, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=950, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=951, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=952, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=953, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=954, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5]]
2017-11-23 10:33:50,997 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT max(q_createtime) FROM t_activating_quantity  WHERE apkId=? AND deviceId=?
    | 1 |   2 |
    |---|-----|
    | 1 | 109 |
  For example:> "SELECT max(q_createtime) FROM t_activating_quantity  WHERE apkId=1 AND deviceId=109"
2017-11-23 10:33:51,000 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247)
	at org.nutz.dao.impl.NutDao.func2(NutDao.java:767)
	at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)
2017-11-23 10:33:51,003 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN  - Error@/api/advert/quantity :
org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT max(q_createtime) FROM t_activating_quantity  WHERE apkId=1 AND deviceId=109'
PreparedStatement: 
'SELECT max(q_createtime) FROM t_activating_quantity  WHERE apkId=? AND deviceId=?'
CaseMessage=Unknown column 'apkId' in 'where clause'
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247)
	at org.nutz.dao.impl.NutDao.func2(NutDao.java:767)
	at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
	... 50 more
2017-11-23 10:34:26,045 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/api/advert/quantity : PluginDataModule.ClientInfo(PluginDataModule.java:175)
2017-11-23 10:34:26,046 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'pluginDataModule'<class com.woyaofa.module.api.PluginDataModule>
------------[ [PackageName=com.UCMobile, Date_Time=Thu Nov 23 09:50:44 CST 2017, CS_INT=5]]
2017-11-23 10:34:26,085 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_preinstall_apk  WHERE c_package_name=?
    |            1 |
    |--------------|
    | com.UCMobile |
  For example:> "SELECT * FROM t_preinstall_apk  WHERE c_package_name='com.UCMobile'"
2017-11-23 10:34:26,131 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device  WHERE c_imei1=?
    |               1 |
    |-----------------|
    | 865687020107973 |
  For example:> "SELECT * FROM t_device  WHERE c_imei1='865687020107973'"
2017-11-23 10:34:26,170 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_activating_quantity  WHERE q_apkId=? AND q_deviceId=?
    | 1 |   2 |
    |---|-----|
    | 1 | 109 |
  For example:> "SELECT * FROM t_activating_quantity  WHERE q_apkId=1 AND q_deviceId=109"
---------111[ActivatingQuantity [id=600, apkId=1, deviceId=109, createtime=2017-11-22 15:02:33.0, time=1], ActivatingQuantity [id=640, apkId=1, deviceId=109, createtime=2017-11-22 15:11:34.0, time=2], ActivatingQuantity [id=641, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=642, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=643, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=644, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=645, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=646, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=647, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=648, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=649, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=650, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=651, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=652, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=653, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=654, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=655, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=656, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=657, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=658, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=659, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=660, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=661, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=662, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=663, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=664, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=665, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=666, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=667, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=668, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=669, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=670, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=671, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=672, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=673, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=2], ActivatingQuantity [id=674, apkId=1, deviceId=109, createtime=2017-11-23 09:26:11.0, time=3], ActivatingQuantity [id=675, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=2], ActivatingQuantity [id=676, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=3], ActivatingQuantity [id=677, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=4], ActivatingQuantity [id=678, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=5], ActivatingQuantity [id=679, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=2], ActivatingQuantity [id=680, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=3], ActivatingQuantity [id=681, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=4], ActivatingQuantity [id=682, apkId=1, deviceId=109, createtime=2017-11-23 09:36:02.0, time=5], ActivatingQuantity [id=683, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=684, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=685, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=686, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=687, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=688, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=689, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=690, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=691, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=692, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=693, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=694, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=695, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=696, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=697, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=698, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=699, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=700, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=701, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=702, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=703, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=704, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=705, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=706, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=707, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=708, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=709, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=710, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=711, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=712, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=713, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=714, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=715, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=716, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=717, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=718, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=719, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=720, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=721, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=722, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=723, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=724, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=725, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=726, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=727, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=728, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=729, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=730, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=731, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=732, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=733, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=734, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=735, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=736, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=737, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=738, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=739, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=740, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=741, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=742, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=743, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=744, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=745, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=746, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=747, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=748, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=749, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=750, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=751, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=752, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=753, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=754, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=755, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=756, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=757, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=758, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=759, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=760, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=761, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=762, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=763, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=764, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=765, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=766, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=767, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=768, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=769, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=770, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=771, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=2], ActivatingQuantity [id=772, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=3], ActivatingQuantity [id=773, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=4], ActivatingQuantity [id=774, apkId=1, deviceId=109, createtime=2017-11-23 09:37:02.0, time=5], ActivatingQuantity [id=775, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=776, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=777, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=778, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=779, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=780, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=781, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=782, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=783, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=784, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=785, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=786, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=787, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=788, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=789, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=790, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=791, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=792, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=793, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=794, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=795, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=796, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=797, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=798, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=799, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=800, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=801, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=802, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=803, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=804, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=805, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=806, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=807, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=808, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=809, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=810, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=811, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=812, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=813, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=814, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=815, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=816, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=817, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=818, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=819, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=820, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=821, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=822, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=823, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=824, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=825, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=826, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=827, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=828, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=829, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=830, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=831, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=832, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=833, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=834, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=835, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=836, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=837, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=838, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=839, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=840, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=841, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=842, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=843, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=844, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=845, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=846, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=847, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=848, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=849, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=850, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=851, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=852, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=853, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=854, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=855, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=856, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=857, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=858, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=859, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=860, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=861, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=862, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=863, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=864, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=865, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=866, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=867, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=868, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=869, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=870, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=871, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=872, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=873, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=874, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=875, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=876, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=877, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=878, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=879, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=880, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=881, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=882, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=883, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=884, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=885, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=886, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=887, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=888, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=889, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=890, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=891, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=892, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=893, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=894, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=895, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=896, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=897, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=898, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=899, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=900, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=901, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=902, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=903, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=904, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=905, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=906, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=907, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=908, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=909, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=910, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=911, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=912, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=913, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=914, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=915, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=916, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=917, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=918, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=919, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=920, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=921, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=922, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=923, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=924, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=925, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=926, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=927, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=928, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=929, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=930, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=931, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=932, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=933, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=934, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=935, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=936, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=937, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=938, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=939, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=940, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=941, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=942, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=943, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=944, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=945, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=946, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=947, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=948, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=949, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=950, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5], ActivatingQuantity [id=951, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=2], ActivatingQuantity [id=952, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=3], ActivatingQuantity [id=953, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=4], ActivatingQuantity [id=954, apkId=1, deviceId=109, createtime=2017-11-23 09:50:44.0, time=5]]
2017-11-23 10:34:26,230 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT max(q_createtime) FROM t_activating_quantity  WHERE apkId=? AND deviceId=?
    | 1 |   2 |
    |---|-----|
    | 1 | 109 |
  For example:> "SELECT max(q_createtime) FROM t_activating_quantity  WHERE apkId=1 AND deviceId=109"
2017-11-23 10:34:26,234 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247)
	at org.nutz.dao.impl.NutDao.func2(NutDao.java:767)
	at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)
2017-11-23 10:34:26,237 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN  - Error@/api/advert/quantity :
org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT max(q_createtime) FROM t_activating_quantity  WHERE apkId=1 AND deviceId=109'
PreparedStatement: 
'SELECT max(q_createtime) FROM t_activating_quantity  WHERE apkId=? AND deviceId=?'
CaseMessage=Unknown column 'apkId' in 'where clause'
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247)
	at org.nutz.dao.impl.NutDao.func2(NutDao.java:767)
	at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
	... 50 more

23 回复

我严重建议你写个testcase之类的代码来测试,而不是上来贴一堆无关的日志

方法如下
		json = Data.decode(json);
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		int num = 1;
		// GSON直接解析成对象
		UpdateClientInfo.R updateClientInfo = new Gson().fromJson(json, UpdateClientInfo.R.class);
		//System.err.println("------------" + updateClientInfo.toString());
		// 对象中拿到集合
		List<Statistics> statistics = updateClientInfo.getUserDate();
		System.err.println("------------" + statistics.toString());
		Cnd cn2 = null;
		for (Statistics statistic : statistics) {
			cn2 = Where.where(cn2, "packageName", "=", statistic.getPackageName());// 通过包名查询软件id询
		}
		List<PreinstallApk> preinstallApks = dao.query(PreinstallApk.class, cn2);
		ActivatingQuantity Quantity = new ActivatingQuantity();
		Cnd cnd = null;
		cnd = Where.where(cnd, "IMEI1", "=", updateClientInfo.getIMEI());// 通过唯一值查询手机
		List<Device> device = dao.query(Device.class, cnd);
		Cnd cnd1 = null;
		for (PreinstallApk preinstallApk : preinstallApks) {
			cnd1 = Where.where(cnd1, "apkId", "=", preinstallApk.getId());// 通过软件id查询软件
		}
		for (Device devices : device) {
			cnd1 = Where.where(cnd1, "deviceId", "=", devices.getId());// 通过手机id查询软件
		}
	//	cnd1 = Where.where(cnd1, "Date_Time", ">=", Quantity.getCreatetime());// 最新的日期
		List<ActivatingQuantity> fetch = dao.query(ActivatingQuantity.class, cnd1);
	
		ActivatingQuantity func2 = (ActivatingQuantity) dao.func2("t_activating_quantity", "max", "q_createtime", cnd1);
		System.err.println("func记录"+func2);


For example:> "SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=1 AND deviceId=109" 2017-11-23 10:36:28,930 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272) at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147) at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114) at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81) at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70) at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239) at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247) at org.nutz.dao.impl.NutDao.func2(NutDao.java:767) at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15) at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44) at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67) at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31) at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) 2017-11-23 10:36:28,946 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN - Error@/api/advert/quantity : org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=1 AND deviceId=109' PreparedStatement: 'SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=? AND deviceId=?' CaseMessage=Unknown column 'apkId' in 'where clause' at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147) at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114) at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81) at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70) at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239) at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247) at org.nutz.dao.impl.NutDao.func2(NutDao.java:767) at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15) at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44) at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67) at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31) at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272) at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53) ... 50 more 2017-11-23 10:37:04,107 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/api/advert/quantity : PluginDataModule.ClientInfo(PluginDataModule.java:175) 2017-11-23 10:37:04,108 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'pluginDataModule'<class com.woyaofa.module.api.PluginDataModule> ------------[ [PackageName=com.UCMobile, Date_Time=Thu Nov 23 09:50:44 CST 2017, CS_INT=5]] 2017-11-23 10:37:04,145 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_preinstall_apk WHERE c_package_name=? | 1 | |--------------| | com.UCMobile | For example:> "SELECT * FROM t_preinstall_apk WHERE c_package_name='com.UCMobile'" 2017-11-23 10:37:04,173 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE c_imei1=? | 1 | |-----------------| | 865687020107973 | For example:> "SELECT * FROM t_device WHERE c_imei1='865687020107973'" 2017-11-23 10:37:04,203 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_activating_quantity WHERE q_apkId=? AND q_deviceId=? | 1 | 2 | |---|-----| | 1 | 109 | For example:> "SELECT * FROM t_activating_quantity WHERE q_apkId=1 AND q_deviceId=109" 2017-11-23 10:37:04,272 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=? AND deviceId=? | 1 | 2 | |---|-----| | 1 | 109 | For example:> "SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=1 AND deviceId=109" 2017-11-23 10:37:04,275 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272) at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147) at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114) at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81) at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70) at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239) at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247) at org.nutz.dao.impl.NutDao.func2(NutDao.java:767) at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15) at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44) at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67) at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31) at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) 2017-11-23 10:37:04,280 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN - Error@/api/advert/quantity : org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=1 AND deviceId=109' PreparedStatement: 'SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=? AND deviceId=?' CaseMessage=Unknown column 'apkId' in 'where clause' at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147) at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114) at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81) at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70) at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239) at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247) at org.nutz.dao.impl.NutDao.func2(NutDao.java:767) at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15) at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44) at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67) at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31) at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272) at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53) ... 50 more 2017-11-23 10:37:39,209 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/api/advert/quantity : PluginDataModule.ClientInfo(PluginDataModule.java:175) 2017-11-23 10:37:39,210 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'pluginDataModule'<class com.woyaofa.module.api.PluginDataModule> ------------[ [PackageName=com.UCMobile, Date_Time=Thu Nov 23 09:50:44 CST 2017, CS_INT=5]] 2017-11-23 10:37:39,250 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_preinstall_apk WHERE c_package_name=? | 1 | |--------------| | com.UCMobile | For example:> "SELECT * FROM t_preinstall_apk WHERE c_package_name='com.UCMobile'" 2017-11-23 10:37:39,288 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE c_imei1=? | 1 | |-----------------| | 865687020107973 | For example:> "SELECT * FROM t_device WHERE c_imei1='865687020107973'" 2017-11-23 10:37:39,317 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_activating_quantity WHERE q_apkId=? AND q_deviceId=? | 1 | 2 | |---|-----| | 1 | 109 | For example:> "SELECT * FROM t_activating_quantity WHERE q_apkId=1 AND q_deviceId=109" 2017-11-23 10:37:39,388 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=? AND deviceId=? | 1 | 2 | |---|-----| | 1 | 109 | For example:> "SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=1 AND deviceId=109" 2017-11-23 10:37:39,398 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272) at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147) at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114) at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81) at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70) at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239) at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247) at org.nutz.dao.impl.NutDao.func2(NutDao.java:767) at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15) at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44) at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67) at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31) at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) 2017-11-23 10:37:39,403 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN - Error@/api/advert/quantity : org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=1 AND deviceId=109' PreparedStatement: 'SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=? AND deviceId=?' CaseMessage=Unknown column 'apkId' in 'where clause' at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147) at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114) at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81) at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70) at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239) at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247) at org.nutz.dao.impl.NutDao.func2(NutDao.java:767) at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15) at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44) at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67) at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31) at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272) at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53) ... 50 more 2017-11-23 10:38:14,435 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/api/advert/quantity : PluginDataModule.ClientInfo(PluginDataModule.java:175) 2017-11-23 10:38:14,436 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'pluginDataModule'<class com.woyaofa.module.api.PluginDataModule> ------------[ [PackageName=com.UCMobile, Date_Time=Thu Nov 23 09:50:44 CST 2017, CS_INT=5]] 2017-11-23 10:38:14,468 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_preinstall_apk WHERE c_package_name=? | 1 | |--------------| | com.UCMobile | For example:> "SELECT * FROM t_preinstall_apk WHERE c_package_name='com.UCMobile'" 2017-11-23 10:38:14,498 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE c_imei1=? | 1 | |-----------------| | 865687020107973 | For example:> "SELECT * FROM t_device WHERE c_imei1='865687020107973'" 2017-11-23 10:38:14,529 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_activating_quantity WHERE q_apkId=? AND q_deviceId=? | 1 | 2 | |---|-----| | 1 | 109 | For example:> "SELECT * FROM t_activating_quantity WHERE q_apkId=1 AND q_deviceId=109" 2017-11-23 10:38:14,582 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=? AND deviceId=? | 1 | 2 | |---|-----| | 1 | 109 | For example:> "SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=1 AND deviceId=109" 2017-11-23 10:38:14,584 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272) at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147) at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114) at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81) at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70) at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239) at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247) at org.nutz.dao.impl.NutDao.func2(NutDao.java:767) at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15) at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44) at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67) at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31) at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) 2017-11-23 10:38:14,589 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN - Error@/api/advert/quantity : org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=1 AND deviceId=109' PreparedStatement: 'SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=? AND deviceId=?' CaseMessage=Unknown column 'apkId' in 'where clause' at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147) at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114) at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81) at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70) at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239) at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247) at org.nutz.dao.impl.NutDao.func2(NutDao.java:767) at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15) at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44) at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67) at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31) at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272) at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53) ... 50 more 2017-11-23 10:38:49,524 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/api/advert/quantity : PluginDataModule.ClientInfo(PluginDataModule.java:175) 2017-11-23 10:38:49,525 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'pluginDataModule'<class com.woyaofa.module.api.PluginDataModule> ------------[ [PackageName=com.UCMobile, Date_Time=Thu Nov 23 09:50:44 CST 2017, CS_INT=5]] 2017-11-23 10:38:49,573 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_preinstall_apk WHERE c_package_name=? | 1 | |--------------| | com.UCMobile | For example:> "SELECT * FROM t_preinstall_apk WHERE c_package_name='com.UCMobile'" 2017-11-23 10:38:49,608 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE c_imei1=? | 1 | |-----------------| | 865687020107973 | For example:> "SELECT * FROM t_device WHERE c_imei1='865687020107973'" 2017-11-23 10:38:49,640 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_activating_quantity WHERE q_apkId=? AND q_deviceId=? | 1 | 2 | |---|-----| | 1 | 109 | For example:> "SELECT * FROM t_activating_quantity WHERE q_apkId=1 AND q_deviceId=109" 2017-11-23 10:38:49,705 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=? AND deviceId=? | 1 | 2 | |---|-----| | 1 | 109 | For example:> "SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=1 AND deviceId=109" 2017-11-23 10:38:49,708 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272) at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147) at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114) at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81) at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70) at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239) at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247) at org.nutz.dao.impl.NutDao.func2(NutDao.java:767) at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15) at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44) at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67) at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31) at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) 2017-11-23 10:38:49,712 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN - Error@/api/advert/quantity : org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=1 AND deviceId=109' PreparedStatement: 'SELECT max(q_createtime) FROM t_activating_quantity WHERE apkId=? AND deviceId=?' CaseMessage=Unknown column 'apkId' in 'where clause' at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147) at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114) at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81) at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70) at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239) at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247) at org.nutz.dao.impl.NutDao.func2(NutDao.java:767) at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27) at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15) at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44) at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67) at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31) at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apkId' in 'where clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272) at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53) ... 50 more

这不很明显吗?

Unknown column 'apkId' in 'where clause'
ActivatingQuantity func2 = (ActivatingQuantity) dao.func2("t_activating_quantity", "max", "q_createtime", cnd1);
cnd1的条件 没有问题吗
cnd1的条件在List<ActivatingQuantity> fetch = dao.query(ActivatingQuantity.class, cnd1);
是没有问题

报错的信息指向apkId字段不存在啊
,那数据库里面到底有没有这个字段?

cnd的条件换成数据库的属性 报错:
2017-11-23 11:06:31,119 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN  - Error@/api/advert/quantity :
java.lang.ClassCastException: java.sql.Timestamp cannot be cast to com.woyaofa.data.ActivatingQuantity
	at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:203)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)

Timestamp tt = (Timestamp ) dao.func2("t_activating_quantity", "max", "q_createtime", cnd1);

方法代码如下:
	json = Data.decode(json);
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		int num = 1;
		// GSON直接解析成对象
		UpdateClientInfo.R updateClientInfo = new Gson().fromJson(json, UpdateClientInfo.R.class);
		// 对象中拿到集合
		List<Statistics> statistics = updateClientInfo.getUserDate();
		Cnd cn2 = null;
		for (Statistics statistic : statistics) {
			cn2 = Where.where(cn2, "c_package_name", "=", statistic.getPackageName());// 通过包名查询软件id询
		}
		List<PreinstallApk> preinstallApks = dao.query(PreinstallApk.class, cn2);
		ActivatingQuantity Quantity = new ActivatingQuantity();
		Cnd cnd = null;
		cnd = Where.where(cnd, "c_imei1", "=", updateClientInfo.getIMEI());// 通过唯一值查询手机
		List<Device> device = dao.query(Device.class, cnd);
		Cnd cnd1 = null;
		for (PreinstallApk preinstallApk : preinstallApks) {
			cnd1 = Where.where(cnd1, "q_apkId", "=", preinstallApk.getId());// 通过软件id查询软件
		}
		for (Device devices : device) {
			cnd1 = Where.where(cnd1, "q_deviceId", "=", devices.getId());// 通过手机id查询软件
		}

		List<ActivatingQuantity> fetch = dao.query(ActivatingQuantity.class, cnd1);
	
		//ActivatingQuantity func2 = (ActivatingQuantity) dao.func2("t_activating_quantity", "max", "q_createtime", cnd1);
		
		Timestamp tt = (Timestamp ) dao.func2("t_activating_quantity", "max", "q_createtime", cnd1);
		System.err.println("func记录"+tt);
报错信息如下:
 For example:> "SELECT max(q_createtime) FROM t_activating_quantity  WHERE q_apkId=1 AND q_deviceId=109"
2017-11-23 11:25:20,693 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN  - Error@/api/advert/quantity :
java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.security.Timestamp
	at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:206)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)
那行  import错了  Where是自己封装的工具类

是java.sql.Timestamp

问下  
执行ActivatingQuantity func2 = (ActivatingQuantity) dao.func2("t_activating_quantity", "max", "q_createtime", cnd1); 是报错的
执行
		Timestamp tt = (Timestamp ) dao.func2("t_activating_quantity", "max", "q_createtime", cnd1);是成功的 有数据返回的




你观察一下输出的sql

func2返回的是单个属性,并非pojo实例

func2()方法返回类型是Object

select max(id) 对应不了一个pojo实例的

除了自定义sql  没有其他的方法吗

聚合函数不是这样用的吗???

问下自定义sql  可以用cnd类吗

可以的,文档有的

Sql sql = Sqls.create("select * from t_user $cnd");
sql.setVar("cnd", Cnd.where(..........));

添加回复
请先登陆
回到顶部