MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: statement.setMaxRows() doesn't work when calling a stored procedure
Posted by: Andreas Wederbrand
Date: November 23, 2012 02:09PM

Actually, after reading through the connector source, I found that it issues SET sQL_SELECT_LIMIT, as you say. And I found that MySQL doesn't use this when executing stored routines.

http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_sql_select_limit

I still consider this a bug but I haven't found in the JDBC specifications how setMaxRows() is supposed to work so I don't think that the JDBC contract is brooken.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
statement.setMaxRows() doesn't work when calling a stored procedure
Andreas Wederbrand
November 22, 2012 03:36AM
Re: statement.setMaxRows() doesn't work when calling a stored procedure
Mark Matthews
November 22, 2012 09:58AM
Re: statement.setMaxRows() doesn't work when calling a stored procedure
Andreas Wederbrand
November 23, 2012 02:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.