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.
