Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

Need to detect values in an Access DB from a JSP Page.

I have a request at work to build an alert system that will generate dynamic content on ASP pages as well as JSP pages.  

I had an idea that I could use an Access back end to store the content and an on/off flag.  This will work great for the ASP side, but how would I implement it on the JSP side?

Can JSP's read Access DB's?

Barry62
0
Barry62
Asked:
Barry62
  • 3
  • 3
  • 2
1 Solution
 
CEHJCommented:
Yes. Use JDBC, but you'd be better off with a superior db - MySQL or PostGresql
0
 
Barry62Author Commented:
OK, I'll try it.  

One question:  How does the servlet know where the database is located?

Barry62
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
objectsCommented:
> How does the servlet know where the database is located?

you specify the database to connect to using the connect string.

http://www.javaalmanac.com/cgi-bin/search/find.pl?words=jdbc
0
 
Barry62Author Commented:
Yes, objects, I know about connection strings.  But from the example that CEHJ provided, I don't see anything that would suggest that the Access database can be anywhere but on the same server, in the same directory as the java code.

My Access database will live on a completely different server than the java servlet.

Can I not do it this way?

Barry62
0
 
objectsCommented:
you'll need to move your access database to the same server, or use a different database.
0
 
Barry62Author Commented:
Thanks.   was afraid I would have to do that, but hoping there was another solution.

Oh, well.  

0
 
objectsCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now