对于测试时，错误信息 Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large

随风万里无云

已于 2023-07-28 13:40:10 修改

阅读量67

点赞数 1

文章标签： mysql 数据库

于 2023-06-16 17:16:48 首次发布

本文链接：https://blog.csdn.net/qq_53325717/article/details/131250689

版权

解决方法

在Windows里面的MySQL路径里找到my.ini文件

在[mysqld]下面加入如下语句即可

max_allowed_packet = 20M

-----------------------------------------

重启myqsl

对于我个人项目中，upload.html的改写

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<link href="../../../lib/ligerUI/skins/Aqua/css/ligerui-all.css" rel="stylesheet" type="text/css" />
<link href="../../../lib/dhtmlx/dhtmlx.css" rel="stylesheet" type="text/css" /> 
<script src="../../../lib/ligerUI/js/jquery-1.5.2.min.js" type="text/javascript"></script>
<script src="../../../lib/dhtmlx/dhtmlx.js" type="text/javascript"></script>
<script src="../../../lib/ajaxfileupload.js" type="text/javascript"></script>
<script src="../../../lib/ligerUI/js/ligerui.all-1.2.5.js" type="text/javascript"></script>
<body>
	<div id="loading">
		<div class="l-window-mask"></div>
		<div class="l-grid-loading">加载中...</div>
	</div>

	<form id="realForm" method="POST" enctype="multipart/form-data">
	    <div id="myForm">
	    </div>
	</form>
	
	<div class="l-clear"></div>
	<div id="maingrid" style="margin-top: 20px"></div>
	<div>
		<ul>
			<li>(1).上传文件的格式为zip</li>
		</ul>
	</div>
</body>
<script type="text/javascript">
var myForm, formData;

var dialog;
$(function(){
	formData = [
		/*{type: "fieldset", label: "基本信息", list:[
			{type: "input", name : "version", label: "配置版本",labelWidth: "auto", position: "label-left", inputWidth: 330, labelWidth : 120},
			{type: "input", name : "desc", label: "描述信息",labelWidth: "auto", position: "label-left", inputWidth: 330, labelWidth :120 },
			{type: "file", name: "files", label: "配置文件", position:"label-left",inputWidth: 330,labelWidth :120,validate: "NotEmpty", required:true}
		]},
		*/
		{type: "fieldset", label: "配置文件", list:[
			{type: "input", label: "配置版本",labelWidth: "auto", position: "label-left", inputWidth: 330},
			{type: "input", label: "描述信息",labelWidth: "auto", position: "label-left", inputWidth: 330},
			{type: "upload", name: "myFiles", inputWidth: 330, inputHeight: 160, url: "upload.upload", titleScreen: true, titleText : "将文件拖拽到此区域或者点击右方的按钮进行上传"}
		]},
		
		{type: "button", value: "提交", name: "send"}
	];
	myForm = new dhtmlXForm("myForm", formData);
	myForm.attachEvent("onButtonClick", function(id){
		if (id == "send" && myForm.validate()){
			//document.getElementById("realForm").submit();
			ajaxFileUpload();
		}
	});
	
	$(":input[name='files']").attr("accept", ".zip");
	
	dialog = frameElement.dialog;
});

function ajaxFileUpload()
{
	$("#loading").ajaxStart(function(){
		$(this).show();
	}).ajaxComplete(function(){
		$(this).hide();
	});

	$.ajaxFileUpload({
			url:'upload.upload?cmd=upload_config&opr=insert',
			secureuri:false,
			fileElementId:'files',
			dataType: 'json',
			data:{type:'configs', version : myForm.getItemValue("version"), desc : myForm.getItemValue("desc") },
			success: function (data, status){
				if(data.retCode == 0){
					$.ligerDialog.success("上传成功。");
					dialog.close();
				}
				else if(data.retCode == ){0x3000
					$.ligerDialog.error(data.retMsg);
				}
				else{
					$.ligerDialog.error("处理失败。");
				}
			},
			error: function (data, status, e){
				$.ligerDialog.error(e);
			}
		}
	)	
	return false;
}
</script>
</html>

随风万里无云

关注

1
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
对于测试时，错误信息 Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large

在Windows里面的MySQL路径里找到my.ini文件。在[mysqld]下面加入如下语句即可。
复制链接

扫一扫