jdbc and Tomcat

[Vikas <vi...@yahoo.co.in>]

Hi I am making call to stored procedure on oracle using CallableStatement.After executing the statement when I am trying to return the result set using statement.getObject(1) it takes long time to return.This was on Tomcat server I tried same thing by making test bean and running it as standalone class.The time difference was almost around 100 secs Is the time difference due to the fact that i am using weberver or i am missing something. Please help. 

******
Viks
******
Catch all the cricket action. Download Yahoo! Score tracker

Re: jdbc and Tomcat

[Tomcat User <to...@secristfamily.com>]

Vikas wrote:

>Hi
>
>I have posted this message previously but I couldn't find the solution.I am posting this again to the community .pls suggest if anybody has faced such problem 
>
> 
>
> 
>
> I am making call to stored procedure on oracle using 
>CallableStatement.After executing the statement when I am trying to return the result 
>set using statement.getObject(1) it takes long time to return.This was 
>on Tomcat server I tried same thing by making test bean and running it 
>as standalone class.The time difference was almost around 100 secs Is 
>the time difference due to the fact that i am using weberver or i am 
>missing something. Please help. 
>
>
>Catch all the cricket action. Download Yahoo! Score tracker
>  
>
The fact that you are using a web server to run this method shouldn't be 
that significant of a difference.  I would look to other factors which 
may be causing this huge of a time delay... - such as:

    - How many other concurrent connections to the database does the web 
server have open at the same time your query is run.
    - Does your instance of Tomcat already take up large amounts of CPU 
resources (due to other things you are running).
    - Does the configuration of your Tomcat (regarding datasources) have 
to spend extra time looking up your datasource name that your standalone 
class didn't have to do?

Obviously, I can't answer these for you but it is where I would start.  
Since jdbc is rather thin, most everything you do runs on the database 
server, which means it doesn't (shouldn't) matter if you run your client 
code in your web server or not.

Randy


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

jdbc and Tomcat

[Vikas <vi...@yahoo.co.in>]

Hi

I have posted this message previously but I couldn't find the solution.I am posting this again to the community .pls suggest if anybody has faced such problem 

 

 

 I am making call to stored procedure on oracle using 
CallableStatement.After executing the statement when I am trying to return the result 
set using statement.getObject(1) it takes long time to return.This was 
on Tomcat server I tried same thing by making test bean and running it 
as standalone class.The time difference was almost around 100 secs Is 
the time difference due to the fact that i am using weberver or i am 
missing something. Please help. 


Catch all the cricket action. Download Yahoo! Score tracker