MySQL access problem. URGENT. Please help!

correro · 03-14-2003, 07:43 PM

When I try to access the database from a web application, I keep getting these error messages:

Code:

/webapps/MyApp/WEB-INF/classes/org/gjt/mm/mysql/Driver.java:126:
class org.gjt.mm.mysql.Connection is an abstract class. It can't be instantiated.
                    return new Connection (host(), port(), _Props, database(), Url, this);

/webapps/MyApp/WEB-INF/classes/org/gjt/mm/mysql/MysqlIO.java:508:
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

Code:

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!

correro · 03-14-2003, 08:16 PM

And the Java code is as follows. Please look into my problem and help me fix it.

Code:

public Connection DBconnect() {
	Connection con = null;
	try {
		Class.forName("org.gjt.mm.mysql.Driver").newInstance();
		String url = "jdbc:mysql://"+DBserver+"/"+DBNAME+"?user="+DBuser+"&password="+DBpasswd+"&useUnicode=true&characterEncoding=GB2312";
		con = DriverManager.getConnection(url, "", "");
	}
	catch(Exception e) {
		System.out.println(e.getMessage());
	}
	return con;
} // end of DBconnect

acid_kewpie · 03-15-2003, 06:54 AM

do not mark anything as urgent, it's just plain rude.

correro · 03-15-2003, 07:42 PM

Sorry, acid_kewpie. I'll follow your advice.

The issue is temporarily resolved. I replaced the driver files, re-installed lots of things. I don't know which of what I did worked.