Oracle JDBC ×Ô´øÁ¬½Ó³Ø
http://www.diybl.com/course/3_program/java/javajs/2008429/111906.html
Èç¹ûҪʹÓóصĻ°,¾Í±ØÐëʹÓÃOracleConnectionCacheImpl,¹²ÓÐÈýÖֳصIJßÂÔ:
DYNAMIC_SCHEME(ÊǶ¯Ì¬Ôö¼Ó.ÓÃÍêÈç¹û³¬¹ýÉÏÏÞÔò¹Øµô)
The cache will create connections above the specified maximum limit
when necessary but will in turn close connections as they are
returned to the cache until the number of connections is within the
maximum limit. Connections will never be cached above the maximum
limit. This is the default setting.
FIXED_RETURN_NULL_SCHEME (Ö±½Ó·µ»ØNull)
The cache will return a null connection once the maximum connection limit has been exceeded.
FIXED_WAIT_SCHEME (ʼÖյȴý)
The cache will wait until there is a connection available and will then return it to the calling application.
oracle.jdbc.pool
Class OracleConnectionCacheImpl
http://download.oracle.com/otn/utilities_drivers/jdbc/101020/javadoc/index.html
oracle Javadoc JDBC 11.2.0.1
http://publish.it168.com/2005/1215/20051215001801.shtml
OC4J 10g 10.1.3 Êý¾ÝÔ´ÖеÄÁ¬½Ó¸ßËÙ»º´æ
Ïà¹ØÎĵµ£º
ÔÚwindowsÏÂsqlplusÍêÈ«Õý³££¬¿ÉÊǵ½linuxÏ£¬sqlplusÖÐÎÄÏÔʾ¾Í³öÎÊÌâÁË£¬×ÜÊÇÏÔʾ“??”£¬Õâ¸öÎÊÌâÓÖÔõô½â¾öÄØ£¿
¾¹ýÔÚÍøÂçÉϲé×ÊÁÏ£¬ÒÔ¼°³¢ÊÔ£¬µÃµ½µÄ½â·¨ÈçÏ£º
ÆäʵºÜ¼òµ¥ÎÒÃÇÖ»ÒªÉèÖÃÍ˳ösqlplus,ÉèÖÃÏàÓ¦µÄ»·¾³±äÁ¿NLS_LANG
export NLS_LANG="SIMPLI ......
Ò» ÒýÑÔ
Êý¾Ý²Ö¿â¼¼ÊõÊÇÄ¿Ç°ÒÑÖªµÄ±È½Ï³ÉÊìºÍ±»¹ã·º²ÉÓõĽâ¾ö·½°¸£¬ÓÃÓÚÕûºÍµçÐÅÔËÓªÆóÒµÄÚ²¿ËùÓзÖÉ¢µÄÔʼҵÎñÊý¾Ý£¬²¢Í¨¹ý±ã½ÝÓÐЧµÄÊý¾Ý·ÃÎÊÊֶΣ¬¿ÉÒÔÖ§³ÖÆóÒµÄÚ²¿²»Í¬²¿ÃÅ£¬²»Í¬ÐèÇ󣬲»Í¬²ã´ÎµÄÓû§Ëæʱ»ñµÃ×Ô¼ºËùÐèµÄÐÅÏ¢¡£Êý¾Ý²Ö¿âϵͳÐèÒªÄܹ»¼°Ê±µØ×·×ٺͷÖÎö´óÁ¿µÄÀúÊ·Êý¾Ý£¬²¢Äܹ»¼°Ê±×ö³ö·ÖÎöºÍÔ¤²â£¬Òò´ËÊ ......
´¥·¢Æ÷ trigger
·ÖÀࣺǰ´¥·¢£¬ºó´¥·¢
Ðд¥·¢Æ÷£¬Óï¾ä´¥·¢Æ÷
Ðд¥·¢Æ÷ÓëÓï¾ä´¥·¢Æ÷µÄÇø±ð£º
Ðд¥·¢Æ÷ÒªÇóµ±Ò»¸ö DML Óï¾ä²Ù×÷Ó°ÏìÊý¾Ý¿âÖеĶàÐÐÊý¾Ýʱ£¬¶ÔÓÚÆäÖеÄÿ¸öÊý¾ÝÐУ¬Ö»ÒªËüÃÇ·ûºÏ´¥·¢Ô¼ÊøÌõ¼þ£¬¾ù¼¤»îÒ»´Î´¥·¢Æ÷,FOR EACH ROW Ñ¡Ïî˵Ã÷´¥·¢Æ÷ΪÐд¥·¢Æ÷£»
Óï¾ä´¥·¢Æ÷ ......
Ë÷Òý×éÖ¯±í£¨IOT£©ÓÐÒ»ÖÖÀàBÊ÷µÄ´æ´¢×éÖ¯·½·¨¡£ÆÕͨµÄ¶Ñ×éÖ¯±íÊÇÒÔÒ»ÖÖÎÞÐòµÄ¼¯ºÏ´æ´¢¡£¶øIOTÖеÄÊý¾ÝÊÇ°´Ö÷¼üÓÐÐòµÄ´æ´¢ÔÚBÊ÷Ë÷Òý½á¹¹ÖС£ÓëÒ»°ãBÊ÷Ë÷Òý²»Í¬µÄµÄÊÇ£¬ÔÚIOTÖÐÿ¸öÒ¶½áµã¼´ÓÐÿÐеÄÖ÷¼üÁÐÖµ£¬ÓÖÓÐÄÇЩ·ÇÖ÷¼üÁÐÖµ¡£
ÈçÏÂͼËùʾ£¬ÔÚIOTËù¶ÔÓ¦µÄBÊ÷½á¹¹ÖУ¬Ã¿¸öË÷ÒýÏî°üÀ¨<Ö÷¼üÁÐÖµ£¬·ÇÖ÷¼üÁÐÖµ>¶ø ......
´æ´¢¹ý³Ì´´½¨Óï·¨£º
create or replace procedure ´æ´¢¹ý³ÌÃû£¨param1 in type£¬param2 out type£©
as
±äÁ¿1 ÀàÐÍ£¨Öµ·¶Î§£©;
±äÁ¿2 ÀàÐÍ£¨Öµ·¶Î§£©;
Begin
Select count(*) into ±äÁ¿1 from ±íA whereÁÐÃû=param1£»
If (ÅжÏÌõ¼þ) then
&n ......