JDownloader.org – Terminal User Interface

Terminal User Interface

Conceptual Ideas

The idea about the terminal implementation is that on any computer (Windows, Linux, Linux server edition, Unix,…) the application can be ran the old-skool way, using command line aka terminals. The ideas explained on this page are only conceptual ideas so far. Implentation hasn’t started yet on this topic and even if it was those conceptual ideas stay conceptual.

Running JD

Continue reading “JDownloader.org – Terminal User Interface”

Rekomendasi Printer


Sedikit rekomendasi untuk printer rumahan. Kemarin baru saja beli printer Canon MP 287, cukup bagus dan sudah dilengkapi dengan sistem tinta infus. Setelah itu browsing2 tentang kriteria printer yang baik. Canon sendiri dengan thermal head print teknologi + infus sudah lebih dari cukup untuk penggunaan rumahan.Thermal print head menggunakan elemen panas untuk memuaikan dan mengeluarkan tinta dari catridge. Setelah menggunakan untuk keperluan pribadi ternyata kurang. Mengapa saya bisa katakan kurang? Continue reading “Rekomendasi Printer”



TFTP Firmware Upgrade
TFTP Server IP Address :
Image File Name : final.bin

http :

reboot :

ya ampun… nangis2 gw 1 jam-an.. untung akhirnya bisa juga diakali.. Alhamdulillah.

VBA Excel–Allow Paste Special Only

While recently answering a post on the MSDN forum, I realized that the Robert Gold(Vice President of Business Intelligence in Bostwick Laboratories, Inc) was facing the same problem that I was facing couple of years back when I was working as a Team Leader in one of the BPO’s. The MIS Department was reporting to me and one of the main jobs was to create “Trackers” for various departments. My team used to take hours to design a particular tracker only to realize after few days that the users were spoiling the format of the tracker by copying and pasting. Completely protecting it with a password was not the option. Nor did we find any option in Excel which forced selective pasting. It was then we devised this macro which allowed the user to paste but behind the scenes, converted that paste into paste special – values.

The only drawback of this method is that if the macros are disabled then this won’t work. But thanks to the IT Department, they ensured that the macros was enabled on each and every pc. After that we never faced a problem with users messing up the format of the sheet.

So how does this code work? What is the logic behind it? I would explain this in 3 sections.

  • Logic
  • Planting the Code
  • Code

Continue reading “VBA Excel–Allow Paste Special Only”

JDBC connection to very busy SQL 2000: selectMethod=cursor vs selectMethod=direct? – Stack Overflow


  1. selectMethod=cursor
    • theoretically requires more server-side resources than selectMethod=direct
    • only loads at most batch-size records into client memory at once, resulting in a more predictable client memory footprint
  2. selectMethod=direct
    • theoretically requires less server-side resources than selectMethod=cursor
    • will read the entire result set into client memory (unless the driver natively supports asynchronous result set retrieval) before the client application can iterate over it; this can reduce performance in two ways:
      1. reduced performance with large result sets if the client application is written in such a way as to stop processing after traversing only a fraction of the result set (with directit has already paid the cost of retrieving data it will essentially throw away; with cursorthe waste is limited to at most batch-size – 1 rows — the early termination condition should probably be recoded in SQL anyway e.g. as SELECT TOP or window functions)
      2. reduced performance with large result sets because of potential garbage collection and/or out-of-memory issues associated with an increased memory footprint

In summary,

  • Can using selectMethod=cursor lower application performance? — either method can lower performance, for different reasons. Past a certain resultset size, cursor may still be preferable. See below for when to use one or the other
  • Is selectMethod= an application-transparent setting on a JDBC connection? — it is transparent, but it can still break their app if memory usage grows significantly enough to hog their client system (and, correspondingly, your server) or crash the client altogether

Source: JDBC connection to very busy SQL 2000: selectMethod=cursor vs selectMethod=direct? – Stack Overflow