Hi !
Featured games (85)
games approved by the League of Dukes
Games in Showcase (636)
Games in Android Showcase (178)
games submitted by our members
Games in WIP (686)
games currently in development
News: Read the Java Gaming Resources, or peek at the official Java tutorials
    Home     Help   Search   Login   Register   
Pages: [1]
  ignore  |  Print  
  mySql connection failed  (Read 1184 times)
0 Members and 1 Guest are viewing this topic.
Offline Matlu

Junior Devvie

Hasta La Victoria Siempre!

« Posted 2005-04-13 21:01:04 »


40% - SQL being shit, MySQL being shit, or JDBC being shit. All this comes down to just two thigns: 1: MySQL authors were smoking some serious drugs when designing a lot of its behaviour. 2: (85% of the problem) SQL has no compile-time checking in Java because JDBC is so incredibly weak.

I'm not sure what exactly was your problem, can you please explain?

Today, I experienced following problem:
On my dedicated unix box I have running mySql 4.1.10 and my game server (java application).
The application is permanently connected to the database, is has 4 prepared sql statements (quite simple) and occasionaly executes some of them.
Everything run smoothly for a week - and then, out of the blue, following exception:

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


     at com.mysql.jdbc.MysqlIO.readFully(
     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket( )
     at com.mysql.jdbc.MysqlIO.checkErrorPacket(
     at com.mysql.jdbc.MysqlIO.sendCommand(
     at com.mysql.jdbc.ServerPreparedStatement.serverExecute(

each subsequent sql statement failed with:

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

MESSAGE: Broken pipe

STACKTRACE: Broken pipe

I have really no idea what could went wrong, when both the database and the application are on the same machine?!
Happened to anybody? Any ideas?

Multiplayer Online Games
Offline blahblahblahh

JGO Coder

Medals: 1

« Reply #1 - Posted 2005-04-13 21:12:44 »

yes, you actually need to read the docs for mmmysql driver and mysql.

its (almost certainly) a design "feature" that has pissed off huge numbers of people over the years.

just make you8r connection auto reconnnnect better, i cant tell you how you have toread thedocs for your particlar version of the driver

malloc will be first against the wall when the revolution comes...
Offline Matlu

Junior Devvie

Hasta La Victoria Siempre!

« Reply #2 - Posted 2005-04-14 06:52:56 »

Uh... if this is a feature... than I'm bit worried what bugs do they have  Shocked

Multiplayer Online Games
Pages: [1]
  ignore  |  Print  
You cannot reply to this message, because it is very, very old.

Dwinin (61 views)
2015-11-07 13:29:08

Rems19 (75 views)
2015-10-31 01:36:56

Rems19 (68 views)
2015-10-31 01:32:37

williamwoles (103 views)
2015-10-23 10:42:59

williamwoles (91 views)
2015-10-23 10:42:45

Jervac_ (104 views)
2015-10-18 23:29:12

DarkCart (131 views)
2015-10-16 00:58:11

KaiHH (113 views)
2015-10-11 14:10:14

KaiHH (153 views)
2015-10-11 13:26:18

BurntPizza (166 views)
2015-10-08 03:11:46
Rendering resources
by Roquen
2015-11-13 14:37:59

Rendering resources
by Roquen
2015-11-13 14:36:58

Math: Resources
by Roquen
2015-10-22 07:46:10

Networking Resources
by Roquen
2015-10-16 07:12:30

Rendering resources
by Roquen
2015-10-15 07:40:48

Math: Inequality properties
by Roquen
2015-10-01 13:30:46

Math: Inequality properties
by Roquen
2015-09-30 16:06:05

HotSpot Options
by Roquen
2015-08-29 11:33:11 is not responsible for the content posted by its members, including references to external websites, and other references that may or may not have a relation with our primarily gaming and game production oriented community. inquiries and complaints can be sent via email to the info‑account of the company managing the website of java‑
Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines | Managed by Enhanced Four Valid XHTML 1.0! Valid CSS!