deployment.sql

来自「orcale9i-java-programming外文书籍源码,结合orcale」· SQL 代码 · 共 70 行

connect sys;

drop user bug_reports cascade;
create user bug_reports identified by bug_reports;
grant connect, resource to bug_reports;
grant create public synonym to bug_reports;
grant drop public synonym to bug_reports;

call dbms_java.grant_permission (
 'BUG_REPORTS',
'java.io.FilePermission',
'C:\temp\*',
 'read,write,delete'
 );

call dbms_java.grant_permission (
 'BUG_REPORTS',
 'java.io.SerializablePermission',
 '*',
 'null'
);

loadjava -user bug_reports/bug_reports@database -resolve -grant PUBLIC -synonym BugReport.java
loadjava -user bug_reports/bug_reports@database -resolve -grant PUBLIC -synonym BugReportPermission.java
loadjava -user bug_reports/bug_reports@database -resolve -grant PUBLIC -synonym BugReportManager.java
loadjava -user bug_reports/bug_reports@database -resolve -grant PUBLIC -synonym BugReportTest.java

connect bug_reports/bug_reports;

call dbms_java.grant_policy_permission (
   'BUG_REPORTS',
   'BUG_REPORTS',
   'wrox.bugreports.BugReportPermission',
   '*'
);

CALL DBMS_JAVA.GRANT_PERMISSION (
   'BUG_REPORTS',
   'BUG_REPORTS:wrox.bugreports.BugReportPermission',
   '*',
   'read,write,delete'
);

CALL DBMS_JAVA.GRANT_PERMISSION (
   'JOHN',
   'BUG_REPORTS:wrox.bugreports.BugReportPermission',
   'A',
   'read,write,delete'
);

CALL DBMS_JAVA.GRANT_PERMISSION (
   'PAUL',
   'BUG_REPORTS:wrox.bugreports.BugReportPermission',
   'B',
   'read'
);

create or replace function write_report return varchar2
as language java
name 'wrox.bugreports.BugReportTest.testWrite() return java.lang.String';
/

set serveroutput on;
call dbms_output.put_line(write_report);

OR:

call dbms_output.put_line(substr(write_report,1,1));

where 's' means success and 'E' means error.