As you may have gathered this is a JDBC error, nada TOS... For whatever reason there is no database connection available when your program, in ApplicationGui.messageReceived(), tries to prepare a (probably) insert statement. It might be that there is a connection cache that is too small, or old statements are not being managed correctly.
MS Varun Jain wrote: > Hi, > > > > I am currently working on an application where I am sensing two sensors, > one periodically and one based on an event. I am using CTP and > dissemination. The network TESTBED consisting of about 40 nodes has been > running successfully for about 4 months now. > > > > All the incoming data is fed from the ROOT node into a Server over > serial link and then logged into a MySQL database from the Java > application. I am having a constant error every now and then and it’s > the same error and I think it happens when too many packets come at the > same time. This is the error…. > > > > > > Exception in door msg No operations allowed after connection closed. > > com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No > operations al > > lowed after connection closed. > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) > > 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:238 > > 0) > > at > com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:236 > > 2) > > at ApplicationGui.messageReceived(KingsCourtGui.java:498) > > at net.tinyos.message.Receiver.packetReceived(Receiver.java:210) > > at net.tinyos.packet.PhoenixSource.dispatch(PhoenixSource.java:160) > > at > net.tinyos.packet.PhoenixSource.packetDipatchLoop(PhoenixSource.java: > > 152) > > at net.tinyos.packet.PhoenixSource.run(PhoenixSource.java:169) > > > > > > The Java application seems to be stuck after this error and Pressing > Ctrl-C brings it back to normal operation, can anyone suggest what i can > do to overcome this problem??? > > > > > > Regards, > > Varun Jain > > > ------------------------------------------------------------------------ > > _______________________________________________ > Tinyos-help mailing list > [email protected] > https://www.millennium.berkeley.edu/cgi-bin/mailman/listinfo/tinyos-help _______________________________________________ Tinyos-help mailing list [email protected] https://www.millennium.berkeley.edu/cgi-bin/mailman/listinfo/tinyos-help
