Transcript Database as a Service Provider

Web Services
Development
made easy
Olivier Le Diouris
Principal Product Manager
Agenda




The Scope
Database as a Service Provider
Database as a Service Consumer
Future
Agenda




The Scope
Database as a Service Provider
Database as a Service Consumer
Future
The Scope
 Web Services Technology Stack
–
–
–
SOAP
WSDL
UDDI
 SOAP Architecture : Services & Service Providers
 JSR-109 : J2EE Web Services
 Benefits of J2EE
Web Services
Internet
Web Services Technology Stack





Uses the Internet, firewall friendly
Language & Platform agnostic
Good interoperability, NO portability
Uses XML messaging
Stateless
SOAP
Fortran
C, C++
Java
Perl
VisualBasic
Cobol
Pascal
C#
WSDL
APL
PL/SQL
ADA
SPL
UDDI
SOAP Services and Providers
A SOAP
Request
A SOAP
Provider
A SOAP
Service
Java,
Perl, Shell Script,
PL/SQL, VB, …
Greetings,
Stock Quotes,
Directions,
Currency Rates,
Traffic, …
Web Services & J2EE
JSR 109
QuickBasic
JAX-R
JCA
JAX-RPC
J2SE
…more! JMS J2ME
JSP
JDBC
JAX-M
war-files
JAX-B
Servlet
ear-files
EJB
JAX-P
Smalltalk
Java
C#
C, C++
Fortran
Perl
PL/SQL
Java
Visual Basic
SPL
Cobol
APL
Pascal
ADA
Prolog
JSR 109
 How to deploy a Java Web Service
the J2EE way
 Java Class(es)
 Java Interface
 WSDL document
 Bundled as a J2EE ear-file
 Brings portability to a Web Services
application
OC4J
D E M O N S T R A T I O N
A J2EE Web Service
and its Proxy
Agenda




The Scope
Database as a Service Provider
Database as a Service Consumer
Future
Database as a Service Provider
 Already existing logic or data-centric process
running in the Database
 To be published as a J2EE Web Service
(JSR 109)
 Use JPublisher to generate
the java wrapper
Rationale
 Use Oracle JPublisher to generate a Java
wrapper
 Publish the Java Wrapper as a JSR-109
compliant Web Service
 Will take advantage of the J2EE container’s
data-sources and connection pooling
mechanism
Oracle JPublisher




Available since Oracle 8
Can manage unsupported types
Today, uses SQLJ
Available from the command line, as well
as from IDE Wizards
D E M O N S T R A T I O N
Exposing PL/SQL
as a Web Service
Agenda




The Scope
Database as a Service Provider
Database as a Service Consumer
Future
Database as a Service Consumer
 Web Services access from the Database
 Immediately available for any application
accessing the Database (SQL Statement,
Oracle PL/SQL, Oracle Forms, etc)
 Use the appropriate features
wherever they run
Web Services
Internet
Rationale
 Generate a java stub or proxy for any Web
Service, after the associated WSDL
 Publish this stub or proxy as a Java Stored
Procedure
 Result: It’s another PL/SQL executable
Web Services
Internet
Requirements
 Store the libraries required by the SOAP client
in the Database (use loadjava)
 Grant the appropriate privileges to access
external resources
Web Services
Internet
D E M O N S T R A T I O N
Consuming a
Web Service from
the Database
Agenda




The Scope
Database as a Service Provider
Database as a Service Consumer
Future
What’s coming
 SQL Query and DML
–







Additional Returned Data Formats
Direct Java-to-Java invocation
AQ /Streams operations
XML Operations
Asynchronous/Deferred Service execution
JAX-RPC Client SOAP stack
Automatic Table Function Generation
Enhanced Tooling
–
–
Command line
JDeveloper
otn.oracle.com
Join Over 3,000,000 Developers!
Free Technical Advice
Free Software Downloads
http://otn.oracle.com
For more information
 TheServerSide.com J2EE Community
–
–
–
–
–
–
–
Largest J2EE site in the world
305,000 registered members
Enterprise Java News
Design Patterns
Free Books
Product Reviews
Articles and Video Interviews
QUESTIONS
ANSWERS