Vivek Ashok Kumar

Greenhorn
+ Follow
since Aug 30, 2011
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Vivek Ashok Kumar

I'm getting an error called Begin Nested Exception while running my batch file which is used to insert data into MySql database from an Excel. the error as follows

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Connection reset

STACKTRACE:

java.net.SocketException: Connection reset

at java.net.SocketInputStream.read(SocketInputStream.java:168)

at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)

at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)

at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)

at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1994)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2411)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)

at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874)

at com.applicationavail.ServiceAvailBatch.insertDatas(ServiceAvailBatch.java:149)

at com.applicationavail.ApplicationMain.main(ApplicationMain.java:22)



** END NESTED EXCEPTION **



Last packet sent to the server was 21298 ms ago.

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2622)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)

at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874)

at com.applicationavail.ServiceAvailBatch.insertDatas(ServiceAvailBatch.java:149)

at com.applicationavail.ApplicationMain.main(ApplicationMain.java:22)

30 Aug 2011 18:11:49 [main ] ERROR com.util.DBConnect.dbRollback(DBConnect.java:80) - SQLException :
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)

at com.mysql.jdbc.Connection.getMutex(Connection.java:3728)

at com.mysql.jdbc.Connection.rollback(Connection.java:5204)

at com.util.DBConnect.dbRollback(DBConnect.java:77)

at com.applicationavail.ServiceAvailBatch.insertDatas(ServiceAvailBatch.java:163)

at com.applicationavail.ApplicationMain.main(ApplicationMain.java:22)

30 Aug 2011 18:11:49 [main ] INFO com.hclt.util.ExcelUtil.closeWorkbook(ExcelUtil.java:51) - Closed workbook.