Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using Oracle Workspace Manager with Web Logic connection pools?

Re: Using Oracle Workspace Manager with Web Logic connection pools?

From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Tue, 30 Dec 2003 12:26:54 -0800
Message-ID: <3FF1DF8E.7030902@bea.com>

Mark Ainsley wrote:

> 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

Hi Mark.
Could it be as simple as having your JDBC code do this?

Statement s = con.createStatement();
s.executeUpdate("EXECUTE DBMS_WM.GotoWorkspace ('Workspace1')");

Note that this sets a DBMS-side behavior, and is transparent to Java, JDBC, and Weblogic, so this state would remain as-is on the given pooled connection. Our pool would not reset this for the next user of the connection, so the ideal application code would set whatever state it needed as above, and before closing the connection, reset the DBMS session state to a default state as might be needed for the next user.
Let me know if this helps,
Joe Weinstein at BEA Received on Tue Dec 30 2003 - 14:26:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US