A new version of the Article Button plugin for Joomla 2.5 can be found here.

IT-Blog

Oracle Java File permissions

Last weekend used some Java Procedures in the database to read and parse files. When granting the permissions (done by the dbms_java package)

EXEC DBMS_JAVA.GRANT_PERMISSION( 'testdeveloper', 'SYS:java.io.FilePermission','/mnt/myhome/tesfiles/', 'read' );

I got this error:

ORA-29532: Java call terminated by uncaught Java exception:
oracle.aurora.vm.IdNotFoundException: -1 is not the number of a user or role
ORA-06512: at "SYS.DBMS_JAVA", line 313
ORA-06512: at line 1

Solution for this: just write the schema name in uppercase!Smile

EXEC DBMS_JAVA.GRANT_PERMISSION('TESTDEVELOPER','SYS:java.io.FilePermission','/mnt/myhome/tesfiles/', 'read' )

 

    Veröffentlichen Sie ihre Kommentare ...


    Warning: Creating default object from empty value in /www/htdocs/w0101274/www/fairtec.at/modules/mod_udjacomments/helper.php on line 387