Try this is a pattern for LOOP/READNEXT on a collection without sucking down all the data in 1
stmt1 = conn1.createStatement();
rs1 = stmt1.executeQuery("SELECT * FROM department)
To get a list of installed apps in windows 7- in case of a complete system re-build.
1. Open command prompt with admin rights. That is, type in cmd either in Start menu search box or in Run dialog box and hit Ctrl + Shift +Enter to open the command prompt with admin rights.Alternatively you can also go to All Programs > Accessories and right-click on Command Prompt and select Run as administrator.
2. Click continue button if you get User Account Control (UAC) Prompt.
3. Here in the Command Prompt, type WMIC and hit enter. Once you type hit enter to see below message.
4. Next, you need to type the following command:
/output:C:\InstallList.txt product get name,version
Where “C” is the drive letter where Windows will store the installed applications list. You can also change the name of the output file and drive letter if you want to modify the output location. Also note that this trick should work in Windows 2000 & XP operating systems without problems.
This gem copied from: http://www.intowindows.com & the following from : http://www.helpdeskgeek.com
"open the Command Prompt as Administrator". To do this in Windows 7 or Windows Vista, enter “cmd” (without the quotes) in the Search Programs and Files box on the Start menu. The cmd.exeprogram should automatically be highlighted in the Programs section of the results. Press Ctrl + Shift + Enter to opencmd.exe as Administrator.
You can also open the Command Prompt as Administrator in Windows 7 or Windows Vista by opening All Programs | Accessories on the Start menu. Right-click on the Command Prompt shortcut and select Run as administrator from the popup menu.
If you are using Windows XP, open All Programs | Accessories on the Start menu. Right-click on the Command Promptshortcut and select Run as from the popup menu.
Use this link to download the current version of Kaspersky Endpoint.