• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Ranch Hand
Posts: 107
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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:
 
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic