Bug #26143 DEFINER='xxx' result in NPE during prepareCall()
Submitted: 7 Feb 2007 11:39 Modified: 8 Feb 2007 7:15
Reporter: Klaus Halfmann Email Updates:
Status: Can't repeat Impact on me:
Category:Connector / J Severity:S3 (Non-critical)
Version:5.0.4 OS:Any (ANY)
Assigned to: CPU Architecture:Any

[7 Feb 2007 11:39] Klaus Halfmann

Trying to call a PROCEDURE with DEFINE=''
results in a 


How to repeat:
Given the follwing Declaration:

       COMMENT ''
	SELECT I * 10;

The follwoing code:

MysqlConnectionPoolDataSource myDs = new MysqlConnectionPoolDataSource();
myDs.setServerName  ("localhost");
myDs.setPassword    ("ucs");
myDs.setUser        ("ucs");
Connection        con = myDs.getConnection();

results in
Exception in thread "main" java.lang.NullPointerException
	at com.mysql.jdbc.StringUtils.indexOfIgnoreCaseRespectQuotes(StringUtils.java:959)
	at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1296)
	at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:3670)
	at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:702)
	at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:513)
	at com.mysql.jdbc.Connection.parseCallableStatement(Connection.java:4422)
	at com.mysql.jdbc.Connection.prepareCall(Connection.java:4496)
	at com.mysql.jdbc.Connection.prepareCall(Connection.java:4470)
	at SPTest.main(SPTest.java:22)

Suggested fix:

- No Idea - depends on some MetaData parsing ?
Look in com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes
[7 Feb 2007 20:51] Mark Matthews
I just tested this with the HEAD of 5.0, and can't repeat it (there's some fixes for just this area of code in HEAD).

Could you test with your stored procedure using a nightly snapshot of 5.0 from http://downloads.mysql.com/snapshots.php#connector-j please?
[8 Feb 2007 7:15] Klaus Halfmann
#1 Much better error message, you now can drop my Feature Request:

java.sql.SQLException: User does not have access to metadata required to determine stored procedure parameter types. If rights can not be granted, configure connection with "noAccessToProcedureBodies=true" to have driver generate parameters that represent INOUT strings irregardless of actual parameter types.

  mysql-connector-java-5.0-nightly-20070208-bin.jar fixed it.

Thanks for your prompt response.

(I hope the security model for StoredProcedures will be refined in 5.1.
 As it is now its OK for us but not in general)