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

ʹÓÃoracleÊý¾Ý¿âÁ¬½Óʱ³öÏÖ´íÎó£¬Çó½â~

ÎÒ´òËãʹÓÃVC6+SQLAPI++Á¬½ÓoracleÊý¾Ý¿â¡£ÎÒ¸Õ×°ÁËÒ»¸öoracle instant client¡£³ÌÐòÔËÐÐʱ²¶×½µ½ÕâÑùµÄ´íÎóÐÅÏ¢¡£


DBMS API Library 'ociw32.dll' loading fails
This library is a part of DBMS client installation, not SQLAPI++
Make sure DBMS client is installed and
this required library is available for dynamic loading

Win32:
1) The directory from which the application loaded
2) The current directory
3) The Windows, Windows system or 32-bit Windows system directory
4) The directories in the PATH environment variable

ÇëÎÊ»áÊÇʲôԭÒòÄØ£¿Ó¦¸ÃÔõô½â¾ö£¿Ð»Ð»¡£



Â¥Ö÷×°µÄÊǿͻ§¶Î£¬ÓзþÎñÆ÷¶ËÂð£¿

Äã×°µÄÊÇclient£¬ËäÈ»clientÒ²¿ÉÒÔ£¬µ«ÅäÖø´ÔÓ£¬ÄãÐèҪװһ¸ö·þÎñÆ÷¶Ë

ÒýÓÃ
Â¥Ö÷×°µÄÊǿͻ§¶Î£¬ÓзþÎñÆ÷¶ËÂð£¿


·þÎñÆ÷¶ËÊÇÁíÍâһ̨»ú¡£²»¹ý³ÌÐòÖÐÁ¬½ÓµÄÄÇЩÓû§ÃûºÍÃÜÂëÒÔ¼°Êý¾Ý¿âÊÇÂÒÌîµÄ£¬ÏëÏÈÊÔÊÔÄܲ»ÄÜÅÜÆðÀ´¡£Á¬½Ó²»³É¹¦»á³öÏÖÉÏÃæµÄ´íÎóÂð£¿

ÒýÓÃ
ÒýÓà 1 Â¥ tianlesoftware µÄ»Ø¸´:
Â¥Ö÷×°µÄÊǿͻ§¶Î£¬ÓзþÎñÆ÷¶ËÂð£¿


·þÎñÆ÷¶ËÊÇÁíÍâһ̨»ú¡£²»¹ý³ÌÐòÖÐÁ¬½ÓµÄÄÇЩÓû§ÃûºÍÃÜÂëÒÔ¼°Êý¾Ý¿âÊÇÂÒÌîµÄ£¬ÏëÏÈÊÔÊÔÄܲ»ÄÜÅÜÆðÀ´¡£Á¬½Ó²»³É¹¦»á³öÏÖÉÏÃæµÄ´íÎóÂð£¿


Óû§Ãû£¬ÃÜÂ룬 Êý¾Ý¿âIP£¬¶Ë¿Ú£¬±ØÐëÒªÕýÈ·£¬²»È»ÔõôÁ¬µÄÉÏȥѽ£¿

ºóÀ´Ã»ÓÃÕâ¸ö¿âÁË¡­¡­¡­¡­ÓÃÁËOCL~~~»¹ÊǽáÌù¸ø·Ö°É~~


Ïà¹ØÎÊ´ð£º

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

´óÁ¬ÄļÒoracleÅàѵºÃ

Ï뿼¸öocpÈÏÖ¤£¬µ±È»£¬Ò²ÏëºÃºÃѧµã¶«Î÷¡£
¿ÉÒÔ×ÔѧµÄ£¡

¸öÈ˾õµÃÖ»ÒªÕÆÎÕÁËÊý¾Ý¿âµÄ»ù±¾ÀíÂÛ£¬Âò²Î¿¼Êé×Ôѧ±È½Ïʵ¼Êµã£¬
ÌØ±ðÊÇÅàѵ̫¹ó²¢ÇÒ²»¿ÉÄÜѧµ½ºÜ¶à¶«Î÷£¡


Êý¾Ý¿âÊǸö³¤ÆÚµÄѧϰ¹ý³Ì£¬Â¥Ö÷¿ÉÒÔÂý ......

oracle ʵÏÖÈÎÒâµÄÐÐתÁÐÆ´½Óºó×ֶηûºÅÈçºÎ´¦Àí


×Ö¶Î FORGANGUID TOTAL FSTATETYPE
1 0412105DA35645EA9A32AE160EEA25BF 1;1 estIllnessRest;estRetire
2 05AF08C3195B4075847685E96711457D 1 estRegular
3 10EDE82520F24289B7 ......

¶à±í¹ØÁª²éѯµÄ sqlд·¨ - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ