Java-Gaming.org    
Featured games (79)
games approved by the League of Dukes
Games in Showcase (477)
Games in Android Showcase (108)
games submitted by our members
Games in WIP (536)
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 995 times)
0 Members and 1 Guest are viewing this topic.
Offline Matlu

Junior Member




Hasta La Victoria Siempre!


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

Quote

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:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
     at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)
     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288 )
     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2784)
     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
     at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1347)

each subsequent sql statement failed with:

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

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Broken pipe

STACKTRACE:

java.net.SocketException: 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
http://www.duelboard.com
Offline blahblahblahh

JGO Coder


Medals: 1


http://t-machine.org


« Reply #1 - Posted 2005-04-13 23: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 Member




Hasta La Victoria Siempre!


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

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

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

 

Add your game by posting it in the WIP section,
or publish it in Showcase.

The first screenshot will be displayed as a thumbnail.

CogWheelz (18 views)
2014-07-30 21:08:39

Riven (23 views)
2014-07-29 18:09:19

Riven (15 views)
2014-07-29 18:08:52

Dwinin (12 views)
2014-07-29 10:59:34

E.R. Fleming (33 views)
2014-07-29 03:07:13

E.R. Fleming (12 views)
2014-07-29 03:06:25

pw (43 views)
2014-07-24 01:59:36

Riven (43 views)
2014-07-23 21:16:32

Riven (30 views)
2014-07-23 21:07:15

Riven (31 views)
2014-07-23 20:56:16
List of Learning Resources
by SilverTiger
2014-07-31 18:29:50

List of Learning Resources
by SilverTiger
2014-07-31 18:26:06

List of Learning Resources
by SilverTiger
2014-07-31 13:54:12

HotSpot Options
by dleskov
2014-07-08 03:59:08

Java and Game Development Tutorials
by SwordsMiner
2014-06-14 00:58:24

Java and Game Development Tutorials
by SwordsMiner
2014-06-14 00:47:22

How do I start Java Game Development?
by ra4king
2014-05-17 11:13:37

HotSpot Options
by Roquen
2014-05-15 09:59:54
java-gaming.org 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‑gaming.org
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!