jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Stored procedures.. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: http://aspose.com/file-tools
subject: Stored procedures..
It's not a secret anymore!