¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused by: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column
Èç¹û³¤¶È¸Ä³É500¾ÍûÎÊÌ⣮
ÈçºÎ½â¾öÕâ¸öÎÊÌ⣿Çë¸ø¸ö¼ò±ãµÄ·½·¨£¬ÒѾÕâÊÇÒѾÉÏÏßµÄϵͳ£¬²»ÊʺÏÔÙ×ö´óµÄ¸Ä¶¯£®
oracleµÄ³¤¶È´óСÊDz»ÊǼ¸£ËµÄÏÞÖÆ°¡£¬¿É²»¿ÉÒÔͨ¹ýµ÷oracle²ÎÊýÀ´Ð޸ģ®
½ô¼±ÇóÖú£¬¸Ðл´ó¼Ò£®
ÒýÓà ¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮ ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update Caused by: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column Èç¹û³¤¶È¸Ä³É500¾ÍûÎÊÌ⣮ ÈçºÎ½â¾öÕâ¸öÎÊÌ⣿Çë¸ø¸ö¼ò±ãµÄ·½·¨£¬ÒѾÕâÊÇÒѾÉÏÏßµÄϵͳ£¬²»ÊʺÏÔÙ×ö´óµÄ¸Ä¶¯£® oracleµÄ³¤¶È´óСÊDz»ÊǼ¸£ËµÄÏÞÖÆ°¡£¬¿É²»¿ÉÒÔͨ¹ýµ÷oracle²ÎÊýÀ´Ð޸ģ® ½ô¼±ÇóÖú£¬¸Ðл´ó¼Ò£®"Èç¹û³¤¶È¸Ä³É500¾ÍûÎÊÌâ",ÊÇÖ¸²åÈëÊý¾ÝµÄ³¤¶È»¹ÊÇvarchar2µÄ³¤¶È£¿
²åÈëÊý¾ÝµÄ³¤¶ÈΪ500.varchar2µÄ³¤¶È»¹ÊÇ3000
²åÈëÊý¾ÝµÄÊDz»ÊÇÓзÇasciiµÄ×Ö·û£¿
ÊÔһϰÑvarchar2¸Ä³Ænvarchar2ÊÔÒ»ÏÂ
»òÕ߸ÄÓÃvarchar2(3000 char)
ÒýÓà ¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
Ïà¹ØÎÊ´ð£º
with adod_dict do begin close; commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺ δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......
ÐÖµÜ Í¼¹ÒÁË¡£ <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value ......