hibernate使用sybase 15.0数据库,在未设置好DB参数时可能会造成乱码,出错显示如下:
Error 500: Hibernate flushing: Could not execute JDBC batch update; SQL [insert into CCS_LOG_ACTION (OP_ID, OP_TIME, MAINTYPE_CODE, SUBTYPE_CODE, SECONDTYPE_CODE, DESCRIPTION, DATALINE, BP_TYPE, BIZ_CODE, BIZ_ID, WORKSHEET_ID, WORKSHEET_NO, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; JZ0BE: BatchUpdateException:鎵ц鎵瑰鐞嗚鍙ユ椂鍑洪敊:Error converting characters into server's character set. Some character(s) could not be converted. ; nested exception is com.sybase.jdbc3.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException:鎵ц鎵瑰鐞嗚鍙ユ椂鍑洪敊:Error converting characters into server's character set. Some character(s) could not be converted.
解决办法:
sp_configure "disable character set conversions" ,1
"disable character set conversions"为静态数据,需要重启server。那先shutdown数据库,然后再./startserver -f servername
昨日帮同事安装LoadRunner9.1,把依赖(或可能需要)的组件都装上后,仍出现“command line option syntax error.type command /? for help” 错误,google一下,竟然跟很多SQLServer数据库安装出错的提示一样,可见http://www.918x.cn/post/679.html:
寻寻觅觅,终于还是在微软站点找到答案。是这样说的:
This problem may occur if all the following conditions are true:
• You run the SQL Server 2000 SP3 Setup.bat file from a folder that contains double-byte character set (DBCS) characters in the folder name.
• An ODBC client program that uses the Sqlsrv32.dll file is running on your computer.
我英文很烂,不过还是勉强看明白了。其中第一点是说,如果你把安装文件放在一个拥有双字节的名字的文件夹里就活该倒大霉。我的SQL SERVER2000安装盘的所在文件夹起了个中文名字,而汉字正是所谓的双字节。将文件夹名字改回英文再装,问题解决了。
分享到:
相关推荐
Converting the CONNECT sample to a local server在本地服务器实现连接的例子(6KB)
can convert the file into pdf format
Bytecode to source converting Java & Kotlin code into
一个简单的小程序,实现的功能是将文本转换成图像。
XML schema, XML document, extended entity relationship model, database schema, data type definition
code for converting gray scale image into color image by using template
主要介绍了spring cloud feign不支持@RequestBody+ RequestMethod.GET报错的解决方法,需要的朋友可以参考下
数据结构与算法分析,适合学习数据结构与算法分析的人使用
converting the values into it s per unit bases
showed greater angiotensin-converting enzyme-I (ACE-I) inhibitory activity (IC90 0.45 mg/mL) than other cephalopods (IC90>0.50 mg/mL). A significant colinearity was found between the electronegative ...
To help you quickly tap into the power of JSF 2.0, the third edition of Core JavaServer™ Faces has been completely updated to make optimum use of all the new features. The book includes Three totally...
D3D to opengl converting library
Yii Rapid Application Development Hotshot Project 1, Develop a Comic Book Database, helps you to set up your Yii development environment and create a project ...reusable by converting it into a module.
Converting floating english
Converting SIDs Between Strings and Binary
The process of converting the unstructured sequence of characters representing an XML document into the structured components such as XML syntax, declaration, comments, elements, attributes, ...
此函数根据由协方差矩阵的特征值的平方根组成的输入计算球面误差可能半径(等效地,来自坐标系中三变量正态分布的 sigma-x、sigma-y 和 sigma-z,其中存在变量之间没有互相关。)这意味着如果您有一个协方差矩阵并...
前端项目-europa,Library for converting HTML into valid Markdown
在操作数据库时,需要将字符串转换成decimal类型。 代码如下: select cast('0.12' as ...error converting data type varchar to numeric. select cast('0.12e+006' as decimal(18,2)); select convert(decimal
Poon, “Novel method for converting digital Fresnel hologram to phase-only hologram based on bidirectional error diffusion,” Opt. Express 21(20), 23680–23686 (2013).”所提方法编写的,用于计算全息中...