Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: Stored Procedures as Web Service

Stored Procedures as Web Service The SOAP database gateway, SPProvider, is a free extension for the SOAP implementation Apache Axis. Stored Procedures from any JDBC-capable database can be deployed as SOAP Web Service. The installation and deployment is

Tutorial Details:

Installation

1. Install Apache Axis (see Axis documentation).
2. Place spprovider0.9.jar in the classpath.
3. Make sure that the axis server can reach the JDBC driver classes.
4. Start the Axis Web application.
5. Modify the file deploy.wsdd . The parameters have to match your database installation
parameter value
driver JDBC driver class
dburl Database URL
user Database user for executing the stored procedures
password Password for the database user
allowedMethods Comma separated list with procedures or * for all reachable procedures
6. Deploy deploy.wsdd

Use

1. Retrieve the WSDL e.g. with a browser at a URL like http://127.0.0.1:8080/axis/services/sp?wsdl
2. Use WSDL2Java to generate the clientside code
3. Use the clientside code in your program.


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
Stored Procedures as Web Service

View Tutorial:
Stored Procedures as Web Service

Related Tutorials:

SQLJ: The 'open sesame' of Java database applications
SQLJ: The 'open sesame' of Java database applications
 
Jini: New technology for a networked world - JavaWorld June 1999
Jini: New technology for a networked world - JavaWorld June 1999
 
A beginner's guide to Enterprise JavaBeans - JavaWorld - October 1998
A beginner's guide to Enterprise JavaBeans - JavaWorld - October 1998
 
Use JNDI to share objects between different virtual machines - JavaWorld July 1999
Use JNDI to share objects between different virtual machines - JavaWorld July 1999
 
How to attach a user interface to a Jini service - JavaWorld October 1999
How to attach a user interface to a Jini service - JavaWorld October 1999
 
The state of Java application middleware, Part 1 - JavaWorld March 1999
The state of Java application middleware, Part 1 - JavaWorld March 1999
 
Use JDBC for industrial-strength performance, Part 1 - JavaWorld January 2000
Use JDBC for industrial-strength performance, Part 1 - JavaWorld January 2000
 
Secure a Web application, Java-style - JavaWorld April 2000
Secure a Web application, Java-style - JavaWorld April 2000
 
A recipe for cookie management
A recipe for cookie management
 
Secure Web services
Secure Web services
 
The first taste of Liberty
The first taste of Liberty
 
J2EE 1.4 eases Web service development
J2EE 1.4 eases Web service development
 
welofunc performer
welofunc performer is a web load test tool to support quality assurance of J2EE web applications.
 
WS-Specifications
WS-Specifications The WS-Specifications build a composable architecture to form an environment for complex Web Service applications. Different vendors, such as BEA, IBM, Microsoft, RSA Security and SAP, have joined forces to lay the foundation of secure
 
Excerpt from Apache Axis Live
Excerpt from Apache Axis Live This chapter, "Getting Started with the Apache Axis Project," you will take "a brief look at what Axis is and how it implements some of the SOAP services.
 
Daffodil DB - Your complete Java RDBMS
Daffodil DB - Cross Platform Java Database Products... Daffodil DB is a J2EE-certified, SQL-99 and JDBC standards compliant Java RDBMS, made available in both Embedded and Network Editions .
 
Service Orchestration - Cornerstone for Building Service-Oriented Architecture
This Web Cast explains the Service-Oriented Architecture (SOA). Service-oriented architecture is rapidly becoming the cornerstone for enterprise infrastructure, bringing cost reductions and increasing IT and business responsiveness.
 
Complete Webhosting Guide, Search Web hosts, Find Plans
Complete Webhosting Guide, Search Web hosts, Find Plans The Complete Web Hosting Guide RoseIndia.net is the complete beginner's guide to finding a web hosting company. Introduction to Web Hosting What is Web Hosting? Linux vs. Windows
 
DB Solo - Database development and management tool
DB Solo is a powerful database development and management tool for developers and DBAs. DB Solo has an intuitive user interface that allows you to explore and manage your database objects as well as execute your own ad-hoc queries.
 
Solaris 10 OS Certification Beta Exams
If you are an expert in system and network administration, you can get involved in the creation of three new Solaris 10 certification exams. These Beta exams count toward official Solaris Certification and allow you to provide comments and technical feedb
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.