Using Oracle Workspace Manager with Web Logic connection pools?

From: Mark Ainsley <MAinsley_at_dstsystems.com>
Date: 30 Dec 2003 12:00:41 -0800
Message-ID: <e583c74c.0312301200.134a638f@posting.google.com>

Hi,
I've determined that Oracle's WSM can be valuable for some of our testing and development efforts here. But, I'm stuck trying to figure out how to utilize this feature when running an application in a Web Logic server using a connection pool.

Basically, I want to have different workspaces (i.e. sandboxes) set-up for various users so that each can run tests in their own isolated database environment and easily reset their view to particular know state(s). I've been able to demonstrate this functionality with splplus, but to do so I must explicitly execute DBMS_WM.* procedures.

It's not clear to me how I can have a connection from Web Logic utilize a particular Workspace for a particular user (ala EXECUTE DBMS_WM.GotoWorkspace ('Workspace1')).

Any ideas would be much appreciated.

-mark Received on Tue Dec 30 2003 - 14:00:41 CST