-
My Oracle8i db is in default shared connection mode.
However, the jdbc connections are all in dedicated mode. How can I force them to use shared mode?
Thanks.
-
by default Oracle is in dedicated mode, to use shared connection you have to set up MTS, have you done so?
-
Yes. The question is about jdbc connections.
-
that's your question... my question is have you set up Multi Threaded Server in Oracle?
-
ann,
to share jdbc connections, you will have to setup a connection pool. There is no easy way to do this in java itself other than pooling and assigning the connections as they are available.
Weblogic has a connection pool built into it. Most app servers have a pool class built into it. Also there are some thrid party classes that can do this for free.
Check out poolman and it was free the last time I used it. ( a few months ago )
http://www.codestudio.com/
Hope that helps. If not explain an example and I can help you through this
-
Thanks. That's what I needed to confirm.
-
Or, you could use oracle's connection manager product. http://technet.oracle.com/docs/produ...cfg.htm#441556
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|