5 Replies Latest reply: Aug 9, 2011 12:47 PM by csenthilmurugan RSS

    Chat tool in application express

    csenthilmurugan
      Hi friends, we have created application in apex and users are accessing application using oracle user name.
      Using the same user name, we need to provide chat facility.

      Is there any option available in oracle or open source where we can integrate with some chat server or is it possible to use gmail chat facility on the same place.

      Thanks for your support.
      Regards
      Senthil
        • 1. Re: Chat tool in application express
          jariola
          Hi,

          You could check Openfire XMPP server
          http://www.igniterealtime.org/projects/openfire/


          I do not know does this help
          http://database-geek.com/2009/03/15/ora_tweet-tweet-from-oracle-a-plsql-twitter-api/

          Br, Jari

          Edited by: jarola on Nov 9, 2009 11:27 AM



          This might help also
          http://apextoday.blogspot.com/2008/05/adding-im-xmppjabber-messaging-to-apex.html

          You can search more from google "oracle xmpp"
          • 2. Re: Chat tool in application express
            csenthilmurugan
            If we have anything like http://code.google.com/p/mia-chat/ then it will be good for apex community.
            mia-chat is developed in PHP, is there anyway we can convert or execute the same in Apex.
            • 3. Re: Chat tool in application express
              jariola
              Hi,

              Have you check that Openfire and SparksWeb ?
              I'm not sure, but it might be easy to integrate SparkWeb to Apex application.

              Br ,Jari
              • 4. Re: Chat tool in application express
                csenthilmurugan
                Thanks Jari, now checking on openfire with JWClient and OracleXMPP, i think, week-end this can be checked and closed.
                Checked the sparkweb, it is on flash and demo itself not working on their web site. Will update you the status by next week. Thanks for your support.
                • 5. Re: Chat tool in application express
                  csenthilmurugan
                  Dear All, using the below program unit, we can validate mail server authentication in apex, please use the same.

                  DECLARE
                  l_ldap_host VARCHAR2(256) := 'mail.domain.com';
                  l_ldap_port VARCHAR2(256) := '389';
                  l_ldap_user VARCHAR2(256) := 'uid=user,ou=people,dc=domain,dc=com';
                  l_ldap_passwd VARCHAR2(256) := 'password'; --user password

                  l_retval PLS_INTEGER;
                  l_session DBMS_LDAP.session;
                  l_attrs DBMS_LDAP.string_collection;
                  l_message DBMS_LDAP.message;
                  l_entry DBMS_LDAP.message;
                  l_attr_name VARCHAR2(256);
                  l_ber_element DBMS_LDAP.ber_element;
                  l_vals DBMS_LDAP.string_collection;

                  BEGIN
                  -- Choose to raise exceptions.
                  DBMS_LDAP.USE_EXCEPTION := TRUE;
                  -- Connect to the LDAP server.
                  l_session := DBMS_LDAP.init(hostname => l_ldap_host,
                  portnum => l_ldap_port);
                  l_retval := DBMS_LDAP.simple_bind_s(ld => l_session,
                  dn => l_ldap_user,
                  passwd => l_ldap_passwd);
                  DBMS_OUTPUT.PUT_LINE('bind:L_RETVAL: ' || l_retval);
                  l_retval := DBMS_LDAP.unbind_s(ld => l_session);
                  DBMS_OUTPUT.PUT_LINE('unbind:L_RETVAL: ' || l_retval);
                  end;