Solved

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

Posted on 2004-08-02
8
180 Views
Last Modified: 2013-11-24
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
Comment
Question by:Barry62
  • 3
  • 3
  • 2
8 Comments
 
LVL 86

Expert Comment

by:CEHJ
ID: 11693374
Yes. Use JDBC, but you'd be better off with a superior db - MySQL or PostGresql
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 11693382
0
 
LVL 8

Author Comment

by:Barry62
ID: 11695335
OK, I'll try it.  

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

Barry62
0
 
LVL 92

Expert Comment

by:objects
ID: 11699967
> 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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 8

Author Comment

by:Barry62
ID: 11703204
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
 
LVL 92

Accepted Solution

by:
objects earned 250 total points
ID: 11711043
you'll need to move your access database to the same server, or use a different database.
0
 
LVL 8

Author Comment

by:Barry62
ID: 11725891
Thanks.   was afraid I would have to do that, but hoping there was another solution.

Oh, well.  

0
 
LVL 92

Expert Comment

by:objects
ID: 11731480
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
triangle challenge 4 79
json example 39 116
Eclipse Neon and jdk 1.8.0 11 72
solarwind tftp server 2 32
I had a project requirement for a displaying a user workbench .This workbench would consist multiple data grids .In each grid the user will be able to see a large number of data. These data grids should allow the user to 1. Sort 2. Export the …
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now