Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem in CallableStatement

 
Meet Gaurav
Ranch Hand
Posts: 492
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Am trying to call this one..

CallableStatement calll = conn.prepareCall("{call test(?,?,?,?,?)}");
...
...
boolean result = calll.execute();

In side this procedure am updating some tables. After executing this statement am getting the result as false. But the procedure is executed sucessfully and all the tables are updated correctly..

Please assist Me.
 
Raghavan Muthu
Ranch Hand
Posts: 3381
Mac MySQL Database Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Meet Gaurav:


In side this procedure am updating some tables. After executing this statement am getting the result as false. But the procedure is executed sucessfully and all the tables are updated correctly..


By looking at the Java Doc of the execute() method of PreparedStatement class, it says the following.




It does NOT really indicate a *failure* of execution.

Hope this helps!
[ October 31, 2008: Message edited by: Raghavan Muthu ]
 
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!