MySQL and Java - problems with stored proc OUT params
Posted by: John Dexter
Date: November 26, 2012 06:39AM

I've run into a problem where Java won't let me call CallableStatement.registerOutParameter, I get an SQLException "Parameter number 1 is not an OUT parameter" which seems to be related to this bug: http://bugs.mysql.com/bug.php?id=17898

I'm new to MySQL (though I do know SQL quite well) and didn't follow all the discussions in that bug, and I don't really understand the different drivers available for use with Java, but I think my question is whether changing the driver I use could help?

I am using mysql-connector-java-5.1.18-bin.jar, with driver string "org.gjt.mm.mysql.Driver". Only because these were what I found in a sample project I worked from, not because I have a special preference for them.

Maybe this even belongs in the noob forum section but I hope someone can help me out.

Options: ReplyQuote


Subject
Written By
Posted
MySQL and Java - problems with stored proc OUT params
November 26, 2012 06:39AM


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.