| Bug #22024 | Stored Procedure mal formation | ||
|---|---|---|---|
| Submitted: | 5 Sep 2006 17:34 | Modified: | 19 Sep 2006 3:48 |
| Reporter: | thrash putopunto | ||
| Status: | Closed | ||
| Category: | Connector/J | Severity: | S3 (Non-critical) |
| Version: | mysql-connector-java-5.0.0-beta-bin | OS: | Linux (Gentoo Linux) |
| Assigned to: | Target Version: | ||
| Tags: | stored procedure parenthesis enter | ||
[13 Sep 2006 11:07]
Tonci Grgin
Hi Thrash and thanks for your bug report. Verified as described by reporter.
[13 Sep 2006 16:43]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/11855

Description: Sorry, I dont speak english... ---------------------------------------------- CREATE PROCEDURE foo ( ) BEGIN -- (...) END ---> Message: Internal error when parsing callable statement metadata (unknown output from 'SHOW CREATE PROCEDURE') ---------------------------------------------- CREATE PROCEDURE foo () BEGIN -- (...) END ---> OK! How to repeat: Foo.java String driverStr = "org.gjt.mm.mysql.Driver"; static String url = "jdbc:mysql://localhost/ACCESO_EJB"; Class.forName("org.gjt.mm.mysql.Driver"); Connection con = DriverManager.getConnection(url, "foo", "xxx"); CallableStatement sentencia = con.prepareCall("{call foo_proc()}"); ResultSet rs = sentencia.executeQuery(); -------------------------------------------------- Foo.sql CREATE PROCEDURE foo ( ) BEGIN -- (...) END