How would you store data for a large scale game server written in java? In mysql or? like player data, equipment, weapons etc.

I''d have all the server-side stuff running in EJB''s. The jBoss EJB container (http://www.jboss.org) is free, so...

Ok, but whats so great with it compared to for instance mysql?

I've never used javaBeans before but I have used sql in one of my games(It was written in coldfusion not java) and I personally liked it for storing things like armor, weapons, items, and enemy data. I found that it was very very easy to use if take some time to plan you database. If you plan it right you can use that data format in most of your games.

Also if your game is a multiplayer game of any kind it's kinda of nice to store all of the players stats, and inventory, magic whatever in a database. That way if you wish to you could still have player to player confrontations without both players being logged on at the sametime. And personally I think that adds a lot of replay value to a game, becuase the players will keep logging back on to see what happened while they were logged off. Anyway that's my $.02

War doesn't determine who is right, war determines who is left.

Edited by - Wrathnut on September 6, 2000 4:03:47 PM