Ò»¸ö¼òµ¥µÄ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ÖÐûÓГ×Ô¶¯Ôö³¤”ÀàÐ͵Ä×Ö¶Î
Ïà¹ØÎĵµ£º
oracle9iÐ¶ÔØ
1,ÔÚ·þÎñÖÐÍ£Ö¹oracleµÄËùÓзþÎñ
2,ÔÚ³ÌÐòÁËжװËùÓÐOracle²úÆ·£¬(µ«Universal Installer±¾Éí²»Äܱ»É¾³ý)
3,ɾ³ý×¢²á±í:
(1)ÔËÐÐregeditÑ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬É¾³ýÕâ¸öÏî
(2)Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle,ɾ³ýÕâ¸öÏî.
(3),Ñ¡ÔñHKEY_LOCAL_MACHI ......
oracle8i Çý¶¯ ojdbc14.jar Õâ¸öÇý¶¯ÓÐÎÊÌ⣬·ÖҳʱҪÊÖ¶¯ д rownum<m ,Ëü×Ô¶¯³ÉÉúµÄ·ÖÒ³²»ÕýÈ·£¬ÓõÄmysqlµÄtop m
Null value was assigned to a property of primitive °ÑentityÖÐintÀàÐ͸ijÉInteger ¿âÖв»ÉèÖÃnullable
number(9) µÄid ²»ÄÜÓÃInterger,µÃÓÃBigDecimal,Òª²»È»È¡idʱ»á±¨´í ......
OracleÆô¶¯Ê±ÐèÒªµÄ·þÎñ£º
ÔÌûµØÖ·£ºhttp://www.blogjava.net/sidanzhou/archive/2008/03/03/183507.html
×¢£ºSID - Êý¾Ý¿â±êʶ
HOME_NAME - Oracle HomeÃû³Æ£¬ÈçOraHome92¡¢OraHome81
£¨1£©OracleServiceSID
Êý¾Ý¿â·þÎñ£¬Õâ¸ö·þÎñ»á×Ô¶¯µØÆô¶¯ºÍÍ£Ö¹Êý¾Ý¿â¡£Èç¹û°²×°ÁËÒ»¸öÊý¾Ý¿â£¬ËüµÄȱʡÆô¶¯ÀàÐÍΪ×Ô¶¯¡£·þÎñ½ø³ ......
1. ·ÖÇø±í
Oracle
½¨ÒéÈç¹ûµ¥¸ö±í³¬¹ý2G¾Í×îºÃ¶ÔÆä½øÐзÖÇø¡£
¶Ô´ó±íµÄ²éѯ¡¢Ôö¼Ó¡¢Ð޸ĵȲÙ×÷¿ÉÒԷֽ⵽±íµÄ²»Í¬·ÖÇøÀ´²¢ÐÐÖ´ÐУ¬¿ÉʹÔËÐÐËٶȸü¿ì£»
1)
Range·ÖÇø
¡¡¡¡Range·ÖÇøÄØÊÇÓ¦Ó÷¶Î§±È½Ï¹ãµÄ±í·ÖÇø·½Ê½£¬ËüÊÇÒÔÁеÄÖµµÄ·¶Î§À´×öΪ·ÖÇøµÄ»®·ÖÌõ¼þ£¬½«¼Ç¼´æ·Åµ½ÁÐ ......
½¨Á¢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 ......