Re: weird error in my JDBC code

[scott]

that does not work at all. If I remove the CALL key word, the program fails at the prepareCall() method call, if I don't it fails at the execute() method call.

so, this is the full java class:

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Types;

public class MysqlTest
{
public static void main(String[] args) throws Exception
{

DriverManager.registerDriver( new com.mysql.jdbc.Driver());
Connection m_conn = DriverManager.getConnection ("jdbc:mysql://localhost/survey","survey","survey");
m_conn.setAutoCommit(false);

String l_initUserSQL = "call init(?, ?);";

CallableStatement l_cstmt = m_conn.prepareCall(l_initUserSQL);

l_cstmt.setString(1,"jirUser");


l_cstmt.registerOutParameter(2,Types.INTEGER);

try
{
l_cstmt.execute();
}
catch(SQLException e)
{
e.printStackTrace();
}

}
}

and this is the stored procedure:

CREATE PROCEDURE `init`(IN `p_subjectName` VARCHAR(192), OUT `srcfid` INTEGER)
BEGIN
set srcfid = 30;
END


anything I am doing wrong here? Or this is just a very basic bug in MYSQL code?