my dog learned polymorphism*
The moose likes JDBC and the fly likes Stored procedures.. 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 "Stored procedures.." Watch "Stored procedures.." New topic

Stored procedures..

vgs lemu

Joined: May 12, 2005
Posts: 2
I have not used stored procedures in JDBC before..
Can anyone brief me on this? (creation, calling, examples, etc.)
Any link or reference will also be helpful.
Arjunkumar Shastry
Ranch Hand

Joined: Feb 28, 2005
Posts: 986
You can create/call stored procedure from java program.While calling stored procedure,first get Connection,then connection.prepareCall("{ call <name of stored procedure>(?,?) }");"?" represents IN parameter if you want to pass argument to stored procedure if any.connection.prepareCall() will return CallableStatement which is subinterface of PreparedStatement.

Namma Suvarna Karnataka
I agree. Here's the link:
subject: Stored procedures..
Similar Threads
How to call a stored procedure from java
JasperReports and Stored Procedures
Comparing database schemas
Stored Procedures
diff b/w stored proc and triggers