现在的位置: 首页 > 综合 > 正文

在Oracle AS 10g 上发布pl/sql webservice.

2013年09月01日 ⁄ 综合 ⁄ 共 3944字 ⁄ 字号 评论关闭

Common:

1. Config.xml

<web-service>
   <display-name>Global eOffice Web Service</display-name>
   <description>Global eOffice Web Service</description>
   <destination-path>./geows.ear</destination-path>
   <temporary-directory>./tmp</temporary-directory>
   <context>/geows</context>
   <stateless-stored-procedure-java-service>
      <jar-generation>
        <schema>asp01/inet21</schema>
        <db-url>jdbc:oracle:thin:@192.168.0.71:1521:ORCL</db-url>
        <prefix>db.func.geo.ws</prefix>
        <db-pkg-name>i1_syncs</db-pkg-name>
      </jar-generation>
      <uri>/syncs</uri>
      <database-JNDI-name>jdbc/OracleDS1</database-JNDI-name>
   </stateless-stored-procedure-java-service>
<wsdl-gen>
   <wsdl-dir>wsdl</wsdl-dir>
   <option name="force">true</option>
<option name="httpServerURL">http://192.168.0.14:7777</option>
</wsdl-gen>
<proxy-gen>
   <proxy-dir>proxy</proxy-dir>
   <option name="include-source">true</option>
</proxy-gen>
</web-service>

2. Data-sources.xml

<?xml version="1.0" standalone='yes'?>
<!DOCTYPE data-sources PUBLIC "Orion data-sources" "http://xmlns.oracle.com/ias/dtds/data-sources.dtd">

<data-sources>
 <!--
  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"
 />

</data-sources>

 

Windows

gen.bat

@echo off

SET OC4J_HOME=C:/oc4j
SET 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:/oc4j
SET 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 geows

call %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_05
export JAVA_HOME

OC4J_HOME=..
export OC4J_HOME

ORACLE_HOME=/u01/app/oracle/product/10.1.0/db_1
export ORACLE_HOME

ORACLE_SID=ORCL
export ORACLE_SID

ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE

PATH=.:$JAVA_HOME/bin:$PATH
export PATH

MYROOT=geows
export MYROOT

CLASSPATH=.:$OC4J_HOME/webservices/lib/wsdl.jar:$OC4J_HOME/lib/xmlparserv2.jar:$OC4J_HOME/soap/lib/soap.jar:$CLASSPATH
export 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_05
export JAVA_HOME

OC4J_HOME=..
export OC4J_HOME

ORACLE_HOME=/u01/app/oracle/product/10.1.0/db_1
export ORACLE_HOME

ORACLE_SID=ORCL
export ORACLE_SID

ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
PATH=.:$JAVA_HOME/bin:$PATH
export PATH

MYROOT=geows
export MYROOT

CLASSPATH=.:$OC4J_HOME/webservices/lib/wsdl.jar:$OC4J_HOME/lib/xmlparserv2.jar:$OC4J_HOME/soap/lib/soap.jar:$CLASSPATH
export 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 ./$MYROOT.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

 

 

抱歉!评论已关闭.