If you are using oracle9, i would rather use the sun box rather than linux, since both cost the same. ( JUST FOR ORACLE )
-----Original Message----- From: Paterson, Trevor [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 2:01 PM To: 'Tomcat Users List'; 'Tim Funk' Subject: RE: PERMISSIONS FOR JDBC ORACLE APPLICATION 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
