Database webservis koymak ve çalıştırmak

10.2.* database kurulumu yapılması

loadjava -thin -user sys/oracle@localhost:1521:orcl -resolve -synonym -verbose -grant public /oracle/ora10g/oc4j/soap/lib/soap.jar /oracle/ora10g/oc4j/lib/dms.jar /oracle/ora10g/lib/servlet.jar /oracle/ora10g/oc4j/j2ee/home/lib/ejb.jar /oracle/ora10g/oc4j/j2ee/home/lib/mail.jar /oracle/ora10g/oc4j/j2ee/home/lib/jssl-1_2.jar

Aynı anda yüklenmesine dikkat edilmeli bir arada yüklenince hata vermiyorlar

C:\jdev1012_2\jdev\lib\jdev-rt.jar
C:\jdev1012_2\jdev\lib\ext\wsakbnk.jar

sqlplus "/as sysdba"

alter system set utl_file_dir='C:/utl' scope=SPFILE;

shutdown immediate;

startup;

drop user ws cascade;

CREATE USER ws IDENTIFIED BY ws;

GRANT CREATE SESSION
, CREATE TABLE
, CREATE TRIGGER
, CREATE SEQUENCE
TO ws;

GRANT CONNECT, RESOURCE TO WS
/

grant create database link to ws with admin option;

execute dbms_java.grant_permission('WS','SYS:java.util.PropertyPermission','*','read,write');
execute dbms_java.grant_permission( 'WS', 'SYS:java.net.SocketPermission','localhost:8988', 'connect,resolve' );
execute dbms_java.grant_permission( 'WS', 'SYS:java.net.SocketPermission','213.153.170.76', 'connect,resolve' );

ALTER USER WS DEFAULT TABLESPACE USERS
/

execute dbms_java.grant_permission( 'WS', 'SYS:java.io.FilePermission', 'c:\utl\firmaBilg.txt', 'delete' )

execute dbms_java.grant_permission( 'WS', 'SYS:java.io.FilePermission', 'c:\utl\firmaBilg.txt', 'write' )

execute dbms_java.grant_permission( 'WS', 'SYS:java.io.FilePermission', 'c:\utl\ilBilg.txt', 'delete' )

execute dbms_java.grant_permission( 'WS', 'SYS:java.io.FilePermission', 'c:\utl\ilBilg.txt', 'write' )

execute dbms_java.grant_permission( 'WS', 'SYS:java.io.FilePermission', 'c:\utl\uomBilg.txt', 'delete' )

execute dbms_java.grant_permission( 'WS', 'SYS:java.io.FilePermission', 'c:\utl\uomBilg.txt', 'write' )

loadjava -thin -user ws/ws@localhost:1521:ORCL EPENTGStub.java

ws ile bağlanıp kontrol edip gerekirse tekrar compile edilmeli.

CREATE OR REPLACE FUNCTION WS.katarUomTypeCnt RETURN NUMBER AS
LANGUAGE JAVA NAME 'com.xt.akbnk.EPENTGStub.katarUomTypeCnt() return java.lang.Integer';
/