aspose file tools*
The moose likes JDBC and the fly likes MySQL 5.0 and stored procedures.. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySQL 5.0 and stored procedures.." Watch "MySQL 5.0 and stored procedures.." New topic
Author

MySQL 5.0 and stored procedures..

Balaji Loganathan
author and deputy
Bartender

Joined: Jul 13, 2001
Posts: 3150
Hi,
Have anyone tried using stored procedure in mysql 5.0?.
I am quite familiar in using stored procedure with MS sql server, but somehow i am always getting "check your syntax error" in mysql 5.0 while trying stored procedure.

If you some good links that you have tried already, please let me know.
Cheers
Balaji


Spritle Software Blogs
Talhah Mafawalla
Greenhorn

Joined: Nov 05, 2006
Posts: 24
Hi Balaji,

You can try searching for stored procedures on the following link:
http://dev.mysql.com/doc/refman/5.0/en/

Or download the MySQL documentation on this link:
http://dev.mysql.com/doc/index.html

Hope this helps
Mathias Nilsson
Ranch Hand

Joined: Aug 21, 2004
Posts: 367
A test




.. Works. Every line must end with ;


SCJP1.4
Balaji Loganathan
author and deputy
Bartender

Joined: Jul 13, 2001
Posts: 3150
Hi Mathias,
Thanks for the test code. Sorry for my late reply.
I still couldn't able to get through with it. I am using windows mysql administrator connected to redhat mysql5.0.

If i have a simple table called "Employee" with two columns Name & Age
Table: Employee
Column1: Name - VARCHAR(255)
Column2: Age - INT

then how would the stored procedure for inserting datas will look like ?
Balaji Loganathan
author and deputy
Bartender

Joined: Jul 13, 2001
Posts: 3150
Finally i got it working, i will soon write here how i did it.
Balaji Loganathan
author and deputy
Bartender

Joined: Jul 13, 2001
Posts: 3150
Originally posted by Balaji Loganathan:
Finally i got it working, i will soon write here how i did it.

Well here is a very well written document.. http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.pdf
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQL 5.0 and stored procedures..
 
Similar Threads
Callling Stored Procedures from CMP
Stored Procedure Problem
Miliceconds + Group By (Interval of 5 Seconds)
turn on / off db constraints -
getting the resultset of a stored procedure?