When I try to access the database from a web application, I keep getting these error messages:
class org.gjt.mm.mysql.Connection is an abstract class. It can't be instantiated.
return new Connection (host(), port(), _Props, database(), Url, this);
class org.gjt.mm.mysql.ResultSet is an abstract class. It can't be instantiated.
return new ResultSet(updateCount, updateID);
When I check the log file, there are lines like
Server configuration denies access to data source
I tried for days to fix it, but in vain. Here's some additional info about the scenario:
(1) I'm using MySQL bundled with RedHat 8.0
(2) The Web server is a JSP engine called Resin.
(3) Things were working fine; until I changed the database root password (not OS root account), which was empty before I changed it.
(4) I tried the following in my attempt to make it work: setting database root password back to empty; removing the database; installing a separate MySQL system in "/usr/local"; re-installing Linux. But it still does not work (the same error messages).
I'm not sure about the nature of this issue. MySQL access privileges? JDBC driver corruption? Java code problem?
Incidentally, this application (exactly the same code and database) is running PERFECTLY fine on Windows 2000 Server, even if I changed the database root password.
I've been thinking about migrating from Windows to Linux, but this is driving me crazy. Please HELP!