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

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>


Ïà¹ØÎĵµ£º

javaµ÷ÓÃoracle´æ´¢¹ý³Ì

Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
´æ´¢¹ý³ÌΪ£º
create or replace procedure adddept(deptno number,dname varchar2,loc varchar2)
as
  begin
    insert into dept values(deptno,dname,loc);
end;
È»ºóÄØ£¬ÔÚjavaÀïµ÷ÓÃʱ¾ÍÓÃÏÂÃæµÄ´úÂ룺
public class TestProcedure {
 Connectio ......

oracle IMP ÃüÁîÏê½â


Ô­ÎĵØÖ·£ºhttp://www.bokee.net/bloggermodule/blog_viewblog.do?id=465310
OracleµÄµ¼ÈëʵÓóÌÐò(Import utility)ÔÊÐí´ÓÊý¾Ý¿âÌáÈ¡Êý¾Ý£¬²¢ÇÒ½«Êý¾ÝдÈë²Ù×÷ϵͳÎļþ¡£impʹÓõĻù±¾¸ñʽ£ºimp[username[/password[@service]]]£¬ÒÔÏÂÀý¾Ùimp³£ÓÃÓ÷¨¡£
 
1. »ñÈ¡°ïÖú
imp help=y
2. µ¼ÈëÒ»¸öÍêÕûÊý¾Ý¿â
i ......

OracleÊý¾Ý¿âµÄµ¼Èëµ¼³ö

oracleÊý¾Ý¿âµÄµ¼ÈëÓëµ¼³öÊÇ×öΪһÃûʵʩ¹¤³Ìʦ»òά»¤¹¤³Ìʦÿ¾­³£Òª×öµÄ¹¤×÷¡£µ±Êý¾Ý¿â½á¹¹ÐèÒª×ö±ä»¯µÄʱºò£¬ÎÒÃÇÒ»°ãÏȽ«Êý¾Ý×ö±¸·Ý£¬´ËʱÎÒÃÇÐèҪʹÓõ½OracleµÄµ¼³ö¹¦ÄÜ¡£µ±ÎÒÃÇÔÚ×öµ¼ÈëµÄʱºò³ö´í»òÕßÎÒÃǵÄÊý¾ÝÔâµ½´íÎóɾ³ýµÄʱºò£¬ÎÒÃÇÐèÒª»Ö¸´Êý¾Ý¿â£¬ÄÇÎÒÃÇÐèҪʹÓõ½µ¼ÈëµÄ¹¦ÄÜ¡£ÏÖÔÚÒ²Óкܶ๦ÄÜÄܹ»°ïÎÒÃÇ×öµ½ ......

Àí½âORACLEÊý¾Ý¿â×Ö·û¼¯

Ò»£®ÒýÑÔ
   
ORACLE
Êý¾Ý¿â×Ö·û¼¯£¬¼´Oracle
È«Çò»¯Ö§³Ö(Globalization Support)
£¬»ò¼´¹ú¼ÒÓïÑÔÖ§³Ö£¨NLS
£©Æä×÷ÓÃÊÇÓñ¾¹úÓïÑԺ͸ñʽÀ´´æ´¢¡¢´¦ÀíºÍ¼ìË÷Êý¾Ý¡£ÀûÓÃÈ«Çò»¯Ö§³Ö£¬ORACLE
ΪÓû§Ìṩ×Ô¼ºÊìϤµÄÊý¾Ý¿âĸÓï»·¾³£¬ÖîÈçÈÕÆÚ¸ñʽ¡¢Êý×Ö¸ñʽºÍ´æ´¢ÐòÁеȡ£Oracle
¿ÉÒÔÖ§³Ö¶àÖÖÓïÑÔ¼°×Ö·û¼ ......

oracleѧϰ±Ê¼Ç1 ¼òµ¥³£Ê¶

ĿǰÖ÷Á÷Êý¾Ý¿â£º
       ΢Èí£ºsql serverºÍaccess
       ÈðµäMySql£ºAB¹«Ë¾mysql
       IBM¹«Ë¾£ºDB2¡¢
       ÃÀ¹úSybase¹«Ë¾£ºSybase
       IBM¹«Ë¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ