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

spring+hibernateÖд¦Àíoracle BLOB

 1¡¢ÅäÖÃhibernate£º
    1.1¡¢ÅäÖÃhibernateµÄ³Ö¾ÃÀàÎļþÖжÔÓ¦µÄ×Ö¶ÎΪbyte[]ÀàÐÍ
    2.2¡¢ÅäÖÃhibernateµÄÀàÓ³ÉäÎļþÖжÔÓ¦µÄ×Ö¶ÎtypeΪ 
            org.springframework.orm.hibernate3.support.BlobByteArrayType
2¡¢ÅäÖÃspring£º
    2.1¡¢ÅäÖÃnativeJdbcExtractor£¬ÈçÏ£º  
          <bean   id="nativeJdbcExtractor" 
               class="org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor" />
 
    2.2¡¢ÅäÖÃoracleLobHandler
       <bean id="oracleLobHandler"   class="org.springframework.jdbc.support.lob.OracleLobHandler" lazy-init="true">
         <property name="nativeJdbcExtractor">
             <ref bean="nativeJdbcExtractor" />
         </property>
       </bean>
   2.3°ÑoracleLobHandler¼ÓÈësessionFactoryÖÐ:
      <property name="lobHandler">
          <ref bean="oracleLobHandler" />
     </property>
3¡¢×ܽ᣺
    ÕýÈ·ÅäÖÃÒÔÉÏÁ½Ìõ£¬¾Í¿ÉÒÔÏñ´¦ÀíÆÕͨµÄ¶ÔÏóÒ»Ñù´¦ÀíoracleµÄ´ó¶ÔÏó¡£¶øÇÒ¿ÉÒÔ·½ÃæµÄ´ÓoracleÉÏÒÆÖ²µ½Ö§³Ö´ó¶ÔÏóµÄÆäËûÊý¾Ý¿âÉÏ£¬ÆÁ±ÎÁ˲»Í¬Êý¾Ý¿â´¦Àílob×ֶεIJî±ð£»
4¡¢À©Õ¹£º
    4.1¡¢´¦Àíclob¶ÔÏóÒ²ºÜ·½±ã£¬ÔÚÅäÖÃhibernateʱ°Ñ¶ÔÓ¦µÄÀàµÄÊôÐÔ×Ö¶ÎÅäÖÃΪString£¬Ó³ÉäÎļþtypeÅäÖÃΪorg.springframework.orm.hibernate3.support.ClobStringType¾ÍÐÐÁË¡£
        <property name="context" column="context" type="org.springframework.orm.hibernate.support.Cl


Ïà¹ØÎĵµ£º

ORACLE¶à±í²éѯÓÅ»¯

 ×ª×ÔijµØ,¶Ô×÷ÕߺÜÀ¢¾Î- -!²»ÏþµÃµØÖ·ÁË..
ORACLE¶à±í²éѯÓÅ»¯
ÕâÀïÌṩµÄÊÇÖ´ÐÐÐÔÄܵÄÓÅ»¯,¶ø²»ÊǺǫ́Êý¾Ý¿âÓÅ»¯Æ÷×ÊÁÏ:
²Î¿¼Êý¾Ý¿â¿ª·¢ÐÔÄÜ·½ÃæµÄ¸÷ÖÖÎÊÌâ,ÊÕ¼¯ÁËһЩÓÅ»¯·½°¸Í³¼ÆÈçÏÂ(µ±È»,ÏóË÷ÒýµÈÓÅ»¯·½°¸Ì«¹ý¼òµ¥¾Í²»ÁÐÈëÁË,ºÙºÙ):
Ö´Ðз¾¶:ORACLEµÄÕâ¸ö¹¦ÄÜ´ó´óµØÌá¸ßÁËSQLµÄÖ´ÐÐÐÔÄܲ¢½ÚÊ¡ÁËÄÚ´æµÄʹÓÃ: ......

OracleµÄÌåϵ

 oracleµÄÌåϵºÜÅÓ´ó£¬ÒªÑ§Ï°Ëü£¬Ê×ÏÈÒªÁ˽âoracleµÄ¿ò¼Ü¡£ÔÚÕâÀ¼òÒªµÄ½²Ò»ÏÂoracleµÄ¼Ü¹¹£¬ÈóõѧÕß¶ÔoracleÓÐÒ»¸öÕûÌåµÄÈÏʶ¡£
¡¡¡¡1¡¢ÎïÀí½á¹¹£¨ÓÉ¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ¡¢²ÎÊýÎļþ¡¢¹éµµÎļþ¡¢ÃÜÂëÎļþ×é³É£©
¡¡¡¡¿ØÖÆÎļþ£º°üº¬Î¬»¤ºÍÑéÖ¤Êý¾Ý¿âÍêÕûÐԵıØÒªÐÅÏ¢¡¢ÀýÈ磬¿ØÖÆÎļþÓÃÓÚʶ±ðÊý¾ÝÎļ ......

Oracle SQLµÄÓ²½âÎöºÍÈí½âÎö


 
˵µ½Èí½âÎö£¨soft prase£©ºÍÓ²½âÎö£¨hard prase£©£¬¾Í²»Äܲ»ËµÒ»ÏÂOracle¶ÔsqlµÄ´¦Àí¹ý³Ì¡£µ±Äã·¢³öÒ»ÌõsqlÓï¾ä½»¸¶Oracle£¬ÔÚÖ´ÐкͻñÈ¡½á¹ûǰ£¬Oracle¶Ô´Ësql½«½øÐм¸¸ö²½ÖèµÄ´¦Àí¹ý³Ì£º
    1¡¢Óï·¨¼ì²é£¨syntax check£©
    ¼ì²é´ËsqlµÄƴдÊÇ·ñÓï ......

Oracleѧϰ±Ê¼Çժ¼6


  declare
  begin
   --SQLÓï¾ä
   --Ö±½ÓдµÄSQLÓï¾ä(DML/TCL)
   --¼ä½Óдexecute immediate <DDL/DCLÃüÁî×Ö·û´®>
   --select Óï¾ä
        <1>±ØÐë´øÓÐinto×Ó¾ä
      &n ......

OracleʹÓõÄhintsµ÷Õû»úÖÆ

 
10gÊý¾Ý¿â½éÉÜ£º¿ÉÒÔʹÓøü¶àеÄoptimizer hintsÀ´¿ØÖÆÓÅ»¯ÐÐΪ¡£ÏÖÔÚÈÃÎÒÃÇ¿ìËÙ½âÎöÒ»ÏÂÕâЩǿ´óµÄÐÂhints:
spread_min_analysis

ʹÓÃÕâÒ»hint£¬Äã¿ÉÒÔºöÂÔһЩ¹ØÓÚÈçÏêϸµÄ¹ØÏµÒÀÀµÍ¼·ÖÎöµÈµç×Ó±í¸ñµÄ±àÒëʱ¼äÓÅ»¯¹æÔò¡£ÆäËûµÄһЩÓÅ»¯£¬Èç´´½¨¹ýÂËÒÔÓÐÑ¡ÔñÐԵĶ¨Î»µç×Ó±í¸ñ·ÃÎʽṹ²¢ÏÞÖÆÐÞ¶©¹æÔòµÈ£¬µÃµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ