topic Open reference for QueryResult in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/open-reference-for-queryresult/m-p/102482#M71320 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I am using web services API in the next code</SPAN><BLOCKQUOTE class="jive-quote">// Execute the query to get all devies<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QueryResult queryResult = repositoryService.query( ClientConstants.STORE, devicesQuery, true);&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Display the results<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ResultSet resultSet = queryResult.getResultSet();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ResultSetRow[] rows = resultSet.getRows();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (rows == null)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; logger.error( "No Devices found!!! Can it be ??");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for ( int i = 0; i &lt; rows.length; i++)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; h = General.getStringQueryResults( rows<EM>);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;String deviceId = h.get( ClientConstants.DEVICE_ID);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;if ( deviceId == null || deviceId.equals( ClientConstants.STR_EMPTY))<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;continue;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String[] devicesParameters = new String[2];<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //first place is for default devie name<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; devicesParameters[0] = new String( h.get( ClientConstants.DEFAULT_DEVICE));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //second place fo user agent<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; devicesParameters[1] = new String( h.get( ClientConstants.USER_AGENT));<BR />&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tmpDevices.put( deviceId, devicesParameters);&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; logger.debug( "Device Loaded. Device Id=" + deviceId + ", default device=" + devicesParameters[0] + ", user agent=" + devicesParameters[1]);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }//for&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }//if-else<BR /></EM></BLOCKQUOTE><BR /><SPAN>I get the response and fill my objects. I have no reference in my code&nbsp; for the response object that I got from alfresco but the memory does not get released (not even after System.gc() direct call). This cause our program to use too much memory. Does any one face this issue before? Do I need to release it some how?</SPAN><BR /><BR /><SPAN>Thx alot,</SPAN><BR /><SPAN>Itay</SPAN></BODY></HTML> Sun, 05 Aug 2007 11:17:16 GMT itayh 2007-08-05T11:17:16Z Open reference for QueryResult https://connect.hyland.com/t5/alfresco-archive/open-reference-for-queryresult/m-p/102482#M71320 Hi,I am using web services API in the next code// Execute the query to get all devies&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QueryResult queryResult = repositoryService.query( ClientConstants.STORE, devicesQuery, true);&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Display the results&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ResultSet resultSet = queryResult.getResultSet();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ResultS Sun, 05 Aug 2007 11:17:16 GMT https://connect.hyland.com/t5/alfresco-archive/open-reference-for-queryresult/m-p/102482#M71320 itayh 2007-08-05T11:17:16Z Re: Open reference for QueryResult https://connect.hyland.com/t5/alfresco-archive/open-reference-for-queryresult/m-p/102483#M71321 <HTML><HEAD></HEAD><BODY><SPAN>I think there may be a close method on the QueryResult and/or the ResultSet</SPAN></BODY></HTML> Sun, 05 Aug 2007 16:17:37 GMT https://connect.hyland.com/t5/alfresco-archive/open-reference-for-queryresult/m-p/102483#M71321 mark_smithson 2007-08-05T16:17:37Z Re: Open reference for QueryResult https://connect.hyland.com/t5/alfresco-archive/open-reference-for-queryresult/m-p/102484#M71322 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>No this is nothing I've noticed before.&nbsp; The ResultSet object is a generated Axis stub, perhaps there is an issue with Axis.</SPAN><BR /><BR /><SPAN>It may be worth while logging this as an issue in Jira to ensure the fix is appropriatly prioritised. (</SPAN><A href="http://issues.alfresco.com" rel="nofollow noopener noreferrer">http://issues.alfresco.com</A><SPAN>)</SPAN><BR /><BR /><SPAN>Cheers,</SPAN><BR /><SPAN>Roy</SPAN></BODY></HTML> Mon, 06 Aug 2007 11:00:09 GMT https://connect.hyland.com/t5/alfresco-archive/open-reference-for-queryresult/m-p/102484#M71322 rwetherall 2007-08-06T11:00:09Z Re: Open reference for QueryResult https://connect.hyland.com/t5/alfresco-archive/open-reference-for-queryresult/m-p/102485#M71323 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>Thx for your responses.</SPAN><BR /><SPAN>I notice that the memory get free after 60 seconds.</SPAN><BR /><SPAN>Maybe it is related to 60 seconds timeout in RepositoryServiceSoapBindingStub?</SPAN><BR /><BR /><SPAN>Thx,</SPAN><BR /><SPAN>&nbsp; Itay</SPAN></BODY></HTML> Tue, 07 Aug 2007 06:31:05 GMT https://connect.hyland.com/t5/alfresco-archive/open-reference-for-queryresult/m-p/102485#M71323 itayh 2007-08-07T06:31:05Z