´ó¼ÒºÃ£¬ÎÒÏëÎÊÒ»¸öÁ½¸öoracleÊý¾Ý¿âͨѶµÄÎÊÌâ
´ó¼ÒºÃ£¬oracleÄܲ»ÄÜʵÏÖÁ½¸öÊý¾Ý¿âÖ®¼äµÄͨѶ°¡
±ÈÈç˵ÎÒµ±Ç°´¦ÔÚÒ»¸öoracle·þÎñÆ÷ÉÏ£¬Îҿɲ»¿ÉÒÔ·ÃÎÊÁíÒ»¸ö·þÎñÆ÷ÉϵÄÊý¾Ý±í£¬²¢°Ñ¸Ã±íÄÚµÄÊý¾Ý²åÈ뵱ǰoracleµÄÊý¾Ý¿âÄÚÄØ£¿
ÓÃdatabase link
create database link user.US.ORACLE.COM
connect to user identified by "pw"
using 'orcl_111';
select * from user.table@user.US.ORACLE.COM;
,.......,,...........¿´ÊéÏÈ°É Â¥Ö÷·
Ïà¹ØÎÊ´ð£º
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......
±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......
ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©
ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿
¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡
Ò»°ã ......