MySQL Forums :: JDBC and Java :: MySQL and Java - problems with stored proc OUT params

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.

Navigate: Previous Message•Next Message

Options: Reply•Quote

Subject	Written By	Posted
MySQL and Java - problems with stored proc OUT params	John Dexter	11/26/2012 06:39AM
Re: MySQL and Java - problems with stored proc OUT params	Todd Farmer	11/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.