我在at层调用manage层里的dao.insert(obj)的时候报错
org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException
java.sql.SQLException: Error
而我在test中调用mange层里的dao.insert(obj)以及在test中直接使用dao.insert都不报错，并且数据能正常插入。
求兽总指点。
At层
@At("/saveNoticeNew3")
@AdaptBy(type = UploadAdaptor.class, args = { "ioc:myUpload" })
@Ok("json")
public Object saveNoticeNew3(@Param("..") DbNoticeInfoDTO dbNoticeInfoDTO, @Param("attachments") TempFile[] tempFiles, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) {
// 富文本框内容content URIDecoder解码
try {
dbNoticeInfoDTO.setContent(java.net.URLDecoder.decode(dbNoticeInfoDTO.getContent(),"UTF-8"));
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
// 对参数进一步处理
dbNoticeInfoDTO.setFiles(tempFiles);
String temp = dbNoticeInfoDTO.getRegions()[0];
String[] asdf = temp.split(",");
List<String> l = Arrays.asList(temp.split(","));
dbNoticeInfoDTO.setRegions(dbNoticeInfoDTO.getRegions()[0].toString().split(","));
dbNoticeInfoDTO.setGroups(dbNoticeInfoDTO.getGroups()[0].split(","));
RedisSessionUtil redisSessionUtil = new RedisSessionUtil();
String token = redisSessionUtil.getSessionString(httpServletRequest, httpServletResponse,"privateUserIdentity"); //解密后的token
//获取当前用户
UserAuthorityService userAuthorityService = new UserAuthorityService();
UserDTO userDTO = userAuthorityService.getUserCondition(httpServletRequest, httpServletResponse);
// 补充dbNoticeInfoDTO参数
dbNoticeInfoDTO.setCreateUserId(userDTO.getId() + "");
dbNoticeInfoDTO.setUserId(userDTO.getId());
dbNoticeInfoDTO.setCreateTime(new Timestamp(new Date().getTime()));
// dbNoticeInfoDTO.setCancelDate(null);
// dbNoticeInfoDTO.setCancelReason(null);
dbNoticeInfoDTO.setNoticeType("1");
dbNoticeInfoDTO.setNoticeLevel("1");
dbNoticeInfoDTO.setPublishStatus("1");
dbNoticeInfoDTO.setSmsNotify("0");
dbNoticeInfoDTO.setPublishDate(new Timestamp(new Date().getTime()));
// 调用manage存储通知公告
Object res = dbNoticeManager.saveNoticeInfoNewTest(dbNoticeInfoDTO, userDTO, Arrays.asList(dbNoticeInfoDTO.getRegions()), Arrays.asList(dbNoticeInfoDTO.getGroups()), token);
NutMap result = new NutMap();
return result;
}
Manage层
public Object saveNoticeInfoNewTest(final DbNoticeInfoDTO dbNoticeInfoDTO, final UserDTO userDTO, final List<String> regions, final List<String> groups, String token) {
DbNoticeInfo dbNoticeInfo = new DbNoticeInfo().fromDTO(dbNoticeInfoDTO);
if (dbNoticeInfo.getId() != null) {
dao.update(dbNoticeInfo);
} else {
dao.insert(dbNoticeInfo);
}
NutMap nutMap = new NutMap();
return nutMap;
}
Test
@Test
public void saveNoticeInfoNewTest() {
//实例化DbNoticeInfo
DbNoticeInfoDTO dbNoticeInfoDTO = new DbNoticeInfoDTO();
// dbNoticeInfoDTO.setNoticeContent("content");
Clob content = new Clob() {
@Override
public long length() throws SQLException {
return 0;
}
@Override
public String getSubString(long pos, int length) throws SQLException {
return null;
}
@Override
public Reader getCharacterStream() throws SQLException {
return null;
}
@Override
public InputStream getAsciiStream() throws SQLException {
return null;
}
@Override
public long position(String searchstr, long start) throws SQLException {
return 0;
}
@Override
public long position(Clob searchstr, long start) throws SQLException {
return 0;
}
@Override
public int setString(long pos, String str) throws SQLException {
return 0;
}
@Override
public int setString(long pos, String str, int offset, int len) throws SQLException {
return 0;
}
@Override
public OutputStream setAsciiStream(long pos) throws SQLException {
return null;
}
@Override
public Writer setCharacterStream(long pos) throws SQLException {
return null;
}
@Override
public void truncate(long len) throws SQLException {
}
@Override
public void free() throws SQLException {
}
@Override
public Reader getCharacterStream(long pos, long length) throws SQLException {
return null;
}
};
// dbNoticeInfoDTO.setId(Long.valueOf(123456));
// dbNoticeInfoDTO.setNoticeContent(content);
dbNoticeInfoDTO.setContent("<div style=\"text-align: center;\"><img src=\"data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD//gA7Q1JFQVRPUjogZ2QtanBlZyB2MS4wICh1c2luZyBJSkcgSlBFRyB2NjIpLCBxdWFsaXR5ID0gOTAK/9sAQwADAgIDAgIDAwMDBAMDBAUIBQUEBAUKBwcGCAwKDAwLCgsLDQ4SEA0OEQ4LCxAWEBETFBUVFQwPFxgWFBgSFBUU/9sAQwEDBAQFBAUJBQUJFA0LDRQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQU/8AAEQgAUABQAwEiAAIRAQMRAf/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC//EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29/j5+v/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC//EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5+jp6vLz9PX29/j5+v/aAAwDAQACEQMRAD8A8hooor+iD+YQo/CiigAo9a+h/wBmn9ku4+OOmXOvapqkmjeH4pjbxGCMPNcyAAttzwqjIGSDk5GODXsOuf8ABOPSHt2OkeM763mA4F7aJMp/75KYrwa+eYHDVXRqT1W+jdvuPosPw/mOKoqvSp+69tUr/ez4Xor2T4qfsoePvhZDNeT2Met6RHlmvtLJkEa+roQGX3OCB6142DkZr1aGJo4qHPRkpLyPHxOFr4Sfs68HF+Yd6PSiiuk5Qoor2v8AZF+FUPxU+MNjFfQibR9JQ6jeIwysm0gRxn1DOVyO6hq5sTXhhaMq09oq51YXDzxdeFCnvJ2Pa/2bf2JtK1vwxb+JPiHb3Ez3yCW00dZXhEcR5DylSG3N1CgjA65JwPPv2sv2ddA+FsEGu+FPOt9OacW1zYTSmURlgSrozZbHGCCT1GK/QfX9UXSbB5CcHHFfnR+1n8aF8Za1J4U04h7SxuRJeXAPDzKCBGPZcnJ9eO3P5vlmYZhj8xUlJ8vVfZS9P6Z+qZtlmW5blbhKC5tk/tOXr+a2sfV/7Dox+zrof/Xzd/8Ao969uu9WhtHCu4Uk45NeJfsPf8m66F/183f/AKPeuQ/bdvpoPhXqnlSvE6XNsyujEMpE6YII6GvExdH6xmk6N7c02vvZ9Bg6/wBVyenXtflpp29In048ceoQkjBzXxZ+1f8Ass24gvPF3hGzW2vIgZr7TYFwk69WkjUdHHUqPvdev3l/ZC/avv7nXLLwR40vGuxdsIdN1adsyCQ/dhlP8W7orHnOAc5BH2X4gsFu7NzjkCraxeQYtd/wkv6+4yjLBcSYJ6afjF/195+MgYMMiivUv2k/h3H8OfinfQWkQi0zUV+3WyKMKm4kOg+jA4HYFa8tr9gw1eGKoxrQ2krn4jisNPB150Km8XYK+6v+Cceixx+G/GerbQZp7uC13dwqIzY/OT9K+Fa+6v8AgnHrUUvhvxnpOQJoLuC629yroy5/OP8AWvD4i5v7NqW8vzR9Bwvy/wBqU+btK33M9r/aD8Sy+GfBWt6jF9+ysZp0B7sqEgfmBX5Uq7ylpJGMkjks7sclieSTX6v/AB58JyeLfBOuaZCP3t7YzW6E9mZCFP5kV+UJjeFmjlRo5UJR0YYKkcEEeteJwlyclX+a6+7+rn0HGnP7Sj/LZ/fpf9D9Lv2G72B/2dtKVZVY293dRygH7jeaWwfwZT+NcH+25qkE3wx1KMOA0lzbogP8R81WwPwUn8K+SPhh8bvFvwhkuh4evkS0uyGnsblPMgkYDAbbkENjjKkH1zVP4jfFjxJ8VLyGbXruNoYSWitLZPLhRj1bGSSfck1o8hr/ANqfWuZcnNzee97WMlxHh1lH1PlftOXl8trXv6ficnBNJbSxzQu0U0bB0dDhlYHIIPrmv2D+G/iR/G3wz8N65MB52paZb3UuBgB2jUsPzJr8fIIJLmaOGGNpZpGCIiDJZicAAeua/YL4c+HH8EfDLw5oc2PO03TILaUg8F1jAb/x4Go4t5PZ0f5rv7tL/oXwXz+1rW+Gy++7t+p8Z/t56VGIfDmoBQJIrqa3z6h0Df8AtP8AWvkavrP9u3Wo5U8PaeGBkkupbjHsiBf/AGpXyZXscOc39nQv3f5s8Pinl/tSduyv9yD8a9q/ZF+K0Pwr+MNjLfziHR9WQ6deOxwse8gxyH0CuFyeylq8VoPNe9iaEMVRlRntJWPnMLiJ4SvCvT3i7n7SalZJfW7IcH0r4Y/aj/ZP1U6zeeLvB9k16twxlv8AS4FzJv7yxL/FnqVHOeRnJx1H7Jv7XVtd6bZeCvG16Le+gVYNO1W4bCXCDhYpGPRxwAx4YYB+b731+Jre5HJFfkCeLyDF7a/hJf19x+3tYLiTBLXT8Yv+vkz8XZYngmeKVGilQlXjcbWUjqCD0NLBDJczRwwo8ssjBUjjBZmJ6AAdTX7A+Ivhf4M8YSebrnhnSNXmxgTXlnHJIB/vEZ/WneG/hv4N8ES+dofhrR9HmxjzrOzjjkx/vAZ/Wvqf9bafJ/BfN66fl+h8f/qXV57e2XL6a/df9T5P/ZH/AGSNR0/WrLxx44smsvsrCbTdIuFxL5n8M0q/w7eqqec4Jxjn638Za4mmac67hvYdM1JrXiy102Ftrhnx618PftO/tNLqAu/DXhq7E91JmK8v4WysC9CiEdXPQkfd+vT5WUsXn+LWmv4RX9fefYxjguHME9dPxk/6+48W/aD8fp8QviZe3FvL5unWA+x27g8PtJLuPqxOD3AFecfjSKoRQAMAUtfr+Fw8cLRjRhtFWPxDF4meMrzr1N5O4UUUV1HIIRkc16/8NP2pvHnwzt4rKG/XWtJjAVLLUwZPLX0RwQyj0GSB6V5DRXNXw1HFR5K0VJeZ14bFV8JP2lCbi/I+y9L/AOCgdq8A/tLwte28uOfsl0kqk/8AAguKqa5+3xBLCw03w1ezSEcfarlIgP8AvkNXx/RXhf6uZdzX5H97/wAz6L/WjNOXl9ovWy/yPTfiJ+0X40+IyS21xerpWmycNaaflN49HcksfcZAPpXmKqFGAMD2paK93D4ajhYclGKivI+dxOLr4uftK83J+YUUUV0nKf/Z\"><br></div><div style=\"text-align: center;\"><br></div><div><div style=\"text-align: center;\"><font size=\"5\" color=\"#ac725e\">标题标题标题biaoti<a href=\"http://localhost:8080/www.baidu.com\" style=\"color: rgb(42, 100, 150); text-decoration-line: underline; outline: 0px;\">百度</a></font></div><div style=\"text-align: right;\"><font face=\"Verdana\" size=\"1\">发布人：上海市民政局社会福利处</font></div><div style=\"text-align: right;\"><font face=\"Verdana\" size=\"1\"> 反对撒地方wwww.baidu.com</font></div><div><ol><li> 段落1<br></li><li> 段落2<br></li><li> 段落3<br></li></ol></div><div> 段落4段落4段落<font face=\"Courier\"><font size=\"3\">4段落4段落4段落4段</font><font color=\"#4986e7\" size=\"5\">落4段落4段落4段落4段落4段</font><font size=\"3\">落4段落4段落4</font><font color=\"#4986e7\" style=\"font-size: medium;\">段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4</font><font size=\"3\">段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落4段落</font><b style=\"font-size: medium;\">4段落4段落4段落4段落4段落4</b></font></div><div><font size=\"3\" face=\"Courier\"><b> 段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落</b>5正文，段落5正文，<i>段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段</i>落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，段落5正文，</font></div><div><br></div><div><ul><li>关键词1<br></li><li>关键词2<br></li><li>关键词3<br></li></ul></div></div><blockquote style=\"padding: 0px; margin-bottom: 0px; margin-left: 40px; border: none;\"><ol><li><u>keyword1 <br></u></li><li><u>keyword2<br></u></li><li><u>keyword3</u><br></li></ol></blockquote><div><div><ul><li><i><b> 这是新的一段这是新的一段这是新的一段这是新的一<font color=\"#fad165\">段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段</font>这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段这是新的一段</b></i><br></li></ul></div><div style=\"text-align: right;\"><img src=\"data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD//gA7Q1JFQVRPUjogZ2QtanBlZyB2MS4wICh1c2luZyBJSkcgSlBFRyB2NjIpLCBxdWFsaXR5ID0gOTAK/9sAQwADAgIDAgIDAwMDBAMDBAUIBQUEBAUKBwcGCAwKDAwLCgsLDQ4SEA0OEQ4LCxAWEBETFBUVFQwPFxgWFBgSFBUU/9sAQwEDBAQFBAUJBQUJFA0LDRQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQU/8AAEQgAUABQAwEiAAIRAQMRAf/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC//EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29/j5+v/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC//EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5+jp6vLz9PX29/j5+v/aAAwDAQACEQMRAD8A8hooor+iD+YQo/CiigAo9a+h/wBmn9ku4+OOmXOvapqkmjeH4pjbxGCMPNcyAAttzwqjIGSDk5GODXsOuf8ABOPSHt2OkeM763mA4F7aJMp/75KYrwa+eYHDVXRqT1W+jdvuPosPw/mOKoqvSp+69tUr/ez4Xor2T4qfsoePvhZDNeT2Met6RHlmvtLJkEa+roQGX3OCB6142DkZr1aGJo4qHPRkpLyPHxOFr4Sfs68HF+Yd6PSiiuk5Qoor2v8AZF+FUPxU+MNjFfQibR9JQ6jeIwysm0gRxn1DOVyO6hq5sTXhhaMq09oq51YXDzxdeFCnvJ2Pa/2bf2JtK1vwxb+JPiHb3Ez3yCW00dZXhEcR5DylSG3N1CgjA65JwPPv2sv2ddA+FsEGu+FPOt9OacW1zYTSmURlgSrozZbHGCCT1GK/QfX9UXSbB5CcHHFfnR+1n8aF8Za1J4U04h7SxuRJeXAPDzKCBGPZcnJ9eO3P5vlmYZhj8xUlJ8vVfZS9P6Z+qZtlmW5blbhKC5tk/tOXr+a2sfV/7Dox+zrof/Xzd/8Ao969uu9WhtHCu4Uk45NeJfsPf8m66F/183f/AKPeuQ/bdvpoPhXqnlSvE6XNsyujEMpE6YII6GvExdH6xmk6N7c02vvZ9Bg6/wBVyenXtflpp29In048ceoQkjBzXxZ+1f8Ass24gvPF3hGzW2vIgZr7TYFwk69WkjUdHHUqPvdev3l/ZC/avv7nXLLwR40vGuxdsIdN1adsyCQ/dhlP8W7orHnOAc5BH2X4gsFu7NzjkCraxeQYtd/wkv6+4yjLBcSYJ6afjF/195+MgYMMiivUv2k/h3H8OfinfQWkQi0zUV+3WyKMKm4kOg+jA4HYFa8tr9gw1eGKoxrQ2krn4jisNPB150Km8XYK+6v+Cceixx+G/GerbQZp7uC13dwqIzY/OT9K+Fa+6v8AgnHrUUvhvxnpOQJoLuC629yroy5/OP8AWvD4i5v7NqW8vzR9Bwvy/wBqU+btK33M9r/aD8Sy+GfBWt6jF9+ysZp0B7sqEgfmBX5Uq7ylpJGMkjks7sclieSTX6v/AB58JyeLfBOuaZCP3t7YzW6E9mZCFP5kV+UJjeFmjlRo5UJR0YYKkcEEeteJwlyclX+a6+7+rn0HGnP7Sj/LZ/fpf9D9Lv2G72B/2dtKVZVY293dRygH7jeaWwfwZT+NcH+25qkE3wx1KMOA0lzbogP8R81WwPwUn8K+SPhh8bvFvwhkuh4evkS0uyGnsblPMgkYDAbbkENjjKkH1zVP4jfFjxJ8VLyGbXruNoYSWitLZPLhRj1bGSSfck1o8hr/ANqfWuZcnNzee97WMlxHh1lH1PlftOXl8trXv6ficnBNJbSxzQu0U0bB0dDhlYHIIPrmv2D+G/iR/G3wz8N65MB52paZb3UuBgB2jUsPzJr8fIIJLmaOGGNpZpGCIiDJZicAAeua/YL4c+HH8EfDLw5oc2PO03TILaUg8F1jAb/x4Go4t5PZ0f5rv7tL/oXwXz+1rW+Gy++7t+p8Z/t56VGIfDmoBQJIrqa3z6h0Df8AtP8AWvkavrP9u3Wo5U8PaeGBkkupbjHsiBf/AGpXyZXscOc39nQv3f5s8Pinl/tSduyv9yD8a9q/ZF+K0Pwr+MNjLfziHR9WQ6deOxwse8gxyH0CuFyeylq8VoPNe9iaEMVRlRntJWPnMLiJ4SvCvT3i7n7SalZJfW7IcH0r4Y/aj/ZP1U6zeeLvB9k16twxlv8AS4FzJv7yxL/FnqVHOeRnJx1H7Jv7XVtd6bZeCvG16Le+gVYNO1W4bCXCDhYpGPRxwAx4YYB+b731+Jre5HJFfkCeLyDF7a/hJf19x+3tYLiTBLXT8Yv+vkz8XZYngmeKVGilQlXjcbWUjqCD0NLBDJczRwwo8ssjBUjjBZmJ6AAdTX7A+Ivhf4M8YSebrnhnSNXmxgTXlnHJIB/vEZ/WneG/hv4N8ES+dofhrR9HmxjzrOzjjkx/vAZ/Wvqf9bafJ/BfN66fl+h8f/qXV57e2XL6a/df9T5P/ZH/AGSNR0/WrLxx44smsvsrCbTdIuFxL5n8M0q/w7eqqec4Jxjn638Za4mmac67hvYdM1JrXiy102Ftrhnx618PftO/tNLqAu/DXhq7E91JmK8v4WysC9CiEdXPQkfd+vT5WUsXn+LWmv4RX9fefYxjguHME9dPxk/6+48W/aD8fp8QviZe3FvL5unWA+x27g8PtJLuPqxOD3AFecfjSKoRQAMAUtfr+Fw8cLRjRhtFWPxDF4meMrzr1N5O4UUUV1HIIRkc16/8NP2pvHnwzt4rKG/XWtJjAVLLUwZPLX0RwQyj0GSB6V5DRXNXw1HFR5K0VJeZ14bFV8JP2lCbi/I+y9L/AOCgdq8A/tLwte28uOfsl0kqk/8AAguKqa5+3xBLCw03w1ezSEcfarlIgP8AvkNXx/RXhf6uZdzX5H97/wAz6L/WjNOXl9ovWy/yPTfiJ+0X40+IyS21xerpWmycNaaflN49HcksfcZAPpXmKqFGAMD2paK93D4ajhYclGKivI+dxOLr4uftK83J+YUUUV0nKf/Z\">发布时间：2018.8.14</div></div><div><br></div>");
dbNoticeInfoDTO.setCreateTime(new Date());
dbNoticeInfoDTO.setCreateUserId("3");
dbNoticeInfoDTO.setNoticeLevel("3");
dbNoticeInfoDTO.setNoticeSubject("subject&&&&&&&&&&&&&&&&&&--Test");
dbNoticeInfoDTO.setNoticeType("2");
dbNoticeInfoDTO.setPublishDate(new Date());
dbNoticeInfoDTO.setPublishStatus("1");
dbNoticeInfoDTO.setSmsNotify("0");
dbNoticeInfoDTO.setUserId(Long.valueOf("3"));
dbNoticeInfoDTO.setReadStatus("0");
dbNoticeInfoDTO.setUserName("发布人姓名");
dbNoticeInfoDTO.setOrganNodeId(Long.valueOf("1234"));
dbNoticeInfoDTO.setSmsContent("短信内容Content");
//实例化regions
List<String> regions = new ArrayList<>();
regions.add("310105000000");
regions.add("310101002000");
//实例化groups
List<String> groups = new ArrayList<>();
groups.add("10042");
groups.add("103");
groups.add("104");
// final DbNoticeInfo dbNoticeInfo = new DbNoticeInfo();
// BeanUtils.copyProperties(dbNoticeInfoDTO, dbNoticeInfo); // DTO -> DO
// dao.insert(dbNoticeInfo);
UserDTO userDTO = new UserDTO();
Object result = dbNoticeManager.saveNoticeInfoNewTest(dbNoticeInfoDTO, userDTO, regions, groups, token);
}
报错部分日志
2018-08-22 12:00:32,552 org.apache.commons.beanutils.BeanUtilsBean.copyProperties(BeanUtilsBean.java:242) DEBUG - BeanUtils.copyProperties(com.wonders.framework.common.notice.entity.DbNoticeInfo@6208a9fb, com.wonders.framework.common.notice.dto.DbNoticeInfoDTO@4eb31df1)
2018-08-22 12:00:32,555 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:140) DEBUG - Converting 'String' value '3' to type 'String'
2018-08-22 12:00:32,558 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:140) DEBUG - Converting 'java.sql.Timestamp' value '2018-08-22 12:00:29.491' to type 'Date'
2018-08-22 12:00:32,559 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:171) DEBUG - Converted to Date value 'Wed Aug 22 12:00:29 CST 2018'
2018-08-22 12:00:32,561 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:140) DEBUG - Converting 'String' value '短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信' to type 'String'
2018-08-22 12:00:32,565 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:140) DEBUG - Converting 'String' value '1' to type 'String'
2018-08-22 12:00:32,567 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:140) DEBUG - Converting 'Long' value '1234' to type 'Long'
2018-08-22 12:00:32,568 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:162) DEBUG - No conversion required, value is already a Long
2018-08-22 12:00:32,574 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:140) DEBUG - Converting 'String' value '1' to type 'String'
2018-08-22 12:00:32,576 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:140) DEBUG - Converting 'String' value '系统测试人员' to type 'String'
2018-08-22 12:00:32,577 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:140) DEBUG - Converting 'Long' value '3' to type 'Long'
2018-08-22 12:00:32,578 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:162) DEBUG - No conversion required, value is already a Long
2018-08-22 12:00:32,580 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:140) DEBUG - Converting 'String' value '标题title' to type 'String'
2018-08-22 12:00:32,582 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:140) DEBUG - Converting 'java.sql.Timestamp' value '2018-08-22 12:00:27.486' to type 'Date'
2018-08-22 12:00:32,582 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:171) DEBUG - Converted to Date value 'Wed Aug 22 12:00:27 CST 2018'
2018-08-22 12:00:32,584 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:140) DEBUG - Converting 'String' value '0' to type 'String'
2018-08-22 12:00:32,586 org.apache.commons.beanutils.converters.AbstractConverter.convert(AbstractConverter.java:140) DEBUG - Converting 'String' value '1' to type 'String'
2018-08-22 12:00:32,588 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - select SEQ_DB_NOTICE_INFO.nextval FROM dual
2018-08-22 12:00:32,593 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - INSERT INTO DB_NOTICE_INFO(ID,USER_ID,NOTICE_TYPE,NOTICE_SUBJECT,NOTICE_CONTENT,NOTICE_LEVEL,PUBLISH_STATUS,SMS_NOTIFY,ATTACHMENT_ID,PUBLISH_DATE,CANCEL_REASON,CANCEL_DATE,EXT1,EXT2,CREATE_USER_ID,CREATE_TIME,UPDATE_USER_ID,UPDATE_TIME,USER_NAME,ORGAN_NODE_ID,SMS_CONTENT) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |
|-------|---|---|---------|--------------------|---|---|---|------|---------------------|------|------|------|------|---|---------------------|------|------|--------|------|------------------------------------------------------------------------------------------------------|
| 10125 | 3 | 1 | 标题title | *Clob(-1772541417) | 1 | 1 | 0 | NULL | 2018-08-22 12:00:29 | NULL | NULL | NULL | NULL | 3 | 2018-08-22 12:00:27 | NULL | NULL | 系统测试人员 | 1234 | 短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信 |
For example:> "INSERT INTO DB_NOTICE_INFO(ID,USER_ID,NOTICE_TYPE,NOTICE_SUBJECT,NOTICE_CONTENT,NOTICE_LEVEL,PUBLISH_STATUS,SMS_NOTIFY,ATTACHMENT_ID,PUBLISH_DATE,CANCEL_REASON,CANCEL_DATE,EXT1,EXT2,CREATE_USER_ID,CREATE_TIME,UPDATE_USER_ID,UPDATE_TIME,USER_NAME,ORGAN_NODE_ID,SMS_CONTENT) VALUES(10125,3,'1','标题title','*Clob(-1772541417)','1','1','0','NULL','2018-08-22 12:00:29','NULL','NULL','NULL','NULL','3','2018-08-22 12:00:27','NULL','NULL','系统测试人员',1234,'短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信') "
2018-08-22 12:00:32,618 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException
java.sql.SQLException: Error
at com.alibaba.druid.pool.DruidDataSource.handleConnectionException(DruidDataSource.java:1491)
at com.alibaba.druid.pool.DruidPooledConnection.handleException(DruidPooledConnection.java:134)
at com.alibaba.druid.pool.DruidPooledStatement.checkException(DruidPooledStatement.java:71)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.setCharacterStream(DruidPooledPreparedStatement.java:836)
at org.nutz.dao.jdbc.Jdbcs.setCharacterStream(Jdbcs.java:885)
at org.nutz.dao.impl.jdbc.ClobValueAdapter2.set(ClobValueAdapter2.java:22)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:306)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90)
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:158)
at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithTransaction(NutDaoRunner.java:104)
at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:88)
at org.nutz.dao.impl.sql.run.NutDaoRunner$1.run(NutDaoRunner.java:74)
at org.nutz.trans.Trans.exec(Trans.java:174)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:72)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:55)
at org.nutz.dao.impl.NutDao.insert(NutDao.java:148)
at com.wonders.framework.common.notice.manager.DbNoticeManager.saveNoticeInfoNewTest(DbNoticeManager.java:70)
at com.wonders.framework.common.notice.at.DbNoticeAt.saveNoticeNew3(DbNoticeAt.java:174)
at com.wonders.framework.common.notice.at.DbNoticeAt$FM$saveNoticeNew3$1b1b7a6a1ec90b0f3aea9cc321a61e32.invoke(DbNoticeAt.java)
at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)
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:202)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
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:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.AbstractMethodError: Method oracle/jdbc/driver/T4CPreparedStatement.setCharacterStream(ILjava/io/Reader;J)V is abstract
at oracle.jdbc.driver.T4CPreparedStatement.setCharacterStream(T4CPreparedStatement.java)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.setCharacterStream(DruidPooledPreparedStatement.java:834)
... 58 more
2018-08-22 12:00:32,627 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN - Error@/notice/saveNoticeNew3 :
org.nutz.dao.DaoException: !Nutz SQL Error: 'INSERT INTO DB_NOTICE_INFO(ID,USER_ID,NOTICE_TYPE,NOTICE_SUBJECT,NOTICE_CONTENT,NOTICE_LEVEL,PUBLISH_STATUS,SMS_NOTIFY,ATTACHMENT_ID,PUBLISH_DATE,CANCEL_REASON,CANCEL_DATE,EXT1,EXT2,CREATE_USER_ID,CREATE_TIME,UPDATE_USER_ID,UPDATE_TIME,USER_NAME,ORGAN_NODE_ID,SMS_CONTENT) VALUES(10125,3,'1','标题title','*Clob(-1772541417)','1','1','0','NULL','2018-08-22 12:00:29','NULL','NULL','NULL','NULL','3','2018-08-22 12:00:27','NULL','NULL','系统测试人员',1234,'短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信内容smsContent短信') '
PreparedStatement:
'INSERT INTO DB_NOTICE_INFO(ID,USER_ID,NOTICE_TYPE,NOTICE_SUBJECT,NOTICE_CONTENT,NOTICE_LEVEL,PUBLISH_STATUS,SMS_NOTIFY,ATTACHMENT_ID,PUBLISH_DATE,CANCEL_REASON,CANCEL_DATE,EXT1,EXT2,CREATE_USER_ID,CREATE_TIME,UPDATE_USER_ID,UPDATE_TIME,USER_NAME,ORGAN_NODE_ID,SMS_CONTENT) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) '
CaseMessage=Error
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:158)
at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithTransaction(NutDaoRunner.java:104)
at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:88)
at org.nutz.dao.impl.sql.run.NutDaoRunner$1.run(NutDaoRunner.java:74)
at org.nutz.trans.Trans.exec(Trans.java:174)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:72)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:55)
at org.nutz.dao.impl.NutDao.insert(NutDao.java:148)
at com.wonders.framework.common.notice.manager.DbNoticeManager.saveNoticeInfoNewTest(DbNoticeManager.java:70)
at com.wonders.framework.common.notice.at.DbNoticeAt.saveNoticeNew3(DbNoticeAt.java:174)
at com.wonders.framework.common.notice.at.DbNoticeAt$FM$saveNoticeNew3$1b1b7a6a1ec90b0f3aea9cc321a61e32.invoke(DbNoticeAt.java)
at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)
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:202)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
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:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Error
at com.alibaba.druid.pool.DruidDataSource.handleConnectionException(DruidDataSource.java:1491)
at com.alibaba.druid.pool.DruidPooledConnection.handleException(DruidPooledConnection.java:134)
at com.alibaba.druid.pool.DruidPooledStatement.checkException(DruidPooledStatement.java:71)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.setCharacterStream(DruidPooledPreparedStatement.java:836)
at org.nutz.dao.jdbc.Jdbcs.setCharacterStream(Jdbcs.java:885)
at org.nutz.dao.impl.jdbc.ClobValueAdapter2.set(ClobValueAdapter2.java:22)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:306)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90)
... 54 more
Caused by: java.lang.AbstractMethodError: Method oracle/jdbc/driver/T4CPreparedStatement.setCharacterStream(ILjava/io/Reader;J)V is abstract
at oracle.jdbc.driver.T4CPreparedStatement.setCharacterStream(T4CPreparedStatement.java)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.setCharacterStream(DruidPooledPreparedStatement.java:834)
... 58 more