Wednesday, June 21, 2006

Invoking External Functionality/System from within the Database

Looking at the picture at the following URL,
http://photos1.blogger.com/blogger/4310/2356/1600/360_DB_Prog.2.jpg, i have touched through my previous posts on the first three points, including:
(1) the user-defined database functinality itself,
(2)calling database functionality from within the database,
and (3) calling user-defined database functionality from outside.

In this post, I'll touch on the fourth point (4): invoking external functionality from within the database.
The requirements range from alerting or notifying external systems based on data value/state, validating or obtaining credit card authorization, querying/updating remote database, invoking a rate/tax engine, obtaining dynamic data, invalidating middle-tier data cache, messaging across tiers, executing OS commands, and so on.

The Java runtime in the database allows the use of various Java-based mechanisms and protocols, depending on the design/implementation of the target external systems as highlighted in the following examples.

- Calling out external RMI Servers allow invoking SAP System from within the database
through SAP JCO.

- Implementing an HTTP-callout trigger using the Java-based HTTPClient for requesting a
Web component (i.e., JavaServer Page) to invalidate a middle-tier data cache. Similarly a
credit card authorization and validation can be implemented using HTTPS Call-out.

- Alerting/Notifying external systems via email, using Java-based mailer in the database.

- Implementing JDBC-Callout to issue queries and DML against remote non-Oracle database(s)
using a 3rd party pure Java JDBC driver.

- Messaging across tiers using JMS over Streams AQ by invoking Message-Driven Beans in the
middle-tier.

- Web Services Callout allows retrieving dynamic data from external Web services or invoking
remote operations through Web services mechanisms.

- Invoking OS commands using Runtime.exec('').

- And so on ...

The beauty of embedding a full fledged Java VM in the database is that even when a protocol or invocation mechanism is not available by default, you can reuse existing Java library that implements the mechanism or protocol in question. The complete details of the examples and case studies with the code samples are available in my soon-to-be-released book http://www.amazon.com/gp/product/1555583296.

13 comments:

Justin said...

Nice work Kuassi! I was just doing a little bit of this the other day and thought, "Man...there is just nothing you can't do using the Oracle JVM, a little Java and PL/SQL". I can't wait to read your take on this. -Justin

Kuassi Mensah said...

Justin,

Yes man, i share your enthousiasm however, this is true as long as database access is involved, and as we all know there is little you can do without an RDBMS. Fwiw, I discuss the use of Java in the database with PL/SQL, and with Java outside the database (stand alone or Java EE) in chapter one of my book, which is freely available @ http://www.oracle.com/technology/books/pdfs/mensah_ch1.pdf.

Kuassi

Anonymous said...

情趣用品,情趣用品,情趣用品,情趣用品,情趣,情趣,情趣,情趣,按摩棒,震動按摩棒,微調按摩棒,情趣按摩棒,逼真按摩棒,G點,跳蛋,跳蛋,跳蛋,性感內衣,飛機杯,充氣娃娃,情趣娃娃,角色扮演,性感睡衣,SM,潤滑液,威而柔,香水,精油,芳香精油,自慰套,自慰,性感吊帶襪,吊帶襪,情趣用品加盟AIO交友愛情館,情人歡愉用品,美女視訊,情色交友,視訊交友,辣妹視訊,美女交友,嘟嘟成人網,成人網站,A片,A片下載,免費A片,免費A片下載愛情公寓,情色,舊情人,情色貼圖,情色文學,情色交友,色情聊天室,色情小說,一葉情貼圖片區,情色小說,色情,色情遊戲,情色視訊,情色電影,aio交友愛情館,色情a片,一夜情,辣妹視訊,視訊聊天室,免費視訊聊天,免費視訊,視訊,視訊美女,美女視訊,視訊交友,視訊聊天,免費視訊聊天室,情人視訊網,影音視訊聊天室,視訊交友90739,成人影片,成人交友,美女交友,微風成人,嘟嘟成人網,成人貼圖,成人電影,A片,豆豆聊天室,聊天室,UT聊天室,尋夢園聊天室,男同志聊天室,UT男同志聊天室,聊天室尋夢園,080聊天室,080苗栗人聊天室,6K聊天室,女同志聊天室,小高聊天室,上班族聊天室,080中部人聊天室,同志聊天室,聊天室交友,中部人聊天室,成人聊天室,一夜情聊天室,情色聊天室,寄情築園小遊戲情境坊歡愉用品,情趣用品,成人網站,情人節禮物,情人節,AIO交友愛情館,情色,情色貼圖,情色文學,情色交友,色情聊天室,色情小說,七夕情人節,色情,情色電影,色情網站,辣妹視訊,視訊聊天室,情色視訊,免費視訊聊天,美女視訊,視訊美女,美女交友,美女,情色交友,成人交友,自拍,本土自拍,情人視訊網,視訊交友90739,生日禮物,情色論壇,正妹牆,免費A片下載,AV女優,成人影片,色情A片,成人論壇,情趣,免費成人影片,成人電影,成人影城,愛情公寓,成人影片,保險套,舊情人,微風成人,成人,成人遊戲,成人光碟,色情遊戲,跳蛋,按摩棒,一夜情,男同志聊天室,肛交,口交,性交,援交,免費視訊交友,視訊交友,一葉情貼圖片區,性愛,視訊,視訊聊天,A片,A片下載,免費A片,嘟嘟成人網,寄情築園小遊戲,女同志聊天室,免費視訊聊天室,一夜情聊天室,聊天室

wow gold said...

If wow goldfocal point of wow gold our new buy wow goldOpen RvR buy wow goldInfluence system cheap wow gold is mortal combat cheap wow goldbetween players of wow power levelingenemy realms. wow power levelingIn order power leveling to ensure that power leveling Keeps, and Fortresses. wow gold buy wow gold cheap wow gold

Anonymous said...

童裝批發
童裝批發
童裝
童裝
酒店喝酒
酒店消費
暑假打工
寒假打工
酒店經紀人
酒店現領
禮服店
酒店小姐
酒店兼職
酒店上班
酒店兼職
禮服店
酒店上班
酒店打工
酒店小姐
酒店經紀
酒店兼差
假日打工
台北酒店經紀
寒暑假打工
專業酒店經紀
酒店藝名
台北酒店
酒店日保
酒店入行
台北禮服店
酒店類型
酒店午場
酒店規定
酒店行政
酒店資訊

Edwin said...

Buy Kamagra
Earn Google
Viagra Cialis
Cheap Kamagra
Cheap Viagra
Cheap Cialis
Make Money on Google
M65 Jacket
M65 Field Jacket
Airline Dog Carrier
Airline Dog Carriers
Viagra Cialis
Earn Google
Airline Dog Carrier
Airline Dog Carriers
Airline Approved Dog Carriers
ED Hardy Wholesale
Copy DVD Software
How to Send Fax
14k Yellow Gold
Redneck Costume
14k Gold Heart
Tandem Baby Stroller

VUONG said...

医師 転職
医師 転職
医師 転職
医師 転職
医師 転職
医師 転職
医師 転職
医師 転職
医師 転職
医師 転職
ビジネス英語
英文 書き方
英語塾
社会人入試
英語 転職
目頭切開
パッケージ
会社設立 格安
人材派遣会社
東横 賃貸
田園都市 賃貸
デザイナーズ 賃貸
恵比寿 賃貸
学芸大学 賃貸
目黒 賃貸
中目黒 賃貸
新築 賃貸
ペット可 賃貸
三軒茶屋 賃貸
パチンコ求人
販売管理
債務整理 池袋
任意整理
液晶テレビ 激安

VUONG said...

先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
事業再生
経営計画書
経営改革
経営改善
会社分割
経営コンサルティング
婚活 福岡
婚活 福岡
婚活 福岡
婚活 福岡
婚活 福岡
婚活 福岡
婚活 福岡
婚活 福岡
婚活 福岡
婚活 福岡
浮気調査 柏
浮気調査 安達
備考調査 追跡調査 東京
不倫調査 離婚調査 東京
浮気調査 素行調査 東京 
ストーカー相談 ストーカー対策 東京
結婚調査 結婚詐欺 東京
信用調査 企業調査 東京
調査料金 東京
身上調査 身元調査 身辺調査 東京
所在調査 東京
夫 妻 浮気 東京

Michael J said...

I love your blog very much,and i also want to introduce my products to all of you,them are nice and very fashion,if you like them,please contact us on our website or eamil us,thks very much for your attention.And this is my products below:
authentic gucci bags, gucci boots outlet
cheap gucci shoes, discount Gucci bags
newest gucci handbags, gucci handbags 2010
Juicy couture, authentic Juicy bags
Juicy handbags outlet, tiffany 2010
Tiffany, tiffany outlet
discount tiffany charms, cheap tiffany Bangles
Armani watches outlet, watch wholesale
discount DG watches, cheap Chanel watches
newest GUCCI watches, wholesale edhardy t shirt
Moncler, Mtb shoes
Moncler jackets, cheap Moncler coats
Moncler Vest, Moncler outlet
moncler polo t shirt, MBT boots
MBT shoes in fashion, cheap mbt shoes sale
discount mbt outlet 2010, MBT Walking Shoes

Michael J said...

I love your blog very much,and i also want to introduce my products to all of you,them are nice and very fashion,if you like them,please contact us on our website or eamil us,thks very much for your attention.And this is my products below:
BABYLISS
Benefit GHD
GHD IV Salon Styler
GHD MINI STYLER
GHD Precious Gift Set
Gold GHD
Kiss GHD
Pink GHD
Pure Black GHD
Pure White GHD
Purple GHD
Rare GHD
cheap ugg boots
discount ugg boots
ugg boots
classic ugg boots
ugg classic tall boots

janewangleilei said...

You can have a look at it.
jordan shoes
Wow.
newest jordans
jordan 7
Wonderful!
air yeezy
jordan true flight
If you like,you can contact us.
jordan 3
jordan 4
We offer different styles.
jordan 1
jordan 2
Thanks.
jordan 5
jordan ajf shoes
There are cheap shoes to choose
nike footwear
jordan flight 45
Good quality with low price.
air jordan 2010
Air Jordan 2009
Enjoy it!
jumpman
nike trainers

r4 card said...

I was just doing a little bit of this the other day and thought, "Man there is just nothing you can't do using the Oracle JVM, a little Java and PL/SQL".

facebook entrar said...

When do I go up the stairs to her again would be very happy to announce to everyone entrar facebook , entrar facebook , login facebook entrar , girl.go.games , facebook entrar , facebook entrar , facebook entrar