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.
