[cobalt-developers] tomcat.policy.custom & permission for external hosts

["Paul Rosenthal" <paul.rosenthal@xxxxxxxxxxxxxxxxx>]

We are porting a working servlet/jsp application from JRun on NT4 to Tomcat
on a Raq4.

This application needs to connect to an Oracle database on another server.
This database is up and running perfectly fine and is contactable.

We have copied over the classes12.zip file which contains the JDBC drivers
we have successfully been using so far.  We have renamed them classes12.jar
and put them in /usr/java/jakarta-tomcat/lib which we believe to be the
right place for them, and believe that they are being picked up and
detected.

On the Tomcat platform, when we try to run the application, it ends with the
error, perhaps not surprisingly:

Null pointer exception (no database
connection)java.security.AccessControlException: access denied
(java.net.SocketPermission IP address:1521 connect,resolve)

[1521 is the Oracle port]

I gather we have to modify the tomact.policy file, and on a Raq4, this is
done by creating a tomcat.policy.custom file.

My question is, what is the exact code I need to enter into this file to
allow Tomcat to "see out" to the remote server, to allow our application to
connect to the database?

Either for a specific site on the Raq4, or for all sites?

I have tried a few things by looking at other examples, but all to no avail.

Any help from either anyone who has actually connected to an Oracle
database, or anyone who just knows how to connect to a remote database on
another machine, would be greatly appreciated.

Regards

Paul Rosenthal