datasource
文章平均质量分 62
book_zenzuguo
这个作者很懒,什么都没留下…
展开
-
ORACLE 函数处理的数据返回值过长 character string buffer too small .
--问题 -- ORA-06502: PL/SQL: 数字或值错误 : character string buffer too small--ORA-06512: 在 "WMSYS.WM_CONCAT_IMPL", line 30 --错误 WMSYS.WM_CONCAT() SELECT HEAD.BOOKING_HEAD_ID, (SELECT ...原创 2012-10-18 10:28:20 · 391 阅读 · 0 评论 -
ibatis+spring select oracle clob
sql-map-config.xml <?xml version="1.0" encoding="UTF-8" ?><! DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apach...原创 2012-10-18 17:06:58 · 93 阅读 · 0 评论 -
oracle触发器更新本表时,如何在被更新记录后更新本表的其他列
oracle触发器更新本表时,如何在被更新记录后更新本表的其他列 赋值tcolumn 给:new.update_column; 如select tcolumn into :new.update_column from dual;或者:new.update_column = tcolumn ;不需要再更新此表。...原创 2012-10-22 15:58:52 · 528 阅读 · 0 评论 -
jndi datasource ibatis glassfish3 eclipse
下载glassfish-3.1.2.2-ml.zip ,解压就可以用。(1) glassfish 配置在4848管理界面中加上datasource "jdbc/AS400B" 在工程中找到applicationContext-resources.xml加入如下内容: <!-- JNDI DataSource for J2EE environme...2012-10-11 10:25:59 · 87 阅读 · 0 评论 -
Dose oracle.sql.ArrayDescriptor support the user defined type in package?
Not all PL/SQL arrays can be direcly accessed using JDBC. Procedures or Functions that take arrays and are declared inside packages instead of with “CREATE TYPE” can not be called using JDBC. This i...原创 2014-08-12 17:32:50 · 360 阅读 · 0 评论