Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

calling Stored Procedure in DB2 thru JDBC

 
Deepika Wadhwa
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is better approach for executing the stored procedure if we use either Prepared Statement or Callable statement ?

Is there any performance difference ???

Thanks in advance
Deepika
 
VS Prapoorna
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Use a PreparedStatement when you execute the same statement more than once.
Use CallableStatement to execute stored procedures. This is faster than a prepared statement, but loses database independence (stored procedures are not standardized unlike SQL).
I think this explanation might helpful.
Regards,
Sarada Prapoorna.V
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Prapoorna"
Your name does not comply with the JavaRanch naming standard described at http://www.javaranch.com/name.jsp
I also notice that you have changed your name from a valid name to this invalid name. Please change it back, since your account will be locked otherwise.
Dave
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic