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]. For more options, visit this group at http://groups.google.com/group/smslib?hl=en.
