3 messages in com.mysql.lists.javaRe: Error in call procedure| From | Sent On | Attachments |
|---|---|---|
| Jose Alanya | 18 Feb 2004 11:23 | |
| Mark Matthews | 18 Feb 2004 11:36 | |
| Jose Alanya | 18 Feb 2004 12:23 |
| Subject: | Re: Error in call procedure |
|---|---|
| From: | Mark Matthews (ma...@mysql.com) |
| Date: | 02/18/2004 11:36:37 AM |
| List: | com.mysql.lists.java |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Jose Alanya wrote:
Hello,
I need to call procedure example :
Class.forName("com.mysql.jdbc.Driver");
Connection c =
DriverManager.getConnection("jdbc:mysql://jalanya:3306/sigeprdev?user=root&password=root","", "");
CallableStatement cllstatement = c.prepareCall("{call get_usr(?)}"); cllstatement.setString(1, "JALANYA"); cllstatement.execute(); c.close();
System.out.println("OK");
and execute my class and show error !
java.lang.StringIndexOutOfBoundsException: String index out of range: -9 at java.lang.String.substring(String.java:1444) at com.mysql.jdbc.DatabaseMetaData$TypeDescriptor.<init>(DatabaseMetaData.java:7031) at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:6615) at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:2637) at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:904) at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:72) at com.mysql.jdbc.Connection.prepareCall(Connection.java:999) at com.mysql.jdbc.Connection.prepareCall(Connection.java:978) at invest.mysql.i.IUsrRO.main(IUsrRO.java:36) Exception in thread "main"
Help me please. Regards.
Joseph
Joseph,
What is the output of "SHOW PROCEDURES LIKE 'get_usr'", issued from the command-line client?
-Mark
- -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com
Meet the MySQL Team! April 14-16, 2004 http://www.mysql.com/uc2004/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAM77btvXNTca6JD8RAiTGAKCadOIXCP/2Qs7TZfrpbqE5SoF2HACfdP5w lDE4LTh994X+e+rOFWMOC6k= =XjDo -----END PGP SIGNATURE-----