hi, I am trying to get some values from a html page into a MYSQL databse through a servlet , my problem is when i enter a value a press submit , the illegal access exception is thrown ,I had the same problem with MSaccess database , but if we give a blank user and password in the getConnection() method , then it works fine . but when i try the same with MYSQL , it still throws a IllegalAccessException,I tried to do this as a simple database application passing the value to be inserted in the commandline parameter it worked fine , it throws this exception only when done as a servlet. Does anybody knows how to create a system dsn entry for MYsql in (controlpanel->odbc) like we do for MSaccess database.Any comments will be appreciated. thanks raghav
posted 14 years ago
You need to get an appropriate driver for mysql. mmmysql driver is very good. Try to search for it on the web. There are even some examples show you how to set up jdbc connection using this driver.