search

simbabarry / smslib

Automatically exported from code.google.com/p/smslib
0 stars 0 forks source link

"SMS_CALLS" error CALLER_ID size derby db #425

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
change size in CALLER_ID VARCHAR(16) NOT NULL

ERROR smslib:169 - SQL failure, will retry in 1 seconds...
java.sql.SQLDataException: Se ha producido un error de truncamiento al intentar 
recortar VARCHAR '5500000000,161,,,' a una longitud 16.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
    at org.smslib.smsserver.interfaces.Database.callReceived(Database.java:154)
    at org.smslib.smsserver.SMSServer$CallNotification.process(SMSServer.java:507)
    at org.smslib.notify.NotifyQueueManager$NotificationQueueManager.process(NotifyQueueManager.java:111)
    at org.smslib.threading.AServiceThread.run(AServiceThread.java:105)
Caused by: java.sql.SQLException: Se ha producido un error de truncamiento al 
intentar recortar VARCHAR '5500000000,161,,,' a una longitud 16.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)

Original issue reported on code.google.com by arkei...@gmail.com on 20 Jun 2011 at 3:21

GoogleCodeExporter commented 9 years ago 
The format of the phone which is supposed to be the CALLER ID is not correct:
'5500000000,161,,,'

You probably hit some incompatibility.
Please let me know of the gsm modem you are using and a log containing the RING 
notification.

Original comment by T.Delenikas on 20 Jun 2011 at 8:35

GoogleCodeExporter commented 9 years ago 
No feedback...

Original comment by T.Delenikas on 12 Jul 2011 at 6:16

GoogleCodeExporter commented 9 years ago 
simcom 300

Original comment by arkei...@gmail.com on 14 Jul 2011 at 3:52