Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

not able to connect to an ms access database using jsp and servlets

 
Christian Nash
Ranch Hand
Posts: 107
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,

I am trying to access an ms access database. Have already setup the system dsn. i am able to access the database through a java file but not through the jsp and servlets.

below is the code i use to connect to the database:


I get the following exception:
 
krishnamoorthy kitcha
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Christian Nash ,


This exception showed the not to set the ojdbc.jar in the class file.

Just find out ojdbc.jar or else put ojdbc.jar in the lib folder of the

servlet folder , or else import package in servlet or jsp .

Please test the same and tell me your feedback.

Regards
k.krishnamoorthy.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You're using the JDBC-ODBC bridge, which is an unsupported driver and only included in the Sun JVM. Looks like you are using the IBM JDK.

Personally I suggest getting away from MS Access. Seriously. It may not be solution you're looking for, but I'd prefer to offer a real solution to a patch on something going wrong.
 
Ulf Dittmer
Rancher
Posts: 42969
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
... not to mention that Access wasn't meant for concurrent access, so all kinds of things could be going wrong in a multithreaded environment like a web app.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic