This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Access Stored Procedures in MSSQL and MySQL 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 "Access Stored Procedures in MSSQL and MySQL" Watch "Access Stored Procedures in MSSQL and MySQL" New topic
Author

Access Stored Procedures in MSSQL and MySQL

Timothy Sam
Ranch Hand

Joined: Sep 18, 2005
Posts: 746
Hi, I'm sorry if this is a little vampiric... Please tell me how to access MSSQL or MySQL and MySQL stored procedures using JDBC. Thanks a lot guys!


SCJP 1.5
http://devpinoy.org/blogs/lamia/ - http://everypesocounts.com/
Maximilian Xavier Stocker
Ranch Hand

Joined: Sep 20, 2005
Posts: 381
vampiric?!?

Anyway CallableStatement is what you want. So instead of the Connection.prepareStatement method your code was using you would use Connection.prepareCall instead.

Look at http://java.sun.com/docs/books/tutorial/jdbc/basics/storedprocedures.html and consult the documentation for your database/driver for more information.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Access Stored Procedures in MSSQL and MySQL
 
Similar Threads
sql query based on variable number of input parameters
IDENTITY_INSERT
Looking for Java /MySQL /Jboss Developer 4-28-04
changing from MSSQL to MySQL
stored procedure doubt??