From: claudioaferraz at gmail.com (claudio ferraz)
Date: Mon, 19 Mar 2007 12:20:44 -0300
Subject: [Pljava-dev] Exception in read/write text files
In-Reply-To: <449f4cf70703181856y459678cdoed68f12a1aecd970@mail.gmail.com>
References: <d522589d0703181307t6fe295afn98c85209bfb67cf1@mail.gmail.com>
	<449f4cf70703181856y459678cdoed68f12a1aecd970@mail.gmail.com>
Message-ID: <d522589d0703190820u6ed1b285laddfd7de9ec9850a@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>