Hi all,
I'm designing a Servlet based data-access utility. The architecture of the
setup is diagrammatically shown in the attached file. There are about 10 different
sites at which data is stored, in MS-access mdb files.
The Servlet will validate the users against these databases. Further
transactions will also use the same database. Each site is connected to the Web server
using dial-up connection. There are two m/c at each site, a RAS m/c and a winNT m/c on
which the mdb file exists.
The Servlet takes queries from users and creates an instance of a TCP/IP
client (for each user). This sends the request data to the corresponding TCP/IP server
over socket. The server (multithreaded) then passes on this request to the Database
access module, which accesses/updates data from the mdb file thru JDBC-ODBC bridge.
The client socket accepts data/error msg from the server socket and returns it to the
Servlet. Servlet then sends the result to the user's browser. A normal transaction for
a user involved 4-5 of such cycles. (i.e.: session tracking has to be done) . The
platform is WinNT for all the machines.
I would like to know the following things :
1) Is the architecture correct ?
2) Will there be performance degradation ? (Traffic = max 10,000 users on the
Servlet and a max 1000 on each Site)
3) How do I implement connection pooling at each site ? (Particularly, how do i
maintain the number of connections, to be just enough for the request traffic?). Can
someone gimme code snippet for this please?
4) Is there a limit to the number of connections that the Access database file
can handle at one time ?
5) Is it feasible to drop the client/server modules and directly access the mdb
files from the Servlet ? (thru ODBC configured on the Web server) If it is, how secure
and crash-proof is the ODBC connection over dial-up ?
6) I plan to use Applet-servlet communication. Can anyone please gimme a few
pointers on this ? and maybe some code snippet to start on.....
7) I tried to configure Netscape Enterprise Server v3.6 SP2 (on WinNT SP5) but it
fails to start the Web Server and Admin Server services. It gives Windows Internal
Error when i try to manually start the service. Can anybody help me out here ?
8) Since Session tracking API are not supported by this web server, how do I
perform session tracking ? Can I use the applet for sending state info to the server ?
How to implement it ?
The list is long and many questions are off-topic. But being inexperianced i felt i
should ask my doubts to all the Gurus out there........PLEASE help me out
guys........i would be thankful for ANY help on ANY part of the above.....
Lots of thanks in advance,
Sanjay Karanjkar
Systems Engineer
Tata Infotech Ltd.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
