wood burning stoves 2.0*
The moose likes JDBC and the fly likes java/mysql/stored proc/parameters Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java/mysql/stored proc/parameters" Watch "java/mysql/stored proc/parameters" New topic

java/mysql/stored proc/parameters

Miran Cvenkel
Ranch Hand

Joined: Nov 23, 2010
Posts: 147
looking at this: http://www.java2s.com/Code/Java/Database-SQL-JDBC/StoredprocedurewithInputOutputparmsandaResultSet.htm

1. There are 6 parameters, 3 in 3 out ?
2. why is there then seven '?' ? That is, what first '?' stands for ?
3. why is indexing started at 2 ?

I presume valid mysql proc for that would be something like that (parameters in that order) ?

Searchable nature photo gallery: http://agrozoo.net/jsp/Galery.jsp?l2=en
Don't get me started about those stupid light bulbs.
subject: java/mysql/stored proc/parameters
Similar Threads
batch updating mysql
setting the null and getting null
Number of parameters in CallableStatement is less than the number of arguments in SP
how to store image object
The Network Adapter Could not establish the Connection....