SQLServer数据库
content 字段类型为 text代码如下:
=======
strSQL = "select * from OA_CT_Report where RepID=''";
rs = dbConnBean.runSQLReturnRS_RW(strSQL);
rs.moveToInsertRow(); //@@@@@@@@@@@@@
rs.updateString("Title",objMod.getTitle());
rs.updateString("Content", objMod.getContent()); //@@@@@@@@@@@@@
rs.insertRow();
dbConnBean.closeResultSet(rs);
======
当objMod.getContent() 获得的字串很长时(譬如整个长度为2137) insert出错异常标识 JavaException
异常来源 com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
异常描述 操作系统或Web服务器引发了内部异常!
异常帮助 系统异常数据:[Microsoft][SQLServer 2000 Driver for JDBC]Row insert failed.
系统帮助 [Microsoft][SQLServer 2000 Driver for JDBC]Row insert failed. ======
例如objMod.getContent() 获得内容为 strTableMod :
var strTableMod="";
strTableMod += "<table width=\"100%\" border=\"1\" cellpadding=\"2\" cellspacing=\"0\" style=\"font-size:13px;\">";
strTableMod += "<tr><td colspan=\"5\"><b>一、本周工作小结</b></td></tr>";
strTableMod += "<tr><td width=\"38%\" align=\"center\">工作内容</td><td width=\"10%\" nowrap >预计进度</td>";
strTableMod += "<td width=\"37%\"align=\"center\">实际完成</td><td width=\"7%\">拖后</td><td width=\"8%\">超前</td></tr>";
strTableMod += "<tr><td> <SPAN lang=EN-US style=\"FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt\">0.5</SPAN><SPAN style=\"FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt\">天</SPAN></td><td> </td><td> </td><td> </td><td> </td></tr>";
strTableMod += "<tr><td> <SPAN lang=EN-US style=\"FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt\">0.5</SPAN><SPAN style=\"FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt\">天</SPAN></td><td> </td><td> </td><td> </td><td> </td></tr>";
strTableMod += "<tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr>";
strTableMod += "<tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr>";
strTableMod += "<tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr>";
strTableMod += "<tr><td colspan=\"5\"><b>二、存在问题及解决建议</b></td></tr>";
strTableMod += "<tr><td align=\"center\">存在问题</td><td colspan=\"4\" align=\"center\">解决建议</td></tr>";
strTableMod += "<tr valign=\"top\" height=\"80\"><td> </td><td colspan=\"4\"> </td></tr>";
strTableMod += "</table>"; ========
感谢各位大大的帮助!
content 字段类型为 text代码如下:
=======
strSQL = "select * from OA_CT_Report where RepID=''";
rs = dbConnBean.runSQLReturnRS_RW(strSQL);
rs.moveToInsertRow(); //@@@@@@@@@@@@@
rs.updateString("Title",objMod.getTitle());
rs.updateString("Content", objMod.getContent()); //@@@@@@@@@@@@@
rs.insertRow();
dbConnBean.closeResultSet(rs);
======
当objMod.getContent() 获得的字串很长时(譬如整个长度为2137) insert出错异常标识 JavaException
异常来源 com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
异常描述 操作系统或Web服务器引发了内部异常!
异常帮助 系统异常数据:[Microsoft][SQLServer 2000 Driver for JDBC]Row insert failed.
系统帮助 [Microsoft][SQLServer 2000 Driver for JDBC]Row insert failed. ======
例如objMod.getContent() 获得内容为 strTableMod :
var strTableMod="";
strTableMod += "<table width=\"100%\" border=\"1\" cellpadding=\"2\" cellspacing=\"0\" style=\"font-size:13px;\">";
strTableMod += "<tr><td colspan=\"5\"><b>一、本周工作小结</b></td></tr>";
strTableMod += "<tr><td width=\"38%\" align=\"center\">工作内容</td><td width=\"10%\" nowrap >预计进度</td>";
strTableMod += "<td width=\"37%\"align=\"center\">实际完成</td><td width=\"7%\">拖后</td><td width=\"8%\">超前</td></tr>";
strTableMod += "<tr><td> <SPAN lang=EN-US style=\"FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt\">0.5</SPAN><SPAN style=\"FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt\">天</SPAN></td><td> </td><td> </td><td> </td><td> </td></tr>";
strTableMod += "<tr><td> <SPAN lang=EN-US style=\"FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt\">0.5</SPAN><SPAN style=\"FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt\">天</SPAN></td><td> </td><td> </td><td> </td><td> </td></tr>";
strTableMod += "<tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr>";
strTableMod += "<tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr>";
strTableMod += "<tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr>";
strTableMod += "<tr><td colspan=\"5\"><b>二、存在问题及解决建议</b></td></tr>";
strTableMod += "<tr><td align=\"center\">存在问题</td><td colspan=\"4\" align=\"center\">解决建议</td></tr>";
strTableMod += "<tr valign=\"top\" height=\"80\"><td> </td><td colspan=\"4\"> </td></tr>";
strTableMod += "</table>"; ========
感谢各位大大的帮助!
好像是jdbc的版本问题。
关安全中心
难道真是jdbc的问题??
........
stmt= conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.setFetchDirection(ResultSet.FETCH_UNKNOWN);
rs= ....
..........