JDBC and dedicated server processes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: JDBC and dedicated server processes

  1. #1
    Join Date
    Oct 2000
    Posts
    90

    Unhappy JDBC and dedicated server processes

    I have 10 Java (JDBC) connections to one database.
    These connections are always opened 24/7.

    Questions: Does Oracle see these connections as 10 separate dedicated
    server processes?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Depends, look in v$session.server
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Oct 2000
    Posts
    90
    Thanks Jeff, that helpled.

    So, the assumption is that 10 users can use one JDBC connection to the database.
    So in this case the JDBC connection is seen as a pool for 10 different users to use to connect
    through one dedicated server process, right?

    And from the database point of view, this is seen as just one dedicated Server process. Right?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Depends, are you using a connection pool?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Oct 2000
    Posts
    90
    Yes I'm using connection pool

  6. #6
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282
    in java, 10 users can use just one connection to the database if you are using design patter techniques, in other words, connection pools. You can do it using OracleConnectionCacheImpl along the singleton design patter, for example.

    every DriverManager.getConnection(..) is a connection to the database, in other words, a server session.



    F

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