DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: How to force jdbc use shared connection

  1. #1
    Join Date
    Apr 2001
    Posts
    35
    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.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    by default Oracle is in dedicated mode, to use shared connection you have to set up MTS, have you done so?

  3. #3
    Join Date
    Apr 2001
    Posts
    35
    Yes. The question is about jdbc connections.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    that's your question... my question is have you set up Multi Threaded Server in Oracle?

  5. #5
    Join Date
    Feb 2001
    Posts
    163
    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


  6. #6
    Join Date
    Apr 2001
    Posts
    35
    Thanks. That's what I needed to confirm.

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
  •  


Click Here to Expand Forum to Full Width