| « | ÆßÔÂ 2009 | » | ||||
|---|---|---|---|---|---|---|
| Ò» | ¶þ | Èý | ËÄ | Îå | Áù | ÈÕ |
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 | ||
×î½ü¡¶ÍøÂç³Éñ«ÁÙ´²Õï¶Ï±ê×¼¡·³ÉΪ´ó¼ÒÕùÂ۵Ľ¹µã¡£ÍøÂçÍæÓÎÏ·£¬¿Ï¶¨»áÉÏñ«£¬ÕâÃ»Ê²Ã´Ææ¹ÖµÄ£¬µ«²»Òª¶¯²»¶¯¾Í°ÑËü»®È뾫Éñ²¡Ö®ÁУ¬ÌýÆðÀ´¹ÖÏÅÈ˵ġ£
1. ɱÈËÊÇ¿ÉÒԵġ£
2. ËÀ£¿Ã»¹ØÏµ¡£Äã¿ÉÒÔËÀÁËÔٻ»îÁËÔÙËÀ¡£
3. ÄãÖ»ÓÐ14ËêÊǰɣ¬Äã¿ÉÒÔÕü¾ÈÈ«ÊÀ½ç£¡
4. ÄãÓв¡Êǰɣ¿Ö»Òª¶ãǽºóÃæ£¬Äã»áÁ¢¼´»Ö¸´½¡¿µ¡£
5. ʳÎïµôÔڵذåÉÏÁË£¬¼ðÆðÀ´ÕÕÑù³Ô----Ä㸸ĸµÄ»°ÊÇ´íµÄ¡£
6. ȡʤ²»ÐèÒª·þÓÃÐ˷ܼÁ¡£
7. ½¨ÖþÎïÎݶ¥²ØÓгÉÏäµÄºÃ¶«Î÷£¬ÄãÒª¾³£È¥²é¿´£¬¿ÉÒÔÆïĦÍгµ´Ó·À»ðÌÝÉϹýÈ¥²é¿´¡£
8. µÐÈ˲»ÊÇÖ±½Ó±Æ½üÄ㣬¶øÊÇÕ¾ÔÚ´«ËÍ´øÉÏ£¬ÒÀ´ÎÓëÄã½ÏÁ¿¡£
9. Ïòºóת¶¯ÅÚËþ²¢Ò»Ö±¿ª»ð£¬Ì¹¿Ë¿ÉÒÔÅܵøü¿ì¡£
10. ÊÀÉϵÄÒ»Çж¼ÊÇÓÉʳÎľͷºÍ»Æ½ðÖÆ³ÉµÄ¡£
11. ÔÚÖÜΧ»Î¶¯20ÃëÖ®ºó£¬¾ø´ó¶àÊýÊØÎÀ¶¼»áÍü¼ÇÒ»¼þÊÂÇ飬¾ÍÊÇÄãÔøÊÔͼ¶óËÀËûÃǵ«×îÖÕδÄܵóѡ£
12. ÔÚÏÖ´úÕ½³¡ÉÏ£¬Îä´ò¹¦·òÕÕÑùÍþÁ¦Îޱȡ£
13. Öе¯ºó£¬Äã²»»á¸Ðµ½ÈκÎÍ´¿à£¬Ò²²»»áÓ°ÏìÄãµÄÄ¿±ê£¬µ«Ëüȷʵ»áÓ°ÏìÄãµÄÊÓÁ¦¡ª¡ªÑÛǰһƬºìÉ«£¬µ±È»ÁË£¬ºìɫֻ»á³ÖÐø¼¸ÃëÖÓ¡£
14. Èç¹ûÒ»ÃûÍõåú±»ÕþµÐ»òÕ߿ֲÀ·Ö×Ó°ó¼Ü£¬Ã÷ÖǵÄ×ö·¨²»Êdzö¶¯ÌØÖÖ²¿¶ÓÓª¾È£¬¶øÊÇÅɳöÒ»ÃûË®¹Ü¹¤ÈË¡£
15. ÄãÖ»ÐèÒª½«ÅåǹָÏòǽ±Ú²¢¿Û¶¯°â»ú£¬±ã¿ÉÍê³É×°µ¯¡£
16. Ïä×ÓÄÚÖ»ÓÐÒ»¸öÎïÆ·£¬¸öÍ·Ò²Òª±ÈÏä×ÓСºÜ¶à¡£Õâ¸öÎïÆ·Í¨³£ÖÃÓÚÏä×ÓÖÐÑ룬¶øÇÒûÓÐÈκΰü×°¡£
17. Äãµ¯ÌøµÄ¸ß¶ÈÊÇÄãÉí¸ßµÄÁ½±¶£¬µ«ÄãÒ»ÓöË®±ã»áËÀ¡£
18. Äã¸ù±¾²»ÐèҪͨ¹ý½ÌÓýºÍÂôÁ¦¹¤×÷»ñµÃ¾ÑéºÍ֪ʶ¡£ËùÓÐÕâЩÄÜÁ¦¾ù¿ÉÒÔͨ¹ýÔÚÏçÏÂËÄ´¦á÷ÁÔ»ñµÃ¡£
19. Çмǣ¬Ò»¶¨Òª´ò¿ªÓöµ½µÄÈκÎÏä×Ó£¬ÀïÃæ¾³£Óкö«Î÷¡£
20. ÏÖ´úÎäÆ÷µÄÓÐЧÉä³Ì´ïµ½Êý°ÙÓ¢Àµ«ÔÚδÀ´µÄËùÓÐÌ«¿ÕÕ½¡¢¿ÕÕ½ÒÔ¼°º£Õ½ÖУ¬ÕâЩÎäÆ÷Ö»ÄÜ´ò»÷´óÔ¼50ÂëÒÔÄڵĵÐÈË¡£
21. ÏÖʵÉú»îÖеķÉÐÐÔ±¿ÉÄÜÒª×ñÊØºÜ¶àÑϸñµÄ¹æ¶¨£¬µ«ÔÚÓÎÏ·Õâ¸öÐéÄâÊÀ½ç£¬ÄãÈ´¿ÉÒÔ¼ÝÊ»ÈκÎÐͺŵķɻúÒÔµ¹Á¢×Ë̬´óÒ¡´ó°ÚµØ´Ó½ðÃÅ´óÇŵ×Ï´©¹ý£¬²¢ÇÒ²»±Øµ£ÐÄÓöµ½ÈκÎÂé·³¡£
22. Õ½Õù×îºÃÍæ¡£
23. ²»¹ÜÄã»÷ÖжԷ½Ê²Ã´²¿Î»£¬Ö»Òª»÷ÖдÎÊý´ïµ½Ò»¶¨³Ì¶È£¬¶Ô·½±ãÁ¢¼´ËÀµô¡£
24. ×ß½üÎäÆ÷ºÍÄÃÆðÎäÆ÷ûÓÐÈκα¾Öʲî±ð£¬×ÜÖ®Õâ¸öÎäÆ÷¾ÍÊÇÄãµÄÁË¡£
25. ÔÚÖÐÊÀ¼Í£¬Å®È˾³£³öÕ÷Õ½³¡£¬Ëù´©¿ø¼×µÄ±£»¤ÐÔÓëÄÐÈ˵Äîø¼×²¢ÎÞ²îÒ죬¾¡¹ÜÕâЩ¿ø¼×Ö»¸Çס²¿·ÖƤ·ô¡£
26. ÂÞÂíºÍÖÐÊÀ¼Í½«¾ü¶¼ÓµÓпɷŴóºÍÐýתµÄ3DÕ½³¡µØÍ¼£¬Í¨¹ýµã»÷´ó¼ýÍ·Ö¸»ÓÊ¿±ø×÷Õ½¡£
27. ËùÓÐÈ˲»ÊÇ˵ӢÓ¾ÍÊÇ˵ÈÕÓÄÉ´â¡¢ÍâÐÇÈ˶¼ÊÇÈç´Ë¡£
28. ±»È˸ɵôÖ®ºó£¬ÄãÓÐ10ÃëÖÓ¾ö¶¨ÊÇ·ñ¼ÌÐøÍ¶ÈëÕ½¶·¡£ÓÐʱºò£¬¡°ËÀ¶ø¸´Éú¡±×î¶àÈÃÄ㻨µãÒø×Ó¡£
29. Ö»ÒªÖÁÉÙÈÔ´÷×ÅÒ»¸ö½äÖ¸£¬Äã¾ÍÓÀÔ¶²»»áËÀ¡£
30. °Î³öÎäÆ÷Ö®ºó£¬ÎÞÂÛÄ㳯ʲôµØ·½¿´£¬Äã¶¼ÄÜ¿´µ½Ò»¸ö¡°+¡±·ûºÅ¡£
31. ´ÓÒ»¶ËÅܵ½ÁíÒ»¶Ë»òÏòºóÅܵÄÈÝÒ×ÓëÃô½Ý³Ì¶ÈÓëÏòǰÅÜÍêȫһÑù¡£
32. ÅÖ×Óͨ³£¾ÍÊǶñÈË¡£¼´Ê¹¿ªÊ¼Ê±Ã»Óж³öÕæÃæÄ¿£¬ËûÃÇÒ²»áÔÚ×îºó±³ÅÑÄã¡£
33. Ò»´ÎÖ»ÄÜÓÃÒ»¸±»¬Ñ©°å£¬ÔڶȼÙʤµØ£¬Î¨Ò»Âô»¬Ñ©°åµÄµêÆÌ×ÜÊÇλÓÚ·±Ã¦¸ßËÙ·¶ÔÃæ£¬²¢ÇÒûÓÐΪ²½ÐÐÕß×¼±¸ÈκÎͨµÀ¡£
34. ¶¯Îïͨ³£¶¼»á½²»°¡£
35. ÔÚ̹¿Ë´óÕ½ÖУ¬Äã¿ÉÒÔÖ±½ÓÔÚÕ½³¡ÖÆÔìÊýÁ¿¾ªÈ˵Ä̹¿Ë£¬ËæºóÒ»´ÎÐÔÅɳöÊý°ÙÁ¾Ì¹¿Ë¶ÔµÐ¾ü×î¼á¹ÌµÄÄ¿±êʵʩÕýÃæ¹¥»÷¡£
36. ¶ÔÊÖÕ½°Üµ«ÈÔ¾²¾²µØÕ¾ÔÚÄÇ£¬ÕâÊÇÔÚ¸æËßÄ㣬ËûÃǵȴýÄ㿳µôËûÃǵÄÄÔ´ü¡£
37. Èç¹û°´ÕÕ¿¨Í¨¶¯ÎïÐÎÏóµÄÒªÇóÖØ¸´Á¬ÐøµÄÎ赸¶¯×÷£¬Äã¾Í¿ÉÒÔÔÚ¼¸·ÖÖÓÖ®ÄÚѧ»á¿ÕÊÖµÀºÍ¼ÝÊ»¼¼Êõ¡£
38. ×÷ΪһÃû¹ÜµÀ¹¤£¬Ã¿Ìì´÷×Ű×ÊÖÌ×¹¤×÷ÏÔÈ»²»ÊÇÒ»¸öÃ÷ÖǵÄÑ¡Ôñ£¬µ«ÊÂʵÉÏ£¬¼´Ê¹´Ó¹ÜµÀÖÐ×¥³ö·¢³ö¶ñ³ôµÄÃÞÍÅ£¬ÄãµÄ°×ÊÖÌ×Ò²²»»á±»ÅªÔà¡£
39. ±»Äã¸ÉµôµÄµÐÈ˵ÄʬÌå»áÔÚ¼¸ÃëÖÓÄÚÏûʧ¡£
40. ÄãÓÀÔ¶²»»áˤõÓ£¬¼´Ê¹ÒÔ×î¿ìµÄËÙ¶ÈÏòºóÅÜ£¬ÄãÒ²Äܿ۶¯É¢µ¯Ç¹µÄ°â»ú¡£
41. ²Î¼Ó¶þÕ½µÄ²½±ø²¿¶ÓʹÓõÄÐл°ÓëÏÖ´ú·´¿ÖÌØ¾¯×éÒ»Ñù£¬ÆäÖаüÀ¨¡°lol¡±¡¢¡°n00b¡±ÒÔ¼°¡°OMG HaXXoR!!11!¡±¡£
42. Èç¹û²»È¥¿´ËûÃÇ£¬Ò»Ð©ÈËÓÀÔ¶²»»áÀ´¿´Äã¡£
43. Äã²»ÐèÒªÓгöÁîÈËÏÛĽµÄ¿Ú²Å£¬ÈÏʶÁ½¸öµ¥´Ê×é³ÉµÄÃüÁî¾Í×ã¹»ÁË¡£
44. Õ¾ÔÚÕýÒåÒ»·½²¢²»Òâζ×ÅÄãÒ»¶¨ÄÜÈ¡µÃʤÀû¡£
45. Ö»Òª´óº°¡°FUND¡±£¬ÄãµÄÒøÐдæ¿îÓà¶î±ã¿ÉÒ»´ÎÔö¼Ó1000ÃÀÔª¡£
46. Ö»ÒªÌß×ã¹»ÊýÁ¿µÄС¹·£¬Äã¾Í¿ÉÔö¼ÓÁ¦Á¿¡¢ÖǻۺÍÃô½ÝÐÔ£¬×îÖÕ³ÉΪÈÌÕß¡£
47. ʳÎïÄܹ»Á¢¼´ÖÎÓú×îΪÑÏÖØµÄËðÉË¡£
48. µç×ÓÈË¡¢ÈÌÕߺÍÌØ¹¤Äܹ»³àÊÖ¿ÕÈ´Ý»ÙÕû×ù³ÇÊв¢ÔÚ½ü¾àÀë¸ñ¶·Öн«×îΪ¿ÉŵĶÔÊÖÕ¶ÓÚÂíÏ£¬µ«Ãæ¶ÔÉÏËøµÄÃÅ»òÏä×Ó£¬ËûÃÇÒ²²»µÃ²»Ñ°ÕÒÔ¿³×£¬·ñÔò¾Í±ÂÏë´ò¿ª¡£
49. ÎÞÂÛʲôʱºò£¬Ö»ÒªÄã×öһЩÁîÈËÐ˷ܵÄÊÂÇ飬ÒôÀ־ͻá×ÔÈ»¶øÈ»µØÏìÆð¡£
50. ÏÖ´ú¾üÊÂѵÁ·½Ì»áÄã´ò»÷µÐÈ˵Ä×îÓÐЧ·½Ê½¾ÍÊÇÕ¾ÔÚÄÇÀï¾²Ö¹²»¶¯£¬Ö±ÃæµÐÈ˲¢ÃÍÁÒ¿ª»ð¡£´ËÍâ£¬ÖÆÔìһЩÏÕ¶ñµÄÔëÒô±©Â¶×Ô¼ºµÄλÖÃÒ²ÊÇÒ»¸ö²»´íµÄÑ¡Ôñ¡£
51. Èç¹ûÔÚשǽÉÏ·¢ÏÖÒ»¿éÍÊÉ«µÄµØ·½£¬ÅܹýȥѹһÏ£¬Ëü¿ÉÄܵ¹Ëú²¢Ö¸ÒýÄãÕÒµ½²ØÓÐÎäÆ÷ºÍ¿ø¼×µÄÃØÃֿܲ⡣
52. Èç¹ûʳÎï³Ô¹â¡¢Îï×ÊÓþ¡£¬ÄãÖ»ÐèÀ뿪·¿×Ó¶øºóÔÙÖØÐ½øÈ룬±ãÓÖ¿ÉÒÔ¡°·áÒÂ×ãʳ¡±¡£
53. ±»Äã¸ÉµôµÄµÐÈËÓÐʱ»á±ä³ÉʳÎï¡¢ÏÖ½ð»ò×Óµ¯¡£
54. Ö»ÒªÔø¾È¥¹ýij¸öµØ·½£¬²»¹ÜÏÖÔÚÉíÔں䦣¬Äã¶¼¿ÉÒÔÁ¢¼´»Øµ½ÄǸöµØ·½¡£
55. ¼±¾È°üÄܹ»ÔÚÒ»ÃëÖÓÖ®ÄÚ×÷ÓÃÓÚÄãµÄÉ˿ڣ¬²»µ«Äܹ»ÈÃÉË¿ÚÂíÐÐÓúºÏ£¬Í¬Ê±»¹»áÔö¼ÓÉúÃüÖµ¡£
56. ÊÖµçͲֻÄܼá³ÖÒ»·ÖÖÓ£¬²»¹ýû¹ØÏµ£¬ËüÃÇ¿ÉÒÔ×ÔÐгäµç¡£
57. Èç¹ûÄãÉÆÓÚ×öÉúÒ⣬ÊÀ½çÉϵÄÿһ¼ÒµêÆÌ¶¼»áÌØ±ðΪÄã½µ¼Û¡£
58. Äã¿ÉÒÔ¹ýÉÏÒ»ÖÖ³äÂúðÏÕµÄÉú»î²¢ÇÒ½»¼¸¸öÅóÓÑ£¬Õû¸ö¹ý³ÌÉõÖÁ¿ÉÒÔÒ»Ö±±£³Ö¡°±Õ×족״̬¡£
59. Äã¿ÉÒÔЯ´øÎÞÏÞÊýÁ¿µÄÎïÆ·£¬°üÀ¨ÖÜÈÕ¿¾ÈâµÄÈ«Ì×É豸£¬Í¬Ê±ÓÖ²»Ó°ÏìÄãµÄÐнøËÙ¶È»òÍâÔÚÐÎÏó¡£
60. ÓëÈ˶Ի°µÄÈÝÒ׳̶ȳ¬ºõÈËÃÇÏëÏó¡£ÄãÒª×öµÄ¾ÍÊÇ×¼±¸Á½¸ö»ò3¸ö¿ÉÄܵĴ𸴣¬¶øºóÑ¡ÔñÒ»¸ö×ÔÈÏÄܹ»»ñµÃ×î´ó½±ÀøµÄ¼´¿É¡£
61. Å®±øÐ¯´ø¶à¸öÖØÐÍÎäÆ÷£¬µ«Éí²ÄÃçÌõ£¬Ðж¯Ãô½Ý£¬ÓµÓÐ˶´óµÄÐØ²¿¡£
62. Ö÷Ì⹫԰¡¢¶¯ÎïÔ°µÄÖ÷È˺ÍÒ½Éú»áÓøñ¶··½Ê½ÌôÑ¡·Ã¿Í£¬¼´Ê¹½«·Ã¿ÍÄçËÀÔÚºþÀïÒ²²»»áÊܵ½Èκγͷ£¡£
63. ÄÉ´â¡¢ÍâÐÇÈëÇÖÕßÒÔ¼°Ð°¶ñ¼¯Íž³£Îª¶ÔÊÖÁôÏÂÒ½ÁƲ¹¸øÆ·£¬¡°°ïÖú¡±ËûÃÇÁÆÉË¡£¶ø¶ÔÓÚ×Ô¼ÒÊ¿±ø£¬ËûÃÇÈ´Ï´²»ÄÜÅö¡±µÄÖ¸Áî¡£
64. ÔÚ80Äê´úÒýÈë3Dģʽ֮ǰ£¬ÓÎÏ·ÖеÄÈËÎïÒÆ¶¯Ëٶȷdz£»ºÂý£¬·½Ê½Ò²½ÏΪµ¥Ò»¡£
65. Ö»ÒªÖØÐÂÅÅÁÐÒ»ÏÂ×Óµ¯¼ÐºÍ¿ÉÀÖ¹Þ£¬ÄãµÄ·«²¼±³°ü¾Í¿ÉÄÜÔÙ×°½øÒ»¸ö»ð¼ýͲ¡£
66. Èç¹û¿´µ½×Ô¼º²»Ï²»¶µÄÈË´ôÔÚÓÎÓ¾³ØÀֻÐè¼òµ¥µØÉ¾³ý×ß³öÓ¾³ØµÄ²½Ö裬ËûÃǾͻáÒòΪ½îÆ£Á¦¾¡ÄçËÀÔÚ³ØÖС£
67. ÇàÍÜ»áÔÚË®ÖжªµôÐÔÃü¡£
68. Äã¿ÉÒÔÔÚ¼¸Ð¡Ê±ÄÚÒ»Ö±¶¢×ÅÅ®È˵ÄÈéÍ·£¬²¢ÇÒÎÞÐèΪÕâÖÖÎÞ³ÜÐÐΪ¸Ðµ½Èκβ»°²¡£È»¶ø£¬Èç¹ûÊÔͼÏñ϶¨¾öÐĵÄÊ¥²®ÄÉȮһÑùÃÍÆË¹ýÈ¥£¬Äã¾³£»ñµÃÕâÑùµÄϳ¡¡ª¡ª±»ËýµÄÊÞÆ¤Òµ¯¿ª¡£
69. ×ۺϾüÊÂѵÁ·²»¹ýÊÇÖ¸ÅÀÉþË÷¡¢¶×·üÁ·Ï°ÒÔ¼°Íê³É¼¸´ÎÉä»÷¡£
70. Äã²»Óõ£ÐÄ×Ô¼º²»ÉÆÓÚÈüÅܶøÊäµô±ÈÈü£¬ËùÓжÔÊÖ¶¼»á²»ÑáÆä·³µØÒ»¶øÔÙ¡¢ÔÙ¶øÈýµØÅãÄã±ÈÊÔÏÂÈ¥£¬Ö±µ½ÄãÓ®ÁËΪֹ¡£
½ñÌì¿´µ½Ò»Æ¬ºÃÎÄÕ£¬ºÍ´ó¼Ò·ÖÏíһϡ£ ²é¿´È«ÎÄ
application express ¼ò³Æ APEX£¬
ÊÇÒ»¸öÓÃÀ´¿ìËÙ¹¹½¨webÓ¦ÓõĿò¼Ü£¬ÍêÈ«»ùÓÚ¶¨ÒåµÄ·½Ê½£¬ÎÞÐèרҵµÄ¿ª·¢¼¼ÄÜ£¬¿ÉÒÔÔÚ¼«¶ÌµÄʱ¼äÄÚÍê³É·Ç³£¸´Ôӵı¨±í£¬¼òÖ±¾ÍÊÇ»¥ÁªÍøÊ±´úµÄform¡£¡£¡£
²é¿´È«ÎÄ
°²×°×îа汾µÄAPEX ,3.1.2
ÏÂÔØ3.1.2 zip°ü£¬µØÖ·
http://www.oracle.com/technology ... press/download.html ²é¿´È«ÎÄ
½ðÈÚΣ»úÊ®Ïî×¢Ò⣺ ²é¿´È«ÎÄ
ÆÕͨÈËÈçºÎÓ¦¶Ô¾¼ÃΣ»ú ²é¿´È«ÎÄ
ǰ¼¸ÌìÔÚÆ½°²ÉîÛÚ×ܲ¿×öÁËÒ»¸ö¼¼Êõ½»Á÷ºÍ¾Ñé·ÖÏí£¬Ïë²»µ½Æ½°²ÉîÛÚ×ܲ¿£¬ÉϺ££¬³É¶¼¶¼²Î»áÁË£¬¾ÓÈ»À´ÁË50-60¸öÈË¡£¡£¡£¡£
×ʼ˵ҪÀ´100¶àÈË£¬¿Éϧ»áÒéÊÒ²»¹»´ó£¬ÈÝÄɲ»ÁËÄÇô¶àÈË¡£
»¹ÓкܶàÅóÓѾÍÕ¾ÔÚÃÅ¿ÚÌý£¬ºÜ¸Ð¶¯£¬ºÜÓгɾ͸Ð.....
²é¿´È«ÎÄ
¡¡¶Ì¶ÌÒ»ÔÂÄÚ£¬ÓÖÒ»¼Ò±£ÏÕ¼¯ÍŸ߲ãÒ×ÈË¡£¼ÌÖÐÔÙ¼¯ÍÅÖ®ºó£¬Öйú±£ÏÕ£¨¿Ø¹É£©ÓÐÏÞ¹«Ë¾£¨Ïã¸ÛÖйú±£ÏÕ£¨¼¯ÍÅ£©ÓÐÏÞ¹«Ë¾£¬Ï³ơ°Öб£¼¯ÍÅ¡±£©½üÈÕÐû²¼£¬Ô¶Ê ³¤¡¢µ³Î¯Êé¼Ç·ëÏþÔöÒòÄêÁäÔÒòжÈΣ¬ÓÉÔ¸±¶Ê³¤¡¢×ܾÀíÁÖ·«½ÓÈζʳ¤¡¢µ³Î¯Êé¼ÇÖ°Îñ£¬Ô¸±×ܾÀíËÎÊï¹âÈÎ×ܾÀí¡¢µ³Î¯¸±Êé¼ÇÖ°Îñ¡£
ÔÚ8ÔÂ19ÈÕÕÙ¿ªµÄÖб£¼¯ÍŸ߼¶¹ÜÀíÈËÔ±»áÒéÉÏ£¬±£¼à»á¸±Ö÷ϯÖÜÑÓÀñÕýʽÐû²¼ÕâÒ»ÈËÊÂÈÎÃâ¾ö¶¨¡£
¡¡¡¡ÈýÄêǰ£¬Ê±Äê58ËêµÄ·ëÏþÔöÓɱ£¼à»á¸±Ö÷ϯһְµ÷ÈÎÖб£¼¯ÍŶʳ¤£¬¶þ´Î¡°½áÔµ¡±Öб£¼¯ÍÅ¡£ÔçÔÚ1986Ä꣬·ëÏþÔöÔøÈÎÖ°Öб£¼¯ÍÅǰÉíÖйú±£ÏչɷÝÓÐÏÞ¹«Ë¾°ÄÃÅ·Ö¹«Ë¾×ܾÀí£¬ÆäºóÀúÈÎ̫ƽ±£ÏÕÏã¸Û·Ö¹«Ë¾×ܾÀí¡¢Öб£¼¯ÍÅ×ܾÀíÖúÀí¼æÈËʲ¿¸ºÔðÈË¡£1998Ä꣬·ëÏþÔö³öÈα£¼à»á¸±Ö÷ϯ£¬·Ö¹Ü²ÆÏÕºÍÔÙ±£ÏÕ¡£
²é¿´È«ÎÄ
±¾´ÎÒ»¹²ÑûÇëÁË4λÔÚÒµ½çÖªÃûµÄר¼ÒÒ»ÆðÀ´·ÖÏíËûÃÇÔÚÐÔÄÜ·½Ãæ£¬ÌØ±ðÊÇ´óÊý¾ÝÁ¿´ó²¢·¢»·¾³ÏµľÑé¡£³öϯµÄ¶¼ÊÇoracleµÄÖØÒªÕ½ÂÔ¿Í»§ºÍÖØÒª¼¯³ÉÉ̵Ä×ÊÉîDBA£¬×ܹ²ÓÐ50¶àÈ˲μÓÁËÉϺ£ºÍ±±¾©µÄround table,·´À¡Ï൱²»´í¡£
²é¿´È«ÎÄ
ͨ¹ýÇ°ÃæµÄϵÁнéÉÜ£¬ÏàÐÅ´ó¼Ò¶ÔÔõô°²×°TT£¬ÔõôÅäÖÃTT¶¼±È½ÏÊìϤÁË¡£Æäʵ´ó¼Ò×î¸ÐÐËȤµÄ»¹ÊÇTTµÄÐÔÄܵ½µ×ÓжàÇ¿
ÄÇôÏÂÃæ½«Í¨¹ý¶Ô±È²âÊÔÀ´¿´¿´TTµÄ¼¸ÖÖÁ¬½Ó·½Ê½ÏÂ(Ö±½ÓÄÚ´æ·ÃÎÊ,TCP/IP C/S·½Ê½£¬»¹Óдò¿ªlogºÍcheckpoint)
µÄÐÔÄܵ½µ×ÔõôÑù¡£¡£¡£
²âÊÔ·½·¨(Ïà¶Ô¼òµ¥£¬²»¹»ÍêÉÆ£¬Ï£Íû´ó¼Ò²»ÒªÈÓ¼¦µ°£¬±Ï¾¹ÊÇÀûÓÃÏÐϾʱ¼ä²âµÄ)£º
ͨ¹ýÒ»¸öjava³ÌÐò£¬Ö±½ÓÁ¬½ÓTT£¬Ò»´ÎÐÔ²åÈë10ÍòÌõ¼Ç¼(ÿ´Î²âÊÔǰ£¬ÏÈtruncate ±í)£¬È»ºóÌá½»£¬¼Ç¼´Ó»ñµÃjdbcÓï¾äÖ®ºóµ½Ö´ÐÐÍê³ÉÌá½»ËùÐèµÄʱ¼ä¡£
²âÊÔ·ÖÀàÈçÏ£¬Ã¿¸ö²âÊÔ5´Î£¬È¡Æ½¾ùʱ¼ä(µ¥Î»Ç§·ÖÖ®Ò»Ãë)£º
1.ͨ¹ýÖ±½ÓÄÚ´æ·ÃÎÊ·½Ê½Á¬½Ó£¬ÎÞlog£¬ÎÞcheckpoint £¬×Ô¶¯commit,ƽ¾ù 1103
2.ͨ¹ýtcp/ip·½Ê½Á¬½Ó£¬ÎÞlog£¬ÎÞcheckpoint ,×Ô¶¯commit,ƽ¾ù 25339
3.ͨ¹ýÖ±½ÓÄÚ´æ·ÃÎÊ·½Ê½Á¬½Ó£¬ÓÐlog£¬ÓÐcheckpoint ,×Ô¶¯commit,ƽ¾ù 1919
4.¶Ôoracle½øÐÐͬÑùµÄ²Ù×÷£¬ÓÉÓÚ²Ù×÷ʱ¼äÌ«³¤£¬·ÅÆú..... £¬ÊµÔÚÌ«³¤ÁË
5.ͨ¹ýÖ±½ÓÄÚ´æ·ÃÎÊ·½Ê½Á¬½Ó£¬ÎÞlog£¬ÎÞcheckpoint £¬×Ô¶¯commit off,ƽ¾ù 560
½áÂÛ:
TT¿Í»§¶Ëͨ¹ýÖ±½ÓÁ¬½Ó·½Ê½£¬Ö±½Óͨ¹ý¹²ÏíÄÚ´æ½»»»ÐÅÏ¢£¬ËÙ¶ÈÊÇͨ¹ýtcp/ipµÄ·½Ê½µÄ25±¶¡£
Èç¹û´ò¿ªlogºÍcheckpoint£¬ÐÔÄÜ»ù±¾Ï½µ1±¶¡£
Èç¹ûÉèÖÃautocommit off £¨È±Ê¡ÊÇÿÌõÓï¾äÖ´ÐÐÍê³É£¬×Ô¶¯commit£©,ÐÔÄÜÔÚÌá¸ßÔ¼Ò»±¶£¡£¡£¡ ²é¿´È«ÎÄ
ÕâÖÖģʽӦ¸ÃÊÇ×îÓмÛÖµµÄ
Á½Ì¨TTͬʱ¶ÔÍâÌṩ·þÎñ£¬TTÖ±½Óͨ¹ý¸´ÖÆÊµÏÖÊý¾Ýͬ²½£¬
ͬʱÿ¸öTT¶¼Í¨¹ýcache agent°Ñ±ä»¯µÄÊý¾Ý´«µÝµ½ºǫ́µÄORACLE£¬ÕâÖּܹ¹Ó¦¸ÃÊÇÎÒÃÇ×î¹ØÐĵģ¬Ò²ÊÇ×îÓÐÓõġ£
ÈçºÎÅäÖÃÄØ£¿
ÒÔÈçÏ»·¾³ÎªÀý˵Ã÷
Ö÷»ú rac01°²×°ÁËTT ,data store·ÅÔÚ /oracle/timesten/TimesTen/tt70/info/wzy £¬ÎļþÒÔwzy¿ªÍ·£¬DSN=wzy_tt70
Ö÷»ú rac02°²×°ÁËTT ,data store·ÅÔÚ /oracle/timesten/TimesTen/tt70/info/wzy £¬ÎļþÒÔwzy¿ªÍ·£¬DSN=wzy_tt70
Êý¾Ý¿âΪһRAC£¬·Ö±ð×°ÔÚrac01ºÍrac02£¬SID·Ö±ðΪrac1ºÍrac2
1.ÔÚoracleÉÏÃæ½¨Á¢ÐèҪͬ²½µÄ±í
sqlplus tt/tt@rac1
create table t1(id number(2) primary key);
2.ÅäÖÃrac01ºÍrac02µÄoracle clientµÄtnsnames.ora£¬
¼ÓÉÏ
RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac01)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac1)
)
)
3.ÅäÖÃrac01ºÍrac02ÉϵÃwzy_tt70£¬×îºóÈçÏÂ
[wzy_tt70]
Driver=/oracle/timesten/TimesTen/tt70/lib/libtten.so
DataStore=/oracle/timesten/TimesTen/tt70/info/wzy/wzy
DatabaseCharacterSet=WE8ISO8859P1
Authenticate=0
PermSize=64
TempSize=16
UID=tt
OracleId=rac1
OraclePwd=tt
4.ÔÚrac01ºÍrac02µÄTTÉÏÃæ·Ö±ð´´½¨µ½oracleµÄcache
ttIsql wzy_tt70
Command>call ttCacheUidPwdSet('tt','tt');
Command>call ttCacheStart;
Command>CREATE USERMANAGED CACHE GROUP update_anywhere_t1
>AUTOREFRESH
>State off
>MODE INCREMENTAL
>INTERVAL 5 SECONDS
>FROM t1(id number(2) primary key,PROPAGATE);
×¢Ò⣺AUTOREFRESH µÄ State Ò»¶¨ÒªÉèÖÃΪ off£¬ÒòΪÎÒÃÇͬʱ´ò¿ªÁËÁ½Ì¨TTµÄдºÍ¸´Öƹ¦ÄÜ£¬¾Í²»ÄÜ×Ô¶¯°ÑoracleµÄ±ä»¯Í¬²½µ½TTÁË£¬ËùÒÔÔÚÕâÖÖÇé¿öÏ£¬¾Í²»½¨ÒéÔÚoracleÉÏÃæ×öÊÂÎï²Ù×÷ÁË¡£
5.ÔÚrac01ºÍrac02µÄTTÉÏÃæ·Ö±ð´´½¨µ½¸´ÖÆ
ttIsql wzy_tt70
Command> CREATE REPLICATION reptest
>ELEMENT e_1 TABLE t1 MASTER wzy on "rac01" SUBSCRIBER wzy on "rac02"
>ELEMENT e_2 TABLE t1 MASTER wzy on "rac02" SUBSCRIBER wzy on "rac01"
6.Æô¶¯rac01ºÍrac02ÉÏÃæµÄreplication agent
ttAdmin -repStart wzy_tt70
7.ÔÚrac01ÉÏÃæµÄTT´Óoracle load data
LOAD CACHE GROUP update_anywhere_t1 COMMIT EVERY 256 ROWS;
Í깤ÁË£¬Ò»¸ö¾ßÓÐ×î¸ß¿ÉÓÃÐԵ쬶øÇÒ×îÓÐʵ¼Ê¼ÛÖµµÄTT¼Ü¹¹¾ÍÍê³ÉÁË¡£¡£¡£
²é¿´È«ÎÄ
Èç¹ûÖ»ÓÐһ̨TT·ÅÔÚÇ°ÃæÌṩ·þÎñ£¬¾ÍËãËüÔٿ죬¿ÉÄÜÄãÒ²Òª¿¼ÂÇһϣ¬Õâһ̨TT³öÎÊÌâÁËÔõô°ì£¿
TTµÄ½â¾ö·½°¸¾ÍÊÇͨ¹ýÀàËÆORACLE data guard¼¼ÊõµÄ¸´ÖÆ£¬ÊµÏָ߿ÉÓÃÐÔ¡£
ÔÚTTÀïÃæ£¬Ô´TT³ÆÎªmaster,¶øÄ¿±êTT³ÆÎª subscriber ¡£
ÔÚTTÀïÃæ£¬¿ÉÒÔ¶¨ÒåÈçÏÂһЩÀàÐ͵ĸ߿ÉÓÃÐÔ»·¾³
1.һ̨TTΪÖ÷£¬ÁíÍâһֻ̨×öÊý¾Ý¸´ÖÆ
µ±Ö÷TT³öÏÖÎÊÌâµÄʱºò£¬ÁíÍâһ̨½Ó¹ÜÒµÎñ
2.һ̨TTΪÖ÷£¬ÁíÍâһ̨TTΪactive standby
µ±Ö÷TT³öÏÖÎÊÌâµÄʱºò£¬ÁíÍâһ̨½Ó¹ÜÒµÎñ£¬ÕâÖÖģʽÓõÃ×î¶à£¬Ò²ÊÇTTÍÆ¼öµÄģʽ
3.Á½Ì¨TTͬʱ¶ÔÍâÌṩ·þÎñ£¬µ«ÊÇÖ»·Ö±ðÌṩ²¿·Ö±íµÄ²Ù×÷
±ÈÈçTT AÌṩ±íÒ»µÄ²Ù×÷£¬Í¬Ê±°Ñ±íÒ»µÄÐÞ¸Äͬ²½µ½TT B
¶øTT BÔòÌṩ±í¶þµÄ²Ù×÷£¬Í¬Ê±°Ñ±í¶þµÄÐÞ¸Äͬ²½µ½TT A
4.Á½Ì¨TTͬʱ¶ÔÍâÌṩͬÑùµÄ·þÎñ
ͬһÕűí¿ÉÒÔͬʱÔÚTT A ºÍTT BÉÏÃæÌṩ·þÎñ
ÔÚËùÓеĸ߿ÉÓÃÐÔģʽÏ£¬TT¶¼¿É¹©ÁËÈýÖÖÊý¾Ýͬ²½Ä£Ê½
1.ÍêÈ«Òì²½
ÕâÖÖģʽÏ£¬ÊÂÎïÔÚmaster Ö±½ÓÌá½»£¬ÓÉ replication agent¸ù¾ÝÈÕÖ¾Òì²½Íê³Éͬ²½¹¤×÷
ÕâÖÖģʽÌá¸ßÁË×î¸ßµÄÐÔÄÜģʽ¡£
2.°ëͬ²½Ä£Ê½
ÕâÖÖģʽÏ£¬ÊÂÎïÔÚmaster Ìύʱ£¬ÓÉ replication agent °ÑÐÞ¸ÄÐÅÏ¢¸´ÖƵ½ subscriber ,µÈ subscriber È·ÈÏÊÕµ½ÕâЩÐ޸ĺó£¬
ÊÂÎïÔÚmasterÉϲÅÄÜÌá½»¡£
3.Íêȫͬ²½Ä£Ê½
ÕâÖÖģʽÏ£¬ÊÂÎïÔÚmaster Ìύʱ£¬ÓÉ replication agent °ÑÐÞ¸ÄÐÅÏ¢¸´ÖƵ½ subscriber ,µÈ subscriber È·ÈÏÊÕµ½ÕâЩÐ޸ĺ󣬲¢ÇÒÔÚsubscriber Ó¦ÓÃÍê³ÉÕâЩÊÂÎï²¢Ìá½»ºó£¬ÊÂÎïÔÚmasterÉϲÅÄÜÌá½»¡£
ÕâÖÖģʽÌá¸ßÁË×î¸ßµÄ±£»¤Ä£Ê½¡£
ÕâºÍoracleµÄdata guard±£»¤Ä£Ê½¼¸ºõÒ»Ö¡£
ͬ²½µÄÔÀíÊÇ masterºÍ subscriber ¶¼Í¨¹ýreplication agent ,¸ù¾ÝÈÕÖ¾µÄÐÅÏ¢£¬Ï໥ͬ²½¡£
¸´ÖƵĵ¥Î»¿ÉÒÔÊÇÒ»ÕÅ±í£¬¼¸ÕÅÓÐÖ÷Íâ¼ü¹ØÏµµÄ±í£¬»òÕßÕû¸ödata store .
´´½¨¸´ÖÆ£¬·Ç³£µÄ¼òµ¥£¬ÒÔÈçÏ»·¾³ÎªÀý˵Ã÷
Ö÷»ú rac01°²×°ÁËTT ,data store·ÅÔÚ /oracle/timesten/TimesTen/tt70/info/wzy £¬ÎļþÒÔwzy¿ªÍ·£¬DSN=wzy_tt70
Ö÷»ú rac02°²×°ÁËTT ,data store·ÅÔÚ /oracle/timesten/TimesTen/tt70/info/wzy £¬ÎļþÒÔwzy¿ªÍ·£¬DSN=wzy_tt70
Ê×ϯ¼ì²érac01ºÍrac02µÄ /etc/hostsÎļþ£¬¼ÓÉ϶Ôrac01,rac02µÄ½âÎö
ÈçÏ£º
10.0.0.1 rac01
10.0.0.2 rac02
ÎÒÃÇÒÔtest_r±íΪÀý˵Ã÷£¬Ê×ÏÈÔÚÁ½Ì¨TTµÄdata storeÉÏÃæ½¨Á¢¸Ã±í
ttIsql wzy_tt70
Command> create table test_r(id number(2) primary key);
È»ºóµÇ½rac01
Ö´ÐÐÈçϲÙ×÷:´Órac01¸´ÖƵ½rac02
´´½¨µ¥ÏòµÄ¸´ÖÆ
µÇ½rac01µÄwzy_tt70 data store
ttIsql wzy_tt70
Command>CREATE REPLICATION reptest ELEMENT TABLE test_r MASTER wzy on "rac01" SUBSCRIBER wzy on "rac02";
×¢Ò⣺MASTER ºÍ SUBSCRIBER ºóÃæ¸úµÄ¶¼ÊÇ data store¶ÔÓ¦µÄÎļþÃûµÄǰ׺£¡ ±ÈÈç
datastoreµÄÅäÖÃÊÇ
/oracle/timesten/TimesTen/tt70/info/wzy/dstest£¬ÄÇô¾ÍÓ¦¸ÃÊÇdstest .
È»ºóÔÚrac01ºÍrac02ÉÏÃæ Æô¶¯ replication agent
ttAdmin -repStart wzy_tt70
ÔÚrac01µÄwzy_tt70ÉÏÃæÉú³ÉһЩ¼Ç¼£¬ÏÖÔÚ¾ÍÄܹ»Í¬²½µ½rac02µÄwzy_tt70ÁË¡£
¼òµ¥°É£¿
TT×îµäÐ͵ÄÓ¦Ó㬾ÍÊÇTTºǫ́Á¬½ÓÒ»¸öoracleÊý¾Ý¿â£¬TTÖ»±£ÁôÉÙÁ¿µÄ×îÐèÒªµÄÊý¾ÝÒÔÌṩ×î¿ìµÄ·ÃÎÊËÙ¶È£¬¶ûºǫ́oracleÊý¾Ý¿âÔòÓÃÀ´±£ÁôËù
ÓеÄÊý¾Ý£¬ÔÚTTÐèÒªµÄʱºò£¬¿ÉÒÔ´ÓoracleÀïÃæ×Ô¶¯³éÈ¡Êý¾Ýµ½TT£¬µ±È»£¬TTÀïÃæµÄÊý¾ÝÒ²¿ÉÒÔ×Ô¶¯Í¬²½µ½oracle£¬Õâ¸ö¹¦ÄÜ£¬ÊÇĿǰÆäËûÄÚ´æ
ÐÍÊý¾Ý¿âÔÝʱÎÞ·¨ÌṩµÄ£¬»òÕß²»¿ÉÄÜ×öµ½ÕâôºÃµÄ£¬±Ï¾¹TTºÍoracleÊÇͬһ¼Ò¹«Ë¾µÄ²úÆ·£¬µ±È»Äܹ»¸üºÃµÄÎ޷켯³ÉÁË¡£
ÔÚTTÀïÃæ£¬cacheÓÐÏÂÃæ¼¸ÖÖÀàÐÍ
1.read only
Êý¾Ý´Óoracle ×Ô¶¯Ë¢Ðµ½ TTÀïÃæ£¬TTÀïÃæÎÞ·¨×öÐ޸ġ£
µäÐÍÓ¦ÓÃÊÇÔÚTTÀïÃæ±£´æÖ»¶ÁµÄ²úÆ·ÐÅÏ¢£¬Óû§ÐÅÏ¢µÈµÈ£¬¶¨ÆÚ´ÓoracleˢиÃÐÅÏ¢
2.Ò첽д
Êý¾ÝÔÚTTÀïÃæ¸üУ¬Òì²½´«µÝµ½oracle ¡£
ÕâÖֱȽÏÊʺÏÔÚTTÉÏÃæ×öÊÂÎñÐÔ²Ù×÷£¬È»ºóͬ²½µ½oracle
3.ͬ²½Ð´
Êý¾ÝÔÚTTÀïÃæ¸üУ¬Í¬²½´«µÝµ½oracle ¡£
ÕâÖֱȽÏÊʺÏÔÚTTÉÏÃæ×öÊÂÎñÐÔ²Ù×÷£¬È»ºóͬ²½µ½oracle
4.È˹¤¹ÜÀíµÄcache
ÔÚÕâÖÖģʽÏ£¬Êý¾Ý¿ÉÒÔͬʱÔÚTTºÍoracleÀïÃæ¸üУ¬×Ô¶¯Í¬²½µ½¶Ô·½¡£
ÕâÖÖ·½Ê½×îÁé»î£¬µ«ÊÇÐèÒª¿¼ÂÇÊý¾Ý³åÍ»µÄÎÊÌ⣬±ÈÈçͬʱÔÚoracleºÍTTÉÏÃæÐÞ¸ÄͳһÌõ¼Ç¼£¬Ôõô´¦Àí¡£
µ±È»TTÌṩÁË»ùÓÚʱ¼ä´ÁµÄ´¦Àí»úÖÆ¡£
ͬ²½µÄÔÀíÊÇÔÚoracleÉÏÃæ¸üеÄÊý¾Ý»áͨ¹ýtrigger²¶»ñ¼Ç¼ÏÂÀ´£¬È»ºóͨ¹ýcache agent¶¨ÆÚÀ´»ñÈ¡ÕâЩÐÅϢͬ²½µ½TT¡£
¶øTTÉϵÄͬ²½ÔòÊÇͨ¹ý·ÖÎöTTµÄ²Ù×÷ÈÕÖ¾À´»ñµÃ×öÁËÄÇЩDML²Ù×÷£¬È»ºóͨ¹ýcache agentͬ²½µ½oracle . ²é¿´È«ÎÄ
ÓÉÓÚÏÖÔÚ»ùÓÚj2eeµÄÓ¦ÓÃÔ½À´Ô½¶à£¬ÎÒ¾ÍÒÔjavaΪÀý£¬ËµÃ÷ÈçºÎͨ¹ýjdbcÁ¬½Óµ½ÉÏÒ»½ÚÎÒÃǽ¨Á¢ºÃµÄdata store.
Ê×ÏÈÎÒÃÇÐèÒª¶¨Òåclasspath£¬¼ÓÉÏÈçϵÄtimestenµÄjdbc
/oracle/timesten/TimesTen/tt70/lib/ttjdbc14.jar::.:/oracle/product/10.2.0/db_1/jdbc/lib/ojdbc14.jar
È»ºóͨ¹ýÈçϵijÌÐò´úÂë½øÐзÃÎÊ
import java.sql.*;
import javax.sql.*;
public class Tttest{
public static void main(String args[])
{
//Ô¶³ÌÁ¬½ÓÐèÒªµÄurl£¬³ÌÐòºÍTT²»ÔÚһ̨·þÎñÆ÷¡£ÐèÒª°´ÕÕÉϽڵķ½·¨£¬Ìáǰ¶¨ÒåºÃDSN
String URL = "jdbc:timesten:client:dsn=wzyCS_tt70";
//±¾µØÁ¬½ÓÐèÒªµÄurl£¬³ÌÐòºÍTTÔÚͬһ̨·þÎñÆ÷
//String URL = "jdbc:timesten:direct:dsn=wzy_tt70";
Connection con = null;
try {
//¼ÓÔØTTµÄÇý¶¯³ÌÐò
Class.forName("com.timesten.jdbc.TimesTenDriver");
} catch (ClassNotFoundException ex) {ex.printStackTrace();
}
try
{
//»ñµÃÁ¬½Ó
con = DriverManager.getConnection(URL);
System.out.println("connected");
//´´½¨jdbc Óï¾ä
java.sql.Statement st=con.createStatement();
//Ö´ÐÐsql ²éѯ²Ù×÷
java.sql.ResultSet rs=st.executeQuery("select * from test");
while (rs.next())
{
//È¡³ö½á¹û¼¯
System.out.println(rs.getString("id"));
}
//¹Ø±ÕÁ¬½Ó
con.close();
// Handle any errors
} catch (SQLException ex) {
ex.printStackTrace();}
}
}
Èç¹ûTT¹¤×÷Õý³££¬DSN¶¨ÒåÕý³££¬ÎÒÃǾÍÄÜ¿´µ½java³ÌÐòÊä³ö ½á¹ûÁË¡£
³ýÁ˸տªÊ¼µÄurlºÍdriver²»Ò»ÑùÒÔÍ⣬ÆäËûµÄ¶¼ÊDZê×¼µÄjdbcÓï·¨£¬ºÜ¼òµ¥£¬Ò²ºÜÇ¿´ó¡£
timestenϵÁÐÈý£ºÈçºÎ°²×°´´½¨×Ô¼ºµÄdata store
ÔÚÍê³ÉÉÏÃæµÄ°²×°ÈÎÎñÖ®ºó£¬ÒòΪÎÒÃÇÐèÒªTT´æ·ÅÎÒÃÇÓ¦ÓõÄÊý¾Ý£¬ÎÒÃǾÍÒªÅäÖÃ×Ô¼ºµÄdata storeÁË(Àí½âΪoracleÀïÃæµÄschema)¡£
ÔÚ×öÕâ¸öÈÎÎñ֮ǰ£¬ÐèÒªÀåÇåÒ»¸ö¸ÅÄDSN=data source name ,Õâ¸öÊDZê×¼µÄODBCµÄÓÃÓÓÃÀ´ÃèÊöÒ»¸ö¿ÉÒÔÌṩodbcÁ¬½ÓµÄÊý¾Ý¿â·þÎñÆ÷£¬
ÔÚtimestenÀïÃæ£¬ËùÓеÄÁ¬½Ó¶¼ÊÇͨ¹ýodbcµÄ£¬¾ÍËãÊÇjdbcÒ²ÊÇͨ¹ýodbcÁ¬½Óµ½µ½TTÉϵġ£
ÔÚTTÀïÃæ£¬ÓÐÁ½ÖÖDSN
1.ϵͳһ¼¶µÄDSN¶¨ÒåÔÚ·þÎñÆ÷¶Ë£¬¶¨Òå¸Ãdata storeµÄÎļþ´æ·ÅλÖã¬ÒÔ¼°ÆäËûµÄһЩ¿ØÖƲÎÊý£¬±ÈÈçÊÇ·ñÐèÒªlog£¬ÊÇ·ñ´ò¿ªcheckpointµÈµÈ¡£
2.¿Í»§¶ËµÄDSN£¬ÓÃÀ´ÃèÊöÒ»¸öÔ¶¶Ë·þÎñÆ÷ÉϵÄdata store£¬¿Í»§¶Ë³ÌÐòÓÃÀ´Á¬½Óµ½·þÎñÆ÷
Ê×ÏÈÎÒÃÇÔÚ¸Õ²Å×°ºÃµÄTT·þÎñÆ÷É϶¨Òå¸öÁ½¸öDSN£¬Ò»¸öϵͳһ¼¶µÄ£¬Ò»¸öÓû§Ò»¼¶µÄ
´ò¿ª $INSTALL_DIR/info/sys.odbc.ini
ÔÚ[ODBC Data Sources] ÏÂÃæÌí¼ÓÈçÏÂÁ½ÐÐ £¬¶¨ÒåÎÒÃÇÕâ¸ödata storeÐèÒªµÄdriver
wzy_tt70=TimesTen 7.0 Driver
wzyCS_tt70=TimesTen 7.0 Client Driver
È»ºóÔÚ ¸ÃÎļþµÄ×îºó£¬Ìí¼ÓÈçÏÂÄÚÈÝ£º
#¶¨Òåϵͳһ¼¶µÄDSN µÄÃû×Ö
[wzy_tt70]
#¶¨ÒåÇý¶¯
Driver=/oracle/timesten/TimesTen/tt70/lib/libtten.so
#¶¨ÒåÎļþ´æ·ÅλÖã¬Êý¾ÝÎļþºÍlog¶¼ÊÇ·ÅÔÚinfo/wzyĿ¼Ï£¬ÒÔ wzy Ϊǰ׺¿ªÊ¼µÄ
DataStore=/oracle/timesten/TimesTen/tt70/info/wzy/wzy
#¶¨ÒåÊý¾Ý¿âµÄ×Ö·û¼¯
DatabaseCharacterSet=WE8ISO8859P1
#¶¨ÒåÊÇ·ñÐèÒªÓû§ÊÚȨÈÏÖ¤
Authenticate=0
#¶¨ÒåÄÚ´æ´óС
PermSize=64
TempSize=16
#¶¨ÒåÓû§Ò»¼¶µÄDSN
[wzyCS_tt70]
#·þÎñÆ÷µÄµØÖ·
TTC_SERVER=LocalHost_tt70
#·þÎñÆ÷data storeµÄϵͳһ¼¶µÄDSN Ãû×Ö£¬¶ÔÓ¦ÉÏÃæ¶¨ÒåµÄ Ãû×Ö
TTC_SERVER_DSN=wzy_tt70 ²é¿´È«ÎÄ