hibernate3 µ÷ÓÃoracle´æ´¢¹ý³ÌµÄ·½·¨
ÅäÖÃÎļþ£º
<hibernate-mapping>
<class name="vo.SshPost" table="ssh_post" >
<!-- <cache usage="read-write"/>-->
<id name="postId" type="java.lang.String">
<column name="post_id" />
<generator class="native" />
</id>
<property name="postName" type="java.lang.String">
<column name="post_name" length="20" />
</property>
<property name="postNo" type="java.lang.String">
<column name="post_no" length="20" />
</property>
<filter name="myfilter" condition=":myfilterParam = post_name"/>
</class>
<sql-query callable="true" name="selectAllUsers">
<return class="vo.SshPost">
<return-property name="postId" column="POST_ID"/>
<return-property name="postName" column="POST_NAME"/>
<return-property name="postNo" column="POST_NO"/>
</return>
{ call P_TEST(?,:VPOSTNO) }
</sql-query>
</hibernate-mapping>
´æ´¢¹ý³Ì£º
CREATE OR REPLACE PACKAGE TESTPACKAGE AS
TYPE Test_CURSOR IS REF CURSOR;
end TESTPACKAGE;
CREATE OR REPLACE PROCEDURE P_TEST(P_CURSOR OUT TESTPACKAGE.TEST_C
Ïà¹ØÎĵµ£º
µÇ½ORACLEʱ³öÏÖ£ºORA-12637 °ü½ÓÊÜʧ°Ü ´íÎó
½â¾ö·½·¨£ºÔÚ\oracle\product\10.2.0\client_1\NETWORK\ADMIN ÖÐÕÒµ½sqlnet.oraÎļþ£¬
°ÑÐÞ¸Ä SQLNET.AUTHENTICATION_SERVICES= (NONE)¾Í¿ÉÒÔÁË¡£ ......
Oracle Êý¾ÝÀàÐͼ°´æ´¢·½Ê½
Ô¬¹â¶« Ô´´
¸ÅÊö
ͨ¹ýʵÀý£¬È«Ãæ¶øÉîÈëµÄ·ÖÎöoralceµÄ»ù±¾Êý¾ÝÀàÐͼ°ËüÃǵĴ洢·½Ê½¡£ÒÔORACLE 10GΪ»ù´¡£¬½éÉÜoralce 10gÒýÈëµÄеÄÊý¾ÝÀàÐÍ¡£ÈÃÄã¶ÔoracleÊý¾ÝÀàÐÍÓÐÒ»¸öȫеÄÈÏʶ¡£½ÒʾһЩ²»ÎªÈËÖªµÄÃØÃܺͱ»ºöÂÔµÄäµã¡£´ÓʵÓúÍÓÅ»¯µÄ½Ç¶È³ö·¢£¬ÌÖÂÛÿÖÖÊý¾ÝÀàÐ͵ÄÌص㡣´ÓÕ ......
°²×°Oracleºó£¬¸ü¸ÄWindows¼ÆËã»úÃû£¬µ¼Ö²¿·ÖOracleµÚÈý·½¹¤¾ß£¬Èç:PLSQL
DeveloperÎÞ·¨µÇ½£¬²¢ÌáʾORA-12541:TNS:no listener»òORA-12547:TNS:¶ªÊ§ÁªÏµµÈ´íÎóÐÅÏ¢µÄ½â¾ö·½·¨¡£
´ð£º´ÓOracleµÄ´íÎóÌáʾÀ´¿´,ÊÇ˵TNS:no listener
£¬¹À¼ÆÊÇijÖÖ·þÎñûÓÐÆô¶¯£¬´ò¿ªwindows¹ÜÀí¹¤¾ß->·þÎñ£¬Ò»¿´£¬ÓÐÒ»¸öOracle ......
select d.code,d.name, sum(w.weight) weight,round(avg(w.price),2) price,sum(w.money) money
from weight_info w left outer join t_dict d on w.productcode=d.code left outer join t_balancecode b on w.balancecode=b.balancecode where 1=1 and w.operdate>TO_TIMESTAMP('2009-11-2 04:12:32.0', ' ......