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

oracleÓësybase Êý¾ÝÒÆÖ²µ½ÎÊÌâ

oracle£¬sybaseÊý¾Ý¿â·þÎñÆ÷¾ù²»ÔÚ±¾µØ£¬²»ÄÜ×öÅäÖñä¸ü£¬Ö»ÄÜÁ¬½Ó¡£
Òª½«oracleÊý¾Ý¿âÖеÄÒ»ÕÅ±íµ¼Èëµ½sybaseÊý¾Ý¿âÖУ¬ÓÃjavaÏà¹ØµÄ¼¼Êõ¸ÃÈçºÎʵÏÖ¡£
ÐèҪÿ°ë¸öСʱִÐÐÒ»´ÎÕâÑùµÄ²Ù×÷¡£

³õ²½½Ó´¥java£¬Çë´ó¼Ò¶à¶à棡

ͨ¹ý´ÓÒ»¸ö¿â°ÑÊý¾ÝÈ¡ÍêÉú³ÉÏàÓ¦µÄsql½Å±¾£¬È»ºóÔÚ¶ÔÁíÒ»¸ö¿âÖ´ÐÐÕâЩ½Å±¾¡£
ǰÌáÊÇ×öºÃ±í×ֶεÄÓ³Éä¹ØÏµ£¬oracleºÍsybaseµÄ×ֶζ¨ÒåÓÐЩ²î±ð¡£


ÓÃJDBCÁ¬½ÓÊý¾Ý¿â£¬´ÓoracleÈ¡ÊýÈ»ºóÆ´³ÉsqlÓï¾ä²åÈësybaseÊý¾Ý¿â¡£ÊÇÏȱ£´æ³Ésql½Å±¾ÔÙͳһ²åÈ뻹ÊÇÒ»±ß¶ÁÒ»±ß´æ¾ÍÒª¿´Êý¾ÝÁ¿ÁË¡£
ÓÃjava.util.TimerºÍjava.util.TimerTaskʵÏÖ¶¨ÆÚÔËÐÐÈÎÎñ¡£
Â¥Ö÷¿ÉÒÔgoogleÒ»ÏÂÏà¹ØµÄÄÚÈÝ¡£


ÓÐÖ»ÄÜѧϰÁË Õâ¸öÊý¾Ý¿â½²¾¿¿É¶àÁË
°ï¶¥ÆðÀ´

·¹ý

ѧϰ


Ïà¹ØÎÊ´ð£º

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

ssh oracle Á¬½Ó


Ðֵܠ ͼ¹ÒÁË¡£

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......

ÊÇ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Êý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......

¹ØÓÚoracle 10gµÄEMÆô¶¯ÎÊÌâ

oracle 10g°²×°Íê±ÏºóĬÈÏ»áÒÔÍøÒ³ÐÎʽÆô¶¯EM£¬µ«Îҹرպó¾ÍûÔÚ¿ªÊ¼²Ëµ¥ÀïÕÒµ½ÏàÓ¦µÄÍøÒ³Ä£Ê½Æô¶¯EMºÍJAVA³ÌÐòÆô¶¯µÄEMÑ¡ÏÇëÎÊÕâÊÇÔõô»ØÊ£¿
emÊǸö·þÎñ£¬

°²×°ºÃÒÔºóÓ¦¸ÃÔÚÄãµÄ·þÎñÁбíÀïÕÒµ½ÀàËÆOrac ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ