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

Transcription

1 Oracle8i Java J

2 Oracle8i Java, 8.1 J Java Developer s Guide, Release 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, 2000, 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 i

4 PL/SQL Oracle RDBMS JDBC SQLJ Java SQL Java HTML JavaServer Pages EJB Oracle8i Java Oracle8i Java Java Java API JDK 1.1 Java JDBC JDBC JDBC Java Java 2 ORB API JNDI Aurora ORB CORBA ORB CORBA EJB Java Java Java javac loadjava ii

5 ByteCode JVM JAR ZIP Java Status Oracle8i JVM Class.forName() Class.forName ClassLoader classfornameandschema lookupclass Class.forName Oracle8i JVM Java Java Java iii

6 CORBA EJB IIOP Enterprise JavaBeans EJB Remote Method Invocation RMI Java JNI SQLJ JDBC JDBC SQLJ JDBC SQLJ SQLJ SQLJ SQLJ SQLJ PL/SQL OracleAgent Java Java DBMS_JAVA Oracle8i JVM Java Enterprise JavaBeans CORBA iv

7 Java JDK CLASSPATH JAR JDK 1.1 JAR Java 2 JAR SQLJ JAR JSP JAR /SID Oracle8i Java JVM Java Oracle8i Java Oracle8i JVM Accelerator Oracle8i JVM Java Java Oracle8i JVM Accelerator v

8 Java Java Java Oracle MemStat MemStat MemStat MemStat vi

9 vii

10 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 JVM Java Oracle8i * Java Oracle8i Java 2 Java Java API Java Oracle8i Java Java SQL PL/SQL Oracle8i Java JDBC SQLJ SQL Java Java CORBA EJB EJB CORBA viii

11 1 Oracle8i Java 3 Java 2 Java Oracle8i Java Java Java comp.lang.java.programmer comp.lang.java.databases Oracle8i Java FAQJDBC SQLJ Java Java Java Sun Microsystems Web Java Java Developer's Kit JDK JDK Oracle8i JVM Java JLS Java JVM 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-15 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 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 Employee 1-4 Oracle8i Java

17 Java 1-2 B A 1 Java 1 Java 1 Oracle8i Java 1-5

18 Java 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() compensationtodate() compensationtodate() 1-6 Oracle8i Java

19 Java Java JVM Java Java 1 C Intel Pentium HP Java Java JVM JVM Java 1-3 Java Java JVM Java JVM 1-3 Java Java Java Java java.langjava.io java.net JVM Java Java write once, run anywhere Java Oracle8i Java 1-7

20 Java 1-4 Oracle Java Java Java JVM Oracle Java JVM Oracle 1-8 Oracle8i Java

21 Java 1-4 Oracle8i JVM 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 JVM Java Java Java Oracle8i JVM Oracle RDBMS JVM 1 Oracle8i JVM 2-41 Oracle8i JVM 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 JVM Oracle8i Java 1-13

26 Oracle8i Java 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 6-2 Java 1 JVM CLASSPATH 1-14 Oracle8i Java

27 Oracle Java Aurora Aurora Aurora Java 1 Aurora Oracle8i Java loadjava CLASSPATH CLASSPATH loadjava Oracle8i Java Tools 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 JavaServer Pages HMTL Oracle8i Java 1-15

28 Oracle Java Java API Java SQL Java SQL Java SQL HTML Java Java Java API Java SQLJ JDBC JavaServer Pages CORBA EJB 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 1-16 Oracle8i Java

29 Oracle Java JDBC JDBC SQL Java JDBC API 1 JDBC Oracle8i JVM 3 JDBC JDBC Thin JDBC thin Oracle SQL 100% Java JDBC thin Web Java web JDBC Oracle Call Interface JDBC Oracle Call Interface OCI Oracle Java JDBC Thin JDBC Oracle8i Java Oracle8i JVM Java Java JDBC Oracle RDBMS 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 Oracle8i Java 1-17

30 Oracle Java SQLJ Java SQLJ Oracle8i JVM EJB CORBA SQLJ JDBC SQLJ Java SQL JDBC Java Java Oracle8i JVM Java Oracle8i JVM SQLJ Oracle8i SQLJ 3-10 SQLJ JDBC SQLJ Java HTML Java JavaServer Pages HTML Web HTML Java Java HTML Oracle8i Oracle Servlet Engine JavaServer Pages JavaServer Pages Web Web Web HTML XML Java Java JavaServer Pages JavaBeans Enterprise JavaBeans EJB HTML JSP JSP JavaBean Enterprise JavaBean Bean JDBC SQLJ JSP Java Java HTTP JSP JSP 1-18 Oracle8i Java

31 Oracle Java JSP JSP Oracle8i JavaServer Pages Oracle8i JVM RDBMS CORBA 2.0 ORB Enterprise JavaBeans EJB CORBA EJB Java OMG CORBA ORB Enterprise JavaBeans EJB ORB Object Management Group OMG Internet Inter-ORB Protocol IIOP Oracle8i 100%pure Java EJB Oracle8i JVM 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 Oracle8i CORBA JavaBeans Enterprise JavaBeans Microsoft COM COM+ Microsoft COM Oracle8i Java 1-19

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

33 Oracle8i 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 Oracle8i Java JavaServer Pages EJB CORBA Web Java HTML Oracle8i Oracle Servlet Engine Oracle8i JavaServer Pages ORB EJB Oracle8i Enterprise Object Request Broker Aurora/ORB JavaBeans Enterprise JavaBeans EJB Oracle Aurora/ORB EJB Oracle Java Oracle8i CORBA Oracle8i Java 1-21

34 Oracle8i Java 1-22 Oracle8i Java

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

36 1 Oracle8i JVM 100% pure Java Java Oracle Java Java Java Java API Oracle8i Java Oracle8i JVM Java Oracle8i RDBMS Sun Microsystems JDK Java Oracle8i Oracle8i JVM 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-13 Java Java 2-3 Java Java Oracle8i JVM Class.forName() Oracle8i JVM 3 Java Java Java Java Oracle8i Java Oracle8i JVM Oracle Oracle8i JVM 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 Oracle8i 1. oracle.aurora.mts.session.session.this_ SESSION().endSession() 2. CORBA EJB 3. Java Java API Oracle8i Java JavaServer Pages CORBA Enterprise JavaBeans EJB 5 API Oracle8i Java 2-5

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

41 JDK 1.1 Java 2 main() Java Java Java 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 JDK 1.1 Java 2 Java 2 Oracle8i Java 2-7

42 JDK 1.1 Java 2 : JDK 1.1 Java 2 PL/SQL API 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 : Java oracle.jdbc2 JDBC API Oracle8i Java 2 java.sql JDBC 2.0 JDK JDBC 2.0 Oracle8i Java 2 JDK 1.1 java.sql oracle.jdbc2 java.sql oracle.jdbc2 classes 111.zip oracle.jdbc2 API java.sql 2-8 Oracle8i Java

43 JDK 1.1 Java 2 JDBC 2.0 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 4. oracle.jdbc2 oracle.jdbc2 #import java.sql.*;... jd = (java.sql.connection) getdc(); getdc oracle.jdbc2 java.sql.* ORA-29521: oracle/jdbc2/<classname> classes12.zip java.sql.* Oracle8i JDBC 4 JDBC JDK 1.1 oracle.jdbc2 JDBC 2.0 API Java classes111.zip oracle.jdbc2 Oracle8i Java 2-9

44 JDK 1.1 Java 2 Java 2 Java 2 ORB API Java 2 java.sql JDBC 2.0 API Java oracle.jdbc2 classes12.zip java.sql Java Oracle8i JDK 1.1 sandbox PL/SQL DBMS_JAVA Java 2 doprivileged Java 2 Java Java 2 JDK 1.2 Java Java 2 Oracle8i JVM ORB Visigenic 3.4 JDK 1.1 Java 2 : CORBA Sun Microsystems Java 2 ORB JDK 1.1 Visigenic CORBA Visigenic Java 2 CORBA Sun Microsystems 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 2-10 Oracle8i Java

45 JDK 1.1 Java 2 Aurora ORB CORBA 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 Oracle8i Java 2-11

46 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 2-12 Oracle8i Java

47 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 CORBA init 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 Oracle8i Java 2-13

48 Java Java CLASSPATH CLASSPATH Java ZIP JAR 2 Oracle8i JVM Java Java Java Oracle8i JVM Oracle8i Java Java 3 3.java.class.sqlj.properties.ser Java Java CLASSPATH 1 Java Oracle8i JVM Java Aurora Oracle8i JVM Java Java Oracle Java Java Java Java Java 2-14 Oracle8i Java

49 Java javac Java loadjava : loadjava 2-16 javac javac Java Java Java loadjava loadjava -resolve java 4. Oracle8i JVM loadjava USER_ERRORS USER_ERRORS Oracle8i -resolve Java Oracle8i JVM Oracle8i JVM loadjava USER_ERRORS USER_ERRORS Oracle8i Oracle8i Java 2-15

50 Java 2 loadjava encoding loadjava JAVA$OPTIONS loadjava JAVA$OPTIONS 2-16 JAVA$OPTIONS encoding = latin1 online = true Oracle8i SQLJ SQLJ Java debug = true javac -g loadjava encoding.java JAVA$OPTIONS javac -encoding JAVA$OPTIONS JAVA$OPTIONS DBMS_JAVA 2-16 Oracle8i Java

51 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 a.b a.b a.b a.b.c.d online = false online = true Oracle8i Java 2-17

52 Java 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 Oracle8i JVM 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()} } A B C A B B C C A A Oracle8i B C 2-18 Oracle8i Java

53 Java 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 Oracle8i Java 2-19

54 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/*" -))' 2-20 Oracle8i Java

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

56 Java B mymethod(a a) { return a; } A B A B A B "-" mymethod mymethod A B A B A B JAR JAR Oracle8i Java Tools loadjava SQL loadjava loadjava Oracle8i Java Tools Java Aurora Java.java.sqlj Java.class Java Java.properties Java.ser SQLJ Java loadjava 2-22 Oracle8i Java

57 Java loadjava.java resolve a. b. c..sqlj 1..class Java resolve a. b. c..ser resolve Oracle8i Java 2-23

58 Java.properties Java ser SQLJ ser dropjava loadjava Java loadjava Java dropjava SQL DDL loadjava dropjava SQL dropjava : loadjava loadjava dropjava Oracle8i Java Tools 2 JVM JAR ZIP USER_OBJECTS 2-27 Java class.java Oracle8i JVM 2-24 Oracle8i Java

59 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.oracle8i JVMPermission.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 Oracle8i Java 2-25

60 Java : Oracle8i JVM loadjava -force loadjava 2 Java SQL Oracle8i RDBMS loadjava -grant Java SQL SQL PL/SQL PL/SQL SQL Java JVM Java 2-2 A B C A B B C * A B * A C * B C 2-2 C A B? 2-26 Oracle8i Java

61 Java * C A A C * B C B B C B loadjava-definer JVM 6 Oracle8i Java 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'; Oracle8i Java 2-27

62 Java Java DBMS_JAVA SHORTNAME() 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 2-28 Oracle8i Java

63 Oracle8i Java SQL Java Java API Java JavaServer Pages CORBA EJB SQL DML PL/SQL Oracle8i Java Java Java JNDI JavaServer Pages URL CORBA EJB Oracle8i CORBA EJB CORBA Java CORBA Java CORBA IOR publish EJB deployejb Oracle8i Oracle Servlet Engine Oracle8i JavaServer Pages Oracle8i Enterprise JavaBeans Oracle8i CORBA Oracle8i Java java.awt java.applet java.awt Java Oracle8i Java 2-29

64 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 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 2-30 Oracle8i Java

65 Oracle8i JVM Class.forName() 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 JVM Class.forName() Java Class.forName() Class ClassNotFoundException ClassLoader JDK Oracle8i JVM JDK 1 ClassLoader CLASSPATH Oracle8i JVM Class.forName() this 2-19 X X Y Y Z X Y Z Y Class Class.forName ClassLoader Oracle8i JVM classfornameandschema Oracle8i Java 2-31

66 Oracle8i JVM Class.forName() ClassForName.lookupClass : Class.forName() SYS PUBLIC SYS PUBLIC PUBLIC Class.forName ClassLoader Oracle8i JVM 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); 2-32 Oracle8i Java

67 Oracle8i JVM Class.forName() classfornameandschema classfornameandschema Oracle8i JVM 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 "<schema>:<class>" SCOTT com.package.myclass oracle.aurora.util.classforname.lookupclass("scott:com.package.myclass"); Oracle8i Java 2-33

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

69 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 1 Oracle8i Java 2-35

70 Aurora Java 1-12 Java 1 Java Aurora JVM Aurora JVM 2-41 Oracle8i JVM Java JVM JVM Java Java 2 Java 2-36 Oracle8i Java

71 1-12 Java Java Java Aurora java.io.fileinputstream java.io.ioexception java.lang.thread.isalive() FALSE MTS ServerSocket ServerSockets 2-40 Java 2 Java Java Java Java Java JVM Oracle8i Java 2-37

72 ? 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 2-38 Oracle8i Java

73 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 Oracle8i Java 2-39

74 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-5 Oracle8i JVM 1 URL java.net.socket() java.net.serversocket() ServerSocket Socket JVM MTS ServerSocket 2-40 Oracle8i Java

75 Oracle8i JVM Socket ServerSocket Socket MTS ServerSocket 1 MTS ServerSocket MTS 1 MTS ServerSocket I/O Oracle8i JVM Aurora JVM JVM 1 Java JVM Thread.yield() mysocket.read() Oracle8i JVM Java JVM JVM Oracle Java Aurora JVM Java Oracle8i Java 2-41

76 Oracle8i JVM Oracle Server JVM JVM Oracle8i JVM Java Oracle 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.mts.session.session.this_session().endsession() Java Oracle8i Java

77 Oracle8i JVM 2. System.exit() oracle.aurora.vm.oracleruntime.exitcall() oracle.aurora.mts.session.session.this_session().endsession() Aurora ThreadDeathException ThreadDeathException System.exit() oracle.aurora.vm.oracleruntime.exitcall() oracle.aurora.vm.oracleruntime.exitsession() Aurora ThreadDeathException Java Java JDBC SQLJ SQL Java Java System.exit() Java Oracle8i Java 2-43

78 Oracle8i JVM 2-44 Oracle8i Java

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

80 Oracle8i Java Java Java Java JavaServer Pages CORBA EJB : JavaServer Pages Oracle8i JavaServer Pages Oracle8i Oracle Servlet Engine 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 3-2 Oracle8i Java

81 Java Java SQL JDBC SQLJ Java SQL 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 Java 3-3

82 Java public class Hello { public static String world () { return "Hello world"; } } 2. Sun Microsystems JDK Java javac javac Hello.java CLASSPATH javac Make 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-19 Oracle8i Java Tools 4. loadjava Oracle8i loadjava -user scott/tiger Hello.class 3-4 Oracle8i Java

83 Java 5. SQL Java SQL SQL SQL*Plus Hello.world() SQL> connect scott/tiger connected SQL> create or replace function HELLOWORLD return VARCHAR2 as 2 language java name 'Hello.world () return java.lang.string'; 3 / Function created. 6. SQL> variable mystring varchar2[20]; SQL> call HELLOWORLD() into :mystring; Call completed. SQL> print mystring; MYSTRING Hello world SQL> call HELLOWORLD() into :mystring Oracle8i Oracle select HELLOWORLD from DUAL SQL PL/SQL Java PL/SQL SQL PL/SQL JDeveloper Java Java Oracle8i Java Java 3-5

84 Java CORBA EJB SQL Oracle8i Oracle8i 3 2 Web / Web 2 CORBA EJB API CORBA Interface Definition Language IDL Oracle8i Java Oracle8i JVM 3-6 Oracle8i Java

85 Java ORB Oracle8i JVM Oracle8i MTS ORB Enterprise JavaBeans * Java * RMI EJB deployejb IDL Java Java 3 CORBA EJB Oracle8i JVM Enterprise JavaBeans 1,1 CORBA IIOP Net8 CORBA EJB IIOP CORBA EJB / 1 IIOP CORBA EJB Oracle8i 2 Java Naming and Directory Interface JNDI JNDI CORBA CosNaming CORBA CosNaming Java ORB ORB Oracle8i Java 3-7

86 Java JVM CORBA CosNaming CORBA CosNaming JNDI URL URL Oracle8i JVM JNDI CORBA CosNaming Oracle8i CORBA Inter-ORB References IOR Enterprise JavaBeans CORBA EJB Oracle8i Enterprise JavaBeans Oracle8i CORBA EJB Oracle RDBMS EmployeeBean 1. EJB EJBHome Java JNDI 2. EJB EJBObject Java Bean 3. Bean EmployeeBean getemployee() SessionBean Bean 4. Bean deployejb 5. EJB EJB deployejb EJB Java Bean 3-8 Oracle8i Java

87 Java 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 Oracle8i CORBA Java IDE Oracle JDeveloper Java CORBA Java UNIX CORBA Oracle8i Enterprise JavaBeans Oracle8i CORBA CORBA mkdir ls rm UNIX java Java java main(string[]) Java System.out System.err Java 3-9

88 Java Remote Method Invocation RMI Oracle8i JVM Java Remote Method Invocation RMI RMI java.net Oracle8i JVM RMI CORBA EJB API Sun Microsystems RMI Oracle8i JVM Sun Microsystems RMI RMI Oracle8i JVM 1 RMI Java Oracle8i ORB EJB RMI CORBA EJB : Net8 IIOP 4-5 Oracle8i JVM Java JNI Java JNI Java Java JNI Java Oracle Oracle8i JVM JNI JNI 100% pure Java SQLJ JDBC 2 Java / SQL JDBC SQLJ SQL JDBC SQL SQLJ Oracle8i Java

89 Java 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 statement 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 Oracle SQLJ SQLJ JDBC SQLJ SQL JDBC Java SQL SQL SQLJ SQL SQL Java 3-11

90 Java JDBC SQLJ 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 pstmt.setint() pstmt.setfloat()? int id 37115? float salary JDBC 4. 1 SQLJ SQLJ #sql 3-12 Oracle8i Java

91 Java 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 1 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 Java 3-13

92 Java #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"); Oracle SQLJ Oracle connect() 3 a. SQLJ Oracle JDBC b. URL oow SID so12 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 3-14 Oracle8i Java

93 Java ename() empno() sal() SQLJ SQLJ SQL SQLJ SQL 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 Java 3-15

94 Java JDBC SQLJ System.out SQLJ 2 SQLJ Java.jar SQLJ 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 3-16 Oracle8i Java

95 Oracle8i JVM JDK jdb Oracle JDeveloper Oracle8i JVM JDeveloper Java JDeveloper IDE Oracle8i JVM Sun Microsystems jdb -g Oracle8i JVM Java Oracle8i jdb Oracle8i JVM Java Oracle8i Java Oracle8i jdb 3-1 jdb 3-1 jdb job 2. DebugProxy Oracle8i 3. DebugAgent 3-1 Java DebugProxy DebugProxy DebugAgent Java 3-17

96 3. DebugAgent 4. jdb jdb 1. -g -g 2 set_compiler_option SQL> call dbms_java.set_compiler_option( mypackage.mycode, debug, true ); : set_compiler_option 1 Oracle8i Java Tools loadjava loadjava % loadjava -u SCOTT/TIGER -v -f -r mycode.java -g Java Oracle8i JVM % javac -g MyCode.java % loadjava -u SCOTT/TIGER -v -f -r mycode.class % ftp dbhost > cd /private/sourcecode > put mycode.java 3-18 Oracle8i Java

97 jdb jdb use > use /private/sourcecode : FilePermission 2. DebugProxy Java jdb jdb aurora_client.jar CLASSPATH debugproxy debugproxy -port 2286 Proxy Name: yourmachinename Proxy Address: aaa.bbb.ccc.ddd Proxy Port: 2286 DebugProxy debugproxy jdb debugproxy 4 UNIX startjdb #!/bin/sh xterm -e jdb -password &1 & debugproxy jdb debugproxy -port 1638 startjdb Java 3-19

98 Windows NT startjdb.bat start jdb -password %1 debugproxy jdb debugproxy -port 1638 startjdb.bat 3. DebugAgent 4 DebugProxy : JAVADEBUGPRIV SQL*Plus IP URL DBMS_JAVA SQL> call dbms_java.start_debugging('yourmachinename', 2286, 66); DebugAgent DebugAgent : Aurora stop_debugging SQL> call dbms_java.stop_debugging(); 3-20 Oracle8i Java

99 restart_debugging SQL> call dbms_java.restart_debugging(66); OracleAgent DBMS_JAVA oracle.aurora.debug.oracleagent oracle.aurora.debug.oracleagent Java public static void start(string host, int port, long timeout_seconds); public static void stop(); public static void restart(long timeout_seconds); 4. jdb DebugAgent DebugProxy jdb jdb 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 3-21

100 3-1 DebugAgent debugproxy tsthost debugproxy jdb 1 debugproxy jdb tsthost 1 SQL> call dbms_java.set_compiler_option(, debug, true ); SQL> exit % loadjava -u SCOTT/TIGER -v -f -r mycode.java % debugproxy -port 2286 start jdb -password. (wait until a debug agent starts up and. contact this proxy... when it does, jdb. starts up automatically and you can set. breakpoints and debug the object, as follows:) > suspend > load SCOTT:myCode > stop in mycode:updateaccount > resume >... tsthost 2 SQL> grant JavaDebugPriv to SCOTT SQL> call dbms_java.start_debugging('tsthost',2286,30); Java Java JDBC SQLJ System.getProperty System.getProperty ("oracle.jserver.version") getproperty 3-22 Oracle8i Java

101 Oracle8i 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-23

102 3-24 Oracle8i Java

103 4 Java Oracle8i Oracle8i JVM Java 6 Oracle8i Java Java Java Oracle8i JVM Java Java 4-1

104 Java Java Oracle8i Oracle8i JVM Java Java JDBC SQLJ CORBA/EJB Oracle Oracle8i JVM Oracle8i JVM 3 Oracle8i Oracle8i Oracle8i JVM Oracle8i Oracle8i Oracle8i JVM initjvm.sql Oracle8i JVM Oracle8i Oracle8i JVM ORACLE_HOME/javavm/install initjvm.sql Oracle8i JVM 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 Oracle8i Java

105 Java 3. CORBA 4. : initjvm.sql 1 Java 50MB SHARED_POOL_SIZE 20MB JAVA_ POOL_SIZE 30MB initjvm.sql 6-7 Java /javavm/readme.txt EJB CORBA Oracle8i JVM Oracle8i Enterprise JavaBeans Oracle8i CORBA Oracle8i Net8 DBMS_JAVA Oracle8i JVM initjvm.sql PL/SQL DBMS_JAVA DBMS_JAVA Java DbmsJava Java RDBMS DBMS_JAVA FUNCTION longname (shortname VARCHAR2) RETURN VARCHAR2 Java Java SQL Aurora SQL 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

106 Java 2-30 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 Oracle8i JVM Java SQLJ 2-14 Java Oracle8i Java Oracle8i SQLJ PROCEDURE set_output (buffersize NUMBER) Java DBMS_OUTPUT 3-23 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 -thin -oci8 -user -password loadjava stderr loadjava Oracle8i Java Tools PROCEDURE grant_permission( grantee varchar2, permission_type varchar2, permission_name varchar2, permission_action varchar2 ) PROCEDURE restrict_permission( grantee varchar2, permission_type varchar2, 4-4 Oracle8i Java

107 Oracle8i JVM 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-6 PROCEDURE start_debugging(host varchar2, port number, timeout number) PROCEDURE stop_debugging PROCEDURE restart_debugging(timeout number) 3-17 Oracle8i JVM Oracle8i Oracle8i JVM Oracle8i Database Configuration Assistant Net8 Assistant Oracle8i JVM initjvm.sql Oracle8i Java Java Java 20MB JAVA_POOL_SIZE 50MB SHARED_POOL_SIZE Oracle Oracle8i JVM SQL initjvm.sql Java 4-5

108 Oracle8i JVM 6-7 Java MTS Aurora JVM 2 Net8 GIOP GIOP EJB CORBA IIOP Net8 GIOP IIOP CORBA EJB SSL IIOP Oracle8i Enterprise JavaBeans Oracle8i CORBA Net8 Oracle Tools SQL*Plus Forms Pro*C OCI SQL Net8 Oracle8i Net Oracle8i Java

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

110 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 Oralce8i Enterprise JavaBeans Oracle8i CORBA Java Java 1. JDK 2. CLASSPATH 3. /SID JDK loadjava deployejb Oracle8i JVM 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

111 Java : Oracle8i Java Java 2 2. CLASSPATH CORBA EJB RMI Java JAR ZIP CLASSPATH JAR ZIP Java CLASSPATH JAR ZIP : NT %ORACLE_HOME% %JAVA_HOME% JAR $ORACLE_HOME/lib/aurora_client.jar $ORACLE_HOME/lib/mts.jar $ORACLE_HOME/lib/vbjorb.jar $ORACLE_HOME/lib/vbjapp.jar CLASSPATH $ORACLE_HOME/lib/aurora.zip JDK 1.1 JAR JDK 1.1 Java 2 JVM JAR $JAVA_HOME/lib/classes.zip JDBC ZIP $ORACLE_HOME/jdbc/lib/classes111.zip SSL JAR $ORACLE_HOME/jlib/jssl-1_1.jar $ORACLE_HOME/jlib/javax-ssl-1_1.jar Java 4-9

112 Java Java 2 JAR Java 2 Java 2 JVM JAR CLASSPATH JDK 1.2 dt.jar JRE 1.2 rt.jar JDBC ZIP $ORACLE_HOME/jdbc/lib/classes12.zip SSL JAR $ORACLE_HOME/jlib/jssl-1_2.jar $ORACLE_HOME/jlib/javax-ssl-1_2.jar SQLJ JAR $ORACLE_HOME/sqlj/lib/translator.zip runtimex.zip JDBC Java 2 $ORACLE_HOME/sqlj/lib/runtime12.zip JDBC Java 2 Enterprise Edition $ORACLE_HOME/sqlj/lib/runtime12ee.zip JDBC JDK 1.1 $$ORACLE_HOME/sqlj/lib/runtime11.zip JDBC JDK $ORACLE_HOME/sqlj/lib/runtime.zip JSP JAR $ORACLE_HOME/jsp/lib/ojsp.jar $ORACLE_HOME/lib/xmlparserv2.jar $ORACLE_HOME/lib/servlet.jar JSP OracleJML JavaBeans $ORACLE_HOME/jsp/lib/ojsputil.jar $ORACLE_HOME/jsp/lib/oraclexmlsql.jar README Make JAR ZIP 4-10 Oracle8i Java

113 Java 3. /SID 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 : Make NT Visual Cafe JDeveloper VisualAge Java 4-11

114 Java 4-12 Oracle8i Java

115 5 Oracle8i Java JVM JAR Java Oracle8i Java JVM Oracle8i Java 5-1

116 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 Oracle8i CORBA JVM Java 2 PL/SQL Aurora JVM Oracle8i Java

117 JVM Java 2 PL/SQL Oracle8i loadjava / grant loadjava Oracle8i Java Tools JVM Oracle8i JVM Java 2 Java 2 JAVA_ADMIN JVM JAVA_ADMIN Java Java 2 Java 2 Java 2 Java Java JAVAUSERPRIV - JAVASYSPRIV - JVM Oracle8i Java 5-3

118 JVM : Oracle 2 Oracle8i JVM Java 2 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 Java 2 CLASSPATH Java java -usepolicy Oracle8i Java PolicyTable 5-4 Oracle8i Java

119 JVM Java 2 SecurityManager Launcher SecurityManager SecurityManager URL CodeSource URL equals TRUE CodeSource CodeSource implies TRUE Oracle8i SecurityManager Aurora SecurityManager Aurora SecurityManager SecurityManager oracle.aurora.rdbms.securitymanagerimpl Aurora SecurityManager Oracle8i JVM PolicyTable PolicyTable DBMS_JAVA PolicyTable JAVA_ADMIN JAVA_ADMIN PolicyTable CodeSource equals TRUE implies TRUE Oracle8i Java 5-5

120 JVM Java 2 Oracle8i Oracle8i DBMS_JAVA Java 2 USER_JAVA_POLICY DBA_JAVA_POLICY 2 DBA_JAVA_POLICY USER_JAVA_POLICY Kind Grantee Permission_schema Permission_type Permission_name Permission_action Status Key GRANT RESTRICT GRANT RESTRICT java.io.filepermission PolicyTable 5-12 NULL ACTIVE INACTIVE ACTIVE INACTIVE 5-6 Oracle8i Java

121 JVM 2 Oracle8i JAVAUSERPRIV JAVASYSPRIV : Grantee Permission type Permission name PUBLIC FilePermission java.lang.security.permission SYS <schema> myschema:mypackage.mypermission Permission action FilePermission Key Java 2 Java Oracle8i Java 5-7

122 JVM 5-1 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 SQL Java Java SQL DBMS_JAVA Java OUT PL/SQL DBMS_JAVA key OUT 5-17 : FilePermission /private/oracle $ORACLE_HOME /private/oracle/** /private/oracle/-- DBMS_JAVA procedure grant_permission( grantee varchar2, permission_type varchar2, permission_name varchar2, permission_action varchar2 ) 5-8 Oracle8i Java

123 JVM 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); 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); Oracle8i Java 5-9

124 JVM 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 ); REM commit the changes to the PolicyTable commit; 5-2 restrict restrict /tmp password /tmp / password / password 1 Oracle8i JVM password 5-10 Oracle8i Java

125 JVM /tmp/* PUBLIC /tmp % ls -al... password test mycode.java mycode.class updsql.sqlj Makefile PUBLIC 1. PUBLIC /tmp 2. PUBLIC /tmp/password 1 3. Larry password 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 Limit 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 limitation, REM Larry can read and write /tmp/password. Oracle8i Java 5-11

126 JVM call dbms_java.grant_permission( LARRY, java.io.filepermission, /tmp/password, read,write ); commit; PolicyTablePermission Oracle8i JVM PolicyTablePermission JAVA_ADMIN JAVA_ADMIN DBA JAVA_ADMIN JAVA_ADMIN PolicyTablePermission PolicyTablePermission FilePermission PolicyTablePermission FilePermission PolicyTablePermissions 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) Java long oracle.aurora.rdbms.security.policytablemanager.grantpolicypermission( java.lang.string grantee, java.lang.string permission_type, java.lang.string permission_name); 5-12 Oracle8i Java

127 JVM 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 Permission_type Permission_name Row_ number PUBLIC <schema> FilePermission java.lang.security.permission SYS <schema> myschema:mypackage.mypermission : PolicyTablePermission # java.io.filepermission#read # 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 as SYSDBA Oracle8i Java 5-13

128 JVM REM SYS grants Larry the right to administer permissions for REM FilePermission call dbms_java.grant_policy_permission( LARRY, SYS, java.io.filepermission, * ); 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; } } 2. grant_policy_permission LARRY MyPermission grant_policy_permission LARRY 5-14 Oracle8i Java