Blocked Prepared Statement

[cbrennan]

I have a several prepared statements that are sometimes blocking and never returning when using BoneCP vs. not using any connection pool. It is not happening at the same point each time. My guess is that some prepared statements are not getting closed and since the connection pool is reusing some connections, when a reused connection is using the same prepared statement again it might cause this issue?

The stack trace is where it is getting stuck is:

SocketInputStream.socketRead0(FileDescriptor, byte[], int, int, int) line: not available [native method]
SocketInputStream.read(byte[], int, int) line: not available
DataInputStream.readFully(byte[], int, int) line: not available
DataInputStream.readFully(byte[]) line: not available
SharedSocket.readPacket(byte[]) line: 826
SharedSocket.getNetPacket(int, byte[]) line: 707
ResponseStream.getPacket() line: 466
ResponseStream.read() line: 103
ResponseStream.peek() line: 88
TdsCore.wait(int) line: 3870
TdsCore.executeSQL(String, String, ParamInfo[], boolean, int, int, int, boolean) line: 1042
JtdsPreparedStatement(JtdsStatement).executeSQLQuery(String, String, ParamInfo[], boolean) line: 406
JtdsPreparedStatement.executeQuery() line: 693
PreparedStatementHandle.executeQuery() line: 172