Search...
FAQs
Subscribe
Pie
FAQs
Recent topics
Flagged topics
Hot topics
Best topics
Search...
Search within JDBC and Relational Databases
Search Coderanch
Advance search
Google search
Register / Login
Forums
Register
Login
Databases
»
JDBC and Relational Databases
Access Stored Procedures in MSSQL and MySQL
Timothy Sam
,
Ranch Hand
Apr 15, 2006 20:11:00
(0 cow)
(0 skulls)
+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!
Maximilian Xavier Stocker
,
Ranch Hand
Apr 16, 2006 12:33:00
(0 cow)
(0 skulls)
+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.
Post by:
autobot
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
.