calling java from Oracle 8i stored prcedure security problem

[John Harkin]

I'm logged in as system/manager when i run the above in sql plus.

When i run the stored proecdure i get
ORA-29532: Java call terminated by uncaught Java exception: java.lang.SecurityException


I only get this when the java code attempts to do something like write to
a file or connect to a URL.
If it does nothing then everthing is fine.

What do i have to do to get it working correctly ?



Java Source :

import java.io.*;

class AreasDML
{
public static void
insertrow ( String JobId)
{
try
{



FileWriter fw = new FileWriter("c:\\temp\\jh.tmp");
fw.write("Hello John");
fw.close();

catch ( IOException e)
{
System.out.println("Error:" + e );
}
}
}

[igordein]

Do you set permission for the file c:\\temp\\jh.tmp
in the oracle configuration file?

"John Harkin" <john.harkin@singularity.co.uk> wrote:
>
>I'm logged in as system/manager when i run the above in sql plus.
>
>When i run the stored proecdure i get
>ORA-29532: Java call terminated by uncaught Java exception: java.lang.SecurityException
>
>
>I only get this when the java code attempts to do something like write to
>a file or connect to a URL.
>If it does nothing then everthing is fine.
>
>What do i have to do to get it working correctly ?
>
>
>
>Java Source :
>
>import java.io.*;
>
>class AreasDML
>{
>public static void
>insertrow ( String JobId)
>{
> try
> {
>
>
>
> FileWriter fw = new FileWriter("c:\\temp\\jh.tmp");
> fw.write("Hello John");
> fw.close();
>
> catch ( IOException e)
> {
> System.out.println("Error:" + e );
> }
>}
>}