• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

servlet with MYsql database problem

 
Raghav
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
SoonAnn Lim
Ranch Hand
Posts: 155
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic