Purchase

USA and Canada
sales@hitsw.com
+1-408-345-4001
 
Asia
Australia
Europe
Latin America

Graphical Database XML Mapping and Transformation

with Full 30-Day Support

Download an application that demonstrates how you might use the Allora web service to allow remote applications to access relational database and then present data to a user. Using SOAP APIs, the application connects to the Allora web service via HTTP and requests data from a database based on user input. The data is returned via SOAP/HTTP and is displayed in a Java-based graphical user interface.

1. Download Allora
   Choose from the following downloadable files:
    
   

   AlloraWebServicesDemo.zip	A zip file that contains all the files needed to run the Web Services demo application. This option is useful if your system supports the zip format.
   AlloraWebServicesDemo.tar.gz	A compressed tar file that contains all the files needed to run the Web Services demo application. You need the GNU gzip program to decompress the tar file (see http://www.gnu.org), and a tar program to extract the files. This option is useful if you are working on a platform that does not support the zip file format.

   
    
   
2. Make sure you have JDK 1.3 or later installed.
    
   
3. Unzip the downloaded file, AlloraWebServicesDemo.zip
   The zip file contains:
    
   

   demo.bat	A Windows script that sets the classpath for JAR files needed to run the demo and then invokes the command to run the demo.
   demo.sh	A UNIX script that sets the classpath for JAR files needed to run the demo and then invokes the command to run the demo.
   demo.jar	The demo classes. See below for more information about what the demo does.
   soap.jar	Standard SOAP classes implemented by the Apache Software Foundation, also available from http://xml.apache.org/soap.
   mail.jar	JavaMail 1.1.3.Required for the Apache SOAP library. http://java.sun.com/products.
   activation.jar	JavaBeans Activation Framework 1.0.1.Required for the Apache SOAP library. http://java.sun.com/products.
   gnu-regexp-1.1.2.jar	Required for the Allora Web Services demo code. Click here to download.
   sax.jar   jaxp-api.jar   dom.jar   xalan.jar   xercerslmpl.jar   xsltc.jar	Libraries that make up JAXP 1.2, also available from http://java.sun.com/xml/jaxp. Required for the Allora Web Services demo code.
   Note: Although this demo uses Allora classes on a remote HiT Software server , no Allora-specific classes on the client (your system) are required to run the web services used in this demo. Allora also offers client libraries to provide additional functionality within the Allora web service.

   
    
   
4. Edit demo.sh or demo.bat (depending on your operating system) to set the classpath for your JDK and the demo JAR files.
    
   
5. Run demo.bat or demo.sh from your desktop. If you do not see a window titled "Allora Web Services Demo - California STAR Test Results" contact HiT XML technical support at
   XML-support@hitsw.com.
    
   
6. Choose either Santa Clara County or San Mateo County from the drop-down list.
    
   
7. Examine the SOAP Request tab.
   The request is sent to the urn AlloraServer and contains a
   SQL SELECT statement to identify the data to retrieve.
    
   
8. Examine the SOAP Response tab.
   It displays an XML document containing a list of school districts for the county you have selected.
    
   
9. Choose a district from the drop-down list.
    
   
10. Examine the SOAP Request and SOAP Response tabs to see how the data for the third drop-down list is obtained.
     
    
11. Choose a school from the drop-down list.
     
    
12. Examine the SOAP Request and SOAP Response tabs to see how the test results data on the "School Records in SOAP Response" tab is obtained.

More About the Demo Application

The application uses published and freely downloadable results from the California Department of Education Standardized Testing and Reporting (STAR) web site. The database used in the demo contains results from 2001 tests performed in Santa Clara and San Mateo counties.

The database is currently hosted at HiT Software (headquarters in San Jose, CA) in a relational database. Other applications and processes could access, query and update this database using the Allora Web Service from anywhere on the Internet.

This demo application uses the most basic web service that is available with Allora. It uses straight SOAP client APIs and does not require you to install Allora client libraries at the remote application. The advantage of using Allora client APIs at the remote application is more dynamic, granular access to relational data.

Allora Web Services Overview

Supported XML Schemas