I had the same problem before (able to receive messages but not able to send) but I was able to solve by recreating the out table using the example script. I am using mysql.
On Jul 18, 3:36 pm, Thanasis <[email protected]> wrote: > Well, if you ask me this is not a solution, but if it fits your needs, > then OK :) > > It has been reported that smslib works on vista. The only thing that > is "sensitive" is the javacomm installation, "sensitive" in the sense > that its a more low-level library than smslib. > > On Jul 18, 10:13 am, Vivek <[email protected]> wrote: > > > 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 for Java 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 -~----------~----~----~----~------~----~------~--~---
