tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paterson, Trevor" <T.Pater...@napier.ac.uk>
Subject RE: PERMISSIONS FOR JDBC ORACLE APPLICATION
Date Wed, 16 Jul 2003 18:00:52 GMT


interesting to know about oracle port openings - our oracle9 is on a redhat
linux machine

however giving my application permission to talk to any port on that machine
( or indeed any IP address...) doesnt solve the problem.

is it an issue with the driver?

thanks
trevor


-----Original Message-----
From: Tim Funk []
Sent: 16 July 2003 18:16
To: Tomcat Users List
Subject: Re: PERMISSIONS FOR JDBC ORACLE APPLICATION


Check to make sure you have Oracle configured to only use one port. Here is 
the thread that talked about that:
http://marc.theaimsgroup.com/?l=tomcat-user&m=105517372716920&w=2

Otherwise- you'll need to adjust your permissions accordingly.

-Tim

Paterson, Trevor wrote:
> Hi
>  
> I am trying to start using the SecurityManager/catalina.policy for a
> servelt/jsp application that accesses an Oracle Database for read/write.
>  
> Everything works fine when I set: permission java.security.AllPermission
for
> the entire application.
>  
> but if I try and limit permissions,  any  table varchar2 data I get back
> from queries via ResultSet.getObject().toString() seems to be
(?URL)encoded
> - Dates and ints are OK.
>  
> I can't work out which file or driver doesn't have appropriate conditions
-
> can anyone help?
>  
> I have tried:
>     permission java.net.SocketPermission "xxx.xxx.xxx.xxx:xxxx",
"connect"; 
>     permission java.util.PropertyPermission "oracle.jserver.version",
> "read";
>     permission java.util.PropertyPermission
> "oracle.jdbc.driver.OracleDriver", "read";
>     permission java.util.PropertyPermission "/WEB-INF/lib/ojdbc.jar",
> "read";
>     permission java.util.PropertyPermission "java.net.*", "read";
>     permission java.util.PropertyPermission "java.sql.*", "read"; 
>  
> currently running jdk 1.4 and Tomcat 4.1.12 and Oracle 9i
> 
> Ta Trevor 
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message