agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] Exception in read/write text files
Date: Mon, 19 Mar 2007 12:20:44 -0300
Message-ID: <d522589d0703190820u6ed1b285laddfd7de9ec9850a@mail.gmail.com> (raw)
In-Reply-To: <449f4cf70703181856y459678cdoed68f12a1aecd970@mail.gmail.com>
References: <d522589d0703181307t6fe295afn98c85209bfb67cf1@mail.gmail.com>
<449f4cf70703181856y459678cdoed68f12a1aecd970@mail.gmail.com>
Hi Mark,
Im using trusted java, see this:
CREATE OR REPLACE FUNCTION execute_service(int4, "varchar", int4)
RETURNS int4 AS
'axml.Active.executeService'
LANGUAGE 'java' VOLATILE;
I try access http://wiki.tada.se/wiki/ , but this link does not work.
Have one another ideia?
Thanks a lot , sorry my poor english.
Cl?udio
2007/3/18, Mark Mitchell <mark81 at gmail.com>:
>
> I believe you have to use the untrusted java (javaU) -- I can't access
> the pljava wiki at tada[1] for some reason at the moment, but I
> believe there are instructions there for how to add a function that
> uses the untrsted java language extension rather than a normal trusted
> one (untrusted allows access to the filesystem).
>
> -Mark
>
> [1] http://wiki.tada.se/wiki/
>
> On 3/18/07, claudio ferraz <claudioaferraz at gmail.com> wrote:
> > Hello friends,
> >
> > Im trying read/write a text file using PL/Java. However, I am receiving
> the
> > following error:
> > The directory is C:\ statistics.txt. Somebody can help me?
> > Thanks a lot.
> >
> >
> > ERROR: 18 Mar 07 16:51:59 axml.Active java.lang.SecurityException: read
> on
> > C:\statistics.txt
> > java.lang.SecurityException: read on C:\statistics.txt
> > at
> > org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java
> :187)
> > at
> >
> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck
> (Backend.java:128)
> > at
> >
> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission
> (Backend.java:106)
> > at java.lang.SecurityManager.checkRead (Unknown Source)
> > at java.io.File.exists(Unknown Source)
> > at java.io.Win32FileSystem.canonicalize(Unknown Source)
> > at java.io.File.getCanonicalPath(Unknown Source)
> > at java.io.FilePermission$1.run(Unknown Source)
> > at java.security.AccessController.doPrivileged(Native
> > Method)
> > at java.io.FilePermission.init(Unknown Source)
> > at java.io.FilePermission.<init>(Unknown Source)
> > at java.lang.SecurityManager.checkRead (Unknown Source)
> > at java.io.File.exists(Unknown Source)
> > at java.io.Win32FileSystem.canonicalize(Unknown Source)
> > at java.io.File.getCanonicalPath(Unknown Source)
> > at java.io.FilePermission$1.run(Unknown Source)
> > at java.security.AccessController.doPrivileged(Native
> > Method)
> > at java.io.FilePermission.init(Unknown Source)
> > at java.io.FilePermission.<init>(Unknown Source)
> > at java.lang.SecurityManager.checkWrite (Unknown
> > Source)
> > at java.io.FileOutputStream.<init>(Unknown Source)
> > at java.io.FileOutputStream.<init>(Unknown Source)
> > at java.io.FileWriter.<init>(Unknown Source)
> > at testes.StatisticsCollector.save (StatisticsCollector.java:102)
> > at axml.Active.executeService(Active.java:20)
> >
> >
> >
> > --
> > Cl?udio A. Ferraz - Analista de Sistemas
> > Mestrando em Banco de Dados COPPE/UFRJ
> > "Se n?o puder fazer tudo, fa?a tudo o que puder."
> > _______________________________________________
> > Pljava-dev mailing list
> > Pljava-dev at gborg.postgresql.org
> > http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >
> >
>
--
Cl?udio A. Ferraz - Analista de Sistemas
Mestrando em Banco de Dados COPPE/UFRJ
"Se n?o puder fazer tudo, fa?a tudo o que puder."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20070319/7ec29e15/attachment.html;
view thread (3+ messages)
Message-ID: <d522589d0703190820u6ed1b285laddfd7de9ec9850a@mail.gmail.com>
Permalink: ../d522589d0703190820u6ed1b285laddfd7de9ec9850a@mail.gmail.com/
Also on: postgresql.org/message-id/d522589d0703190820u6ed1b285laddfd7de9ec9850a@mail.gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Exception in read/write text files
In-Reply-To: <d522589d0703190820u6ed1b285laddfd7de9ec9850a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox