Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using Oracle Workspace Manager with Web Logic connection pools?
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