Table of Contents
The install steps is divided in many steps, please respect the order if you are not familiar with these manipulations. If you are already experimented and think the install process can be improved, contact me.
To install, just look at the following script
and follow instructions. All jars are in
In the script, all XMPP features belong to XMPP schema, so the only thing you have to do to use XMPP from an another schema is to grant execute privileges to your target schema. In my install script, it's already done so SCOTT can send XMPP messages from it's own session like that :
SQL> sho user USER is "SCOTT" SQL> select dbms_xmpp.send_plain_text_message('talk.google.com', 2 5222, 3 'gmail.com', 4 'Scott.Tiger',-- The GTalk login 5 'XXXXXXXXX', -- The GTalk password 6 'Adrien.Sales@gmail.com', -- The recipient 7 'XMPP Test from scott', 8 'Hello from scott on his 11g') xmpp_return_code 9 from dual; XMPP_RETURN_CODE ---------------- 0