Roads ? - where we're going, we don't need roads ...
Consuming WS-Security enabled webservices in PL/SQL - part 2 | ORA600
ORA600 content Content RSS
Oracle ORA600 News RRSS Oracle News RSS
ORA600 blog Blog RSS
ORA600 blog Blog Atom

User login

Consuming WS-Security enabled webservices in PL/SQL - part 2

A couple of weeks ago I wrote about consuming ws-security enabled webservices in PLSQL.

The problem was that, even using Oracle 11g and Jpublisher 11g, I was not able to generate a usertoken and password in the SOAP header according to the WS-Security standard.

My twisted solution was to put a WS proxy (or gateway if you like) in between the consumer (database) and the provider.
I would then place the proxy in the DMZ - and on behalf of the consumer :
- the proxy would set up an SSL connection to the provider
- receive the plsql/jpub generated XML
- inject a WS-Security header in the SOAP envelop
- adjust http headers (especially HOST & Content-Length)
- send the new SOAP message to the provider
- receive the response from the provider
- send the response to the consumer

It's not a real proxy in the sense that it proxies the complete http traffic. The proxy/gateway needs to alter the message and that wouldn't be possible if we would use SSL encryption straight out of the database :

Oracle rdbms --- http/s ----> proxy ---- http/s -----> WS provider (endpoint)

So instead we do something like this :

Oracle rdbms --- http ---> proxy (endpoint) ---> http/s --> WS provider (endpoint)
|                                             |
+->(set endpoint to proxy)    |
                                              +-> alter soap message + set endpoint to WS provider
In order for it to work you need to run jpub and use the WS provider as endpoint.
Then load all the generated plsql packages and java classes.
Then set the endpoint to the proxy/gateway address before you consume the WS, like this :
exec referencedatawebservice.setendpoint('')
(in this case we are running the gateway on localhost on port 8000)
And then the proxy will send the soap message further on over http/s.

Anyway I've made my little proxy/gateway available for download here
It's only tested in combination with Oracle 11g rdbms & jpub - I used it and it works, but use it at your own risk.

How to run it :
- download the ws_proxy.cfg config file here
- download WSP.jar here
- open ws_proxy.cfg and adjust the parameters to your needs/requirements
PORT - server socket port the gateway binds on
SO_TIMEOUT - socket timeout in msec
LOG_DIR - directory where the proxy will place its logfiles
LOG_FILE - logfile name - the logfile will automatically rotate every 10Mb
SERVER_PORT - WS provider socket port (443)
SERVER_HOST - WS provider virtual hostname
WSSE_USERNAME - WS-Security wsse usertoken
WSSE_PASSWORD- - password for the above username
XMLNS - additional namespaces - these will be injected in the SOAP header - look at the xml jpub is generating based on the wsdl
- make sure the root/CA certificate that signed the WS provider's server certificate is available in java's certificate wallet
(typically placed in JAVA_HOME/lib/security/cacerts - check with the keytool utility - if the root certificate is not
available then the proxy won't be able to setup a SSL connection with the ws provider)
- start the proxy : >java -cp WSP.jar WS_proxy
Reading ws_proxy.cfg ...
Reading ws_proxy.cfg done !
Current size logfile = 260 bytes
Init done...
Create socket on port 8000...
Create socket on port 8000 done!
Waiting for incoming connection.

- connect to the Oracle database
- set the endpoint of the webservice to the proxy
- consume the webservice - all done !

I have an idea or two to make it better ... but for now that's all I need.


Technorati Tags:

usa viagra sale,

viagra femenino lima [url=]viagra[/url] online viagra buy online viagra in the uk


i canadian pharmacy online wild [url=]canadian pharmacies shipping to usa[/url] canadian pharmacy online

cialis super active overseas

acxess cialis usa mail [url=]cheap cialis online[/url] cialis generic achat cialis angleterre

we like it order viagra viagra

compra viagra espana [url=]viagra cheap[/url] viagra online pharmacy fast delivery viagra


y buy cheap levitra lips [url=]buy generic levitra[/url] buy generic levitra

we use it cialis philippines

buy cialis cheap us [url=]cheap cialis[/url] buy cheap cialis cialis 5mg price comparison

cialis 5mg side effect

cialis-preise eu [url=]buy cialis online[/url] buy cialis online cialis 20 vendita

we use it viagra 10mg

viagra eye side effects [url=]cheap viagra[/url] cheap viagra click now viagra shop

bestellen viagra deutschland

viagra achat en lign [url=]viagra cheap[/url] viagra buy force generic super viagra


y buy generic cialis idea or|[url=]cialis lowest price[/url] cialis coupon

women using viagra

bestellen viagra deutschland [url=]viagra[/url] cheap viagra viagra generic free shipping

viagra for sale nyc

generic viagra definition [url=]viagra[/url] viagra cheap online drugs viagra


b viagra worse sort|[url=]buy viagra online[/url] buy viagra online

cialis i want to buy

economico indian cialis [url=]generic cialis[/url] generic cialis 1 pillola cialis


a payday loans online from go|[url=]payday loans direct lenders[/url] instant payday loans

buy cialis philippines

cheap cialis rx cialis 20 mg best price buy cialis miami [url=]generic cialis 60 mg[/url] buy cialis online for cheap

cialis duration of action

can cialis treat bph [url=]cheap cialis[/url] cheap cialis cialis flushed face 10 mg

only today 5 mg cialis

i prezzi migliori a cialis [url=]buy cialis[/url] cheap cialis cialis einnahme

black cialis uk

only here get cialis fast [url=]buy cialis[/url] cialis buy cialis sex pills


g viagra coupons knowing justice|[url=]buy viagra online[/url] buy viagra online


o cialis coupon himself pain|[url=]cialis lowest price[/url] generic cialis online


u payday loans door bed|[url=]payday loans online[/url] payday loans for bad credit

cialis tadalafil prices

cialis 5 mg generico en mexico [url=]cialis[/url] cialis online coupon cialis now cheap

we like it viagra pills

la marca migliore di viagra [url=]online viagra[/url] buy viagra online viagra brain the news abc

drugs canada

canada phar order cialis in canada generic pharmacies in india [url=]buying cialis in canada[/url] drugs of canada


i payday loans bring making|[url=]best payday loans[/url] payday loans online

generisches cialis online

sildenafil cialis online [url=]buy cialis online[/url] buy cheap cialis cialis 100mg pret


j cialis coupon close satisfied|[url=]buy cialis online[/url] buy generic cialis

viagra brain the news abc

the best place uk viagra [url=]viagra online[/url] viagra online buy viagra sample canada

viagra website official

dr viagra pharmacy [url=]generic viagra[/url] viagra buy viagra in mumbai cod

only here buy cialis soft tabs

cialis 5 mg generico en mexico [url=]cheap cialis online[/url] cialis generic prednisone and cialis

cialis mg generico

niederlande pharmacy cialis [url=]cialis generic[/url] cheap cialis kaiser price cialis


h cialis coupon I'm drink|[url=]cialis lowest price[/url] cialis


h payday loans no credit check consequence chance|[url=]payday loans no credit check[/url] best payday loans

generic buy cialis online

cialis kaufen duisbur [url=]online cialis[/url] online cialis economico indian cialis

cialis economici

we recommend purchase cialis [url=]buy cheap cialis[/url] generic cialis i snort 20 mg cialis

car loan calculator monthly payment

aarp membership low cost insurance aaa auto [url=]hartford auto insurance[/url] cheapest auto insurance


o buy viagra online whatever reason|[url=]buy cheap viagra[/url] buy cheap viagra

viagra online india price

viagra homme effet [url=]buy viagra online[/url] online viagra only now buy viagra new york

cheap uk viagra

acheter viagra authentiqu [url=]viagra online[/url] generic viagra get generic viagra,

order viagra canada pharmacy.

viagra sildenafil mujere [url=]viagra cheap[/url] viagra online viagra heart after a

bestellen viagra deutschland

cialis generic viagra [url=]cheap viagra[/url] viagra cheap better than viagra

cialis dosage 20mg

cialis without a doctor is there generic cialis cheap cialis without prescription [url=]cialis for everyday[/url]

cialis 5 mg serve

click now generic cialis [url=]buy cialis online[/url] cialis generic cialis tadalafil prices

5mg cialis generic europe

brand cialis canadian source [url=]generic cialis[/url] cheap cialis costo cialis 10 mg

hay algun generico cialis

buy cialis sex pills [url=]generic cialis[/url] generic cialis cialis tadalafil prices

how much does cialis cost

how to order generic cialis [url=]cialis[/url] cheap cialis online hay algun generico cialis

order safe generic cialis

cialis best price uk. [url=]buy cialis[/url] buy cialis prix du cialis 20 mg cpr4

ordre de proces de cialis

generic brand cialis uk paypal [url=]generic cialis[/url] cialis cialis flushed face 10 mg

only here buy cialis soft tabs

my wife to cialis by mistake [url=]online cialis[/url] generic cialis cialis online rx pharmacy

See DUDE primer for info

Get Support


Belgium :
Kurt Van Meerbeeck
ORA600 bvba
Cell : +32 495 580714

Denmark :
Michael Môller
Service & Support Manager
Miracle AS
E-mail :
Cell: +45 53 74 71 27

Latin America

Brazil :
Cell : +55 47 88497639


South Africa :
Kugendran Naidoo
NRG Consulting
Cell : +27 82 7799275