• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

weblogic server connection pool problem

 
Balasubramaniam Arumugam
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Recently we have changed oracle oci8 driver instead of thin driver.
After that we are geting errors linke this.
weblogic server 6.1 sp4 becomes dead slow.
can anybody.
-----------------------------------
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
] at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
] weblogic.common.ResourceException: No available connections in pool ESAUTH32
] at weblogic.common.internal.ResourceAllocator.reserve(ResourceAllocator.java:578)
] at weblogic.common.internal.ResourceAllocator.reserve(ResourceAllocator.java:405)
] at weblogic.common.internal.ResourceAllocator.reserveNoWait(ResourceAllocator.java:373)
] at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:165)
] at weblogic.jdbc.common.internal.ConnectionPool.reserveNoWait(ConnectionPool.java:126)
] at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:194)
-------------------------------------------------
 
Ajith Kallambella
Sheriff
Posts: 5782
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to BEA/Weblogic forum...
 
Rahul Mahindrakar
Ranch Hand
Posts: 1869
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Increase your pool size or your connections are leaking
No available connections in pool ESAUTH32
 
Valery Anciaux
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
You might want to use the 'monitor connections' from the console to check for not closed connections.
Seems that you don't close your connections systematically.
Maybe the way connections are released (or not released) have something to do with the driver you are using.
Normally, an OCI driver should not be slower than a thin, anyway.
Val�ry
 
Balasubramaniam Arumugam
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
and this is the exception which I get frequently.

java.rmi.RemoteException: Transaction Rolledback.; nested exception is:
weblogic.transaction.internal.TimedOutException: Transaction has timed out when making request to XAResource 'ncs_domainXAPool'.>
java.rmi.RemoteException: EJB Exception:; nested exception is:
java.rmi.RemoteException: Transaction Rolledback.; nested exception is:
weblogic.transaction.internal.TimedOutException: Transaction has timed out when making request to XAResource 'ncs_domainXAPool'.
java.rmi.RemoteException: Transaction Rolledback.; nested exception is:
weblogic.transaction.internal.TimedOutException: Transaction has timed out when making request to XAResource 'ncs_domainXAPool'.
weblogic.transaction.internal.TimedOutException: Transaction has timed out when making request to XAResource 'ncs_domainXAPool'.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic