Forum Stats

  • 3,827,397 Users
  • 2,260,770 Discussions
  • 7,897,225 Comments

Discussions

jdbc thin connection (from getconnection method) hang

user12025482
user12025482 Member Posts: 48 Blue Ribbon
edited Dec 15, 2012 11:14AM in General Database Discussions
Hi Colleagues,
our developers created application which uses method getconnection to connect database by jdbc thin client. During normal workload on DB machine everything is ok, but when disk are 100% busy on DB, application cannot establish connection to database (getconnection hang for few minutes and finnally it will connect) but sqlplus could connect at once.
I've tested this behavior on different machines and with different java version (1.5, 1.6).
Do you know why jdbc thin client cannot connect to DB server during heavy workload?
Thanks for any suggestions.
Tagged:

Answers

  • sb92075
    sb92075 Member Posts: 42,196 Blue Diamond
    edited Dec 14, 2012 11:35PM
    user12025482 wrote:
    Hi Colleagues,
    our developers created application which uses method getconnection to connect database by jdbc thin client. During normal workload on DB machine everything is ok, but when disk are 100% busy on DB, application cannot establish connection to database (getconnection hang for few minutes and finnally it will connect) but sqlplus could connect at once.
    I've tested this behavior on different machines and with different java version (1.5, 1.6).
    Do you know why jdbc thin client cannot connect to DB server during heavy workload?
    Thanks for any suggestions.
    Oracle RDBMS does not know or care about different "flavor" (JDBC, OCI, ODBC, etc.) of client.
    is application 3-tier?
    does application use connection pooling?
    I suspect problem is with the application & NOT Oracle DB itself.
  • Osama_Mustafa
    Osama_Mustafa Member Posts: 6,086 Gold Trophy
    Please open it in the right Section ,


    Also Refer to :
    JDBC Connection Hang [ID 1140473.1]
    How to Configure JDBC Connections that are Hanging on the Socket Thread? [ID 371467.1]
    Console Hangs when trying to reset JDBC Connection pool [ID 822234.1]
This discussion has been closed.