JDBC Socket Exception when closing connection to MySQL

Question

I am connecting to MySQL using the following connection string in JDBC.

jdbc:mysql://127.0.0.1/db?enable-named-pipe&socket=MySQL&socketFactory=com.mysql.jdbc.NamedPipeSocketFactory&zeroDateTimeBehavior=convertToNull

If i use a tcp/ip connection i can close the connection fine but it seems if i use a local socket/pipe connection to MySQL it throws the following exception.

java.netSocketException: Socket is not connected

Seems like the connection is being dropped without me needing to close the connection, so when using a local socket/pipe i don't have to close the connection it is done automatically, am i correct in thinking this? The data i have inserted seems to have gone in fine.

Thanks.

What is the question? If you think you are doing nothing wrong, I'd suggest filing a bug report with MySQL. — Mark Rotteveel
– Mark Rotteveel, Commented Feb 13, 2013 at 10:39
Can you delete the the main program context from Run configuration and Run it again. — Anil
– Anil, Commented Feb 13, 2013 at 10:40

JCS · Accepted Answer · 2013-02-13 11:00:42Z

1

It seems to be due to a JVM bug that hasn't been fixed yet http://bugs.mysql.com/bug.php?id=62518

answered Feb 13, 2013 at 11:00

JCS

9174 gold badges20 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Audrius Meškauskas · Accepted Answer · 2013-02-13 10:42:05Z

0

You know that you have not closed the connection and that you should.

For peace of mind, you may try to close the connection anyway and catch the thrown exception. This may be better than to rely on some kind of bug kind of feature that may go away in the next minor release.

answered Feb 13, 2013 at 10:42

Audrius Meškauskas

21.9k12 gold badges85 silver badges100 bronze badges

Collectives™ on Stack Overflow

JDBC Socket Exception when closing connection to MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related