• Post Reply Bookmark Topic Watch Topic
  • New Topic

start time for a CallableStatement

 
Grace Green
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


How could I get the time at which the CallableStatement starts executing ?



The only option I know of is to make another db call to get the sysdate (select sysdate from dual) right before executing the CallableStatement.
ANy other good option ? Thanks
 
Jan Cumps
Bartender
Posts: 2620
14
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You could use java.util.Date, or System.currentTimeMillis(), or System.nanoTime()
 
Madhan Sundararajan Devaki
Ranch Hand
Posts: 312
Java MS IE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I believe, you can store the start time and end time within the callable entity and return it.
 
Sudheer Bhat
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why not log the time in the callable stored function/procedure? Put this as the first executable statement in the callable routine.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!