We are trying to  post some transactions to the database(just select and update), just handful  and getting delayed responses from the database using JDBC.


We are using WebSphere 7 and type 4 driver connecting to ORACLE back end.  These transactions run much faster  when run directly against database. DBA s argue that the transactions are processed faster but waiting on the client to   accept.  


Nothign is logged from WebSphere perspective in the System* logs regarding this issue. What sort of tracing can I enable on the Websphere to  get more information regarding this.


Thanks in advance      

Hi,

  I suggest the next traces
 
    *=info:WAS.j2c=all:RRA=all:Transaction=all

  MustGather: Connection pooling problems for WebSphere Application Server
  www-01.ibm.com/support/docview.wss?rs=18...
   and select Collecting data manually
    
  How to enable Oracle JDBC Driver tracing with WebSphere Application Server
  www-01.ibm.com/support/docview.wss?uid=s...
   
  How to Enable Oracle Universal Connection Pooling (UCP) in WebSphere Application Server
  www-01.ibm.com/support/docview.wss?uid=s...

  Configuring defaultRowPrefetch for an Oracle JDBC driver
  www-01.ibm.com/support/docview.wss?uid=s...  
   
  Hope this helps.
 
regards

Thanks Gabriel, I will try these out.