10gR1Java DB — JDBC — ݿ Web

Ը
Oracle ݿ 10g
Java
JDBC Web


ݿе Java 汾УѾݿ⼯ɵ Java OracleJVM J2SE 1.4.x Java SQLPL/SQLXMLJ2EE Web ļɡŻ Java ڴJava Լ Java صǻ˷ JDBC ʵָĻỰ SQL ݷٶȡ

JDBC ׵ϵṹǿ JDBC 3.0 Եȫ֧֣һʵʩ JDBC Web RowSet (JSR-114)
Oracle JDBC Ѿ JDBC 3.0ϵṹΪ JavaJ2EEWeb GRID ṩݿӡ һ JDBC ܹЧشǰӦ÷ܹѾڴֹ֧ܣʹܹݿʵ̬Ӧӳء Oracle Ϣļʵʵϻ¼ĿӦó֪ͨ (FaN)Լٵӹת (FCF)SQLJ֧

ݿ Web
ǰݿͨЭʵģݿ Web δӿͻ˿ͨ Web Э鴥ݿ֮һݿỰʹ Web ʽṩĶ̬ݡݿ Web ۺ Oracle ݿ⣨SQLPL/SQLJava-in-the-DatabaseJDBCHTTPclientSOAP ͻˣԼ Oracle Ӧ÷JavaJ2EEJDBCSOAP XMLHTTPĹܡ 磬 OracleJVM мһڴ Java JAX-RPC SOAP ͻ˿ݿͱΪһ Web ʹߡ

JPublisherṩԺѡʹɽݿΪ Web ʹⲿ Web ݿ Web 񿪷Ͳ

ݿе Java —
  • OracleJVM ʱ J2SE 1.4 ݣϸİȫԣHeadless AWT
  • ܣԵ Java Poolµĸ JDBC 򡢸ֽУ (Loadjava)
  • Java/J2EE Java ݿֱӵã PL/SQL װ鷳
ݿе Java — ݣ

  • ?Ż Java ڴר÷
  • ?ǿRMI HTTP (JSP/Servlets)EJB Web
ݿ Web —
  • ֧ݿΪ Web ʹߣ
    һ WSDL Java ࡢPL/SQL װݿеӦļ
  • http://www.oracle.com/technology/tech/webservices/database.html
ݿе Web — ݣ
  • ֧ݿΪ Web ṩߣ PL/SQLJava 洢̡SQL ѯ SQL DML Ϊ Web
    ӳ PL/SQL ͣCLOBBLOB
    οαͽӳ
JDBC — µͺǿ
  • IEEE ˫ȡIEEE 㡢TIMESTAMPTIMESTAMP WITH ZONE INTERVAL-DAY-TO-SECONDTIMESTAMP WITH LOCAL TIMEZONELONG-TO-LOB תԼ UNLIMITED SIZE LOB ı֧
  • VARRAY ܺ͹ǿ
  • FLOAT Ͷ DOUBLE Ϊ Java 洢̲
  • ַ LONG
  • ּ֧ PL/SQL
  • ȫ򻯣µ orai18n.jarȡе nls_charset ļ
JDBC — µʽӸٻ
  • ͸
  • ˢ³¾
  • ԵӼ
  • ʶ
  • л
JDBC ֧ RAC GRID

µӻ漯ɣ
  • ݿ¼Ŀ֪ͨ (FaN)
  • UP ¼ٽӣ٣
  • DOWN ¼ٽӹת
ݵ 2 4 JDBC
  • JDBC-Thin ִ֧֤
  • JDBC-Thin ָ֧ܱ XA
  • JDBC-Thin ֧ PL/SQL
  • JDBC-Thin ֧µļ㷨3DES112 3DES168
µ JDBC 3.0
  • CallableStatement PreparedStatement е
  • µIJοӿں·
  • J2EE ܹԴ
  • ӳأ鿴ʽӻͿӹת
  • BLOB CLOB
Oracle9i R2Ѿ JDBC 3.0
  • ȫл
  • PreparedStatement
  • JDK 1.4 ֿ֧ͻ JDBC
JDBC ֧ WebRowSet (JSR-114)
  • /д XML ʽ
  • ԴϿ
  • Early Draft Specification
JDBC — ɹ//
  • ˵˾֧֣ActionClientIdExecutionContextId Module (DMS )
  • JDBC-OCI ļʱͻ
  • ǿ Oracle JDBC Datum

SQLJ — ֧

10g R1 SQLJ ֧֣SQLJ 10.1.0.4 汾δݿ汾н»֧֣ Metalink ˵290400.1

ͬʱͨ JPublisher -sqlj ѡʹȫ SQLJ ܡ

JPublisher

ȫ JDBC ֵ֧֧֡Ͱ

  • NCHAR
  • ʱ
  • SQLJ
  • SQL Opaque
ͨ²طʱ PL/SQL ͣ
  • Ԥת





 
Ȩ͹˾Ϣ
 
 

寄送此页面
Printer View 打印机视图