mysql enregistrement_nested exception is java.sql.SQLException: Incorrect string value: '\xE7\x99\xB...

本文解决了一个Hibernate操作中出现的HTTPStatus500错误,详细介绍了因image字段类型不匹配导致的SQL异常,并提供了修改字段类型的解决方案。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

HTTP Status 500 - Hibernate operation: could not insert: [cn.itcast.shop.product.vo.Product]; uncategorized SQLException for SQL [insert into product (pname, market_price, shop_price, image, pdesc, is_hot, pdate, csid) values (?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE7\x99\xBB\xE9\x99\x86...' for column 'image' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xE7\x99\xBB\xE9\x99\x86...' for column 'image' at row 1

69bc5a20c742827ac9a5c3141710c75c.png

image字段类型有问题

f5a608c427cb00e5f3631810426861d9.png

修改字段类型:

mysql> alter table product modify image varchar(255) charset utf8 collate utf8_general_ci;

Query OK, 71 rows affected

Enregistrements: 71 Doublons: 0 Avertissements: 0

扩展:

修改字段名称:

mysql> alter table product change image images varchar(255);

Query OK, 0 rows affected

Enregistrements: 0 Doublons: 0 Avertissements: 0

以下是“PackageContents.xml ”代码 <?xml version="1.0" encoding="utf-8"?> <ApplicationPackage SchemaVersion="1.0" AutodeskProduct="AutoCAD" Name="Autodesk Save to Web and Mobile" NameChs="Autodesk 保存到 Web 和 Mobile" NameCht="Autodesk 儲存至網頁版和行動版" NameCsy="Uložit do služby Autodesk Web and Mobile" NameDeu="In Autodesk Web & Mobile speichern" NameEsp="Guardar en la versión web y para dispositivos móviles de Autodesk" NameFra="Enregistrement Autodesk sur le Web et au format mobile" NameHun="Mentés az Autodesk webes vagy mobil fiókba" NameIta="Salva su Autodesk Web & Mobile" NameJpn="Autodesk Web およびモバイルに保存" NameKor="Autodesk Save to Web and Mobile" NamePlk="Autodesk Save to Web & Mobile" NamePtb="Salvar para Web e dispositivos móveis da Autodesk" NameRus="Сохранить в Autodesk в интернете и на мобильных устройствах" Description="Open and save drawings to Autodesk Cloud." DescriptionChs="打开图形并将其保存到 Autodesk 云。" DescriptionCht="開啟和儲存圖面至 Autodesk Cloud。" DescriptionCsy="Umožňuje otevírat a ukládat výkresy ve službě Autodesk Cloud." DescriptionDeu="Öffnen und speichern Sie Zeichnungen in der Autodesk Cloud." DescriptionEsp="Abra y guarde dibujos en Autodesk Cloud." DescriptionFra="Ouvrir et enregistrer des dessins sur Autodesk Cloud." DescriptionHun="Rajzokat nyithat meg vagy menthet az Autodesk Cloud szolgáltatásban." DescriptionIta="Aprire e salvare i disegni su Autodesk Cloud." DescriptionJpn="Autodesk クラウドから図面を開いたり保存したりします。" DescriptionKor="도면을 열고 Autodesk Cloud에 저장합니다." DescriptionPlk="Otwórz i zapisz rysunki w usłudze Autodesk Cloud." DescriptionPtb="Abra e salve os desenhos no Autodesk Cloud." DescriptionRus="Открытие и сохранение чертежей в Autodesk Cloud." AppVersion="3.1.8" FriendlyVersion="3.1.8" ProductType="Application" SupportedLocales="Enu|Deu|Esp|Fra|Ita|Plk|Ptb|Chs|Cht|Csy|Hun|Jpn|Kor|Rus" AppNameSpace="appstore.exchange.autodesk.com" Author="Autodesk, Inc" ProductCode="{5BF7551A-09A6-4BDD-AE1E-048104FB478C}" UpgradeCode="{7DE2392C-408E-48AF-A7F6-48E9E1CD6D05}" OnlineDocumentation="www.autodesk.com" HelpFile="./Contents/Resources/en-US/SaveToWebMobHelp.htm" HelpFileFra="./Contents/Resources/fr-FR/SaveToWebMobHelp.htm" HelpFileIta="./Contents/Resources/it-IT/SaveToWebMobHelp.htm" HelpFileDeu="./Contents/Resources/de-DE/SaveToWebMobHelp.htm" HelpFileEsp="./Contents/Resources/es-ES/SaveToWebMobHelp.htm" HelpFilePtb="./Contents/Resources/pt-BR/SaveToWebMobHelp.htm" HelpFileChs="./Contents/Resources/zh-CN/SaveToWebMobHelp.htm" HelpFileCht="./Contents/Resources/zh-TW/SaveToWebMobHelp.htm" HelpFileCsy="./Contents/Resources/cs-CZ/SaveToWebMobHelp.htm" HelpFileHun="./Contents/Resources/hu-HU/SaveToWebMobHelp.htm" HelpFileJpn="./Contents/Resources/ja-JP/SaveToWebMobHelp.htm" HelpFileKor="./Contents/Resources/ko-KR/SaveToWebMobHelp.htm" HelpFilePlk="./Contents/Resources/pl-PL/SaveToWebMobHelp.htm" HelpFileRus="./Contents/Resources/ru-RU/SaveToWebMobHelp.htm" > <CompanyDetails Name="Autodesk" Url="www.autodesk.com" Email="apps@autodesk.com" Phone=" " /> <RuntimeRequirements OS="Win64" Platform="AutoCAD*|ACADLT" SeriesMin="R24.3" /> <!-- AutoCAD 2019 to 2025 --> <Components Description="AutoCAD x64"> <RuntimeRequirements OS="Win64" Platform="AutoCAD*" SeriesMin="R24.3" SeriesMax="R25.0" /> <RegistryEntries> <RegistryEntry Key="WebMobile" Name="WebMobAppPackageVersion" Value="3.1.8" Type="REG_SZ" Flags="Create|Open" /> </RegistryEntries> <ComponentEntry AppName="adefunsstartup" Version="1.0.0" ModuleName="./Contents/AutoCAD/$(OS)/defunsstartup.lsp" LoadOnAutoCADStartup="True"> <Commands GroupName="wdcj"> <Components> <!-- 为每个DLL创建单独的ComponentEntry --> <ComponentEntry ModuleName="./Contents/AutoCAD/win64/BW.dll" LoadOnAutoCADStartup="True"/> <ComponentEntry ModuleName="./Contents/AutoCAD/win64/bzxl.dll" LoadOnAutoCADStartup="True"/> <ComponentEntry ModuleName="./Contents/AutoCAD/win64/ktj.dll" LoadOnAutoCADStartup="True"/> <ComponentEntry ModuleName="./Contents/AutoCAD/win64/ljmtj.dll" LoadOnAutoCADStartup="True"/> <ComponentEntry ModuleName="./Contents/AutoCAD/win64/pkbz.dll" LoadOnAutoCADStartup="True"/> <ComponentEntry ModuleName="./Contents/AutoCAD/win64/pmxlg.dll" LoadOnAutoCADStartup="True"/> <ComponentEntry ModuleName="./Contents/AutoCAD/win64/tzcl.dll" LoadOnAutoCADStartup="True"/> <!-- CUIX菜单 --> <ComponentEntry AppName="MyCUIXLoader" ModuleName="./Contents/AutoCAD/win64/wodechajian.cuix" LoadOnAutoCADStartup="True"> <Commands> <Command Global="LoadMyCUIX" Local="加载菜单"> <AssemblyMapping Name="LoadMyCUIX" Path="./Contents/AutoCAD/win64/wodechajian.cuix"/> </Command> </Commands> </ComponentEntry> </Components> 按以下 步骤操作CAD启用后插件自动加载未成功 MyPlugin.bundle/ # 主文件夹(必须以此后缀结尾) ├── Contents/ # 核心内容目录(必须) │ ├── x64/ # 64位插件目录(必须) │ │ └── MyPlugin.dll # 你的插件DLL │ ├── en-US/ # 可选:英文资源目录(如帮助文件) │ └── resources/ # 可选:图标等资源 └── PackageContents.xml # 核心配置文件(必须)
最新发布
07-16
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值