Google has a lot of hits on

+"invalid authorization specification" +tomcat

The solution often suggested is to GRANT access privileges on a per-database-level. Some solutions even suggest editing the mysql tables directly. The whole thing is a bit too mysterious for my taste. The Tomcat developers should probably think of having a resolution for this problem on their website.

If you grant privileges on a TABLE level instead of a DATABASE level, for some strange reason, the access is given.

GRANT SELECT, INSERT, UPDATE, DELETE ON somedatabase.sometable TO someuser IDENTIFIED BY 'somepass';

BR

Morten Hjerl-Hansen
www.dramaticjavagames.com

P.S. If you found my solution helpful, please consider trying out new online multiplayer game and buying an inexpensive account. The game aims on being inspiring and beautiful: www.dramaticjavagames.com

Link:

http://www.itdesignservices.com/text...lkthrough.html