oracle¡¢proxool¡¢hibernateʹÓÃ×ܽá
¿ªÊ¼ÔÚmyeclipse6.5ÖÐDB BROWERн¨ÁËÒ»¸öÊý¾Ý¿âÁ¬½Ó£¬Èçͼ£º
Ò»Á¬½Ó£¬±¨³öÁËÁ½¸ö´íÎó£º
1. ORA-00604 error occurred at recursive SQL level string.
2.ORA-12705: invalid or unknown NLS parameter value.
²é×ÊÁϺó½â¾ö£¨ÆÚ¼äÎÒ»¹¸Ä¹ýtestÓû§µÄÁ¬½ÓȨÏÞ£©£º
½«MyEclipseÖÐeclipseĿ¼ÏµÄeclipse.iniÎļþ£¬°ÑDuser.language=en ¸Ä³É Duser.language=zh¾ÍÐÐÁË.
proxool.xml·ÅÔÚSRCÏ£¬ÊÇÕâôдµÄ£º
Xml´úÂë
<?xml version="1.0" encoding="UTF-8"?>
<proxool-config>
<proxool>
<alias>DBPool</alias>
<driver-url>jdbc:oracle:thin:@192.168.1.88:1521:XE</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="test" />
<property name="password" value="test" />
</driver-properties>
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<maximum-new-connections>20</maximum-new-connections>
<prototype-count>5</prototype-count>
<maximum-connection-count>1000</maximum-connection-count>
<minimum-connection-count>10</minimum-connection-count>
</proxool>
</proxool-config>
applicationContext.xmlÖеÄsessionFactory£º
Xml´úÂë
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="mappingResources">
<!--Êý¾Ý×ÖµäµÄÓ³ÉäÎļþ-->
<list>
<!--²âÊÔʵÌåÓ³ÉäÎļþ-->
<value>yang\model\testmapping\ListTest.hbm.xml</value>
<!-- ................ -->
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.proxool.xml">proxool.xml</prop>
<prop key="hibernate.proxool.pool_alias">DBPool</prop>
Ïà¹ØÎĵµ£º
OracleÊý¾Ý¿âÖ»ÊÇһЩÎļþ×é³É£¬OracleʵÀýÊÇÖ¸ÓÐ×Ô¼ºµÄϵͳȫ¾ÖÇøºÍÏà¹ØÊý¾Ý¿âÎļþµÄOracle·þÎñÆ÷½ø³Ì¼¯¡£ÐÂ×°µÄOracleÊý¾Ý¿â¹ÜÀíϵͳÓÐÒ»¸öԤװµÄÊý¾Ý¿â£¨Í¨³£½ÐORCL£©£¬Í¬Ê±»áÆô¶¯Ò»¸öʵÀý£¬ÒÔºóµÄÊý¾Ý¿âÁ¬½Ó£¬¶¼Ä¬ÈÏÊÇͨ¹ýÕâ¸öʵÀýÁ¬½Óµ½¸ÃÊý¾Ý¿â¡£
¿ÉÒÔн¨Êý¾Ý¿â£¬ ......
ÿÌì1µãÖ´ÐеÄoracle JOBÑùÀý
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X,
what => 'ETL_RUN_D_Date;',
next_date => to_date('2009-08-26 01:00:00','yyyy-mm-dd hh24:mi:ss'),
interval => 'trunc(sysdate)+1+1/24',
no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number ......
Oracle
ÖеÄÈÕÆÚÀàÐͼ°ÆäÏà¹ØµÄº¯Êý
Oracle
ÌṩÁ˺ܶàµÄÄÚÖõÄÈÕÆÚÀàÐÍ£¬°üÀ¨Èçϼ¸ÖÖ£º
Date
Timestamp
Timestamp With Time Zone
Timestamp With Local Time Zone
Interval Year To Month
Interval Day To Second
DateÀàÐÍÓÃÓÚ´æ´¢ÈÕÆÚ£¬¾«È·µ½Ã룬¿ÉÄÜͨ¹ýÉèÖÃNLS_DATE_FORMAT»òÕßTO_CHAR·½·¨À´¸ñʽ»¯ÈÕÆÚµÄÊ ......
ĿǰÖ÷Á÷Êý¾Ý¿â£º
΢Èí£ºsql serverºÍaccess
ÈðµäMySql£ºAB¹«Ë¾mysql
IBM¹«Ë¾£ºDB2¡¢
ÃÀ¹úSybase¹«Ë¾£ºSybase
IBM¹«Ë¾ ......
ÏȽ¨ÁËÕŲâÊÔ±í
SQL> select * from test_a;
ID PLAYNAME SCORE
-------------------- --- ......