Does anyone have any sort of any idea on how to deal with this problem?
This is happening again and again and not all the time but randomly anytime.--Regards,Manasi Save
On Wed, 02 Jun 2010 06:46:56 -0400, Manasi Save
wrote:
Dear Venugopal, Here's the Sample
Java Code Which Calls stored procedur
Dear Venugopal, Here's the Sample Java Code Which Calls
stored procedure :- //get the connection to databaseConnection dbConnection = getConnection(); //create the call
for procedureString procedureCallStmtStr = "Call XYZ()"; //create callable statement objectCallableStatement cs =
conn.prepareCal
Stored procedures are not executed like a query.
They are executed thru a Call { procedure} method.
Please check the same or let us know how you are executing the Query/Calling
the Procedure.
Regards,
VR Venugopal Rao
--- On Fri, 28/5/10, Manasi Save wrote:
From: Manasi Save
Subject: Stran
mysql Version :- 5.1.42-community-log
mysql Connector/J Version :- mysql-connector-java-5.1.6-bin.jar
Sample Java Code Which Calls stored procedure :-
//get the connection to database
Connection dbConnection = getConnection();
//create the call for procedure
String procedureCallStmtStr =
Hello Manasi,
If possible can you please send in the code that you mentioned (procedure or
trigger).
Please give a detailed technical explanation explaining the query which you
used from command line and the query used in the procedure. Please mention
the table structure, show table status and fe
2010/5/28 Manasi Save :
[...]
> Or am I doing something wrong?
probably;
you better send us another e-mail writing at least:
- mysql version you are using
- mysql Connector/J version you are using
- piece of java code you are using to call the stored procedure
- source of the stored procedure (or