I believe that I answered it in my earlier response. Danny's connection url
indicated that he was using IBM DB2 Universal Database. He can move the
actual database to another machine and install the IBM DB2 Client
Application Enabler software on his web server machine. The CAE includes the
same jdbc drivers that the database itself includes. He can configure the
remote database in the CAE. The CAE includes the same "applet listener"
software that the database does. (This runs on NT as service called "DB2
JDBC Applet Server".)
The picture can look like the following:
Applet HTTP GET/POST
V V
-------fire-wall---------------------------------------
Applet listener Servlets
\ /
CAE
-------fire-wall---------------------------------------
V
database server
The internal firewall rules have to allow connection to your database server
from the CAE.
You can use the type 2 database driver from the servlets on the web server
machine via a url like jdbc:db2:databasename where database name is the
database alias in the CAE.
Applets can still use the jdbc:db2://serverName:port/databaseName.
John Zerbe - Mellon Bank
IM&R - Middleware Team
Phone: 412-234-1048 E-Mail:[EMAIL PROTECTED]
> -----Original Message-----
> From: Gupta, Lokesh [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, November 09, 1999 9:12 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Database and Web Server on seperate Box
>
> I was following the threads spun off the original email form Danny.
> However,
> none of the replies seem to answer the question, "Why there was an error
> and
> what should be the solution?". If you put the web-server and the db-server
> behind the firewall but on different boxes, then will the error still be
> there - I believe yes. Then, what are the possible solutions?
>
> -----Original Message-----
> From: Danny Rubis [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 07, 1999 8:36 AM
> To: [EMAIL PROTECTED]
> Subject: Database and Web Server on seperate Box
>
>
> Hey!
>
> I have two questions about the above Subject, one concerning
> servlets (on-topic) and one concerning applets (off-topic).
>
> Architecture presently:
>
> Database, web server and servlet engine is on one Intel/NT box.
> All servlet access to the database is with direct connections like:
>
> "jdbc:db2://serverName:port/databaseName",
>
> where serverName
> is the same for the webserver and the database connection.
>
> Architecture proposed:
>
> But, when I try to move the database to a different box, say
>
> "jdbc:db2://serverName_on_a_different_box:port/databaseName",
>
> I will get a Security violation warning that I am trying to access
> another
> machine. Will someone help with some ideas.
>
> Applets have the same problem and maybe even a more difficult one to
> solve. All of the applets access the database same as above.
> Because the applet is loaded into the web browser, I think I
> am at the mercy of the web browser security. What to do?
>
> Is there a solution that will work for both servlets and applets?
>
> Is seems only natural that this is the next progression from getting
> servlets running on one box with small amounts of data residing in
> a DB to the day when the DB data gets to be too big. In
> that case, It doesn't make good sense to have the DB and web stuff
> on the same box, IMO. I think servlets are in a new phase now.
> They have proven to be a viable solution to the delivering the
> Business model.
>
> If any one knows how to do this, I think it has to be someone on this
> E-list. :>)
>
> Thank you.
>
> Danny Rubis
>
> __________________________________________________________________________
> _
> 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
>
> __________________________________________________________________________
> _
> 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
___________________________________________________________________________
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
