svn commit: r1146016 - in /esme/site/trunk/content/docs/clients: apache-james-(email-integration).mdtext pl-sql-client.mdtext

[rh...@apache.org]

Author: rhirsch
Date: Wed Jul 13 13:40:55 2011
New Revision: 1146016

URL: http://svn.apache.org/viewvc?rev=1146016&view=rev
Log:
[ESME-351] Move wiki to CMS

Added:
    esme/site/trunk/content/docs/clients/apache-james-(email-integration).mdtext
    esme/site/trunk/content/docs/clients/pl-sql-client.mdtext

Added: esme/site/trunk/content/docs/clients/apache-james-(email-integration).mdtext
URL: http://svn.apache.org/viewvc/esme/site/trunk/content/docs/clients/apache-james-%28email-integration%29.mdtext?rev=1146016&view=auto
==============================================================================
--- esme/site/trunk/content/docs/clients/apache-james-(email-integration).mdtext (added)
+++ esme/site/trunk/content/docs/clients/apache-james-(email-integration).mdtext Wed Jul 13 13:40:55 2011
@@ -0,0 +1,5 @@
+Daniel Koller has created an Apache ESME Mailet as a plugin for the Open source Mail Server [Apache James|http://james.apache.org/server/] which allows users of an Apache ESME infrastructure (both humans and technical systems) to send email messages to an Apache ESME instance using their own identity. Messages sent through the mailet show up as personal messages from these end users, so people following you get them in the respective blogging timeline.  
+
+The install guide is available on [Google Docs|https://docs.google.com/Doc?id=df96bz6v_18cw9vrcwr&pli=1].
+
+This new functionality is especially useful for integrating legacy applications into the Apaache ESME environment inasmuch as many such applications might not be able to integrate via the REST API but usually have the ability to send emails. Furthermore, an email interface also allows users to post Apache ESME messages with mobile devices. 
\ No newline at end of file

Added: esme/site/trunk/content/docs/clients/pl-sql-client.mdtext
URL: http://svn.apache.org/viewvc/esme/site/trunk/content/docs/clients/pl-sql-client.mdtext?rev=1146016&view=auto
==============================================================================
--- esme/site/trunk/content/docs/clients/pl-sql-client.mdtext (added)
+++ esme/site/trunk/content/docs/clients/pl-sql-client.mdtext Wed Jul 13 13:40:55 2011
@@ -0,0 +1,72 @@
+Title: PL SQL Client
+
+*Description*: This client was developed to be able to integrate Oracle
+applications into ESME
+
+*Status*: Alpha
+
+*Download:*  Just source available
+
+
+<a name="PLSQLClient-Code"></a>
+#### Code
+
+{code:sql}
+CREATE OR REPLACE PROCEDURE esme AS 
+http_req utl_http.req; 
+http_resp utl_http.resp; 
+t_update_send VARCHAR2(4000); 
+ 
+BEGIN 
+ 
+--Preliminaries 
+ 
+utl_http.set_proxy('proxy:81');  
+utl_http.set_response_error_check(TRUE); 
+utl_http.set_detailed_excp_support(TRUE); 
+utl_http.set_transfer_timeout(to_char('60')); 
+ 
+--login first 
+ 
+http_req :=
+utl_http.begin_request('http://api.esme.us/esme/api/login?token=IFDHJ2RNDZCAT24ZJZUKDG54TVOIVTXL',
+  'POST',   utl_http.http_version_1_1); 
+ 
+t_update_send := 'status='; 
+utl_http.set_header(http_req,	'Content-Length',  
+to_char(LENGTH(t_update_send))); 
+utl_http.write_text(http_req,	t_update_send); 
+ 
+http_resp := utl_http.get_response(http_req); 
+ 
+UTL_HTTP.END_RESPONSE(http_resp); 
+ 
+ 
+--send message 
+ 
+http_req :=
+utl_http.begin_request('http://api.esme.us/esme/api/send_msg?message=Oracle_Test&tags=Test,plsql&via=oracle',
+  'POST',   utl_http.http_version_1_1); 
+ 
+t_update_send := 'status='; 
+utl_http.set_header(http_req,	'Content-Length',  
+to_char(LENGTH(t_update_send))); 
+utl_http.write_text(http_req,	t_update_send); 
+ 
+http_resp := utl_http.get_response(http_req); 
+ 
+UTL_HTTP.END_RESPONSE(http_resp); 
+ 
+ 
+END esme; 
+/{code}
+
+<a name="PLSQLClient-Help"></a>
+#### Help
+
+None available
+
+<a name="PLSQLClient-Details"></a>
+#### Details
+
+* The client requires that you use a token to access ESME