Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - 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²ÎÊýÀ´Ð޸ģ®

½ô¼±ÇóÖú£¬¸Ðл´ó¼Ò£®
ÒýÓÃ
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮

ÎÒÉèÖÃÁËÒ»¸ö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)

ÒýÓÃ
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

Oracle Æô¶¯µÄÎÊÌâ

oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html

Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..

cm ......

visual c#ÎÞ·¨Á¬½Óoracle£¿£¿£¿

´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺

δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......

ORACLE°²×°ÎÊÌâ

oracle°²×°Ê±£¬ÔÚ½øÐмì²âʱ£¬ÌáÊ¾ÍøÂç¼à²âδ³É¹¦£¬ÐèÒª°²×°ÐéÄâÍø¿¨

µ«ÊÇÎÒÃǰ칫ÊÒͬÑùÅäÖõÄÁ½Ì¨µçÄÔ£¬ÎªÊ²Ã´Ò»Ì¨³öÏÖÍøÂç¼à²âδ³É¹¦£¬¶øÁíһ̨»ú×Ó¾ÍûÓгöÏÖÕâÖÖÇé¿ö

ÔÚʲôÇé¿öÏ£¬»á³öÏÖÍøÂç¼à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ