Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: "Peter H. Coffin" Newsgroups: comp.databases.mysql Subject: Re: is mysql at fault for this JDBC error? (com.mysql.jdbc.exceptions.jdbc4.CommunicationsException) Date: Wed, 27 Apr 2011 07:16:41 -0500 Organization: A noiseless patient Spider Lines: 39 Message-ID: References: <37fce90f-1c0e-4205-a930-3a7fb10f3275@h38g2000yqn.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Injection-Info: mx03.eternal-september.org; posting-host="le/2G4+BNpieVhQI6uJ2Lw"; logging-data="17763"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+ATItdfB8ZcsVDdwIxyTW2" User-Agent: slrn/0.9.9p1 (OpenBSD) Cancel-Lock: sha1:MoZ9wSbNmKKF794cfVtx5WOVeC8= Xref: x330-a1.tempe.blueboxinc.net comp.databases.mysql:700 On Tue, 26 Apr 2011 23:39:03 -0700 (PDT), terry433iid@yahoo.com wrote: > I am running a java class that queries mysql via JDBC, the database is > also servicing a GUI via tomcat (connection pool) > > All of a sudden the java application crashes and below is the log file > output that I get > > So - I'm left wondering if this is a mysql error......or tomcat > messing with connection pool ..... or JDBC error.....??? > > I cannot find any good info on the web for the error, so any feedback > appreciated > > > > --------------------------------- > SelectStr: show tables > Error while executing SQL transaction: No operations allowed after > connection closed.Connection was implicitly closed due to underlying > exception/error: > > > ** BEGIN NESTED EXCEPTION ** > > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException > MESSAGE: Communications link failure > > Last packet sent to the server was 1 ms ago. The database connection went away unexpectedly. Probably because the network means that the communications link was using got closed unexpectedly. If the database is still running and other connections are working, it's not the database doing it. -- Christian Biblical literalists are trusting themselves to an archaic English translation of a Latin translation of (help me here) Greek? Aramaic? source. I wouldn't even trust a VCR manual to make it through that intact. - Dr. Dee