Oracle8i Java開発者ガイド, リリース8.1

Transcription

1 Oracle8i Java : J

2 Oracle8i Java, 8.1 : J Oracle8i Java Developer s Guide, Release 2 (8.1.6) A Sheryl Maring Steve Harris, Ellen Barnes, Peter Benson, Greg Colvin, Bill Courington, Matthieu Devin, Jim Haungs, Hal Hildebrand, Mark Jungerman, Susan Kraft, Thomas Kurian, Scott Meyer, Tom Portfolio, Dave Rosenberg, Jerry Schwarz, Harlan Sexton, Tim Smith, David Unietis, Brian Wright. Copyright 1996, 1999, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Corporation Restricted Rights Notice Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication, and disclosure of the Programs, including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR , Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA

3 ... vii 1 Oracle8i Java Java Java Java JVM Java Oracle8i Java Oracle Java Java PL/SQL Oracle RDBMS JDBC i

4 SQLJ Java SQL EJB Oracle8i Java Oracle8i Java Java Java API JDK 1.1 Java JDBC Java Java 2 ORB API JNDI Aurora ORB CORBA ORB CORBA EJB Java Java Java javac loadjava ByteCode JVM ii

5 JAR ZIP Java Status JServer Class.forName() Class.forName ClassLoader classfornameandschema lookupclass Class.forName JServer Java Java Java CORBA EJB IIOP Enterprise JavaBeans EJB Remote Method Invocation RMI Java JNI iii

6 SQLJ JDBC JDBC SQLJ JDBC SQLJ SQLJ SQLJ SQLJ SQLJ PL/SQL OracleAgent Java Java DBMS_JAVA JServer Java Enterprise JavaBeans CORBA Java JDK CLASSPATH /SID iv

7 JVM Java Java Java Java Oracle A... A-2... A-2... A-3... A-5... A-5 loadjava... A-8... A-8... A-9... A-11 dropjava... A-16 v

8 ... A A A A-19 vi

9 Oracle8i Java Oracle8i Java 1-20 Oracle8i Java Java Oracle PL/SQL Java PL/SQL Java 1 Oracle8i Java Java Java Java Java Java Sun Microsystems Java Java Java Oracle8i Java Java 2 * Java Oracle8i Java 100% pure Java Oracle8i JServer Java Oracle8i * Java Oracle8i Java 2 Java vii

10 Java API Java Oracle8i Java Java SQL PL/SQL Oracle8i Java JDBC SQLJ SQL Java Java CORBA EJB EJB CORBA 1 Oracle8i Java 3 Java 2 Java Oracle8i Java Java Java Oracle8i Java FAQJDBC SQLJ Java Java Java Sun Microsystems Web Java Java Developer s Kit JDK JDK Oracle8i Java Server JServer Java JLS Java JVM viii

11 comp.lang.java.programmer comp.lang.java.databases Java Java 2 Oracle Java Oracle8i Java ix

12 x

13 1 Oracle8i Java Java Oracle8i Java EJB CORBA Java API 1 Oracle8i Java Java Java Oracle Java Oracle PL/SQL SQL Oracle Java Java 1-2 Java Oracle8i Java 1-11 Oracle8i Java Oracle8i Java SQLJ JDBC Java EJB CORBA 1-16 Oracle Java Oracle8i Java Oracle8i Java 1-20 Oracle8i Java Oracle8i Java 1-1

14 Java Oracle8i Java Oracle Java Oracle8i Java Java Sun Microsystems Java Java Java JVM C C Java Oracle8i Java Java Java Java Java Oracle8i Java 1-2 Oracle8i Java

15 Java 1-1 lastname ID ID 2 Employee 1-1 Employee Employee private String id public String lastname... new Employee() id = lastname = Smith private getid() public setid(string anid)... new Employee() Employee id = lastname = Jones Employee Employee Employee 1 Employee Smith Jones 2 Oracle8i Java 1-3

16 Java Java Employee Java id Employee Employee.getId() ID Employee.getId() Employee.getId() Java Object Java Object B A B B A 1-2 FullTimeEmployee Employee Employee id lastname FullTimeEmployee FullTimeEmployee bonus B A B Employee FullTimeEmployee 1-4 Oracle8i Java

17 Java Employee 1-2 Employee id lastname EmployeeEmployee PartTimeEmployee FullTimeEmployee 2 : Employee PartTimeEmployee schedule FullTimeEmployee bonus PartTimeEmployee FullTimeEmployee FullTimeEmployee "Exempt" FullTimeEmployee "Non Exempt" salarytodate ExemptEmployee salarytodate() NonExemptEmployee salarytodate() B A 1 Java 1 Java Oracle8i Java 1-5

18 Java 1 Employee FullTimeEmployees NonExemptEmployees switch switch:(employee.type){ case: Employee return employee.salarytodate; case: FullTimeEmployee return employee.salarytodate + employee.bonustodate... Employee switch switch Java Employee Employee compensationtodate() NonExemptEmployee compensationtodate() private float compensationtodate() { return super.compensationtodate() + this.overtimetodate(); } FullTimeEmployee private float compensationtodate() { return super.compensationtodate() + this.bonustodate(); } compensationtodate() FullTimeEmployees PartTimeEmployees Employee Contractor compensationtodate() 1-6 Oracle8i Java

19 Java Java JVM compensationtodate() compensationtodate() Java Java 1 C IntelPentium HP Java Java JVM JVM Java 1-3 Java Java JVM Java JVM 1-3 Java Java Java Oracle8i Java 1-7

20 Java Java Java Java java.langjava.io java.net JVM Java Java write once, run anywhere Java 1-4 Oracle Java Java Java JVM Oracle Java JVM Oracle 1-8 Oracle8i Java

21 Java 1-4 JServer Java SQLJ EJB Java SQLJ Aurora ORB JDBC Java Aurora Oracle RDBMS SQL Java Oracle8i Java 1-9

22 Java Sun Microsystems Java JVM Java JLS JVM Sun Microsystems JVM Java Compatibility Kit JCK Oracle JVM JCK Java Java Java Java Java Java Java Java Oracle Server Java Java Java JVM JVM Java Java Java PL/SQL Java SQL Java C ID Java C Java Java Java Java Java Naming and Directory Interface (JNDI) Java 1-10 Oracle8i Java

23 Oracle8i Java Java Oracle Java Java Oracle8i Security Manager Oracle Java JDBC SQLJ Java Oracle Java Oracle8i Java Java Java Java Java C Java Java Java JVM JVM Java 1 Java Java Oracle8i Oracle8i Java Aurora RDBMS Java Oracle8i Java JLS Java JCK Java Oracle8i Java 1-11

24 Oracle8i Java Java Java Java Java Java 1 JVM Java Oracle8i Java 1 Oracle8i JServer Java Java Java Oracle8i JServer Oracle RDBMS JVM 1 JServer 2-40 JServer Java Java C C++ Java JVM 1 Aurora JVM Aurora JVM Oracle8i 1-12 Oracle8i Java

25 Oracle8i Java Oracle8i Aurora JVM Aurora JVM Java Aurora Aurora Aurora Aurora Java Aurora 3 Mark and lazy Sweep 1 Oracle8i Java 1-13

26 Oracle8i Java JServer Java JVM JVM Java C Java JVM Java 2 Just In Time (JIT) JIT Java Java Java C Java C C C Java C Oracle8i Java Aurora/ORB JDBC Oracle JIT Java Oracle8i Java

27 Oracle8i Java Java 1 JVM CLASSPATH Aurora Aurora Aurora Java 1 Aurora Oracle8i Java loadjava CLASSPATH CLASSPATH loadjava A Oracle8i Java 1-15

28 Oracle Java Oracle Java Java 1 Java Oracle Java Java Java Oracle8i Java Java 100% Aurora JVM Oracle8i Java Java PL/SQL Java Java PL/SQL Java PL/SQL PL/SQL Java JDBC SQLJ SQL Object Request Broker Aurora/ORB Enterprise JavaBeans Java API Java SQL Java SQL Java SQL Java JavaAPI Java SQLJ JDBC CORBA EJB 1-16 Oracle8i Java

29 Oracle Java Java PL/SQL Java Java Java Java PL/SQL Java SQL*Plus Net8 OCI PRO* JDBC SQLJ Oracle8i Java Java PL/SQL Java Java PL/SQL PL/SQL Java Oracle8i Java JVM PL/SQL Oracle RDBMS PL/SQL Java Java PL/SQL Java Java Oracle 2 API SQL JDBC SQLJ 2 API JDBC / 2 SQLJ Java SQL SQL JDBC JDBC SQL Java JDBC API 1 JDBC Oracle JServer 3 JDBC JDBC Thin JDBC thin Oracle SQL 100% Java JDBC thin Web Java web Oracle8i Java 1-17

30 Oracle Java JDBC Oracle Call Interface JDBC Oracle Call Interface OCI Oracle Java JDBC thin JDBC Oracle8i Java JServer Java Java JDBC OracleRDBMS Java SQL Oracle 8i Java-SQL JDBC 3-10 SQLJ JDBC Oracle8i JDBC SQLJ Java SQL JDBC Java SQL API JDBC SQL Java IBM Tandem Sybase Sun Microsystems SQL Java SQLJ SQLJ JDBC API ANSI x API JDBC Java JDBC SQLJ Java SQLJ JServer EJB CORBA SQLJ JDBC SQLJ Java SQL JDBC Java Java JServer Java JServer SQLJ Oracle8i SQLJ 3-10 SQLJ JDBC Oracle 8i SQLJ 1-18 Oracle8i Java

31 Oracle Java JServer RDBMS CORBA 2.0 ORB Enterprise JavaBeans EJBCORBA EJB Java OMG CORBA ORB Enterprise Java Beans EJB ORB Object Management Group OMG Internet Inter-ORB Protocol IIOP Oracle8i 100% pure Java EJB JServer EJB 1-2 Java 1 Java JavaBeans JavaBean JDeveloper IDEJavaBeans JavaBean Bean JavaBeans Java Bean Bean Sun Microsystems IBM Enterprise JavaBeans EJB EJB Oracle8i EJB Oracle8i Enterprise JavaBeans CORBA JavaBeans Enterprise JavaBeans Microsoft COM COM+ Microsoft COM JavaBeans EJB Oracle8i Java 1-19

32 Oracle8i Java Java Oracle8i Server Java JServer Java Java JServer JServer Java Java JDeveloper Java Enterprise JavaBeans Oracle8i Java Oracle8i Java Aurora JVM Oracle8i Java Oracle8i Java Java JDBC SQLJ JPublisher Oracle8i Java Java Oracle8i JDBC JDBC JDBC Java Oracle Java SQL JDBC Java SQL SQLJSQL Oracle8i SQLJ Java SQLJ Java SQL JDBC SQLJ JPublisher Oracle Java Oracle8i JPublisher 1-20 Oracle8i Java

33 Oracle8i Java Java EJB CORBA PL/SQL Java Java Java Java PL/SQL Java SQL*Plus Net8 OCI PRO* JDBC SQLJ Oracle8i Java Java PL/SQL Java Java PL/SQL PL/SQL Java Oracle8i Java JVM Oracle8i Java ORB EJB Oracle8i Enterprise Object Request Broker Aurora/ORB JavaBeans CORBA Enterprise JavaBeans EJB Oracle Aurora/ORB EJB Oracle Java Oracle8i Java 1-21

34 Oracle8i Java 1-22 Oracle8i Java

35 2 Oracle8i Java JServer Java Java Java Oracle8i Java Java JDK 1.1 Java 2 Java Java JServer Class.forName() JServer : JServer API Java API JServer API Oracle8i Java 2-1

36 1 Oracle8i JServer 100% pure Java Java Oracle Java Java Java Java API Oracle8i Java JServer Java Oracle8i RDBMS Sun Microsystems JDK Java Oracle8i JServer Aurora Java Oracle8i Oracle8i JVM Java Oracle 1 1 Java SQL Java Java PL/SQL Java CORBA CORBA EJB EJB Java SQL PL/SQL Java java <classname> Java Aurora JVM 2-2 Oracle8i Java

37 Java Java Java Java 2-12 Java Java 2-3 Java Java JServer Class.forName() JServer 3 Java Java Java Java Oracle8i Java JServer Oracle JServer Java 2-1 Java Java Oracle8i Java 2-3

38 Java 2-1 Java } Java JVM Java Java Java 1 Aurora JVM 1 Aurora JVM Java 2-4 Oracle8i Java

39 Java Java Aurora JVM Java 1 1 Java API Oracle8i 1. oracle.aurora.vm.oracleruntime.exitsession() 2. CORBA EJB 3. Java Oracle8i Java CORBA Enterprise JavaBeans EJB 3 API Oracle8i Java 2-5

40 API Java CORBA EJB SQL PL/SQL Java RDBMS Oracle Java SQL CORBA EJB Oracle8i Enterprise JavaBeans CORBA : Oracle8i SQLJ JDBC SQL Java API 3 Java Sun Microsystems JDK main() Java main() java <classname> Java Java main() Java main() Java 2-21 Java 2-27 main() Java Java Java 2-6 Oracle8i Java

41 JDK 1.1 Java 2 java myprogram myprogram main() myprogram main() mymethod Oracle8i myprogram.class mymethod mymethod JDK 1.1 Java 2 Java 2 JDK 1.1 Sun Microsystems Java 2 Sun Microsystems Web Java 2 Oracle8i JDBC 2.0 Java 2 Java 2 ORB API Java 2 JDK 1.1 JDK 1.1 Java 2 Java 2 Java 2 : JDK 1.1 Java 2 PL/SQL API Java 2 Oracle8i Java 2-7

42 JDK 1.1 Java 2 JDBC JDK 1.1 Oracle oracle.jdbc JDBC 2.0 Oracle8i Java 2 JDBC 2.0 java.sql JDBC 2.0 API oracle.jdbc2 JDBC JDBC 2.0 : JDK 1.1 Java oracle.jdbc2 API API Oracle8i Java 2 java.sql JDBC 2.0 JDK classes111.zip oracle.jdbc2 oracle.jdbc JDK 1.1 oracle.jdbc2 JDBC 2.0 API Java classes111.zip oracle.jdbc2 Java 2 java.sql JDBC 2.0 API Java oracle.jdbc2 classes12.zip java.sql Java Java 2 1. oracle.jdbc2 java.sql oracle.jdbc2 Oracle JDK 1.1D JDBC 2.0 Java 2 classes12.zip oracle.jdbc2 2. Connection gettypemap() java.util.dictionary java.util.map Hashtable java.util.map java.util.hashtable 3. Make classes111.zip classes12.zip Oracle8i Java

43 JDK 1.1 Java 2 Java 2 Java 2 ORB API Oracle8i JDBC 4 Java Oracle8i JDK 1.1 sandbox PL/SQL DBMS_JAVA Java 2 doprivileged Java 2 Java 2 Java Oracle8i JServer ORB Visigenic 3.4 JDK 1.1 Java 2 : CORBA Tools Sun Microsystems Java 2 ORB JDK 1.1 Visigenic CORBA Visigenic Java 2 CORBA Sun Microsystem CORBA Oracle8i CORBA 3 Sun Microsystems CORBA JNDI JDK 1.1 Java 2 Aurora ORB Aurora ORB ORB JNDI ORB ORB Aurora ORB CORBA ORB OMG CORBA ORB Aurora ORB CORBA Oracle8i Java 2-9

44 JDK 1.1 Java 2 JNDI JNDI CORBA CORBA Aurora ORB JDK 1.1 Java 2 oracle.aurora.jndi.orb_ dep.orb.init ORB ORB ORB 1 Java 2 ORB init ORB Aurora init 1 ORB init ORB Aurora ORB IIOP oracle.aurora.jndi.orb_dep.orb init init : init org.omg.corba.orb com.visigenic.vbroker.orb.orb public com.visigenic.vbroker.orb.orb init(); public org.omg.corba.orb init(properties props); public org.omg.corba.orb init(string[] args, Properties props); Properties props String[] args ORB ORB 2-10 Oracle8i Java

45 JDK 1.1 Java Aurora ORB init Aurora Orb ORB // Create the client object and publish it to the orb in the client // Substitute Aurora's Orb.init for OMG ORB.init call // old way: org.omg.corba.orb orb = org.omg.corba.orb.init (); com.visigenic.vbroker.orb.orb orb = oracle.aurora.jndi.orb_dep.orb.init(); SSL_CREDENTIALS ORB.init public org.omg.corba.orb init(string un, String pw, String role, boolean ssl, java.util.properties props); String un String pw String role Boolean ssl Properties props TRUE SSL FALSE SSL ORB CORBA ORB CORBA JNDI ORB Java 2 Aurora Visigenic ORB ORB.init ORB 1 ORB.init ORB IIOP Oracle8i Java 2-11

46 Java : Aurora CORBA Visibroker 3.4 org.omg.corba.orbclass org.omg.corba.orbsingletonclass com.visigenic.vbroker.orb.orb com.visigenic.vbroker.orb.orb 2-2 OMG Visigenic OMG CORBAinit Visigenic OMG System.getProperties().put("org.omg.CORBA.ORBClass", "com.visigenic.vbroker.orb.orb"); System.getProperties().put("org.omg.CORBA.ORBSingletonClass", "com.visigenic.vbroker.orb.orb"); java -Dorg.omg.CORBA.ORBClass=com.visigenic.vbroker.orb.ORB -Dorg.omg.CORBA.ORBSingletonClass=com.visigenic.vbroker.orb.ORB CORBA EJB Oracle8i publish JDK 1.1 Java CORBA EJB CORBA IDL Java Sun Microsystems Java Java.java Java.class.properties.ser 2-12 Oracle8i Java

47 Java Java CLASSPATH CLASSPATH Java ZIP JAR 2 JServer Java Java Java JServer Oracle8i Java Java 3 3.java.class.sqlj.properties.ser Java Java CLASSPATH Java Oracle8i JServer Java Aurora JServer Java Java Oracle Java Java Java Java Oracle8i Java 2-13

48 Java Java javac loadjava : loadjava 2-15 javac javac Java Java Java loadjava loadjava -resolve JServer loadjava USER_ERRORS USER_ERRORS Oracle8i -resolve Java JServer JServer loadjava USER_ERRORS USER_ERRORS Oracle8i 2-14 Oracle8i Java

49 Java 2 loadjava loadjava encoding JAVA$OPTIONS online loadjava encoding JAVA$OPTIONS loadjava JAVA$OPTIONS 2-16 JAVA$OPTIONS encoding = latin1 online = trueoracle8i SQLJ SQLJ Java debug = true javac -g loadjava encoding JAVA$OPTIONS javac -encoding online SQLJ TRUE FALSE Oracle8i Java 2-15

50 Java JAVA$OPTIONS JAVA$OPTIONS DBMS_JAVA PROCEDURE set_compiler_option(name VARCHAR2, option VARCHAR2, value VARCHAR2 ; FUNCTION get_compiler_option(name VARCHAR2, option VARCHAR2) RETURNS VARCHAR2; PROCEDURE reset_compiler_option(name VARCHAR2, option VARCHAR2); name option name Java Java JAVA$OPTIONS name name option 'online' 'encoding' 'debug' Oracle8i SQLJ JAVA$OPTIONS JAVA$OPTIONS DBMS_JAVA java.set_compiler_option SQL> execute dbms_java.set_compiler_option('x.y', 'online', 'false'); 2-1 JAVA$OPTIONS encoding online a.b.c.d a.b.c.d online = true 2-16 Oracle8i Java

51 Java a.b a.b a.b a.b.c.d online = false online = true 2-1 JAVA$OPTIONS JAVA$OPTIONS a.b.c.d online true a.b.c.d a.b.c.d.e a.b online false a.b a.b.c.x online true a.c x.y JServer public class A { B b; public void assignb () {b = new B()} } public class B { C c; public void assignc () {c = new C()} } public class C { A a; public void assigna () {a = new A()} } Oracle8i Java 2-17

52 Java A B C A B B C C A A Oracle8i B C Oracle8i Oracle8i loadjava Java Java CLASSPATH ZIP JAR Aurora Java Oracle8i Java Java java.lang.* JVM PUBLIC SCOTT CLASSPATH PUBLIC SCOTT Java CLASSPATH "class not found" : Java loadjava 2-18 Oracle8i Java

53 Java Oracle8i PUBLIC PUBLIC PUBLIC Oracle loadjava -resolve SCOTT OTHER PUBLIC loadjava -resolve -resolver "((* SCOTT)(* OTHER)(* PUBLIC))" -resolver SCOTT OTHER PUBLIC OTHER "my/gui/*" loadjava -resolve -resolver '((* SCOTT) ("my/gui/*" OTHER) (* PUBLIC))' ISV JAR Java Sun Microsystems JVM Oracle8i JAR JAR "-" "my/gui" loadjava -resolve -resolver '((* SCOTT) (* PUBLIC) ("my/gui/*" -))' Oracle8i Java 2-19

54 Java SCOTT PUBLIC loadjava -resolve -resolver "((* SCOTT) (* PUBLIC) (* -))" : "-" "-" ByteCode JVM.class JVM JServer Oracle ORA ORA ORA loadjava.class Java ORA loadjava Java IncompatibleClassChangeError loadjava JServer JLS "-" Java A B A B 2-20 Oracle8i Java

55 Java B A B mymethod(a a) { return a; } A B A B A B "-" mymethod mymethod A B A B A B JAR JAR A loadjava A-7 loadjava Java Aurora Java.java.sqlj.class Java.properties Java.ser SQLJ Java Java Java loadjava Oracle8i Java 2-21

56 Java loadjava.java resolve a. b. c..sqlj resolve a. b. c..ser.class Java resolve 2-22 Oracle8i Java

57 Java.properties Java ser SQLJ ser dropjava loadjava Java loadjava Java dropjava SQL DDL loadjava dropjava : loadjava A-7 loadjava dropjava A-15 2 JVM JAR ZIP USER_OBJECTS 2-26 Java class.java JServer Oracle8i Java 2-23

58 Java y x.java x.class x.java 1 2 x.java y y z.java x.java loadjava z.java z.java y x.java y z.java y x.java y x.java y z.java JVM SQL CREATE PROCEDURE CREATE TABLE CREATE ANY PROCEDURE CREATE ANY TABLE oracle.aurora.security.jserverpermission.loadlibraryinclass.<classname> 5-25 JAR ZIP loadjava.class.java.properties.sqlj.ser.jar.zip JAR ZIP loadjava JAR ZIP loadjava JAR ZIP JAR ZIP JAR ZIP loadjava JAR ZIP : JServer loadjava -force 2-24 Oracle8i Java

59 Java loadjava 2 Java SQL Oracle8i RDBMS loadjava -grant Java SQL SQL PL/SQL PL/SQL SQL Java JMV Java 2-2 A B C A B B C * A B * A C * B C 2-2 C A B? * C A A C Oracle8i Java 2-25

60 Java * B C B B C B loadjava -definer JVM 5 Java USER_OBJECTS Java USER_OBJECTS USER_OBJECT OBJECT_NAME OBJECT_TYPE STATUS JAVA SOURCE JAVA CLASS JAVA RESOURCE VALID INVALIDJAVA RESOURCE VALID USER_OBJECTS OBJECT_NAME DBMS_JAVA LONGNAME() SQL*Plus> SELECT dbms_java.longname(object_name) FROM user_objects WHERE object_type='java SOURCE'; Java DBMS_JAVA SHORTNAME() 2-26 Oracle8i Java

61 Java SQL*Plus> SELECT object_type FROM user_objects WHERE object_name=dbms_java.shortname('known_fullname'); OBJECT_TYPE SVRMGR> select * from javasnm; SHORT LONGNAME /78e6d350_BinaryExceptionHandl sun/tools/java/binaryexceptionhandler /b6c774bb_classdeclaration sun/tools/java/classdeclaration /af5a8ef3_jarverifierstream1 sun/tools/jar/jarverifierstream$1 Status STATUS Java VALID VALID VALID USER_OBJECTS SQL*Plus USER_OBJECTS Java COL object_name format a30 COL object_type format a15 SELECT object_name, object_type, status FROM user_objects WHERE object_type IN ('JAVA SOURCE', 'JAVA CLASS', 'JAVA RESOURCE') ORDER BY object_type, object_name; USER_OBJECTS SELECT object_name, object_type, status FROM user_objects WHERE object_name LIKE '%Alerter'; Alerter OBJECT_NAME USER_OBJECTS Oracle8i Java Oracle8i Java SQL Java Oracle8i Java 2-27

62 Java API Java CORBA EJB SQL DML PL/SQL Oracle8i Java Java Java CORBA EJB Oracle8i CORBA EJB CORBA Java CORBA Java CORBA IOR publish EJB deployejb Oracle8i Enterprise JavaBeans CORBA Oracle8i Java java.awt java.applet java.awt Java java.awt Oracle8i Oracle8i Server Java Oracle oracle.aurora.awt.unsupportedoperation Oracle8i Java 2 Compatibility Kit java.awt java.awt.manual java.applet Oracle RDBMS Windows NT 2-28 Oracle8i Java

63 Java Compatibility Kit Java Java Java Java Compatibility Kit Java Java Oracle8i Server 31 Java SQL Oracle8i SQL Oracle8i DBMS_JAVA Java FUNCTION longname (shortname VARCHAR2) RETURN VARCHAR2 Java select dbms_java.longname (object_name) from user_objects where object_type = 'JAVA CLASS' and status = 'INVALID'; DBMS_JAVA shortname() USER_OBJECTS FUNCTION shortname (longname VARCHAR2) RETURN VARCHAR2 Java Oracle8i Java Oracle8i Java 2-29

64 JServer Class.forName() JServer Class.forName() Java Class.forName() Class ClassNotFoundException ClassLoader JDK JServer JDK 1 ClassLoader CLASSPATH JServer Class.forName() this 2-18 X X Y Y Z X Y Z Y Class Class.forName ClassLoader JServer classfornameandschema ClassForName.lookupClass 2-30 Oracle8i Java

65 JServer Class.forName() : Class.forName() SYS PUBLIC SYS PUBLIC PUBLIC Class.forName ClassLoader JServer ClassLoader Class.forName() ClassLoader Class.forName Class forname (String name, boolean initialize, ClassLoader loader); 2-3 Class.getClassLoader x Class c1 = Class.forName (x.whatclass(), true, x.getclass().getclassloader()); 2-4 oracle.aurora.vm.oracleruntime.getcallerclass Class.getClassLoader workforcaller Class.forName void workforcaller() { ClassLoader c1 = oracle.aurora.vm.oracleruntime.getcallerclass().getclassloader();... Class c = Class.forName (name, true, c1); Oracle8i Java 2-31

66 JServer Class.forName() classfornameandschema classfornameandschema JServer DbmsJava 2-5 save DbmsJava.classForNameAndSchema import oracle.aurora.rdbms.classhandle; import oracle.aurora.rdbms.schema; import oracle.aurora.rdbms.dbmsjava; void save (Class c1) { ClassHandle handle = ClassHandle.lookup(c1); Schema schema = handle.schema(); writenmae (schema.getname()); writename (c1.getname()); } Class restore() { String schemaname = readname(); String classname = readname(); return DbmsJava.classForNameAndSchema (schemaname, classname); } lookupclass 1 oracle.aurora.util.classforname.lookupclass "< >:< >" SCOTT com.package.myclass oracle.aurora.util.classforname.lookupclass("scott:com.package.myclass"); 2-32 Oracle8i Java

67 JServer Class.forName() : / Class.forName JServer / oracle.aurora.rdbms.dbmsobjectoutputstream java.io.objectoutputstream oracle.aurora.rdbms.dbmsobjectinputstream java.io.objectinputstream DbmsObjectOutputStream JServer lookupwithclassloader from Class.forName from lookupwithclassloader ForName ForName from lookupwithclassloader ForName from lookupwithclassloader lookupwithschema classfornameandschema Oracle8i Java 2-33

68 import oracle.aurora.vm.oracleruntime; import oracle.aurora.rdbms.schema; import oracle.aurora.rdbms.dbmsjava; public class ForName { private Class from; /* Supply an explicit class to the constructor */ public ForName(Class from) { this.from = from; } /* Use the class of the code containing the "new ForName()" */ public ForName() { from = OracleRuntime.getCallerClass(); } /* lookup relative to Class supplied to constructor */ public Class lookupwithclassloader(string name) throws ClassNotFoundException { /* A ClassLoader uses the resolver associated with the class*/ return Class.forName(name, true, from.getclassloader()); } /* In case the schema containing the class is known */ static Class lookupwithschema(string name, String schema) { Schema s = Schema.lookup(schema); return DbmsJava.classForNameAndSchema(name, s); } } Java Java JVM Java Java Java Aurora JVM Java Oracle8i Java

69 Aurora Java 1-12 Java 1 Java Aurora JVM Aurora JVM 2-40 JServer Java JVM JVM Java Java Oracle8i Java 2-35

70 1-12 Java Java Java Aurora java.io.fileinputstream java.io.ioexception java.lang.thread.isalive() FALSE MTS ServerSocket ServerSockets 2-39 Java 2 Java Java Java Java Java JVM 2-36 Oracle8i Java

71 ? Java public static void addfile(string[] newfile) { File infile = new File(newFile); FileReader in = new FileReader(inFile); int i; while ((i = in.read())!= -1) out.write(i); /*closing the file, which frees up the operating system file handle*/ in.close(); } in File File : Java JVM 1 JVM 2-7 Java Oracle8i Java 2-37

72 File 2-7 Concat 1 outfile outfile outfile outfile FileDescriptor addfile 2-7 public class Concat { static File outfile = new File("outme.txt"); FileWriter out = new FileWriter(outFile); public static void addfile(string[] newfile) { File infile = new File(newFile); FileReader in = new FileReader(inFile); int i; while ((i = in.read())!= -1) out.write(i); in.close(); } } addfile outme.txt 2 1. File 2. outme.txt File 2-38 Oracle8i Java

73 outme.txt 2-8 public class Concat { public static void addfile(string[] newfile) { /*open the output file each call; make sure the input*/ /*file is written out to the end by making it "append=true"*/ FileWriter out = new FileWriter("outme.txt", TRUE); File infile = new File(newFile); FileReader in = new FileReader(inFile); int i; while ((i = in.read())!= -1) out.write(i); in.close(); /*close the output file between calls*/ out.close(); } } Net8 TTC IIOP 4-6 JServer 1 URL java.net.socket() java.net.serversocket() ServerSocket Socket JVM MTS ServerSocket Socket Socket MTS Oracle8i Java 2-39

74 JServer ServerSocket ServerSocket 1 MTS ServerSocket MTS 1 MTS ServerSocket I/O JServer Aurora JVM JVM 1 Java JVM Thread.yield() mysocket.read() JServer Java JVM JVM Oracle Java Aurora JVM Java Oracle Server JVM JVM JServer Java Oracle 2-40 Oracle8i Java

75 JServer Java 6MB 8MB Oracle Server 40KB Java 1 Aurora JVM JVM Aurora JVM Aurora * Aurora Aurora oracle.aurora.vm.deadlockerror * 1 oracle.aurora.vm.limboerror Java 3. System.exit() oracle.aurora.vm.oracleruntime.exitcall() oracle.aurora.vm.oracleruntime.exitsession() Java System.exit() oracle.aurora.vm.oracleruntime.exitcall() oracle.aurora.vm.oracleruntime.exitsession() Oracle8i Java 2-41

76 JServer Aurora ThreadDeathException ThreadDeathException System.exit() oracle.aurora.vm.oracleruntime.exitcall() oracle.aurora.vm.oracleruntime.exitsession() Aurora ThreadDeathExceptions Java Java JDBC SQLJ SQL Java Java System.exit() Java 2-42 Oracle8i Java

77 3 Java 2 Oracle8i Java Oracle8i Java Java Java SQLJ JDBC Java 3-1

78 Oracle8i Java Java Java Java CORBA EJB SQLJ JDBC JDBC SQLJ Java Oracle8i Java Java Java CORBA EJB Java Oracle8i Java Java Java 2. Java SQL Java Oracle8i Java API JDBC SQLJ 2 SQLJ JDBC SQLJ 2 3. Java N Oracle8i CORBA EJB CORBA EJB EJB CORBA Oracle8i Java JDBC Java JDBC SQLJ Java SQL JDBC SQLJ SQL Java SQL Java SQL Java JDBC SQLJ SQL Java SQL JDBC SQLJ Java SQL Java 3-2 Oracle8i Java

79 Java Java CORBA Enterprise JavaBeans Java Java Java Java Java API Java CORBA EJB Remote Method Invocation RMI Java JNI SQLJ JDBC Java Java PL/SQL Java DML Java Java "Hello world" Java 1. Java Hello Hello.world() "Hello world" public class Hello { public static String world () { return "Hello world"; } } 2. Sun Microsystems JDK Java javac javac Hello.java CLASSPATH javac Make Java 3-3

80 Java Java Java Hello.class Java Hello.class CLASSPATH CLASSPATH.jar.zip CLASSPATH 3. Hello.class Java Hello.class world() String PUBLIC PUBLIC java.lang loadjava loadjava 2-18 A-7 loadjava 4. loadjava Oracle8i loadjava -user scott/tiger Hello.class 5. SQL Java SQL SQL SQL*Plus Hello.world() connect scott/tiger create or replace function HELLOWORLD return VARCHAR2 as language java name 'Hello.world () return java.lang.string'; 6. variable mystring varchar2(20); call HELLOWORLD() into :mystring; print mystring; 3-4 Oracle8i Java

81 Java call HELLOWORLD() into :mystring Oracle8i Oracle select HELLOWORLD from DUAL SQL PL/SQL Java PL/SQL SQL PL/SQL JDeveloper Java Java Oracle8i Java CORBA EJB SQL Oracle8i Oracle8i 3 Java 3-5

82 Java 2 Web / Web 2 CORBA EJB API CORBA Interface Definition Language IDL Oracle8i Java Jserver ORB JServer Oracle8i MTS ORB Enterprise JavaBeans * Java * EJB deployejb IDL Java Java 3 CORBA EJB Jserver Enterprise JavaBeans 1.0 CORBA IIOP Net8 CORBA EJB IIOP CORBA EJB / 1 IIOP CORBA EJB 3-6 Oracle8i Java

83 Java Oracle8i 2 Java Naming and Directory Interface JNDI JNDI CORBA CosNaming CORBA CosNaming Java ORB ORB JServer CORBA CosNaming CORBA CosNaming JNDI URL URL JServer JNDI CORBA CosNaming Oracle8i CORBA Inter-ORB References IOR Enterprise JavaBeans CORBA EJB Oracle8i Enterprise JavaBeans CORBA EJB Oracle RDBMS EmployeeBean 1. EJB EJBHome Java JNDI 2. EJB EJBObject Java Bean 3. Bean EmployeeBean getemployee() SessionBean Bean 4. Bean deployejb Java 3-7

84 Java 5. EJB EJB deployejb EJB Java Bean EJB EJB N EJB 1. Java JNDI 2. EJB CORBA Oracle 3. Bean JNDI create() 1 EJB 4. Bean Bean IIOP EJB java.io.serializable Oracle8i Enterprise JavaBeans CORBA Java IDE Oracle JDeveloper Java CORBA Java UNIX CORBA Oracle8i Enterprise JavaBeans CORBA CORBA 3-8 Oracle8i Java

85 Java mkdir ls rm UNIX java Java java main(string[]) Java System.out System.err Remote Method Invocation RMI JServer Java Remote Method Invocation RMI RMI java.net JServer RMI CORBA EJB API Sun Microsystems RMI JServer Sun Microsystems RMI RMI JServer 1 RMI Java Oracle8i ORB EJB RMI CORBA EJB : Net8 IIOP 4-6 JServer Java JNI Java JNI Java Java JNI Java Oracle JServer JNI JNI 100% pure Java Java 3-9

86 Java SQLJ JDBC 2 Java / SQL JDBC SQLJ SQL JDBC SQL SQLJ 1 JDBC JDBC Sun Microsystems API SQL Java JDBC X/Open SQL Call Level Interface SQL92 Entry Level Sun Microsystems java.sql JDBC Oracle 3 JDBC 1. JDBC Thin 100% pure Java Oracle 2. JDBC OCI OCI 8 OCI 7 Oracle 3. Oracle8i Server JDBC JDBC SQL statment SQL SQL JDBC SQL SQLJ SQLJ 1 SQL Java JDBC Oracle SQLJ ANSI X3H SQLJ SQLJ SQLJ.sqlj SQLJ Java SQL SQLJ Oracle SQLJ Java Java 3-10 Oracle8i Java

87 Java JDBC SQLJ Oracle SQLJ SQLJ JDBC SQLJ SQL JDBC Java SQL SQL SQLJ SQL SQL JDBC SQLJ JDBC: // (Presume you already have a JDBC Connection object conn) // Define Java variables String name; int id=37115; float salary=20000; // Set up JDBC prepared statement. PreparedStatement pstmt = conn.preparestatement ( select ename from emp where empno=? and sal>? ); pstmt.setint(1, id); pstmt.setfloat(2, salary); // Execute query; retrieve name and assign it to Java variable. ResultSet rs = pstmt.executequery(); while (rs.next()) { name=rs.getstring(1); System.out.println("Name is: " + name); } // Close result set and statement objects. rs.close() pstmt.close(); 1. Java name id salary 2. SQL preparestatement() SQL SQL SQL SQL Java Java 3-11

88 Java pstmt.setint() pstmt.setfloat() "?" int id "?" float salary JDBC 4. 1 SQLJ SQLJ #sql SQLJ: String name; int id=37115; float salary=20000; #sql {select ename into :name from emp where empno=:id and sal>:salary); System.out.println("Name is: " + name); SQLJ SQL Java Java SQL ":" Java name id salary SQLJ Oracle8i Java

89 Java SQLJ SQLJ import java.sql.*; import sqlj.runtime.ref.defaultcontext; import oracle.sqlj.runtime.oracle; #sql iterator MyIter (String ename, int empno, float sal); public class MyExample { public static void main (String args[]) throws SQLException { Oracle.connect ("jdbc:oracle:thin:@oow11:5521:sol2", "scott", "tiger"); #sql { insert into emp (ename, empno, sal) values ('SALMAN', 32, 20000) }; MyIter iter; } } #sql iter={ select ename, empno, sal from emp }; while (iter.next()) { System.out.println (iter.ename()+" "+iter.empno()+" "+iter.sal()); } 1. SQLJ JDBC JDBC #sql iterator MyIter (String ename, int empno, float sal); SQLJ MyIter MyIter Java String 2 Java int 3 Java float 3 ename empno sal MyIter Oracle8i SQLJ 3 2. Oracle.connect("jdbc:oracle:thin:@oow11:5521:sol2","scott", "tiger"); Java 3-13

90 Java Oracle SQLJ Oracle connect() 3 a. SQLJ Oracle JDBC b. URL oow SIDso12 thin JDBC scott tiger c. SQLJ JDBC SQLJ 3. SQL a. emp #sql {insert into emp (ename, empno, sal) values ('SALMAN', 32, 20000)}; b. MyIter iter; #sql iter={select ename, empno, sal from emp}; 4. while (iter.next()){ System.out.println(iter.ename()+" "+iter.empno()+" "+iter.sal()); } next() JDBC next() true ename() empno() sal() SQLJ SQLJ SQL SQLJ SQL 3-14 Oracle8i Java

91 Java SQLJ Oracle JDeveloper IDE Java Windows SQLJ IDE SQLJ sqlj %sqlj MyExample.sqlj SQLJ SQL user URL %sqlj MyExample.sqlj SQLJ SQLJ SQLJ SQL SQLJ SQLJ SQLJ 1 JDBC SQLJ System.out SQLJ 2 SQLJ Java.jar SQLJ Java 3-15

92 Oracle loadjava Oracle8i SQLJ SQLJ 1..jar 2. loadjava.jar 3. SQL MyExample create or replace procedure SQLJ_MYEXAMPLE as language java name 'MyExample.main(java.lang.String[])'; SQLJ_MYEXAMPLE PL/SQL Oracle JDBC Oracle SQL PL/SQL SQLJ PL/SQL SQLJ PL/SQL Oracle SQLJ PL/SQL SQL PL/SQL SQLJ JServer Oracle JDeveloper JDK jdb IDE Jserver : 5-24 Aurora JVM sun.tools.debug.agent Java 3-16 Oracle8i Java

93 JServer Oracle : JDeveloper JServer JDeveloper Java Sun Microsystems jdb JVM Java JServer Java jdb Sun Microsystems JDK Java Oracle8i Java DebugProxy Java DebugProxy sun.tools.debug.agent Oracle8i 3 jdb 1 DebugProxy 2 DebugAgent jdb Java 3-17

94 1. DebugProxy DebugProxy DebugAgent 2. DebugAgent DebugAgent DebugAgent DebugAgent DebugAgent DebugProxy 3. DebugAgent DebugProxy DebugProxy jdb jdb Java jdb 1. aurora_client.jar $ORACLE_HOME/lib DebugProxy Oracle8i Server Aurora JVM aurora_ client.jar CLASSPATH DebugProxy debugproxy debugproxy -port 2286 Proxy Name: yourmachinename Proxy Address: aaa.bbb.ccc.ddd Proxy Port: 2286 Aurora DebugProxy Windows NT jdb debugproxy -port 2286 start jdb -password 3-18 Oracle8i Java

95 2. : JAVADEBUGPRIV 5-24 SQL*Plus IP URL DBMS_JAVA SQL> call dbms_java.start_debugging('yourmachinename', 2286, 66); : Aurora stop_debugging SQL> call dbms_java.stop_debugging(); restart_debugging SQL> call dbms_java.restart_debugging(66); OracleAgent DBMS_JAVA oracle.aurora.debug.oracleagent oracle.aurora.debug.oracleagent Java 3-19

96 public static void start(string host, int port, long timeout_seconds); public static void stop(); public static void restart(long timeout_seconds); 3. Agent Number: 1 Agent Name: servername Agent Address: eee.fff.jjj.kkk Agent Port: 2286 Agent Password: 3i65bn jdb JDK jdb -password 3i65bn start_debugging System.out System.err jdb dbgtrace jdb -dbgtrace -password 3i65bn Java Java JDBC SQLJ System.getProperty System.getProperty ("oracle.jserver.version") 3-20 Oracle8i Java

97 getproperty Oracle8i "8.1.5" "8.1.6" NULL System.out System.err SQL*Plus SQL> SET SERVEROUTPUT ON SQL> CALL dbms_java.set_output(2000); 2,000 1,000,000 5,000 SQL> SET SERVEROUTPUT ON SIZE 5000 SQL> CALL dbms_java.set_output(5000); SQL*Plus Oracle8i SQL*Plus Java 3-21

98 3-22 Oracle8i Java

99 4 Java Oracle8i JServer Java 5 Java Java JServer Java Java 4-1

100 Java Java Oracle8i JServer Java Java JDBC SQLJ CORBA/EJB Oracle JServer JServer 3 Oracle8i Oracle8i JServer Oracle8i Oracle8i JServer initjvm.sql JServer Oracle8i JServer ORACLE_HOME/javavm/install initjvm.sql JServer initjvm.sql Java Java Java CORBA initjvm.sql Java Java Java Java SQLJ JDBC CORBA ORB EJB 4-3 DBMS_JAVA DBMS_JAVA initjvm.sql 1. SYS CORBA 4-2 Oracle8i Java

101 Java 4. : initjvm.sql 1 Java 50MB SHARED_POOL_SIZE 20MB JAVA_ POOL_SIZE 30MB initjvm.sql 5-26 Java /javavm/readme.txt EJB CORBA Oracle8i JServer Oracle8i Enterprise JavaBeans CORBA Oracle8i Net8 DBMS_JAVA Jserver initjvm.sql PL/SQL DBMS_ JAVA DBMS_JAVA Java DbmsJava Java RDBMS DBMS_JAVA FUNCTION longname (shortname VARCHAR2) RETURN VARCHAR2 Java Java SQL SQL Aurora Java select dbms_java.longname (object_name) from user_objects where object_type = 'JAVA CLASS' and status = 'INVALID'; FUNCTION shortname (longname VARCHAR2 RETURN VARCHAR2 DBMS_JAVA shortname() USER_ OBJECTS Java 4-3

102 Java 2-29 Oracle8i Java FUNCTION get_compiler_option (what VARCHAR2, optionname VARCHAR2) PROCEDURE set_compiler_option (what VARCHAR2, optionname VARCHAR2, value VARCHAR2) PROCEDURE reset_compiler_option (what VARCHAR2, optionname VARCHAR2) 3 Oracle8i JServer Java SQLJ 2-14 Java Oracle8i Java Oracle8i SQLJ PROCEDURE set_output (buffersize NUMBER) Java DBMS_OUTPUT 3-21 PROCEDURE loadjava (options varchar2) PROCEDURE loadjava (options varchar2, resolver varchar2) PROCEDURE dropjava (options varchar2) loadjava dropjava Java call dbms_java.loadjava ('... options...'); call dbms_java.dropjava ('... options...'); loadjava dropjava loadjava -resolver -resolver -resolver loadjava -thin -oci8 -user -password stderr A-7 loadjava 4-4 Oracle8i Java

103 Java PROCEDURE grant_permission ( grantee varchar2, permission_type varchar2, permission_name varchar2, permission_action varchar2 ) PROCEDURE restrict_permission ( grantee varchar2, permission_type varchar2, permission_name varchar2, permission_action varchar2) PROCEDURE grant_policy_permission ( grantee varchar2, permission_schema varchar2, permission_type varchar2, permission_name varchar2) PROCEDURE revoke_permission (permission_schema varchar2, permission_type varchar2, permission_name varchar2, permission_action varchar2) PROCEDURE disable_permission (key number) PROCEDURE enable_permission (key number) PROCEDURE delete_permission (key number) JVM 5-5 PROCEDURE start_debugging (host varchar2, port number, timeout number) PROCEDURE stop_debugging PROCEDURE restart_debugging (timeout number) 3-16 Java 4-5

104 JServer JServer Oracle8i JServer Oracle8i Database Configuration Assistant Net8Assistant JServer initjvm.sql Oracle8i Java Java Java 20MB JAVA_POOL_SIZE 50MB SHARED_POOL_SIZE Oracle JServer SQL initjvm.sql 5-26 Java MTS Aurora JVM 2 Net8 GIOP GIOP EJB CORBA IIOP Net8 GIOP Net8 IIOP CORBA EJB SSL IIOP Oracle8i Enterprise JavaBeans CORBA Oracle Tools SQL*Plus Forms Pro*C OCI SQL Net8 Oracle8i Net Oracle8i Java

105 JServer Java Java API Java Enterprise JavaBeans EJB CORBA Java EJB CORBA Java MTS Java EJB CORBA MTS MTS Oracle8i Net8 EJB CORBA Java 1 2 MTS EJB CORBA Java Java Java PL/SQL Net8 Net8 Oracle8i Net8 EJB CORBA CORBA Internet Inter-Orb Protocol IIOPIIOP Oracle8i Enterprise JavaBeans CORBA Net8 IIOP Java MTS Oracle8i Java MTS Oracle8i Net8 9 MTS_ DISPATCHERS MTS Java Java SQL PL/SQL Net8 Net8 Oracle8i Net8 Java 4-7

106 Java Enterprise JavaBeans CORBA EJB CORBA Internet Inter-Orb Protocol IIOP IIOP TCP/IP GIOP IIOP General Inter-Orb Protocol GIOP MTS Oracle8i SSL GIOP GIOP GIOP MTS Oracle8i Net8 GIOP Oracle8i Enterprise JavaBeans CORBA Java Java 1. JDK 2. CLASSPATH 3. /SID JDK loadjava deployejb JServer JDK Solaris 2.6 JDK PATH JDK JDK JDK $ which java /usr/local/packages/jdk1.1.6/bin/java $ which javac /usr/local/packages/jdk1.1.6/bin/javac $ java -version java version "1.1.6" JDK PATH JDK CLASSPATH JDK 4-8 Oracle8i Java

107 Java : Oracle8i Java Java 2 2. CLASSPATH 3. /SID CORBA EJB RMI Java JAR ZIP CLASSPATH JAR ZIP Java JAR ZIP Oracle8i Enterprise JavaBeans CORBA Make JAR ZIP SID SID orcl Oracle8i SID UNIX Windows NT $ make SERVICE=sess_iiop://localhost:myportnum:mysid ORACLE_SERVICE sess_iiop://localhost:myportnum:mysid 4. $ORACLE_HOME/javavm/demo/demo.tar Windows NT demo.zip Oracle8i $ORACLE_HOME/javavm/demo/examples/jsp/helloworld $ORACLE_HOME/javavm/demo/examples/corba/basic/helloworld $ORACLE_HOME/javavm/demo/examples/ejb/basic/helloworld Java 4-9

108 Java : Make NT Visual Cafe JDeveloper VisualAge 4-10 Oracle8i Java

109 5 Java 5-1

110 JVM JAR Java Oracle8i Java JVM 2 Net8 JDBC EJB CORBA Net8 JDBC Net8 1 Net8 / Oracle8i Net8 Kerberos secureid Advanced Networking Option Oracle8i Advanced Security SSL Oracle8i Advanced Security JDBC Net8 Net8 Oracle8i JDBC EJB CORBA Oracle8i Enterprise JavaBeans CORBA 5-2 Oracle8i Java

111 JVM Java 2 PL/SQL Aurora JVM 2 Java 2 PL/SQL Oracle8i JVM JServer Java 2 Java 2 JVM Java 2 JAVA_ADMIN JVM JAVA_ADMIN loadjava / grant A-7 loadjava Java Java 2 Java 2 JVM 5-3

112 Java 2 Java Java JAVAUSERPRIV JAVASYSPRIV JVM : Oracle 2 JServer Java 2 Java Java 2 Java 2 CLASSPATH Oracle8i Java2 Sun Microsystems Java 2 Oracle8i Sun Microsystems Java 2 Li Gong Inside Java 2 Platform Security Scott Oaks Java Security Java2 CLASSPATH Java java -usepolicy SecurityManager Launcher Oracle8i Java PolicyTable SecurityManager Aurora SecurityManager Aurora SecurityManager SecurityManager oracle.aurora.rdbms.securitymanagerimpl 5-4 Oracle8i Java

113 Java2 SecurityManager SecurityManager Oracle8i Aurora SecurityManager URL JServer CodeSource URL equals TRUE CodeSource CodeSource implies TRUE PolicyTable PolicyTable DBMS_JAVA PolicyTable JAVA_ADMIN JAVA_ADMIN PolicyTable CodeSource equals TRUE implies TRUE Java 2 Oracle8i Oracle8i DBMS_JAVA Java 2 5-5

114 USER_JAVA_POLICY DBA_JAVA_POLICY 2 DBA_JAVA_POLICY USER_JAVA_POLICY Kind GRANT RESTRICT GRANT RESTRICT Grantee Permission schema Permission type java.io.filepermission. Permission name Permission action PolicyTablePermission 5-11 NULL Status Key ACTIVE INACTIVE ACTIVE INACTIVE Oracle8i Java

115 Oracle8i JAVAUSERPRIV JAVASYSPRIV : Grantee Permission type FilePermission java.lang.security.permission SYS <schema> myschema:mypackage.mypermission Permissionname Permission action Permission FilePermission Key 5-7

116 Java 2 Java java.util.propertypermission java.io.serializablepermission java.io.filepermission java.net.netpermission java.net.socketpermission java.lang.runtimepermission java.lang.reflect.reflectpermission java.security.securitypermission oracle.aurora.rdbms.security.policytablepermission oracle.aurora.security.jserverpermission DBMS_JAVA procedure grant_permission( grantee varchar2, permission_type varchar2, permission_name varchar2, permission_action varchar2 ) procedure grant_permission( grantee varchar2, permission_type varchar2, permission_name varchar2, permission_action varchar2, key OUT number) Java long oracle.aurora.rdbms.security.policytablemanager.grant( java.lang.string grantee, java.lang.string permission_type, java.lang.string permission_name, java.lang.string permission_action); void oracle.aurora.rdbms.security.policytablemanager.grant( java.lang.string grantee, java.lang.string permission_type, java.lang.string permission_name, java.lang.string permission_action, long[] key); 5-8 Oracle8i Java

117 : DBMS_JAVA Java OUT PL/SQL DBMS_JAVA key OUT 5-17 DBMS_JAVA procedure restrict_permission( grantee varchar2, permission_type varchar2, permission_name varchar2, permission_action varchar2) procedure restrict_permission( grantee varchar2, permission_type varchar2, permission_name varchar2, permission_action varchar2, key OUT number) Java long oracle.aurora.rdbms.security.policytablemanager.restrict( java.lang.string grantee, java.lang.string permission_type, java.lang.string permission_name, java.lang.string permission_action); void oracle.aurora.rdbms.security.policytablemanager.restrict( java.lang.string grantee, java.lang.string permission_type, java.lang.string permission_name, java.lang.string permission_action, long[] key); 5-1 DBMS_JAVA grant_ permission PolicyTable Larry PolicyTable SQL Larry Dave / connect larry/larry REM Grant DAVE permission to read and write the Test1 file. call dbms_java.grant_permission('dave', 'java.io.filepermission', '/test/test1', 'read,write'); 5-9

118 REM commit the changes to the PolicyTable commit; 5-2 /tmp password /tmp / password / password 1 JServer password 1. /tmp / 2. /tmp 1 password / 3. password / Larry connect larry/larry REM Grant permission to all users (PUBLIC) to be able to read and write REM all files in /tmp. call dbms_java.grant_permission('public', 'java.io.filepermission', '/tmp/*', 'read,write'); REM Restrict permission to all users (PUBLIC) from reading or writing the REM password file in /tmp. call dbms_java.restrict_permission('public', 'java.io.filepermission', '/tmp/password', 'read,write'); REM By providing a more specific rule that overrides the restriction, REM Larry can read and write /tmp/password. call dbms_java.grant_permission('larry', 'java.io.filepermission', 5-10 Oracle8i Java

119 commit; '/tmp/password', 'read,write'); JServer JAVA_ADMIN JAVA_ADMIN DBA JAVA_ADMIN JAVA_ADMIN JAVA_ADMIN PolicyTablePermission FilePermission PolicyTablePermission DBMS_JAVA DBMS_JAVA procedure grant_policy_permission( grantee varchar2, permission_schema varchar2, permission_type varchar2, permission_name varchar2) procedure grant_policy_permission( grantee varchar2, permission_schema varchar2, permission_type varchar2, permission_name varchar2, key OUT number) 5-11

120 Java long oracle.aurora.rdbms.security.policytablemanager.grantpolicypermission( java.lang.string grantee, java.lang.string permission_type, java.lang.string permission_name); void oracle.aurora.rdbms.security.policytablemanager.grantpolicypermission( java.lang.string grantee, java.lang.string permission_type, java.lang.string permission_name, long[] key); Grantee Permission schema <schema> Permission type FilePermission java.lang.security.permission Permission name Permission Row number : PolicyTablePermission '#' java.io.filepermission#read '#' 5-12 Oracle8i Java

121 5-3 PolicyTable JAVA_ADMIN SYS Larry FilePermission PolicyTable Larry REM Connect as SYS, which is assigned JAVA_ADMIN role, to give Larry permission REM to modify the PolicyTable connect SYS/SYS REM SYS grants Larry the right to administer permissions for REM FilePermission call dbms_java.grant_policy_permission('larry', 'SYS', 'java.io.filepermission', '*'); Permission Java 2 Permission MyPermission MyPermission BasicPermission BasicPermission Permission package test.larry; import java.security.permission; import java.security.basicpermission; public class MyPermission extends BasicPermission { public MyPermission(String name) { super(name); } public boolean implies(permission p) { boolean result = super.implies(p); return result; } } 5-13

122 2. PolicyTable LARRY MyPermission grant_policy_permission LARRY MyPermission PolicyTable REM Since Larry is the user that creates MyPermission, Larry connects to REW the database to assign permissions for MyPermission. connect larry/larry REM As the owner of MyPermission, Larry grants himself the right to REM administer permissions for test.larry.mypermission within the JVM REM security PolicyTable. Only the owner of the user-defined permission REM can grant administrative rights. call dbms_java.grant_policy_permission('larry', 'LARRY', 'test.larry.mypermission', '*'); REM commit the changes to the PolicyTable commit; SQL MyPermission LARRY DAVE "act" REM Since Larry is the user that creates MyPermission, Larry connects to REW the database to assign permissions for MyPermission. connect larry/larry REM Once able to modify the PolicyTable for MyPermission, Larry grants himself REM full permission for MyPermission. Notice that the Permission is prepended REM with its owner schema. call dbms_java.grant_permission( 'LARRY', 'LARRY:test.larry.MyPermission', '*', null); REM Larry grants Dave permission to do any actions that start with 'act.*'. call dbms_java.grant_permission ('DAVE', 'LARRY:test.larry.MyPermission', 'act.*', null); REM commit the changes to the PolicyTable commit; 3. MyPermission 5-14 Oracle8i Java

123 SecurityManager sensitive act print hello 4 2 SQL LARRY DAVE act print hello print print hello AccessController.doPrivileged LARRY package test.larry; import java.security.accesscontroller; import java.security.permission; import java.security.privilegedaction; import java.sql.connection; import java.sql.sqlexception; /** * MyActions is a class with a variety of public methods that * have some security risks associated with them. We will rely * on the Java security mechanisms to ensure that they are * performed only by code that is authorized to do so. */ public class Larry { private static String secret = "Larry's secret"; MyPermission sensitivepermission = new MyPermission("sensitive"); /** * This is a security sensitive operation. That is it can * compromise our security if it is executed by a "bad guy". * Only larry has permission to execute sensitive. */ public void sensitive() { checkpermission(sensitivepermission); print(); } /** * Will print a message from Larry. We need to be 5-15

124 * careful about who is allowed to do this * because messages from Larry may have extra impact. * Both larry and dave have permission to execute act. */ public void act(string message) { MyPermission p = new MyPermission("act." + message); checkpermission(p); System.out.println("Larry says: " + message); } /** * Print our secret key * No permission check is made; anyone can execute print. */ private void print() { System.out.println(secret); } /** * Print "Hello" * This method invokes doprivileged, which makes the method run * under definer's rights. So, this method runs under Larry's * rights, so anyone can execute hello. * Only Larry can execute hello */ public void hello() { AccessController.doPrivileged(new PrivilegedAction() { public Object run() { act("hello"); return null; } }); } /** * If a security manager is installed ask it to check permission * otherwise use the AccessController directly */ void checkpermission(permission permission) { SecurityManager sm = System.getSecurityManager(); sm.checkpermission(permission); } } 5-16 Oracle8i Java

125 disable_permission revoke revoke_permission grant resrict disable_permission 1 disable_permission * grant restrict grant restrict * DBA_JAVA_POLICY DBMS_JAVA procedure revoke_permission(permission_schema varchar2, permission_type varchar2, permission_name varchar2, permission_action varchar2) procedure disable_permission(key number) Java void revoke(string schema, String type, String name, String action); void oracle.aurora.rdbms.security.policytablemanager.disable(long number); DBMS_JAVA procedure enable_permission(key number) Java void oracle.aurora.rdbms.security.policytablemanager.enable(long number); 5-17