---------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 回复
方法如下
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
ActivatingQuantity func2 = (ActivatingQuantity) dao.func2("t_activating_quantity", "max", "q_createtime", cnd1);
cnd1的条件 没有问题吗
cnd1的条件在List<ActivatingQuantity> fetch = dao.query(ActivatingQuantity.class, cnd1);
是没有问题
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)
方法代码如下:
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)
添加回复
请先登陆