Re: java in the database (10gR2 & 11gR2)

From: Jeremy <jeremy0505_at_gmail.com>
Date: Sat, 5 Feb 2011 15:25:02 -0000
Message-ID: <MPG.27b77c2b9099584e9898a5_at_News.Individual.NET>

In article <3497fa16-854d-40b2-becb-
a1cca3cf445b_at_j11g2000yqh.googlegroups.com>, bdbafh_at_gmail.com says...
> Jeremy,
>
> > Are there any
> > difference between 10g and 11g in this respect (as we will need to make
> > this work in both versions)?
>
> Part of upgrading a database to 11g (11.2.0.2 at this point) is to
> create access control lists for the UTL packages, i.e. UTL_SMTP using
> the package DBMS_NETWORK_ACL_ADMIN.
> http://www.oracle-base.com/articles/11g/FineGrainedAccessToNetworkServices_11gR1.php
>
> This would not likely have affected 10g R2, but possibly it was
> backported into the 10.2.0.5 patchset?
> You might want to list more detailed version info.
>

Thanks for that - DB in which we are evaluating "jc" is running 11.2.0.1.0 on Windows Server 2003.

We are able to access e.g. utl_smtp and utl_http from within PL/SQL no problems there.

Question really at this stage is whether there are any explicit access rights that need to be granted in order for java code to be able to access these kinds of network functions.

-- 
jeremy

Received on Sat Feb 05 2011 - 09:25:02 CST