Get an exception when close the connections

Ask around here!

Get an exception when close the connections

Postby oschina » Sun Jan 24, 2010 1:15 am

Here is the exception stack (BoneCP 0.6.3):

2010-1-24 9:07:43 com.jolbox.bonecp.BoneCP terminateAllConnections
Fatal: Error in attempting to close connection
java.sql.SQLException: com/mysql/jdbc/profiler/ProfilerEventHandlerFactory
at com.jolbox.bonecp.ConnectionHandle.markPossiblyBroken(ConnectionHandle.java:231)
at com.jolbox.bonecp.ConnectionHandle.internalClose(ConnectionHandle.java:322)
at com.jolbox.bonecp.BoneCP.terminateAllConnections(BoneCP.java:127)
at com.jolbox.bonecp.BoneCP.shutdown(BoneCP.java:108)
at com.jolbox.bonecp.BoneCPDataSource.close(BoneCPDataSource.java:149)
oschina
 
Posts: 15
Joined: Wed Dec 30, 2009 3:06 pm

Re: Get an exception when close the connections

Postby wwadge » Sun Jan 24, 2010 8:35 am

What logging mechanism are you using?

Looking at:
http://www.cs.unca.edu/~jkdawg/2009Fall/csci/343.001/notes/mysql-connector-java-5.1.10/src/com/mysql/jdbc/profiler/ProfilerEventHandlerFactory.java

the only exception that is present is related to logging.

Also do you have some kind of mysql profiling switched on?

Does this error occur every time you try to shutdown the pool or happens randomly?

Wallace
wwadge
Site Admin
 
Posts: 713
Joined: Mon Oct 19, 2009 7:50 pm

Re: Get an exception when close the connections

Postby oschina » Tue Jan 26, 2010 4:26 am

Also do you have some kind of mysql profiling switched on?(NO)

Does this error occur every time you try to shutdown the pool or happens randomly? (NO)
oschina
 
Posts: 15
Joined: Wed Dec 30, 2009 3:06 pm

Re: Get an exception when close the connections

Postby hanaper » Fri Mar 25, 2011 7:16 am

at com.jolbox.bonecp.ConnectionHandle.markPossiblyBroken(ConnectionHandle.java:284)
at com.jolbox.bonecp.CallableStatementHandle.registerOutParameter(CallableStatementHandle.java:1342)
It was a little wrong ah, how to deal with.
My English is not good, use translation software translation.
hanaper
 
Posts: 1
Joined: Wed Mar 23, 2011 3:49 am

Re: Get an exception when close the connections

Postby wwadge » Fri Mar 25, 2011 11:36 am

Please show the full stack trace.
wwadge
Site Admin
 
Posts: 713
Joined: Mon Oct 19, 2009 7:50 pm


Return to BoneCP - Help, Q&A, Whatever!

Who is online

Users browsing this forum: Bing [Bot] and 2 guests