Thanks for your help!!But there exists another problem,when i execute the command:mysql> CREATE PROCEDURE p1() -> BEGIN -> execute immediate 'SELECT btrkommii FROM rptsys.phyitemname'; -> END;ERROR 1064 (42000):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'execute immediate 'SELECT btrkommii FROM rptsys.phyitemname';END' at line 3
使用root用户登录mysql server, 运行如下语句: GRANT SELECT ON mysql.proc TO 'yourUser'@'localhost'之后,再次运行Java程序,ok,一切正常。 我終于找到答案了
-> BEGIN
-> execute immediate 'SELECT btrkommii FROM rptsys.phyitemname';
-> END;ERROR 1064 (42000):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'execute immediate 'SELECT btrkommii FROM rptsys.phyitemname';END' at line 3
GRANT SELECT ON mysql.proc TO 'yourUser'@'localhost'之后,再次运行Java程序,ok,一切正常。
我終于找到答案了