feature overview	Oracle Database 10g  Java™, JDBC, and Web Services

Overview  Java in the Database: in this release, we’ve upgraded OracleJVM. the Java engine integrated with the database, to J2SE 1.4.x, improved the integration of Java with SQL, PL/SQL, XML, J2EE and Web services. We’ve optimized Java memory management, Java class loading, and Java pool adjustment; we’ve also re-designed the servers-side JDBC driver for faster in-session SQL data access. JDBC in Summary: Complete Re-Architecture: Complete support for mandatory JDBC 3.0 features, early implementation of JDBC Web RowSet (JSR-114) Oracle JDBC driver have been upgraded to JDBC 3.0 and rearchitected to provide the best database connectivity for Java, J2EE, Web Services and GRID. This new generation of JDBC driver capable of handling more efficiently infrastructure services traditionally handled by application servers or their containers. We've Grid-enabled the driver so that it can dynamically provision the connections pool in resonance with the addition or substraction of  database instances. The integration with Oracle notification services results in fast application notification (FaN) of instance failure or start-up events, and fast connection fail-over (FCF). SQLJ: Desupport Database Web Services:Databases were traditionally accessed through connected protocols, with Database Web Services, non-connected clients can trigger database operations through Web services protocols; conversely a database session can consume dynamic data available as web services. Database Web services combines capabilities in the Oracle Database (SQL, PL/SQL, Java-in-the-Database, JDBC, HTTPclient, SOAP client), and the Oracle Application server (Java, J2EE, JDBC, SOAP server, XML, HTTP).  As an example, loading a pure Java JAX-RPC based SOAP client library in OracleJVM turns your database into a Web service consumer. JPublisher - New features and options for exposing Database Operations as Web services and Consuming external Web services, and simplifying Database Web Services development and deployment. FEATURE DETAILS Java in the Database -- What's New OracleJVM runtime goes J2SE 1.4 compatible: Stringent Security, Headless AWT Performance: Self Tuning Java Pool, New Faster Server-side JDBC driver,                    Faster Bytecode verifier (Loadjava) Direct Java/J2EE to Java DB call (avoid the hassle of the PL/SQL wrapper) Java in the Database -- What's New (cont.) ŸOptimized Java Memory Management (dedicated server) ŸCall-Outs Enhancements: RMI Call-out, HTTP Callout (JSP/Servlets), EJB Call-out, Web Services Call-out Database Web Services -- What's New Support for Database As Web Services Consumer: –For a given WSDL, generate the Java proxy classes, the PL/SQL wrappers and load the appropriate files in the database See http://www.oracle.com/technology/tech/webservices/database.html – Database Web Services -- What's New (Cont) Support for Database As Web Services Provider: Publishing PL/SQL, Java Stored Procedure, SQL Queries, and SQL DML as Web Services –Mapping PL/SQL Types (CLOB, BLOB) –Mapping of REF CURSORs and Result Sets JDBC -- New Data Types and Enhancements Native support for IEEE double, IEEE float, TIMESTAMP,TIMESTAMP WITH ZONE, INTERVAL-DAY-TO-SECOND, TIMESTAMP WITH LOCAL TIMEZONE, LONG-TO-LOB conversion, and UNLIMITED SIZE LOBs VARRAY Performance and functional enhancements Binary FLOAT and binary DOUBLE as Java Stored  Procedures parameters String Length Increased in LONG Columns Support for checking PL/SQL compiler warnings Globalization: New orai18n.jar, supersedes existing  nls_charset files JDBC -- New Implicit Connection Caching Transparent Cache Access Refresh Stales Connections Attributes Based Connection Retrieval Reclaim/Reuse Abandonned Connections Heterogeneous Identities Centralized Cache Management JDBC Support for RAC and GRID Integrated with the New Connectin Cache: Fast Notification of Database Events (FaN) Fast Connection (Re)-Balancing on UP Events Fast Connection Fail-Over on DOWN Events Compatible type-2 and type-4 JDBC drivers JDBC-Thin support for Proxy Authentication JDBC-Thin support for High-Performance Native XA JDBC-Thin support for PL/SQL Index Table JDBC-Thin support for new Encryption Algorithms: 3DES112 and 3DES168 New JDBC 3.0 Features Named Parameters in CallableStatement and PreparedStatement New Ref interface and Datalink J2EE Connector Architecture Resource Adapter Connection Pooling: see Implicit Connection Caching and Fast Connection Fail-Over Statement Pooling BLOB and CLOB Update JDBC 3.0 features already in Oracle9i R2    Transaction savepoints  Toggling between local and global transaction Reuse PreparedStatement JDK 1.4 support for client JDBC drivers JDBC Support for WebRowSet (JSR-114) Read/Writing result sets from/into XML format Disconnected from data-source Based on Early Draft Specification JDBC -- Manageability / Ease of Use / Flexibility End-To-End Metrics Support: Action, ClientId, ExecutionContextId, and Module (DMS monitoring) Instant Client for JDBC-OCI Enhanced Oracle JDBC Datum SQLJ - ReSupport Although de-supported as of 10g R1, SQLJ will be supported again in 10.1.0.4 patch release and future database releases (see Metalink Note Note:290400.1 In the mean time you can have access to full SQLJ functionalities through the -sqlj option of JPublisher. JPublisher Complete JDBC types support; new supported types include: NCHAR Timestamp SQLJ objects SQL Opaque Easier access to native PL/SQL types through:  Predefined type conversions   Top of Page |Copyright and Corporate Info