Send XMPP (Gtalk/Google Talk also supported) messages (thanks to Jabber) within a single line of PL/SQL code, get buddies list and status in relational tables (or xml) on Oracle 11g.
Be the first to post a text review of Oracle XMPP/Jabber Instant Messenger. Rate and review a project by clicking thumbs up or thumbs down in the right column.
To provide an easier and more complete set of tools, i've started to implement XMPP package inside oracle-jutils (https://sourceforge.net/projects/oracle-jutils/). Some names have changed but the code has been totally reviewed to provide more functionalities, in a cleaner way. All my development efforts will be focused on oracle-jutils. Do not hesitate to go on oracle-jutils and tell me if you think about functionalities you would like to be added.
Now using Smack 3.1.0 In this release, the Smack 3.1.0 libraries are required as i do use some new Presence functionalities/bug corrections. Added send_single_plain_text_message PL/SQL function To get more details about the message return code, i've added a single send message function. function send_single_plain_text_message (iHost IN VARCHAR2, -- the host where XMPP service is hosted iPort IN NUMBER,-- the XMPP service port iService IN VARCHAR2,-- the XMPP service iLogin IN VARCHAR2,-- the login of the account you will use to send messages iPasswd IN VARCHAR2,-- the password of the account that sends mesage iRecipient IN VARCHAR2,--the recipient(s) adress, for example toto@gmail.com;titi@gmail.com iSubject IN VARCHAR2, -- the Subject iMessage IN VARCHAR2)-- the message RETURN NUMBER;
Now using Smack 3.1.0, and added new function send_single_plain_text_message to get more detailed return code. Also using more detailed Presence return codes for this function.
As asked by Noel Portugal, i've made sources for the JDK14 available so you can send xmmp messages from Oracle 10g. Now you are able to build the library by your own. Have a look at oracle-xmpp-10g package.
With a little big late, the changelog : http://www.igniterealtime.org/builds/smack/docs/3.1.0.beta1/changelog.html I'll have a closer look at new features which feature i could add to the 11g DBMS_XMPP package : SMACK-142] - Added support for Kerberos/NTLM. (6 votes) [SMACK-210] - Added support for MD5 SASL. (1 vote) [SMACK-256] - Added support for new sophisticated TLS mechanisms including SmartCard and Apple's KeychainStore. [SMACK-242] - Added support for JEP-50: Ad-hoc commands. [SMACK-251] - Added support for XEP-0163: Personal Eventing Protocol. (1 vote) [SMACK-226] - XMLConnection can now be used with an http/socks proxy. (2 votes) [SMACK-254] - Loading the Roster during login is now optional. [SMACK-255] - Added ability to set mime type for avatar. [SMACK-235] - Improved performance of Roster class. [SMACK-241] - Updated Base64 implementation to match Openfire's. [SMACK-240] - Updated Jingle implementation to newest version. [SMACK-246] - Improve Jingle logging using commons-logging [SMACK-244] - Updated JSTUN to 0.7.2. [SMACK-259] - Updated XPP library to latest version.
In the latesr release, i've updated the documentation to tell how to use oracle-xmpp with openfire and spark in a very few steps.
Be the first person to add a text review.
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?
Thanks for your review!
Get credit for your review by logging in via OpenID. Click your account provider: