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

hibernate.cfg.xml¹ØÁªOracleÊý¾Ý¿âµÄÅäÖÃ

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE hibernate-configuration (View Source for full doctype...)>
- <!-- Generated by MyEclipse Hibernate Tools.
--> - <!-- ÒÔÉϼ¸ÐÐËùÓеÄhibernate.cfg.xml¶¼Ïàͬ
--> [url=file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/hibernate.cfg.xml#]-[/url] <hibernate-configuration>
[url=file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/hibernate.cfg.xml#]-[/url] <session-factory>
- <!-- Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄURLÒÔ¼°ÒªÁ¬½ÓµÄÊý¾Ý¿â
--> <property name="connection.url">jdbc:oracle:thin:@127.0.0.1:1521:sryx</property>
- <!-- Á¬½ÓÊý¾Ý¿âµÄÓû§Ãû
--> <property name="connection.username">yf</property>
- <!-- Á¬½ÓÊý¾Ý¿âµÄÃÜÂë
--> <property name="connection.password">yf</property>
- <!-- Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄÇý¶¯
--> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
- <!-- Ö¸¶¨Á¬½ÓµÄÊý¾Ý¿âÀàÐÍ
--> <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
- <!-- JDBC´ÓÊý¾Ý¿âÿ´Î¶ÁÈ¡µÄ¼Ç¼Êý 100»¹½«ÓÅ»¯
--> <property name="jdbc.fetch_size">50</property>
- <!-- JDBCÖ´ÐÐÅúÁ¿É¾³ý£¬¸üУ¬²åÈëʱÿ´Î²Ù×÷µÄ¼Ç¼Êý 30µ½50°É
--> <property name="jdbc.batch_size">50</property>
- <!-- connectionÊÇ·ñ¹ö¶¯½á¹û¼¯
--> <property name="jdbc.use_scrollable_resultset">true</property>
- <!-- ÔÚÉú³ÉµÄSQLÓï¾äÖвúÉú×¢ÊÍ
--> <property name="use_sql_comments">true</property>
- <!-- Á¬½ÓSQLSERVER2000ÓÃ
<session-factory name="java:/hibernate/HibernateFactory"> <property name="show_sql">true</property> <property name="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property> <property name="connection.url">jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=hibernate_test</property> <property name="c


Ïà¹ØÎĵµ£º

redhat linux enterprise 5 °²×°Oracle10G

1¡¢ÓÉÓÚorcale10²»Ö§³Ö redhat as5 ÐèÒªÐÞ¸Ä/etc/redhat-realease ½« Red
  Hat Enterprise Linux Server release 5 (Tikanga) ¸ÄΪRed Hat Enterprise
 Linux Server release 4 (Tikanga) £¬°²×°Íê³ÉºóÔÙ½«ÆäÐ޸ĻØÀ´
2¡¢ÐÞ¸Ä/etc/hosts Îļþ½«127.0.0.1¸ÄΪ±¾»úIPµØÖ· ·ñÔòÍøÂç¼ì²éͨ²»¹ý
 
3¡¢¼ì² ......

ORACLE SQLÐÔÄÜÓÅ»¯

ORACLE SQLÐÔÄÜÓÅ»¯
ÎÒÒª½²µÄÌâÄ¿ÊÇOracle SQLÐÔÄÜÓÅ»¯£¬Ö»ÊÇOracleÐÔÄÜÓÅ»¯ÖеÄÒ»Ïî¡£OracleµÄÐÔÄÜÓÅ»¯°üº¬ºÜ¶à·½Ã棬±ÈÈçµ÷ÕûÎïÀí´æÈ¡£¬µ÷ÕûÂß¼­´æÈ¡£¬µ÷ÕûÄÚ´æÊ¹Ó㬼õÉÙÍøÂçÁ÷Á¿µÈ¡£ÕâÀïÑ¡ÔñSQLÐÔÄÜÓÅ»¯ÊÇÒòΪÕⲿ·ÖÄÚÈÝÎÒÃDzâÊÔÈËÔ±×îÈÝÒ×½Ó´¥µ½£¬ÁíÍ⿪·¢ÈËԱдSQL½Å±¾Ê±ÓÐʱºÜËæÒ⣬²»Öª²»¾õ¾Í»áÔì³É³ÌÐòÐÔÄÜÉϵÄÏ ......

ORACLE³£ÓÃSQLÓÅ»¯hintÓï¾ä

PowerBuilderÈ¡µÃ¾Þ´ó³É¾ÍµÄÔ­Òò¾ÍÊÇÓй¦ÄÜÇ¿´óºÍÁé»î¶à±äµÄDatawindow¶ÔÏ󣬱¾ÈËÓÃPowerBuilder¿ª·¢¹ýÒ»¶Îʱ¼äºó£¬×ܽá³öһЩ¼¼ÇÉ£¬ÒÔ¹©¹ã´óµÄPB¿ª·¢Õß½è¼øÊ¹Óá£
1¡¢ ÈçºÎ´´½¨Ò»¸ö¾ßÓÐÖð½¥µÝÔöÇóºÍ¹¦Äܵı¨±í£¬ÈçÏÂÐÎʽ£º Running TotalÁУ¬ÎÒÃÇ¿ÉʹÓüÆËãÁУºCumulativeSum£¨Quantity for all£©£¬¼´¿É´ïµ½Öð½¥µÝÔöÇóºÍ ......

oracle Ö®ËÄÁ½²¦Ç§½ï ÃîÕк¯Êý

1.»ñÈ¡µÇ½Óû§µÄÖ÷»úÃû
        select sys_context('userenv','host') from dual;
2.»ñÈ¡µÇ½Óû§µÄIPµØÖ·
        select sys_context('userenv','ip_address') from dual; ......

Oracle±¸·ÝÓë»Ö¸´°¸Àý

Ò». Àí½âʲôÊÇÊý¾Ý¿â»Ö¸´
  µ±ÎÒÃÇʹÓÃÒ»¸öÊý¾Ý¿âʱ£¬×ÜÏ£ÍûÊý¾Ý¿âµÄÄÚÈÝÊǿɿ¿µÄ¡¢ÕýÈ·µÄ£¬µ«ÓÉÓÚ¼ÆËã»úϵͳµÄ¹ÊÕÏ£¨Ó²¼þ¹ÊÕÏ¡¢Èí¼þ¹ÊÕÏ¡¢ÍøÂç¹ÊÕÏ¡¢½ø³Ì¹ÊÕϺÍϵͳ¹ÊÕÏ£©Ó°ÏìÊý¾Ý¿âϵͳµÄ²Ù×÷£¬Ó°ÏìÊý¾Ý¿âÖÐÊý¾ÝµÄÕýÈ·ÐÔ£¬ÉõÖÁÆÆ»µÊý¾Ý¿â£¬Ê¹Êý¾Ý¿âÖÐÈ«²¿»ò²¿·ÖÊý¾Ý¶ªÊ§¡£Òò´Ëµ±·¢ÉúÉÏÊö¹ÊÕϺó£¬Ï£ÍûÄÜÖØ¹¹Õâ¸öÍêÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ