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.
