websphereÔÚoracleÈ¡Êý¾ÝÎÊÌâ
ÕâÊÇÔÚCompute½ÚµãÉϵÄESQL´úÂ룬ÇÒÊý¾ÝÔ´ÒѾдÉÏ£¬Í¬Ê±Ò²ÔÚ´úÀíÉÏÉèÖÃÁËmqsisetdbparms SITBRK -n MBAPP -u MBAPP -p MBAPP£¬
CREATE COMPUTE MODULE Exe4_Compute_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
-- ±¾Ä£¿é½«Ê×Ïȸ´ÖÆÏûϢͷ£¬²¢ÔÚ·ÃÎÊÊý¾Ý¿â±íCUSTOMERµÄ»ù´¡ÉÏ
-- ÖØÐ¹¹ÔìÊä³öXMLÏûÏ¢£¬Ìí¼ÓÒ»¸öеÄ×Ö¶Îname
-- Ê×Ïȸ´ÖÆÏûϢͷ
DECLARE I INTEGER 1;
WHILE I < CARDINALITY(InputRoot.*[]) DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I+1;
END WHILE;
-- ·ÃÎÊÊý¾Ý¿â±í¸ñcustomerµÃµ½Óëxml×Ö¶Îid¶ÔÓ¦µÄÓû§Ãû³Æ£¬²¢È¥µô¿Õ¸ñ
DECLARE TEMP CHAR;
SET TEMP = THE(SELECT ITEM T.CUST_NAME from Database.CUSTOMER AS T WHERE T.CUST_ID = InputRoot.XML.record.id);
SET TEMP = TRIM(BOTH ' ' from TEMP);
-- ¹¹ÔìÊä³öxmlÏûÏ¢
SET OutputRoot.XML.record.id = InputRoot.XML.record.id;
SET OutputRoot.XML.record.name = TEMP;
SET OutputRoot.XML.record.address = InputRoot.XML.record.address;
SET OutputRoot.XML.record.amount1 = InputRoot.XML.record.amount1;
SET OutputRoot.XML.record.amount2 = InputRoot.XML.record.amount2;
RETURN TRUE;
END;
END MODULE;
²¿ÊðʱûÓÐÎÊÌ⣬¿ÉÔÚ²âÊÔʱ£¬¸ù±¾Ã»ÓнøÈëµ½Computer½ÚµãÖ±½ÓcatchÁË£¬¾ÍÊÇ·ÅÈëÏûÏ¢ºó£¬Ö±½Ó´ÓFailure³öÀ´ÁË£¬Çë½
Ïà¹ØÎÊ´ð£º
лл
ÎÒÒ²ÊÇÏëÖªµÀ
me too
ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......
¸öÈ˾õµÃÔÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
·þÎñÆ÷ϵͳÊÇxp,Êý¾Ý¿âoracle10g£¬web·þÎñÆ÷ÊÇtomcat£¬Á¬½ÓÊý¾Ý¿âʱ±¨Á¬½Ó´íÎó£¬ÈçÏÂËùʾ£ºThe Network Adapter could not establish the connectionÒì³££¬oracle·þÎñºÍ¼àÌýÒѾÆðÀ´ÁË£¨¶øÇÒ¶¼ÊÇÕýÈ·µÄ£©¡£Êý¾Ý¿âjar ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......