The HUAWEIs usually require the user to explicitly define the SMSC number. This is a setting in the SMSServer's config file.
On Dec 11, 11:32 am, "[email protected]" <[email protected]> wrote: > Hi the version of SQLServer JDBC drivers am using is > SqdriversJDBC2.0 > > I tried with updatingthe jdbc drivers to sqljdbc.jar and sqljdbc4.jar > > know am able to update the message in the OUT table but the Modem is > unable tosend the message nor read from it > > Is there any problem with the Huawei E220 Modem ? > > am getting the following log on the console > > Dec 11, 2009 12:28:13 PM org.smslib.helper.Logger logWarn > WARNING: GTW: modem1: CMS Error 500: Retrying... > Dec 11, 2009 12:28:20 PM org.smslib.helper.Logger logWarn > WARNING: GTW: modem1: CMS Error 500: Retrying... > Dec 11, 2009 12:28:28 PM org.smslib.helper.Logger logError > SEVERE: GTW: modem1: CMS Error 500: Quit retrying, message lost... > Dec 11, 2009 12:28:38 PM org.smslib.helper.Logger logInfo > INFO: SMSServer: sending synchronously... > > On Dec 8, 10:24 am, Pietro <[email protected]> wrote: > > > > > Can you check the jdbc driver version?. Maybe it's old and don't > > support updateable results sets. The other thing is an error in the > > url but I don't use sqlserver. > > > HTH > > > Pietro > > > On Dec 7, 6:43 am, Samuel John <[email protected]> wrote: > > > > Hi Thanasis I have run the scripts provided in smslib misc folder.. > > > > and i can see the ID feild set to primary key > > > > 2009/12/5 Thanasis <[email protected]> > > > > > You probably didn't set the ID field to be a primary key. > > > > > On Dec 5, 3:23 pm, "[email protected]" <[email protected]> > > > > wrote: > > > > > Hi All, > > > > > > Am trying to use SMSLib with HUAWEI E220 Modem > > > > > > and using SQLServer2000 as back end. > > > > > > when am trying to push sms from smsserver_out table. > > > > > > am getting this error:- > > > > > > Dec 5, 2009 4:21:06 PM org.smslib.helper.Logger logError > > > > > SEVERE: SMSServer: sending messages exception! > > > > > java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC] > > > > > ResultSet is not updateable. > > > > > at com.microsoft.jdbc.base.BaseExceptions.createException > > > > > (Unknown Source) > > > > > at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown > > > > > Source) > > > > > at com.microsoft.jdbc.base.BaseResultSet.validateUpdateable > > > > > (Unknown Source) > > > > > at com.microsoft.jdbc.base.BaseResultSet.updateString(Unknown > > > > > Source) > > > > > at com.microsoft.jdbc.base.BaseResultSet.updateString(Unknown > > > > > Source) > > > > > at org.smslib.smsserver.interfaces.Database.getMessagesToSend > > > > > (Database.java:308) > > > > > at org.smslib.smsserver.SMSServer.sendMessages(SMSServer.java: > > > > > 381) > > > > > at org.smslib.smsserver.SMSServer$OutboundPollingThread.run > > > > > (SMSServer.java:280) > > > > > Dec 5, 2009 4:21:06 PM org.smslib.helper.Logger logInfo > > > > > INFO: SMSServer: sending synchronously... > > > > > Dec 5, 2009 4:21:16 PM org.smslib.helper.Logger logError > > > > > SEVERE: SMSServer: sending messages exception! > > > > > java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC] > > > > > ResultSet is not updateable. > > > > > at com.microsoft.jdbc.base.BaseExceptions.createException > > > > > (Unknown Source) > > > > > at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown > > > > > Source) > > > > > at com.microsoft.jdbc.base.BaseResultSet.validateUpdateable > > > > > (Unknown Source) > > > > > at com.microsoft.jdbc.base.BaseResultSet.updateString(Unknown > > > > > Source) > > > > > at com.microsoft.jdbc.base.BaseResultSet.updateString(Unknown > > > > > Source) > > > > > at org.smslib.smsserver.interfaces.Database.getMessagesToSend > > > > > (Database.java:308) > > > > > at org.smslib.smsserver.SMSServer.sendMessages(SMSServer.java: > > > > > 381) > > > > > at org.smslib.smsserver.SMSServer$OutboundPollingThread.run > > > > > (SMSServer.java:280) > > > > > Dec 5, 2009 4:21:16 PM org.smslib.helper.Logger logInfo > > > > > INFO: SMSServer: sending synchronously... > > > > > > If any body have ever come across this situation please let me know. > > > > > > My configuration file looks like:- > > > > > > # Lets add a modem > > > > > gateway.0=modem1, SerialModem > > > > > modem1.port=COM15 > > > > > modem1.baudrate=9600 > > > > > modem1.manufacturer=HUAWEI > > > > > modem1.model= E220 > > > > > modem1.protocol=PDU > > > > > modem1.pin=0000 > > > > > modem1.inbound=yes > > > > > modem1.outbound=yes > > > > > modem1.smsc_number= > > > > > modem1.init_string=ATZ\rATZ\rATZ\r > > > > > > # Here is an example of a Microsoft SQL Server database interface. > > > > > interface.0=db1, Database > > > > > db1.url=jdbc:sqlserver://localhost:1433;DatabaseName=smslib > > > > > db1.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver > > > > > db1.username=lynx > > > > > db1.password=nairobi > > > > > db1.type=mssql > > > > > db1.tables.sms_in= smsserver_in > > > > > db1.tables.sms_out= smsserver_out > > > > > db1.tables.calls= smsserver_calls > > > > > db1.batch_size=50 > > > > > db1.retries=2 > > > > > db1.update_outbound_on_statusreport=no > > > > > -- > > > > > 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]<smslib%[email protected]> > > > > . > > > > For more options, visit this group at > > > >http://groups.google.com/group/smslib?hl=en. > > > > -- > > > Knowledge not shared is Knowledge Wasted > > > Priyanka Shetty.P -- 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.
