This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Retrieve Stored Procedure Code Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Retrieve Stored Procedure Code" Watch "Retrieve Stored Procedure Code" New topic
Author

Retrieve Stored Procedure Code

Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15286
    
    6

Is there a way to retrieve the actual sql code from a stored procedure in MySQL. Also, is there a way to get the names of all the stored procedures in a database without knowing them?


GenRocket - A Test Data Generation Platform
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Gregg
Check out the getProcedures method of the DatabaseMetaData class. It lloks like ti might return the actual code too.
hope that is what you were looking for.


Dave
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15286
    
    6

Dave my savior. Thank you very much.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Retrieve Stored Procedure Code
 
Similar Threads
OracleCallableStatement Problem
Transaction Management Query
OUT parameter
Stored procedure question
VARBINARY in sp -how-to