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: Mark Ainsley <MAinsley_at_dstsystems.com>
Date: 31 Dec 2003 08:08:19 -0800
Message-ID: <e583c74c.0312310808.27eae968@posting.google.com>


I was thinking that it might boil down to having to explicitly execute this statement in my application. But, I was hoping to avoid a product code change. What I was hoping to find was some magical configuration that could do this outside of the application source, like a special setting in Oracle's JDBC driver, or a WL connection start-up command, or ...

So, short of discovering any magic, this may be the best course... The code change may not be as bad as I initially thought (just have to convince the right developers over here :^),

Thanks,
  -mark

Joe Weinstein <joeNOSPAM_at_bea.com> wrote in message news:<3FF1DF8E.7030902_at_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 Wed Dec 31 2003 - 10:08:19 CST

Original text of this message

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