Forums Register Login

Access Stored Procedures in MSSQL and MySQL

+Pie Number of slices to send: Send
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!
+Pie Number of slices to send: Send
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.
Every snowflake is perfect and unique. And every snowflake contains a very tiny ad.
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 727 times.
Similar Threads
stored procedure doubt??
Looking for Java /MySQL /Jboss Developer 4-28-04
sql query based on variable number of input parameters
changing from MSSQL to MySQL
IDENTITY_INSERT
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 07:46:36.