Programmer's Journal

Script to get your Windows Key

2016-04-16T17:02:00.002+08:00

I found the following article on how to obtain the Windows Key without installing any third party software. This is useful but may not be necessary to reinstall your windows should you want perform a fresh Windows install; especially for those who did a Windows 10 upgrade. The script is as follow: Set WshShell = CreateObject("WScript.Shell") MsgBox ConvertToKey(WshShell.RegRead("HKLM\SOFTWARE\

Java Web Tier Framework Comparison

2015-08-24T19:00:00.000+08:00

I found this old reference in my collection, not sure how much of this is still valid but thought of posting it here so it will not get loss. FrameworkDescriptionProsConsReference InfoLicensing GWTGoogle Web Toolkit (GWT) is an open source Java software development framework that makes writing AJAX applications easy for

Forward Mails Based on Search Criteria

2015-07-31T19:07:00.001+08:00

Have you ever wanted to forward all mails that matching a search expression? That option is not available through the Gmail interface but it is relatively easy to do that with a script. An example of the script is as follow: function forwardMail() { var threads = GmailApp.search("before:2009/07/01 after:2009/06/30"); // second search string. for (var i in threads) { &

Using MailApp.SendMail

2015-07-15T20:45:00.000+08:00

I thought that you could only MailApp.SendMail api in Google Script with standard parameter for example: MailApp.sendEmail(recipient, subject,body) However, I just realize that you just need to use braces to use other advance parameters. For example to add cc, you can do the following. function sendTestMail() { var toList = "strovek@gmail.com"; &

Useful Windows commands

2014-10-02T19:00:00.000+08:00

Received the following list of commands from a friend that can be run off from the Run Command Prompt:Program Run Command...Accessibility Controls = access.cplAccessibility Wizard = accwizAdd Hardware Wizard = hdwwiz.cplAdd/Remove Programs = appwiz.cplAdministrative Tools = control admintoolsAdobe Acrobat ( if installed ) = acrobatAdobe Distiller ( if installed ) = acrodistAdobe ImageReady ( if

Turning on Wifi for Windows using Command line

2014-07-08T19:34:00.000+08:00

The configuration on my notebook in the office automatically disables my wifi when I connect to our network by cable. On several occasions, the wifi dos not turn back on after I remove my PC from the docking station. I was also unable to find anything in the control panel on Windows 7 to help me do this, luckily, I found the solution from this article. The solution is shown below. An alternative

Limiting GApp search to a folder

2013-10-16T20:00:00.000+08:00

Found this trick in a discussion on the topic. This is a feature lacking in the new search operator. Click on folder so you are only viewing within the folder you want to search The URL in your browser location bar will change to something like:https://drive.google.com/?ui=4&authuser=0#folders/0B6AzksONG..... Copy the text from the URL which comes after "folders/" Insert that text instead

Java Script to Produce Proper Capitalization

2012-12-27T22:14:00.001+08:00

The code is as follow: /* * Title Caps * * Ported to JavaScript By John Resig - http://ejohn.org/ - 21 May 2008 * Original by John Gruber - http://daringfireball.net/ - 10 May 2008 * License: http://www.opensource.org/licenses/mit-license.php */ (function(){ var small = "(a|an|and|as|at|but|by|en|for|if|in|of|on|or|the|to|v[.]?|via|vs[.]?)"; var punct = "([!\"#$%&'()*+,./:;<=>?@[\\\\

JDBC Connection String to Use LDAP

2012-11-30T07:00:00.000+08:00

If LDAP allows anonymous. String ldapHost = "ldap-server:389"; String context = ",dc=nl,dc=abnamro,dc=com"; String serviceName = "mts-a-de-grid"; String user = "aldo"; String pass = "aldo"; String url = "jdbc:oracle:thin:@ldap://" + ldapHost + "/" + instance + ldap_context; OracleDataSource o = new OracleDataSource(); o.setUser(user);

sudo: /etc/sudoers is mode 0640, should be 0440

2012-10-19T18:30:00.000+08:00

If you encounter the following error, it is likely because you ran the su command while your current folder is /etc and the sudo is in the same folder. Reference: http://askubuntu.com/questions/189818/how-to-repair-sudo-etc-sudoers-is-mode-0640-should-be-0440

Retrieving JDBC version information

2012-10-17T19:00:00.000+08:00

The following is how you can retrieve the jdbc version: import oracle.jdbc.OracleConnection; import oracle.jdbc.pool.OracleDataSource; import java.sql.SQLException; import java.sql.DatabaseMetaData; import java.util.Properties; public class JDBCVersionInfo { public static void main(String[] args) { try { &

Allowing your netbook to go beyond 1024x600

2012-10-13T07:00:00.000+08:00

One of the issues for many netbooks is the max resolution allowed is 1024x600. Unfortunately, that prevents you from seeing and accessing part of the screen in many applications. The solution is as follow: 1) Run regedit2) Search and modify all values "Display1_DownScalingSupported" from "0" to "1"3) Restart the system4) Enjoy with the two new resolutions 1024x768 i 1152x864

Solution to Windows 7 unable to connect to Windows Service

2012-10-12T11:52:00.002+08:00

I encountered the following error after connecting to my DSL modem which failed to connect to internet. I had a disruption of service from my service provider. After the windows started up, everything was working but the task bar was all white. I am using Windows 7 Starter edition. The solution is as follow: Click on Start button. Type Cmd in the Start Search text box.&

Show Intel Proset Wifi Connection Utility icon on the Task Bar

2012-10-03T18:00:00.000+08:00

This will allow you to make the Intel ProSet Icon visible on your Task Tray. Click on the Windows Start button -> Intel PROSet Wireless -> Wifi Connection Utility In the Wifi Connection Utility, select Tools -> Application Settings Select show icon on the Task Bar. With the icon on the task tray, it will be much easier to select the profile you want to use to

JBoss Admin tutorial

2012-10-01T18:00:00.000+08:00

The tutorial for JBoss administration can be found here. One good info from the site is the JBoss Architecture, the following is the architecture for JBoss 5.

Locating your phone if it is under Google Device Policy

2012-09-28T09:18:00.001+08:00

If your company is using Google for Business and you have Google Device Policy App installed and enabled on your Android Phone. There is a page that will help you locate your phone. The url is: https://www.google.com/apps/mydevices/b/0?pli=1 Note, however, that this is possible only if you phone has recently connected to internet (wifi) and has GPS enabled There are also some options like

Taking a screenshot on your un-rooted Android Phone

2012-09-26T20:42:00.000+08:00

HTC Desire HD I found this by accident. This works with HTC Desire HD. I then did a search and found that the trick has been there all this while (since the 3.5 upgrade) I read that it is a feature in HTC Sense 3.5 and higher, not sure if similar function is available for non HTC phones. Press the standby/on button and the home button at the same time. Key thing to remember is

Blog on design by 37 signal

2012-09-11T18:00:00.000+08:00

I came across this site while reading some emails on copywriting. This blog is by a company called 37 signals. The site is found here. Some of the articles are as follow: Clarity over brevity in variable and method names Good Enough Nagios Monitoring Performance

Control output from PL/SQL

2012-09-01T09:30:00.000+08:00

Usually when I write a PL/SQL script and schedule it, there are certain things I want to generate and record into a log file. I usually do that using a pipe command. Assuming my program is in a file called comp.sql, I would then execute: sqlplus scott/tiger@orcl comp.sql >> comp.log Within the comp.sql, I will start with the following commands: SET TIMING ONSET

Executing dynamic code in PL/SQL

2012-08-31T18:00:00.000+08:00

This is a sample of how to execute a dynamic code to create a partition: PROCEDURE cre_part_tab (ptable IN VARCHAR2, ptag IN VARCHAR2, plim IN VARCHAR2) IS /********************************************************* * Procedure to facilitate creating of new Partitions&

Using a procedure within a Oracle Trigger

2012-08-30T15:02:00.000+08:00

This is a sample how you can declare a procedure in the Declare section of the PL/SQL block. This will reduce the number of redundant code in your program. In the sample below, I want to log changes to value of fields within an employee master database. I will make the assumption that the tables are already there. Create Or Replace Trigger trEmp_AttribUpdBefore Update Of

SQL command to find the location of the trace file in Oracle

2012-08-29T08:27:00.003+08:00

select u_dump.value || '/' || instance.value || '_ora_' || v$process.spid || nvl2(v$process.traceid, '_' || v$process.traceid, null ) || '.trc'"Trace File"from V$PARAMETER u_dump cross join V$PARAMETER instance cross join V$PROCESS join V$SESSION on v$process.addr = V$SESSION.paddr where u_dump.name = 'user_dump_dest' and instance.name = '

Postgres Memory Architecture vs Oracle Memory Architecture

2012-08-01T18:00:00.000+08:00

The following is the memory architecture for Postgres 9.0. The image is obtained from another blog which has the full explanation. Oracle Memory Architecture is as follow. The information is obtained from the Oracle document.

SQL Joins

2012-07-24T18:00:00.000+08:00

Coming from an Oracle environment, I have a problem remember the joins. This document will help me remember. In the sample below, the SQL query with the word join is ANSI SQL compliant and works also with other databases like postgres, MySQL, SQLServer etc. Sample Data I will use two tables for the examples. SampTab1 - data is as follow: NAME ROLE John Mascot

Sendmail vs Mailx

2012-07-18T17:49:00.001+08:00

sendmail has the 'intelligence' to figure out how to send the mail to a recipient not on the local machine - provided the machine has access/can route to the network where recipient is located. In order for mailx to do this, you need to use /etc/aliases ( /etc/mail/aliases ) Reference https://forums.oracle.com/forums/thread.jspa?messageID=8258664