Skip navigation links

MySQL Forums :: JDBC and Java :: Calling Procedure() from java


Advanced Search

Calling Procedure() from java
Posted by: Anil Patimalla ()
Date: October 23, 2009 10:25AM

While I am Executing a Procedure from java,Its Type of String Containing Procedure
This is My Coding Part :
CallableStatement callStmt = con.prepareCall(eQuery);
boolean proc1 = callStmt.execute();
callStmt.close(); callStmt = null;
callStmt = con.prepareCall("{call AnonymousProc()}");
boolean proc = callStmt.execute();

In the First Call the Procedure Gets Executed And for the Second call The Procedures Fires.and Does the Some Operations.

The Problem is When i am Using this Code in Stand Alone its Working fine.But If i Make use of the same in an Package Application .The Procedure Call in not Working.
stating that particular Procedure doesnt exisit.In my Application I have to Execute Number of Sql Files with Procedures.

if any one get me out of this ,

Thanks in Advance

Options: ReplyQuote


Subject Written By Posted
Calling Procedure() from java Anil Patimalla 10/23/2009 10:25AM


Sorry, only registered users may post in this forum.