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.
