Spring HTTP-Remoting Connector Builder

This Connector Builder generates Spring HTTP-Remoting classes. Spring HTTP-Remoting is uses to call PL/SQL stored procedures tunneled by a HTTP webserver. This is required if no direct access to the Oracle database is allowed or wanted. The implementation is very stable and allows running different versions JRE (up from Java 1.5) on server and client. The complete code and configuration is generated.

Generated Code

  • Server Generated Code :
    • Service interface classes
    • Java implementation classes
    • Java transfer objects
    • Spring servlet configuration
  • Client Generated Code :
    • Service interface classes
    • Java transfer objects
    • Client service factory class


  • Oracle JDBC driver.
  • Connection pool libraries : UCP (Oracle Universal Connection Pool), Spring connection pool, Apache connection pool or etc.
  • Spring Web-MVC

Manual Configuration

  • Server configuration :
    • Modify web.xml
    • Spring DataSource bean
  • Client configuration :
    • Context calling properties

Example web.xml

The configuration sections listener, servlet and servlet-mapping requires configuration as any other Spring configuration.
  • listener-class : Is required to start Spring in a web container.
  • servlet-name : The servlet context name of your service. The same value as param-value without -servlet.xml.
  • servlet-mapping : Maps the calling url to this servlet/service.
  • param-value :
    • first parameter : Spring DataSource configuration file.
    • second parameter : The generated servlet/service configuration file created by the PL/SQL Connector Builder.
XML-File : web.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" id="WebApp_ID" version="3.0" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
    <param-value>/WEB-INF/serviceDataSource-ds.xml /WEB-INF/service-servlet.xml</param-value>

Example Spring DataSource Bean

This example demonstrates the use of a Spring Datasource configured bean with the PropertyPlaceholderConfigurer. Be sure to configure the 'bean id'-name identical to the setting of PL/SQL Connector Builder.
XML-File : springremoting_int_double-ds.xml

Example Client Calling Context Configuration

The client factory loads the client calling context and the spring remote http-invoker configuration then getting a remote call proxy. Four parameter must be set. All parameters starts with the name of the <servlet/service>.server.<parameter>.
  • springremoting_int_double.server.address : The server name or IP address.
  • springremoting_int_double.server.port : The configured port.
  • springremoting_int_double.server.webapp : Web-Application there the servlet/service runs in.
  • springremoting_int_double.server.context : The servlet/service-name
XML-File : springremoting_int_double-context.xml

Spring Remoting Example Download

To get more detailed information, have a look at the runnable example. Download Example Page >>>

UI Configuration