PLSQL WebService is published on Oracle AS 10G.

Common:

Config.xml

Global EOFECE Web Service Global EOFECE Web Service ./ geows.ear ./ TMP / geows ASP01 / INET21 JDBC: Oracle: Thin: @ 192.168.0.71: 1521: OrCl db.func.geo.ws i1_syncs / syncs JDBC / ORACLEDS1 WSDL True http://192.168.0.14:777 proxy True

2. Data-Sources.xml

<-!. An example / default DataSource that uses Oracle JDBC-driver to create the connections This tag creates all the needed kinds of data-sources, transactional, pooled and EJB-aware sources The source generally used. In Application Code Is The "EJB" One - IT Provides Transactional Safety and Connection Pooling. Oracle Thin Driver Could Be Used As Well, Like Below. URL = "JDBC: Oracle: Thin: @HOST: Port: SID" -> < data-source class = "com.evermind.sql.DriverManagerDataSource" name = "OracleDS" location = "jdbc / OracleCoreDS" xa-location = "jdbc / xa / OracleXADS" ejb-location = "jdbc / OracleDS" connection-driver = "Oracle.jdbc.driver.Oracledriver" username = "ASP01" password = "inet21" url = "JDBC: Oracle: Thin: @ 192.168.0.71: 1521: OrCl" inactivity-timeout = "30" />

Windows

Gen.bat

@echo off

SET OC4J_HOME = C: / OC4JSET JAVA_HOME = C: /J2SDK1.4.2_03

Set classpath =.;% OC4J_HOME% / WebServices / lib / wsdl.jar;% OC4J_HOME% / lib / xmlparserv2.jar;% OC4J_HOME% / SOAP / LIB / SOAP.jar

Call% java_home% / bin / java -jar% OC4J_HOME% / WebServices / lib / webservicesassembler.jar -config ./config.xml

@echo on

INSTALL.BAT

@echo off

SET OC4J_HOME = C: / OC4JSET JAVA_HOME = C: /J2SDK1.4.2_03

Set classpath =.;% OC4J_HOME% / WebServices / lib / wsdl.jar;% OC4J_HOME% / lib / xmlparserv2.jar;% OC4J_HOME% / SOAP / LIB / SOAP.jar

Call% java_home% / bin / java -jar% OC4J_HOME% / WebServices / lib / webservicesassembler.jar -config ./config.xml

Call% java_home% / bin / java -jar% OC4J_HOME% / J2EE / home / admin.jar ORMI: // localhost admin Welcome -Deploy -file ./geows.ear -Deploymentname geowscall% java_home% / bin / java -jar% OC4J_HOME% / J2EE / Home / Admin.jar ORMI: // localhost admin Welcome -bindwebapp geows geows_web http-web-site / geows

@echo on

Linux

Gen

#! / bin / sh

Java_home = / usr / local / j2sdk1.4.2_05export java_home

OC4J_HOME = .. export oc4j_home

Oracle_Home = / U01 / App / Oracle / Product / 10.1.0 / db_1export Oracle_home

Oracle_sid = ORCLEXPORT ORACLE_SID

Oracle_base = / u01 / app / oracleexport Oracle_base

PATH =:. $ JAVA_HOME / bin: $ PATHexport PATH MYROOT = geowsexport MYROOT CLASSPATH =:. $ OC4J_HOME / webservices / lib / wsdl.jar: $ OC4J_HOME / lib / xmlparserv2.jar: $ OC4J_HOME / soap / lib / soap.jar :! $ CLASSPATHexport CLASSPATH $ JAVA_HOME / bin / java -jar $ OC4J_HOME / webservices / lib / WebServicesAssembler.jar -config ./config.xml install # / bin / sh JAVA_HOME = / usr / local / j2sdk1.4.2_05export JAVA_HOME OC4J_HOME = ..export OC4J_HOME ORACLE_HOME = / u01 / app / oracle / product / 10.1.0 / db_1export ORACLE_HOME ORACLE_SID = ORCLexport ORACLE_SID ORACLE_BASE = / u01 / app / oracleexport ORACLE_BASE PATH =:. $ JAVA_HOME / bin: $ PATHexport PATH mYROOT = geowsexport mYROOT CLASSPATH =:. $ OC4J_HOME / webservices / lib / wsdl.jar: $ OC4J_HOME / lib / xmlparserv2.jar: $ OC4J_HOME / soap / lib / soap.jar: $ CLASSPATHexport CLASSPATH $ JAVA_HOME / bin / java -jar $ OC4J_HOME / webservices /LIB/webservicesassembler.jar -config ./config.xml $ java_home / bin / java -jar $ OC4J_HOME / J2EE / Home / Admin.jar ORMI: // Localhost Admin Welcome -Deploy -file ./ * $Root.ear -Deploymentname $ MyRoot $ java_home / bin / java -Jar $ OC4J_HOME / J2EE / Home / Admin.jar ORMI: // localhost admin Welcome -bindwebapp $ myroot $ myroot_web http-web-site / $ myroot