Skip to content

Instantly share code, notes, and snippets.

@harshadura
Created August 30, 2013 19:19
Show Gist options
  • Save harshadura/6393341 to your computer and use it in GitHub Desktop.
Save harshadura/6393341 to your computer and use it in GitHub Desktop.
sd
INFO: Unexpected database error occurred
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'update_time' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
at org.durapix.chitchat.db.DbTasks.addUserToChatDb(DbTasks.java:484)
at org.durapix.chitchat.user.ChatUser.setAddress(ChatUser.java:167)
at org.durapix.chitchat.user.ChatUser.<init>(ChatUser.java:42)
at org.durapix.chitchat.main.ChatMain.init(ChatMain.java:28)
at org.durapix.chitchat.main.ChatMain.<init>(ChatMain.java:15)
at org.durapix.chitchat.main.ListnerServelet.onReceivedSms(ListnerServelet.java:31)
at hms.kite.samples.api.sms.MoSmsReceiver$2.run(MoSmsReceiver.java:118)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Aug 31, 2013 12:48:21 AM org.durapix.chitchat.db.DbTasks getUserId
INFO: Unexpected database error occurred
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1098)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2380)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2362)
at org.durapix.chitchat.db.DbTasks.getUserId(DbTasks.java:124)
at org.durapix.chitchat.user.User.setId(User.java:121)
at org.durapix.chitchat.user.ChatUser.<init>(ChatUser.java:43)
at org.durapix.chitchat.main.ChatMain.init(ChatMain.java:28)
at org.durapix.chitchat.main.ChatMain.<init>(ChatMain.java:15)
at org.durapix.chitchat.main.ListnerServelet.onReceivedSms(ListnerServelet.java:31)
at hms.kite.samples.api.sms.MoSmsReceiver$2.run(MoSmsReceiver.java:118)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Aug 31, 2013 12:48:21 AM org.durapix.chitchat.db.DbTasks getType
INFO: Unexpected database error occurred
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1098)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2380)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2362)
at org.durapix.chitchat.db.DbTasks.getType(DbTasks.java:1184)
at org.durapix.chitchat.user.User.setType(User.java:82)
at org.durapix.chitchat.user.ChatUser.<init>(ChatUser.java:44)
at org.durapix.chitchat.main.ChatMain.init(ChatMain.java:28)
at org.durapix.chitchat.main.ChatMain.<init>(ChatMain.java:15)
at org.durapix.chitchat.main.ListnerServelet.onReceivedSms(ListnerServelet.java:31)
at hms.kite.samples.api.sms.MoSmsReceiver$2.run(MoSmsReceiver.java:118)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Aug 31, 2013 12:48:21 AM org.durapix.chitchat.db.DbTasks setType
INFO: Unexpected database error occurred
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1098)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2380)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2362)
at org.durapix.chitchat.db.DbTasks.setType(DbTasks.java:1158)
at org.durapix.chitchat.db.DbTasks.getType(DbTasks.java:1207)
at org.durapix.chitchat.user.User.setType(User.java:82)
at org.durapix.chitchat.user.ChatUser.<init>(ChatUser.java:44)
at org.durapix.chitchat.main.ChatMain.init(ChatMain.java:28)
at org.durapix.chitchat.main.ChatMain.<init>(ChatMain.java:15)
at org.durapix.chitchat.main.ListnerServelet.onReceivedSms(ListnerServelet.java:31)
at hms.kite.samples.api.sms.MoSmsReceiver$2.run(MoSmsReceiver.java:118)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Aug 31, 2013 12:48:21 AM org.durapix.chitchat.db.DbTasks getChatPartner
INFO: Unexpected database error occurred
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1098)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2380)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2362)
at org.durapix.chitchat.db.DbTasks.getChatPartner(DbTasks.java:654)
at org.durapix.chitchat.user.ChatUser.sendChatMessage(ChatUser.java:201)
at org.durapix.chitchat.main.ChatMain.checkForTheKeyWord(ChatMain.java:170)
at org.durapix.chitchat.main.ChatMain.init(ChatMain.java:29)
at org.durapix.chitchat.main.ChatMain.<init>(ChatMain.java:15)
at org.durapix.chitchat.main.ListnerServelet.onReceivedSms(ListnerServelet.java:31)
at hms.kite.samples.api.sms.MoSmsReceiver$2.run(MoSmsReceiver.java:118)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Aug 31, 2013 12:48:21 AM org.durapix.chitchat.db.DbTasks getResponceFromDb
INFO: Unexpected database error occurred
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1098)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2380)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2362)
at org.durapix.chitchat.db.DbTasks.getResponceFromDb(DbTasks.java:272)
at org.durapix.chitchat.message.ResponceMessage.<init>(ResponceMessage.java:15)
at org.durapix.chitchat.user.ChatUser.sendChatMessage(ChatUser.java:212)
at org.durapix.chitchat.main.ChatMain.checkForTheKeyWord(ChatMain.java:170)
at org.durapix.chitchat.main.ChatMain.init(ChatMain.java:29)
at org.durapix.chitchat.main.ChatMain.<init>(ChatMain.java:15)
at org.durapix.chitchat.main.ListnerServelet.onReceivedSms(ListnerServelet.java:31)
at hms.kite.samples.api.sms.MoSmsReceiver$2.run(MoSmsReceiver.java:118)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Aug 31, 2013 12:48:21 AM org.durapix.chitchat.db.DbTasks checkForOperatorType
INFO: Unexpected database error occurred
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1098)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2380)
at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2362)
at org.durapix.chitchat.db.DbTasks.checkForOperatorType(DbTasks.java:1126)
at org.durapix.chitchat.util.Utilities.sendMessage(Utilities.java:466)
at org.durapix.chitchat.message.Message.sendMessage(Message.java:45)
at org.durapix.chitchat.user.User.sendMessage(User.java:153)
at org.durapix.chitchat.user.ChatUser.sendChatMessage(ChatUser.java:212)
at org.durapix.chitchat.main.ChatMain.checkForTheKeyWord(ChatMain.java:170)
at org.durapix.chitchat.main.ChatMain.init(ChatMain.java:29)
at org.durapix.chitchat.main.ChatMain.<init>(ChatMain.java:15)
at org.durapix.chitchat.main.ListnerServelet.onReceivedSms(ListnerServelet.java:31)
at hms.kite.samples.api.sms.MoSmsReceiver$2.run(MoSmsReceiver.java:118)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Aug 31, 2013 12:48:21 AM org.durapix.chitchat.main.ListnerServelet onReceivedSms
INFO: Unexpected error occurred
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at org.durapix.chitchat.util.Utilities.etiSendMessage(Utilities.java:396)
at org.durapix.chitchat.util.Utilities.sendMessage(Utilities.java:476)
at org.durapix.chitchat.message.Message.sendMessage(Message.java:45)
at org.durapix.chitchat.user.User.sendMessage(User.java:153)
at org.durapix.chitchat.user.ChatUser.sendChatMessage(ChatUser.java:212)
at org.durapix.chitchat.main.ChatMain.checkForTheKeyWord(ChatMain.java:170)
at org.durapix.chitchat.main.ChatMain.init(ChatMain.java:29)
at org.durapix.chitchat.main.ChatMain.<init>(ChatMain.java:15)
at org.durapix.chitchat.main.ListnerServelet.onReceivedSms(ListnerServelet.java:31)
at hms.kite.samples.api.sms.MoSmsReceiver$2.run(MoSmsReceiver.java:118)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment