• 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
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

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: 43027
76
  • 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.
 
You know it is dark times when the trees riot. I think this tiny ad is their leader:
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
reply
    Bookmark Topic Watch Topic
  • New Topic