We are looking for an SMPP Client Based on Java to replace our old SMPP Client.
SMPP Client should have MySQL / MSSQL DB Support for message picking and updating the delivery messages.
Key Requirements :
SMPP 3.4 Compatible
MSSQL / MySQL Compatible
Short Message
Long Message
Unicode
Binary
DLR Fetching and Update
This project is immediate requirement and will be open only for 3 days.
DB Schema is attached for further study
## Deliverables
Source should be provided.
We must have the ability to modify the connection parameters and recompile the file in order to get the Java executable.
Sample of the DB Schema
CREATE TABLE `cellxnet_new`.`tbl_msg_sms` (
`id` int(10) unsigned NOT NULL auto_increment,
`SmppClient` varchar(20) NOT NULL,
`SourceAddr` varchar(20) NOT NULL,
`DestAddr` varchar(20) NOT NULL,
`SmppMsgId` varchar(50) NOT NULL default '0',
`Message` varchar(512) NOT NULL,
`ScheduleTime` datetime NOT NULL,
`Status` varchar(20) NOT NULL default 'W',
`SubmitTime` datetime NOT NULL,
`SubmitRespTime` datetime NOT NULL,
`DelivTime` datetime NOT NULL,
`userid` char(13) default NULL,
`messagecount` int(10) unsigned NOT NULL,
`IsFlash` tinyint(3) unsigned NOT NULL default '0',
`SubmitDate` date NOT NULL,
PRIMARY KEY (`id`),
KEY `FK_tbl_msg_sms_1` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=1276436 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
Please Note .
1. .Jar File will run in GUI Mode.
2. UserName / Password and all other configurations will be pre-defined in the application. Ability to modify the configuration will be not available in the .jar file. We must have the source to modity the configurations and compile the .jar file.
3. The SMPP client will only pick from database and send through SMPP connection. There is no need of picking the value from csv file.
4. The Java SMPP Client Should be compatible in all OS that runs Sun Java.
5. There will be seperate configuration for Transmitter IP / Transmitter Port and Receiver IP , Receiver Port along with Mode = Receiver / Transmitter / Transceiver.
6. There must be a minimum of 2 instance of configuration. ie. SMPP Connection 1 , SMPP Connection 2. This is required to add a failover SMPP to the SMPP Client. The Client should send message to any of the active SMPP Connection. Ability to add more than 2 instance is added benefit.
7. SMPP Client Configurations should have the ability to change the path and file type of log file. General file type will be .txt, .xls, .csv.
8. SMPP Client configuration should have DB_Type Option . Supported DB_Type = PostGRE, MySQL, MSSQL. Depending upon the DB_Type connection strings and query style will be automatically changed in the SMPP Client.
Sample Configuration File of JAVA SMPP Client.
# Customer Information
CUST_ID = <Customer Name / Company Name >
CUST_LOC = <Customer Address>
CUST_CON = <Customer Contact Number>
# Database Configuration
DB_TYPE = <MySQL / PostGRE / MSSQL>
DB_ADDR = <IP ADDRESS>
DB_UID= <Username>
DB_PASS = <Password>
# SMPP #1
SMPP_1_Mode = <Receiver/Transmitter/<wbr />Transceiver>
SMPP_1_Receiver_IP = <SMPP Server IP>
SMPP_1_Receiver_Port= <SMPP Receiver Port>
SMPP_1_Transmitter_IP = <SMPP Server IP>
SMPP_1_Transmitter_Port= <SMPP Transmitter Port>
SMPP_1_UID = <Username>
SMPP_1_PASS = <Password>
SMPP_1_SYS_TYPE = <System Type>
SMPP_1_ADDR_RANGE = <Address Range>
SMPP_1_EnquireLink = <EnquireLink Interval>
SMPP_1_Rcon_Int = <Reconnect Interval>
SMPP_1_DLR = <Delivery Report Fetching true / false>
# SMPP #2
SMPP_2_Mode = <Receiver/Transmitter/<wbr />Transceiver>
SMPP_2_Receiver_IP = <SMPP Server IP>
SMPP_2_Receiver_Port= <SMPP Receiver Port>
SMPP_2ransmitter_IP = <SMPP Server IP>
SMPP_2Transmitter_Port= <SMPP Transmitter Port>
SMPP_2_UID = <Username>
SMPP_2_PASS = <Password>
SMPP_2_SYS_TYPE = <System Type>
SMPP_2_ADDR_RANGE = <Address Range>
SMPP_2_EnquireLink = <EnquireLink Interval>
SMPP_2_Rcon_Int = <Reconnect Interval>
SMPP_2_DLR = <Delivery Report Fetching true / false>
# Log
Log_Type = <1 = txt , 2 = csv, 3 = xls, 4 = html>
Log_Path = <Windows / Linux Path>
Log_Method = <Daily = 1 Log File Per Day, Hourly = 1 Log File Every Hour>
Log_File = <CellxNet_SMPP_ddmmyy / Cellxnet_SMPP_ddmmyy_hrs>
The SMPP Client will be compiled against the above configuration which will result in the executable .Jar file.