聽(tīng)聽(tīng)@Lob
聽(tīng)聽(tīng)@Column(columnDefinition聽(tīng)=聽(tīng)"LongBlob")
聽(tīng)聽(tīng)public聽(tīng)byte[]聽(tīng)getContent()聽(tīng){
聽(tīng)聽(tīng)聽(tīng)聽(tīng)return聽(tīng)content;
聽(tīng)聽(tīng)}
涓寮濮嬶紝閰嶇疆mysql jdbc url濡備笅
jdbc.url聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)=聽(tīng)聽(tīng)聽(tīng)聽(tīng)jdbc:mysql://localhost/test\
聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)?useUnicode=true\
聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)&characterEncoding=gbk
涓嫻嬭瘯錛屾姤閿?br />Caused聽(tīng)by:聽(tīng)java.sql.BatchUpdateException:聽(tīng)Syntax聽(tīng)error聽(tīng)or聽(tīng)access聽(tīng)violation聽(tīng)message聽(tīng)from聽(tīng)server:聽(tīng)"You聽(tīng)have聽(tīng)an聽(tīng)error聽(tīng)in聽(tīng)your聽(tīng)SQL聽(tīng)syntax聽(tīng)near聽(tīng)''D0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF0900060000000000000'聽(tīng)at聽(tīng)line聽(tīng)1"
聽(tīng)聽(tīng)聽(tīng)聽(tīng)at聽(tīng)com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1540)
鍚屾牱鐨勮鍙ワ紝鐩存帴鍦╩ysql鍛戒護(hù)琛屼笅榪愯灝辨病闂錛屽亸鍋廽dbc涓婂氨鏈夎繖鑷瘺鐥呫傛崲jdbc driver鐗堟湰錛屾敼@Lob涓?@Type(type = "org.springframework.orm.hibernate3.support.BlobByteArrayType")錛屾敼hibernate閰嶇疆錛堟瘮濡俬ibernate.jdbc.use_streams_for_binary true錛夛紝鐢氳嚦鏄洿鎺ョ敤jdbc鏉nsert錛屼貢涓冨叓緋熸姌鑵懼崐澶╋紝闂鐓ф棫銆傛渶鍚庡彧濂界敤涓娾滄鈥濇嫑錛屾妸byte[]閰嶆垚String錛屽湪淇濆瓨鐨勬椂鍊欐妸byte[]淇濆瓨鎴恏ex String鏍煎紡錛屽彇鐨勬椂鍊欏啀瑙g爜鍥炴潵銆?br />
姝嫑緇堝綊鏄鎷涳紝榪欎袱澶╄佷負(fù)榪欎笢瑗垮績(jī)鐑?chǔ)锛屾櫄涓婂悆楗殑鏃跺欐棤鎰忎腑鎯寵搗charset鐨勯棶棰橈紝鎶婁唬鐮佹崱鍥炴潵鍐嶆祴璇曚簡(jiǎn)涓涓嬶紝闂瑙e喅錛屽搱鍝堬紒
jdbc.url聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)=聽(tīng)聽(tīng)聽(tīng)聽(tīng)jdbc:mysql://localhost/mmwy_blog\
聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)?useUnicode=true\
聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)聽(tīng)&characterEncoding=utf-8
濡傛灉璁炬垚iso-8859-1銆乽tf-8,淇濆瓨?shù)竴鐐歸棶棰橀兘娌℃湁錛屾崲鐢╣bk銆乬b2312銆乥ig5涔嬬被鐨勫瓧絎﹂泦錛岄棶棰樺氨鍑烘潵浜?jiǎn)銆?br />

]]>