I have the following domain problem, I want to design a web services that client can consume them from a portal. I have Oracle Database. I thought to use session Facade or Service Locator, but I am not sure.
use apache cxf . This is one of the good tool to expose webservice. As jschell pointed please sort out the requirements first. Than you can choose the technology and tools. Generally the frameworks follow best patterns, its better to use them instead of re inventing.