setMaxRows() out of range

msampson · December 7, 2004, 5:27pm

I get this error when a client logs into servoy server.

java.sql.SQLException: setMaxRows() out of range. 2147483647 > 50000000. 
Couldn't get the default messages 
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: setMaxRows() out of range. 2147483647 > 50000000. setMaxRows() out of range. 2147483647 > 50000000.

Clients working with the server often stop working at random. Does anyone know what causes this error? I had been getting this error before I upgraded to the newest version of servoy. Then it stopped happening for about a month. Now its doing it again.

below is my entire server log right after starting the server and loging in with one client.

Loading servoy.properties from C:\Documents and Settings\Administrator\servoy.properties 
Loading - Done 
Using RMI registry on port 1099 
Loading servoy.properties from C:\Documents and Settings\Administrator\servoy.properties 
Loading - Done 
java.sql.SQLException: setMaxRows() out of range. 2147483647 > 50000000. 


java.sql.SQLException: setMaxRows() out of range. 2147483647 > 50000000.
	at com.mysql.jdbc.Statement.setMaxRows(Statement.java:450)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
	at $Proxy0.setMaxRows(Unknown Source)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.setMaxRows(DelegatingPreparedStatement.java:186)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.setMaxRows(DelegatingPreparedStatement.java:186)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.setMaxRows(DelegatingPreparedStatement.java:186)
	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source)
	at com.servoy.j2db.Messages.loadMessagedFromDatabase(Unknown Source)
	at com.servoy.j2db.Messages.loadMessagedFromDatabase(Unknown Source)
	at com.servoy.j2db.server.servlets.MessagesServlet.doGet(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:748)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011)
	at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106)
	at java.lang.Thread.run(Unknown Source)

Couldn't get the default messages 
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: setMaxRows() out of range. 2147483647 > 50000000. setMaxRows() out of range. 2147483647 > 50000000. 

com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: setMaxRows() out of range. 2147483647 > 50000000. setMaxRows() out of range. 2147483647 > 50000000.
	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source)
	at com.servoy.j2db.Messages.loadMessagedFromDatabase(Unknown Source)
	at com.servoy.j2db.Messages.loadMessagedFromDatabase(Unknown Source)
	at com.servoy.j2db.server.servlets.MessagesServlet.doGet(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:748)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011)
	at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106)
	at java.lang.Thread.run(Unknown Source)

msampson · December 7, 2004, 6:41pm

I just upgraded to the very newest version of servoy server, version R2 2.1.2-build315, java ersion 1.4.2_05_b04, with windows 2000. I have not gotten this error since, but I expect it will come back.

jcompagner · December 7, 2004, 11:52pm

no it will not come back
which version did you use? Because this is fixed a some builds ago.

msampson · December 8, 2004, 4:52pm

I had been using version Version R2 2.1.1-build 313 (Windows 2000), and whatever version I was using before that one gave me the same problem.

Topic		Replies	Views
Error when trying to create 3.5.1. repository on Vista Classic Servoy	2	3086	October 16, 2007
I18N and MySQL don't play well together? Classic Servoy	6	2844	October 28, 2004
HELP SERVOY ...Cant Connect to The App Server Classic Servoy	19	16330	March 13, 2009
Updating to 2.2.4 causes Indexoutofboundsexception Classic Servoy	1	1318	May 29, 2006
Tools>Security bug on Oracle Classic Servoy	14	13004	August 23, 2004

setMaxRows() out of range

Related topics