Hi Thanasis,
I resolved the SMSSERVER_OUT table problem.
Instead of using sendMessages() , i created a new method sendMsg() which
will be called from OutboundPollingThread .
public synchronized boolean sendMsg(String mobileNo,String message){
boolean flag=false;
sendMsg = new OutboundMessage(mobileNo,message);
try {
srv.sendMessage(sendMsg);
Calendar calendar=Calendar.getInstance();
System.out.println("Message Sent Successfullt at
:"+calendar.getTime());
flag=true;
} catch (TimeoutException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (GatewayException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (InterruptedException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
*In OutboundPollingThread i getting data SMSSERVER_OUT*
while(resultSet1.next()){
sendMsg( resultSet1.getString("RECIPIENT"), resultSet1.getString("TEXT")
}
It is working fine.
Thank you very much for your support.
I have one doubt does SMSLIB3.4 is compatible with *Windows Vista Business*
urs,
Vivek
On Fri, Jul 17, 2009 at 1:25 PM, Vivek <[email protected]> wrote:
> I filled all NOT NULL values,Then also im unable to send messages
> urs,
> nandu
>
>
>
>
> On Fri, Jul 17, 2009 at 11:25 AM, Thanasis <[email protected]> wrote:
>
>>
>> Check your NULL/NOT NULL values as well as your DEFAULT values
>> according to the docs here:
>> http://smslib.org/doc/smsserver/interfaces/database/#Outbound_SMS_Table
>>
>> I see too many NULLs in your SQL statement...
>>
>> On Jul 17, 8:07 am, Vivek <[email protected]> wrote:
>> > Hi Thanasis,
>> >
>> > I guess ,
>> > Some thing wrong with out table data .
>> > I am sending a row .
>> > Can you plz go through it .
>> >
>> -----------------------------------------------------------------------------
>> > Insert into SMSSERVER_OUT
>> > (ID, TYPE, RECIPIENT, TEXT, WAP_URL,
>> > WAP_EXPIRY_DATE, WAP_SIGNAL, CREATE_DATE, ORIGINATOR, ENCODING,
>> > STATUS_REPORT, FLASH_SMS, SRC_PORT, DST_PORT, SENT_DATE,
>> > REF_NO, PRIORITY, STATUS, ERRORS, GATEWAY_ID)
>> > Values
>> > (92, 'O', '+919811488535', 'HI7', NULL,
>> > NULL, NULL, NULL, NULL, '7',
>> > 1, NULL, NULL, NULL, TO_TIMESTAMP('4/16/2009 3:39:18.671000
>> > PM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM'),
>> > '208', 1, 'U', NULL, 'modem1');
>> >
>> --------------------------------------------------------------------------------------------
>> >
>> > urs,
>> > Vivek
>> >
>> > On Fri, Jul 17, 2009 at 9:49 AM, Vivek <[email protected]> wrote:
>> > > Hi Thanasis ,
>> >
>> > > In errors field is having > 0 value.
>> > > What does it mean ?
>> > > Is there any problem in configurations.
>> >
>> > > urs,
>> > > Vivek
>> >
>> > > On Thu, Jul 16, 2009 at 10:36 PM, Thanasis <[email protected]>
>> wrote:
>> >
>> > >> Sorry, I cannot reproduce this.
>> >
>> > >> I work with MS Sql Server, and "*" as the gateway in the database -
>> > >> but I don't think it makes any difference.
>> > >> Check your database for correct structure. Also check to see if the
>> > >> "errors" field has any >0 value - this would indicate failed attempts
>> > >> to send the messages.
>> >
>> > >> On Jul 16, 1:05 pm, Vivek <[email protected]> wrote:
>> > >> > I done out table data as u mentioned .
>> > >> > Still not yet solved that problem
>> >
>> > >> > urs,
>> > >> > nandu
>> >
>> > >> > On Thu, Jul 16, 2009 at 2:42 PM, Vivek <[email protected]>
>> wrote:
>> > >> > > Hi
>> >
>> > >> > > I am sending in table record.
>> >
>> > >>
>> ---------------------------------------------------------------------------
>> > >> ---------------
>> > >> > > Insert into SMSSERVER_IN
>> > >> > > (ID, PROCESS, ORIGINATOR, TYPE, ENCODING,
>> > >> > > MESSAGE_DATE, RECEIVE_DATE, TEXT, ORIGINAL_REF_NO,
>> > >> > > ORIGINAL_RECEIVE_DATE,
>> > >> > > GATEWAY_ID)
>> > >> > > Values
>> > >> > > (93, 0, '919811488535', 'I', '7',
>> > >> > > TO_TIMESTAMP('7/16/2009 12:36:45.750000
>> PM','fmMMfm/fmDDfm/YYYY
>> > >> > > fmHH12fm:MI:SS.FF AM'), TO_TIMESTAMP('4/16/2009 2:34:10.968000
>> > >> > > PM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM'), '1', NULL, NULL,
>> > >> > > 'modem1');
>> >
>> > >>
>> ---------------------------------------------------------------------------
>> > >> -----------------
>> > >> > > In this table gateway_id stored as modem1.
>> >
>> > >> > > I changed modem1 to SerialModem in out table.
>> > >> > > then also i am having same problem
>> > >> > > urs,
>> > >> > > nandu
>> >
>> > >> > > On Thu, Jul 16, 2009 at 2:22 PM, Thanasis <[email protected]
>> >
>> > >> wrote:
>> >
>> > >> > >> There is a discrepancy here:
>> >
>> > >> > >> In your config file, you name your modem gateway as
>> "SerialModem".
>> >
>> > >> > >> But the row you've created sets the gateway_id field to
>> "modem1".
>> > >> This
>> > >> > >> message will never leave! Set the gateway_id field to "*" or at
>> least
>> > >> > >> to "SerialModem" (in order to match with your gateway).
>> >
>> > >> > >> On Jul 16, 11:45 am, Vivek <[email protected]> wrote:
>> > >> > >> > One row from out table
>> > >> > >> > Insert into SMSSERVER_OUT
>> > >> > >> > (ID, TYPE, RECIPIENT, TEXT, WAP_URL,
>> > >> > >> > WAP_EXPIRY_DATE, WAP_SIGNAL, CREATE_DATE, ORIGINATOR,
>> ENCODING,
>> > >> > >> > STATUS_REPORT, FLASH_SMS, SRC_PORT, DST_PORT, SENT_DATE,
>> > >> > >> > REF_NO, PRIORITY, STATUS, ERRORS, GATEWAY_ID)
>> > >> > >> > Values
>> > >> > >> > (68, 'O', '+919871515064', 'HI', NULL,
>> > >> > >> > NULL, NULL, NULL, NULL, '7',
>> > >> > >> > 1, NULL, NULL, NULL, NULL,
>> > >> > >> > NULL, 1, 'U', 1, 'modem1');
>> >
>> > >> > >> > urs,
>> > >> > >> > Vivek
>> >>
>>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SMSLib User Group" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/SMSLib?hl=en
-~----------~----~----~----~------~----~------~--~---
