[Arianne-bugs] [ arianne-Bugs-3035822 ] [stendhal/enginee]upgrade empty db will occur error log

[SourceForge.net <no...@so...>]

Bugs item #3035822, was opened at 2010-07-28 08:50
Message generated for change (Tracker Item Submitted) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=101111&aid=3035822&group_id=1111

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Code
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: [stendhal/enginee]upgrade empty db will occur error log

Initial Comment:
MYSQL: 5.1.49
Connector/J: 5.1.13
StendHal Server: 0.86

refer to mysql bug :http://bugs.mysql.com/bug.php?id=41448

After create an empty db on MYSQL, then start StendHal Server by ./runserver.sh, error log in server.log:
==========================================================================
2010-07-28 09:05:26 ERROR [marauroad ] WordList                 ( 706) - error closing DB accessor
java.sql.SQLException: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate() or Connection.prepareStatement().
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
	at com.mysql.jdbc.StatementImpl.getGeneratedKeys(StatementImpl.java:1878)
	at games.stendhal.server.entity.npc.parser.WordList.insertIntoDB(WordList.java:767)
	at games.stendhal.server.entity.npc.parser.WordList.writeToDB(WordList.java:693)
	at games.stendhal.server.entity.npc.parser.WordList.attachDatabase(WordList.java:101)
	at games.stendhal.server.core.engine.StendhalRPWorld.onInit(StendhalRPWorld.java:132)
	at marauroa.server.game.rp.RPServerManager.initializeExtensions(RPServerManager.java:171)
	at marauroa.server.game.rp.RPServerManager.<init>(RPServerManager.java:137)
	at marauroa.server.marauroad.init(marauroad.java:346)
	at marauroa.server.marauroad.run(marauroad.java:282)



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=101111&aid=3035822&group_id=1111