Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 PL/SQLÈëÃÅÖ®¿®Êö

 Ò»¡¢PL/SQL³öÏÖµÄÄ¿µÄ
¡¡¡¡½á¹¹»¯²éѯÓïÑÔ(Structured Query
Language£¬¼ò³ÆSQL)ÊÇÓÃÀ´·ÃÎʹØϵÐÍÊý¾Ý¿âÒ»ÖÖͨÓÃÓïÑÔ£¬ËüÊôÓÚµÚËÄ´úÓïÑÔ£¨4GL£©£¬ÆäÖ´ÐÐÌصãÊǷǹý³Ì»¯£¬¼´²»ÓÃÖ¸Ã÷Ö´ÐеľßÌå·½·¨ºÍ;
¾¶£¬¶øÊǼòµ¥µÄµ÷ÓÃÏàÓ¦Óï¾äÀ´Ö±½ÓÈ¡µÃ½á¹û¼´¿É¡£ÏÔÈ»£¬ÕâÖÖ²»¹Ø×¢ÈκÎʵÏÖϸ½ÚµÄÓïÑÔ¶ÔÓÚ¿ª·¢ÕßÀ´ËµÓÐ׿«´óµÄ ......

OracleÖÐStart with...Connect ByÀí½â¼°Ó÷¨

oracleÖÐconnect by priorʵÏֵݹé²éѯ
ÊÕ¼¯µÄ¼¸ÌõÔÚoracleÖÐͨ¹ýconnect by priorÀ´ÊµÏֵݹé²éѯ
Start with...Connect By×Ó¾äµÝ¹é²éѯһ°ãÓÃÓÚÒ»¸ö±íά»¤Ê÷ÐνṹµÄÓ¦Óá£
´´½¨Ê¾Àý±í£º
CREATE TABLE TBL_TEST
(
ID    NUMBER,
NAME VARCHAR2(100 BYTE),
PID   NUMBER &nbs ......

Oracle ´æ´¢¹ý³ÌÖе÷ÓÃ×Ô¶¨ÒåµÄº¯ÊýÎÊÌ⣿

 ÎÒÏÖÔÚÔÚ×öÒ»¸öOracleÊý¾Ýµ¼È룬Ҫ½«EXCELÊý¾Ýµ¼Èëµ½OracleÊý¾Ý¿âÖУ¬ÏȶÁÈ¡Êý¾Ý£¬½«Êý¾Ý±£´æÔÚÒ»ÕÅÁÙʱ±íÖУ¬È»ºóµ¼Èë֮ǰ¶ÔÁÙʱ±íÖÐÊý¾ÝµÄÿ¸ö×Ö¶Î×öУÑ飬±ÈÈçÊý¾ÝÊÇ·ñΪÕûÊý£¬ÕûÊýµÄ×î´óλÊý£¬¼°µ¼ÈëµÄÊý¾ÝÔÚÔ­Êý¾Ý¿âÖÐÊÇ·ñÒѾ­´æÔڵȣ¬ÎÒдÁËÒ»¸ö´æ´¢¹ý³Ì£¬¶ÔÒì³£µÄÊý¾Ý£¬½«×ֶΓis_checked”ÉèΪÒì³ ......

OracleÊý¾Ý¿âÖØÐÂÆô¶¯²½Öè

 ±¾ÎÄÏêϸµÄ½éÉÜÁËOracleÊý¾Ý¿â½ÏºÃµÄÊ®ÖÖÖØÐÂÆô¶¯²½Öè¡£
¡¡¡¡1. Í£Ó¦ÓòãµÄ¸÷ÖÖ³ÌÐò¡£
¡¡¡¡2. Í£oralceµÄ¼àÌý½ø³Ì:
¡¡¡¡$lsnrctl stop
¡¡¡¡3. ÔÚ¶ÀÕ¼µÄϵͳÓû§Ï£¬±¸·Ý¿ØÖÆÎļþ:
¡¡¡¡SQL>alter database backup controlfile to trace;
¡¡¡¡4. ÔÚ¶ÀÕ¼µÄϵͳÓû§Ï£¬ÊÖ¹¤Çл»ÖØ×÷ÈÕÖ¾Îļþ£¬È·±£µ±Ç°ÒÑÐ޸Ĺýµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ