• 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
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

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.
 
I was her plaything! And so was this tiny ad:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic