wood burning stoves 2.0*
The moose likes JDBC and the fly likes Problem in  CallableStatement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem in  CallableStatement" Watch "Problem in  CallableStatement" New topic
Author

Problem in CallableStatement

Meet Gaurav
Ranch Hand

Joined: Oct 08, 2008
Posts: 492
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

Joined: Apr 20, 2006
Posts: 3344

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 ]

Everything has got its own deadline including one's EGO!
[CodeBarn] [Java Concepts-easily] [Corey's articles] [SCJP-SUN] [Servlet Examples] [Java Beginners FAQ] [Sun-Java Tutorials] [Java Coding Guidelines]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Problem in CallableStatement
 
Similar Threads
Error calling Stored Procedure "SELECT in a stored procedure must have INTO "
Problem in CallableStatement
callableStatement.execute()
%rowtype mapping in java
How to execute two SQL stmts. simulteneously ?