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

Á¬½ÓOracleÊý¾Ý¿âµÄHibernateÅäÖÃÎļþ

Á¬½ÓOracleÊý¾Ý¿âµÄHibernateÅäÖÃÎļþ
Á¬½ÓOracleµÄHibernateÅäÖÃÎļþÓÐÁ½ÖÖ¸ñʽ£¬Ò»ÖÖÊÇxml¸ñʽµÄ£¬ÁíÒ»ÖÖÊÇJavaÊôÐÔÎļþ¸ñʽµÄ¡£ÏÂÃæ·Ö±ð¸ø³öÕâÁ½ÖÖ¸ñʽÅäÖÃÎļþµÄ´úÂë¡£
1£®xml¸ñʽµÄÅäÖÃÎļþ
ÏÂÃæ½«¸ø³öÁ¬½Ó±¾µØOracle·þÎñÆ÷ÉϵÄdb_database02Êý¾Ý¿âʱHibernateÅäÖÃÎļþhibernate.cfg.xmlµÄ´úÂë¡£
Àý³Ì2-5£º¹âÅÌ\mr\02\sl\05\hibernate.cfg.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!--Ö¸¶¨Á¬½ÓÊý¾Ý¿âÓõÄÇý¶¯-->
<property name="connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
<!--Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄ·¾¶-->
<property name="connection.url">
jdbc:oracle:thin:@localhost:1521:db_database02
</property>
<!--Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄÓû§Ãû-->
<property name="connection.username">SYSTEM</property>
<property name="connection.password">SYSTEM</property><!--Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄÃÜÂë-->
<!--Ö¸¶¨Êý¾Ý¿âʹÓõÄSQL·½ÑÔ-->
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<!--µ±show_sqlÊôÐÔΪtrueʱ±íʾÔÚ³ÌÐòÔËÐÐʱÔÚ¿ØÖÆÌ¨Êä³öSQLÓï¾ä£¬Ä¬ÈÏΪfalse£¬½¨ÒéÔÚµ÷ÊÔ³ÌÐòʱÉèΪtrue£¬·¢²¼³ÌÐò֮ǰÔÙ¸ÄΪfalse,ÒòΪÊä³öSQLÓï¾ä»áÓ°Ïì³ÌÐòµÄÔËÐÐËÙ¶È-->
<property name="show_sql">true</property>
<mapping resource="UserForm.hbm.xml"/><!--Ö¸¶¨³Ö¾Ã»¯ÀàÓ³ÉäÎļþ-->
</session-factory>
</hibernate-configuration>
ÔÚÉÏÃæµÄ´úÂëÖУ¬“localhost”´ú±í±¾µØOracle·þÎñÆ÷£¬Èç¹ûÏëÁ¬½ÓÆäËû·þÎñÆ÷¿ÉÒÔÐÞ¸ÄΪҪÁ¬½ÓµÄOracle·þÎñÆ÷µÄÃû³Æ£» “db_database02”ΪҪÁ¬½ÓµÄÊý¾Ý¿âÃû³Æ£»“SYSTEM”ΪµÇ¼Óû§Ãû£»“SYSTEM”±íʾÓû§ÃÜÂ룻 “UserForm.hbm.xml”Ϊ³Ö¾Ã»¯Àà¶ÔÓ¦µÄÓ³ÉäÎļþÃû³Æ¡£
2£®JavaÊôÐÔÎļþ¸ñʽµÄÅäÖÃÎļþ
ÏÂÃæ½«¸ø³öÁ¬½Ó±¾µØOracle·þÎñÆ÷ÉϵÄdb_database02Êý¾Ý¿âʱHibernateÅäÖÃÎļþhibernate.propertiesµÄ´


Ïà¹ØÎĵµ£º

Oracle²éÕÒµÚn¸ö×î´óÖµ

ÔÚ¹úÄÚÍâÐí¶àOracle DBAÕ¾µãÉÏ£¬Óкܶà²éÕÒ±íÖеÚn¸ö×î´óÖµµÄС¼¼ÇÉ£¬ÕâЩÓï¾äȷʵÏ൱ÇÉÃËüÃǶ¼¶À±Ùõè¾¶µØÓõ½ÁËOracle±íÖеÄÒ»¸öα×ֶΓlevel”¡£µ«ÊÇÔںܶàÇé¿öÏ£¬Õâ¸öÓï¾ä±ä³ÉÁË ÃÀÀöµÄÏÝÚå¡£Èç¹ûÄãÏëÖªµÀΪʲô£¬²¢ÔõÑùÈÆ¹ýËü£¬ÇëÌýÎÒµÀÀ´£¡
Ñо¿Á˼¸Ì죬ÎÒ·¢ÏÖÒ»ÖÖÑÜÉúËã·¨£¬¼´ÕÒ³öµÚn¸öºÍµÚm¸ö×î´óÖ ......

Oracle tnsÅäÖõÄ6ÖÖ³£¼û´íÎó½â¾öÎÊÌâ

¾­¹ý³¤Ê±¼äѧϰOracle£¬Äã¿ÉÄÜ»áÓöµ½Oracle tnsÅäÖÃÎÊÌ⣬ÕâÀォ½éÉÜOracle tnsÅäÖÃÎÊÌâµÄ½â¾ö·½·¨¡£×î½üæ×Ű²×°OracleÊý¾Ý¿â£¬±¾À´Í¦¼òµ¥µÄ£¬¿ÉÀÏÊdzöÏÖÎÊÌ⣬×îºó×Ô¼ºÔÚÍøÉÏÕûÀíÁËһЩtns´íÎó½â¾ö·½·¨£¬Ï£Íû¶Ô³õѧÕßÓÐÒæ¡£
³£¼ûÎÊÌâ:
1¡¢ORA-12541:tns:ûÓмàÌýÆ÷£º
ÏÔ¶øÒ×¼û£¬·þÎñÆ÷¶ËµÄ¼àÌýÆ÷ûÓÐÆô¶¯£¬ÁíÍâ¼ì²é¿Í» ......

oracle Ëø £¨²éѯ/½âËøÓï¾ä)

ͨ¹ý select * from table whereid=16701 for update Ëø×¡Ò»Õűí
ͨ¹ýÒÔÏÂÓï¾ä¿É²éѯ³ö±»Ëø×¡µÄ¶ÔÏó
SELECT OBJECT_ID,
       SESSION_ID,
       SERIAL#,
       ORACLE_USERNAME,
     &nb ......

ÔÚWindows 7 ϰ²×° Oracle 10g ¹ý³Ì

£¨ºìÉ«²¿·ÖΪÐÞ¸ÄÄÚÈÝ£©
µÚÒ»²½£¬ÔÚ´ÅÅÌϽ¨Ò»¸öÎļþ¼Ð£¬×¢Òâ²»ÒªÓпոñ£¬·ñÔòoracle°²×°Ê±»á³öÏÖ¾¯¸æ¡£
µÚ¶þ²½£¬ÓÃÓÚ½øÈë°²×°½çÃæºó£¬¼ì²â»·¾³ÔÚ°²×°Îļþ¼ÐÀïËÑË÷ "refhost.xml"£¬¹²2¸öÎļþ¡£
ÓüÇʱ¾´ò¿ª£¬¿´µ½
 <!--Microsoft Windows vista-->
  <OPERATING_SYSTEM>
  &l ......

Oracle Êý¾ÝÀàÐͼ°´æ´¢·½Ê½

Oracle Êý¾ÝÀàÐͼ°´æ´¢·½Ê½
      Ô¬¹â¶« Ô­´´
      ¸ÅÊö
      ͨ¹ýʵÀý£¬È«Ãæ¶øÉîÈëµÄ·ÖÎöoralceµÄ»ù±¾Êý¾ÝÀàÐͼ°ËüÃǵĴ洢·½Ê½¡£ÒÔORACLE 10GΪ»ù´¡£¬½éÉÜoralce
      10gÒýÈëµÄеÄÊý¾ÝÀàÐÍ¡£ÈÃÄã¶Ôor ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ