1 / 27

Web Services Development made easy

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.

amena-villarreal
Download Presentation

Web Services Development made easy

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Web Services Development made easy

  2. Olivier Le Diouris Principal Product Manager

  3. Agenda • The Scope • Database as a Service Provider • Database as a Service Consumer • Future

  4. Agenda • The Scope • Database as a Service Provider • Database as a Service Consumer • Future

  5. 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

  6. WSDL SOAP UDDI Web Services Technology Stack • Uses the Internet, firewall friendly • Language & Platform agnostic • Good interoperability, NO portability • Uses XML messaging • Stateless Fortran Java Perl APL C, C++ PL/SQL VisualBasic C# SPL Cobol Pascal ADA

  7. Java, Perl, Shell Script, PL/SQL, VB, … A SOAP Provider Greetings, Stock Quotes, Directions, Currency Rates, Traffic, … A SOAP Service SOAP Services and Providers A SOAP Request

  8. JAX-R JCA JAX-RPC J2SE QuickBasic …more! JMS J2ME Java Smalltalk JSP JDBC Fortran JAX-M C# Perl war-files JAX-B C, C++ PL/SQL Servlet Java Visual Basic ear-files SPL Cobol EJB APL Pascal JAX-P ADA Prolog Web Services & J2EE JSR 109

  9. 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

  10. D E M O N S T R A T I O N A J2EE Web Service and its Proxy

  11. Agenda • The Scope • Database as a Service Provider • Database as a Service Consumer • Future

  12. 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

  13. 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

  14. Oracle JPublisher • Available since Oracle 8 • Can manage unsupported types • Today, uses SQLJ • Available from the command line, as wellas from IDE Wizards

  15. D E M O N S T R A T I O N Exposing PL/SQL as a Web Service

  16. Agenda • The Scope • Database as a Service Provider • Database as a Service Consumer • Future

  17. 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

  18. 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

  19. 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

  20. D E M O N S T R A T I O N Consuming a Web Service from the Database

  21. Agenda • The Scope • Database as a Service Provider • Database as a Service Consumer • Future

  22. 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

  23. otn.oracle.com Join Over 3,000,000 Developers! Free Technical Advice Free Software Downloads http://otn.oracle.com

  24. 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

  25. Q & Q U E S T I O N S A N S W E R S A

More Related