Re: MySQL and Java - problems with stored proc OUT params
Posted by: Todd Farmer
Date: November 27, 2012 11:23AM

Hi John,

The "org.gjt.mm.mysql.Driver" class exists for legacy code compatibility, best to use "com.mysql.jdbc.Driver" instead. But that's not relevant to your problem.

Can you provide the example code where you attempt to register the parameter? Also, look at the actual stored procedure definition. Is the first parameter truly defined as an OUT parameter? You can post the output of the following, if so:

mysql> SELECT * FROM information_schema.parameters WHERE SPECIFIC_SCHEMA = '<your routine schema name here.' AND SPECIFIC_NAME = '<your routine name here.'\G

Best regards,

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL and Java - problems with stored proc OUT params
November 27, 2012 11:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.