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

Ò»¸ö¼òµ¥µÄhibernateÁ¬½ÓoracleÊý¾Ý¿âÀý×Ó£¡

Ò»¡¢ Hibernate½éÉÜ
    HibernateÊÇ»ùÓÚ¶ÔÏó/¹ØÏµÓ³É䣨ORM£¬Object/Relational Mapping£©µÄÒ»¸ö½â¾ö·½°¸¡£ORM·½°¸µÄ˼ÏëÊǽ«¶ÔÏóÄ£ÐͱíʾµÄ¶ÔÏóÓ³Éäµ½¹ØÏµÐÍÊý¾Ý¿âÖУ¬»òÕß·´Ö®¡£HibernateĿǰÊÇORM˼ÏëÔÚJavaÖÐ×î³É¹¦¡¢×îÇ¿´óµÄʵÏÖ¡£ËüÓÚ2001ÄêµÄÄêÄ©·¢²¼µÚÒ»¸ö°æ±¾£¬Á¢¼´ÒýÆðÁ˹㷺µÄ×¢Òâ¡£2003Äê6Ô£¬Hibernate2·¢±í£¬²¢ÇÒ»ñµÃJolt´ó½±£¬½ø¶ø±»JBossÎüÄɳÉΪËüµÄÒ»¸ö×ÓÏîÄ¿¡£2005Äê3Ô£¬Hibernate 3·¢±í£¬ÆäÖÐ×öÁËһЩ±È½ÏÖØ´óµÄ¸Ä½ø¡£±¾ÎÄÒÔHibernate3Ϊ»ù´¡±àд¡£
    ÁíÍ⣬Hibernate³ýÁË¿ÉÒÔÔÚJ2EEÈÝÆ÷ÖÐÔËÐÐÍ⣬»¹¿ÉÒÔÔËÐÐÔÚJavaÓ¦ÓóÌÐòÖС£±¾ÎľÍÊÇÒÔJavaÓ¦ÓóÌÐòΪÀýÀ´½éÉÜËü¡£
¶þ¡¢ÅäÖÿª·¢»·¾³
    ±¾ÎÄÒÔÒ»¸öJavaÓ¦ÓóÌÐò£¨Java Application£©ÎªÀý£¬½éÉÜÈçºÎʹÓÃHibernateÀ´½øÐÐÊý¾Ý¿â²Ù×÷¡£
    ÔÚ½øÐÐHibernate¿ª·¢Ö®Ç°£¬ÐèÒªÊ×ÏÈ»ñµÃHibernateÀà¿â¡¢ÏàÓ¦Êý¾Ý¿âµÄJDBCÇý¶¯Àà¿â¡£HibernateÀà¿â¿ÉÒÔ´Óhttp://www.hibernate.orgÖÐÏÂÔØ£¬Ä¿Ç°µÄ°æ±¾ÊÇ3.0¡£¶øJDBCÇý¶¯¿ÉÒÔ¸ù¾Ý²»Í¬µÄÊý¾Ý¿âÀ´Ñ¡Ôñ£¬ÔÚÕâ¸öÀý×ÓÖУ¬Ê¹ÓõÄÊÇOracleÊý¾Ý¿â£¬ÄÇôÏàÓ¦µÄJDBCÇý¶¯¿ÉÒÔ´ÓOracle°²×°Ä¿Â¼\ora92\jdbcÏ»ñµÃ¡£ÆäËûµÄÊý¾Ý¿âÇë¸ù¾ÝÏà¹ØµÄ˵Ã÷»ñµÃ¡£
    ÏÂÔØHibernate°üºó£¬¿ÉÒÔ½«Ëü½âѹµ½Ò»¸öÎļþ¼Ð£¬´Ë´¦¼ÙÉèΪC:\hibernate-3.0£¬È»ºó½«C:\hibernate-3.0\ϵÄhibernate.jarºÍC:\hibernate-3.0\libϵÄÄÇЩµÚÈý·½Àà¿âÒ²·Åµ½»·¾³±äÁ¿CLASSPATHÖС££¨Í¨³££¬Ö»ÐèÒªdom4j¡¢cglig¡¢commons-logging¡¢commons-collections¡¢log4j¡¢ehcache¡¢asm¡¢jta¡¢antlrÕâЩÀà¿â¾Í¿ÉÒÔÁË£©
    ×öÍêÕâЩÅäÖú󣬾ͿÉÒÔÔÚ´Ë»ù´¡ÉϽøÐлùÓÚHibernateµÄJava³ÌÐò¿ª·¢ÁË¡£
Èý¡¢¿ª·¢»ùÓÚHibernateµÄÓ¦ÓÃ
    ÏÖÔÚ¼ÙÉèÎÒÃÇÔÚOracleÊý¾Ý¿âÖд´½¨ÁËÒ»¸ö±íStudent£¬ËüµÄ×Ö¶ÎÈçϱíËùʾ£º
×ֶΠ˵Ã÷
Student_ID ѧԱ±àºÅ£¬ÕûÐÍ£¬PK£¬×Ô¶¯Ôö³¤
Student_Name ѧԱÐÕÃû£¬×Ö·û´®ÀàÐÍ
Student_Age ѧԱÄêÁ䣬ÕûÐÍ
Èç¹ûÎÒÃÇÔÚOracleÖж¨ÒåÕâ¸öÊý¾Ý¿â±í£¬ÎÒÃÇ¿ÉÒÔ¶¨ÒåÒ»¸ö´´½¨Êý¾Ý¿â±íµÄSQL½Å±¾ÈçÏ£º
create table Student(
 Student_ID  number(6) NOT NULL PRIMARY KEY,
 Student_Name varchar2(10) NOT NULL,
 Student_Age number(2) NOT NULL
);
    ÁíÍ⣬ÒòΪÔÚOracleÖÐûÓГ×Ô¶¯Ôö³¤”ÀàÐ͵Ä×Ö¶Î


Ïà¹ØÎĵµ£º

oracleº¯Êý´óÈ« ×Ö·û´¦Àíº¯Êý

F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌØ±ð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖÆºÍ»ù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆÎª2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆÎª255×Ö·û(Ô ......

Oracle DB Link


Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£
  
1¡¢ ÅäÖÃTNS £¬ $ORACLE_HOME/NETWORK/ADMIN/tnsname.ora
10gstandby =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = HFCC-KF-3068)(PORT = ......

linux¹ØÓÚ$ORACLE_HOME/root.shºÍ/etc/oratab

1.°²×°Ê±ÒªÖ´ÐÐÁ½¸ö½Å±¾£¬root.shÊÇÆäÖÐÒ»¸ö¡£
   ÐèÒªÓÃrootÓû§Ö´ÐÐroot.shÈ¥Éú³É/etc/oratabÎļþ¡£————1.dbcaÖв»»áÓÐɾ³ýÑ¡Ïî(ÒòΪÔËÐÐʱÐèÒª/etc/oratab)
                   & ......

Oracle 10g R2 RACÔÚVMWAREÉϵݲװ

½¨Á¢sshÐÅÈΣ¬racµÄ°²×°ÒªÓÃsshºÍscpÀ´¿½±´°²×°Îļþ¡£
ÔÚËùÓеĽڵãÉÏÔËÐУº
mkdir ~/.ssh
chmod 700 ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
ÔÚrdb1½ÚµãÉÏÖ´ÐУº
ssh rdb1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh rdb1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh rdb2 ......

´´½¨ºÍɾ³ýOracleÊý¾Ý¿âÓû§¡¢±í¿Õ¼ä

1. ´´½¨ÆÕͨÓû§
  >create user username identified by username;
  >grant create tablespace, resource ,connect to username;
2. ´´½¨±í¿Õ¼äºÍÓû§
    2.1 ´´½¨ÁÙʱ±í¿Õ¼ä
  >create temporary tablespace DB_TEMP
   tempfile '/opt/oracle/oradata/mydb/t ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ