• Table of contents
• Specification
  • Programming Guide
    • Jar version
    • Jar File Download
    • properties file
  • Database Table
  • SMS Service

Specification¶

Programming Guide¶

Jar version¶

Jar File Download¶

"Jar":
"Properties":

properties file¶

• mocean.properties

1. api.key.{DB}.{country/project}
2. api.secret.{DB}.{country/project}
3. url.domain - Mocean Domain name
4. url.sms - Send SMS
5. url.otp.ppc - OTP via sms and voice
6. url.otp.ppa - OTP via sms
7. url.verify - Verify OTP code
8. url.query - Message delivery status
9. dlr.mask - Delivery Report 0=No, 1=Yes
10. response.format - JSON/XML
11. otp.validity.in.second
12. local.valid.period.in.second
13. connection.timeout
14. connection.read.timeout
15. allow.list - If enable, only phone number in the list allow to sent.

Database Table¶

CREATE TABLE MOCEAN_INTERFACE (
    OTP_ID VARCHAR(15) NOT NULL,
    MOBILE VARCHAR(15) NOT NULL, 
    TRX_CODE VARCHAR(5) NOT NULL,
    SHOPPER_REF_NO INTEGER, 
    STATUS_CODE VARCHAR(5),
    STATUS_DESC VARCHAR(100),
    REQUEST_ID VARCHAR(50),
    REQUEST_ID_EXTRA VARCHAR(100),
    DELIVERY_STATUS INTEGER,
    TOTAL_SMS INTEGER,
    CREATE_DATETIME TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP,
    MODIFY_DATETIME TIMESTAMP,
    ORDER_ID VARCHAR(15),
    PRIMARY KEY (OTP_ID))

SMS Service¶