Hi !
Featured games (84)
games approved by the League of Dukes
Games in Showcase (565)
Games in Android Showcase (151)
games submitted by our members
Games in WIP (606)
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 1092 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.

ags1 (13 views)
2015-03-31 10:55:12

theagentd (13 views)
2015-03-27 23:08:20

wxwsk8er (54 views)
2015-03-20 15:39:46

Fairy Tailz (47 views)
2015-03-15 21:52:20

Olo (29 views)
2015-03-13 17:51:59

Olo (32 views)
2015-03-13 17:50:51

Olo (39 views)
2015-03-13 17:50:16

Olo (44 views)
2015-03-13 17:47:07

ClaasJG (58 views)
2015-03-10 11:36:42

ClaasJG (42 views)
2015-03-10 11:33:01
How to: JGO Wiki
by Mac70
2015-02-17 20:56:16

2D Dynamic Lighting
by ThePixelPony
2015-01-01 20:25:42

How do I start Java Game Development?
by gouessej
2014-12-27 19:41:21

Resources for WIP games
by kpars
2014-12-18 10:26:14

Understanding relations between setOrigin, setScale and setPosition in libGdx
by mbabuskov
2014-10-09 22:35:00

Definite guide to supporting multiple device resolutions on Android (2014)
by mbabuskov
2014-10-02 22:36:02

List of Learning Resources
by Longor1996
2014-08-16 10:40:00

List of Learning Resources
by SilverTiger
2014-08-05 19:33:27 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!