InnoSetup Language not shown up

Some languages are missing on the Select Setup Language dialog, or it doesn't show up at all.
If you would like to force all languages to be visible regardless of whether they can be displayed properly under the active code page, set the ShowUndisplayableLanguages [Setup] section directive (new in Inno Setup 5.1.7).
ShowUndisplayableLanguages=yes
refer to here.

Turn on Olite SQL Trace

Want to tune your sql on Olite database? You can put the following parameter in your polite.ini file, [All databases] segment:
OLITE_SQL_TRACE = TRUE

You should see a trace file: oldb_trc.txt in your mobile client bin directory, if you are using msql to run your sql script on the Olite DB.

Oracle change xmltype column lob tablespace

One friend asked me this question today: How do you chnage xmltype column lob tablespace?

1. xmltype is an object type, it contains XMLDATA which is a CLOB object, you can treat "column.XMLDATA" as a clob object. please refer to here.
   
2. How to move a lob from one tablespace to another? The answer is to use 'alter table move lob(...) ...'; please refer to here.

To put everything together, here is how you can setup and test it:

1. Create a test table with xmltype column:
• CREATE TABLE xwarehouses (
  warehouse_id NUMBER,
  warehouse_spec XMLTYPE)
  XMLTYPE warehouse_spec STORE AS CLOB
  (TABLESPACE catusedt
  STORAGE (INITIAL 6144 NEXT 6144)
  CHUNK 4000
  NOCACHE LOGGING);
2. Alter the table to change the LOB tablespace:

• alter table xwarehouses
  move LOB(warehouse_spec.XMLDATA)
  STORE AS xwarehouses_seg
  (TABLESPACE catusedpht
  STORAGE (INITIAL 6144 NEXT 6144)
  CHUNK 4000
  NOCACHE LOGGING);
  

Error queue - records with "Client was out of sync" message

We are seeing Client was out of sync in our Oracle Lite Server Error Queue, my colleague found this post, which helps us understand how to fix this kind of problem. Here are my notes regarding to it:

1. Login to Mobile Manager; goto Error Queue; select the Transaction ID you are interested in; Publication Items.
   
2. Select the Publication Item you are interested in; View records; The DML Operation most likely will show 'Error'; Check th rows you would like to change the Update DML ; Select the desired 'Update DML' from the top left drop down(to choose between insert and update, depends whether that row exists in your application database), then Click Go; You should see the DML Operation changed to the desired one, rather than Error.
   
3. Click 'Apply'; You should see Confirmation: Changes were applied successfully.
4. Repeat step 2 and 3 for all the publication items in that transaction.
5. Back to Error Queue, select the Transaction you worked on, click Execute.
6. Go back to Mobile Manager home page you should see your transaction in the In Queue(1).
7. Refresh the page to see the MGP active, then return to Idle, make sure your Transaction does not reenter to the Error Queue.

Using keepalives to prevent disconnection after idle for some time

Connection to some remote Unix server get disconnected too often? Try to set the PUTTY sending null packet in the Connection configuration Category

Please refer to here.

Set the JVM platform default character encoding to UTF-8

You could set the JVM platform defalult character encoding to UTF-8 by using the following JVM option:
-Dfile.encoding=UTF-8

Make sure this flag come before your Main program name, especially when you are calling org.apache.tools.ant.Main.

Please refer here.

while loop on unix shell command line

Would like to repeat the ls -l command on unix command line every 30 seconds?
$ while true; do ls -l; sleep 30; done;

How to turn on QuickEdit Mode for cygwin

Want to get right button copy and left button drag select works in cywin?
Here are the steps:

Right click on the icon in the upper left of the title bar
and select properties Under Options, select 'QuickEdit Mode',
hit ok Select 'Modify shortcut that started this window'

How to select a element without specific attribute?

I ran into this simple question in one of my task:
Here is how you select an element without a specific attribute:

B[@C=''] selects B that has no C attribute or has attribute
with empty value.

B[not(@C)] seelcts b that don't have a C attribute

B[not(@*)] selects B that have no attribute.

Please refer to here.

How to check the Solaris last boot time?

$ who -b
or
$ uptime

Please refer to here.

vi replace with confirmation and replace with regex group

Search from every line, replace confirmation (with [y]es)
:%s/search_string/replace_string/gc

Replace with regex group:
:%s/<img alt="\(.\+\)"\ssrc=.\+/\1/gc

Vi simple tutorial

Some examples:
You have [admin, admin1, user3], and you would like to change it to ['admin','admin1','user3']; here your are:%s\(\w\+\)/'\1'/gc

IntelliJ supports UTF-8?

One of my colleague complained that the IntelliJ does not support UTF-8 correctly:

1. System.out.println("Dealer Caterpillar ciężkiego używanego wyposażenia i używanych części"); when you run it, the special character corrupted.
2. After you safe the java file, restart the Intellij, the special character corrupted.

Here is my trick: In Intellij Settings->General->Default encoding, choose UTF-8 and restart, the java file will be stored in UTF-8 encoding.

Gvim: encoding puzzles.

You can reload a file using a different encoding if vim wasn't able to detect the correct encoding:
:e ++enc=<encoding>
for example:
:e ++enc=utf-8

Choose a font type like Courier New.

You can achieve both of these by adding the following lines in your gvim startup configuration file .vimrc:

set enc=utf-8
set guifont=Courier_New:h11:cDEFAULT

How to comment multiple lines in vim?

Place cursor at the beginning of the first line you want to change.
Press Ctrl+v
Move the cursor down to the last line you want to change.
Press I (The capital letter after H and before J)
Type in the text you wish to insert
Press Esc

Now all lines selected should show the inserted text.

Want to insert new line in file?
try \r, like:
%s/,/,\r/gc

WireShark to capture loopback traffic

Please refer to this link.

How to add newline (line feed) in XSLT result xml file

Please try to add:
<xsl:text>&#xa;</xsl:text>

Disabling Windows' native Zip folder support

To prevent Windows XP from treating compressed Zip files as a folder, go to "Start > Run" and type the following:
regsvr32 /u zipfldr
If you wish to restore native Zip support in Windows, just go back to "Start > Run" and type the following:
regsvr32 zipfldr


Thanks to this blog entry.

IDEA does not follow the Goto Implementation for EJB?

Check whether your module is correcly configured as an EJB module.
Project Structure->Modules->XXXEJB module->Ejb Module Settings
check whether your EJB module deployment descriptor setting exists or not, if not, then Add it.

Using FireFox Web Developer Extention to create or overwrite a cookie

Recently we need to test our application behavior with different cookie values, but the cookie is not create by our site, it is create by a third party website. The problem is how can I manipulate the cookie content easily to test our application behavior?

I found that the Web Developer extension of FireFox is perfect for this task, you can create/overwrite the cookie as you want:
Just go directly to Cookie->Add Cookie

Setup svnserve for personal usage

It is handy to have your own SVN server for you own small projects.
Here are the steps I used to setup a SVN server on Windows XP:
1. Download the Subversion binary for Windows from here, and unzip it to your local drive. Note: I was using 1.4.3
2. Create your own repository like: svnadmin create /svn-win32-1.4.3/repos/dliurepo
3. Setup the svnserve as Windows service: X:\svn-win32-1.4.3\bin>sc create svnserve binpath= "c:\dev\svn-win32-1.4.3\bin\svnserve.exe --service -r X:\svn-win32-1.
4.3\repos\dliurepo" displayname= "svn server"
4. Edit the svnserve.conf in your repository conf directory add the following texts:
[general]
password-db = userfile
anon-access = read
auth-access = write
realm = test svn realm
5. Create a new file named userfile in the same directory where svnserve.conf locates with the following content:
[users]
user1=password1

Further references:
Setup svnserve as windows service.
Version Control with Subversion.

Notes: sc command's option name includes the equal sign. Do NOT forget to put space after the option name '='.

Dump the SVN repository:
svnadmin dump <repository> > dumpfilename

Load dump into SVN repository:
svnadmin load <repository> < dumpfilename

Setup home Subversion Server with Apache.
Subversion and Apache
Having any Subversion Problem or Question? Search SVNForum

Copy, paste, and cut text block in VI

Copy block in vi:
Mark Beginning of Block : mx set mark x (x may be any letter)
Mark End of Block and "Copy'' : y`x yank from here to mark x into buffer
Mark End of Block and "Cut'' : d`x delete from here to mark x into bufferFor the whole file try:

Goto to line one: 1G
Sort from current line to end of file: !Gsort<cr>
Or if you want to think of it as one command: 1G!Gsort<cr>

Sort a range:
Move Cursor to last line to sort
mark the line with mark 'a': ma
move cursor to first line to sort
sort from current line to mark 'a': !'asort<cr>

Now what does the special chars above mean.

'!' is the vi filter command, it is followed by a movement command
that says what is being filtered. That is followed by the actual
filter cmd. The filter cmd can be any executable. In this case sort.
Since vi does not know how long the filter command name is, you have
to hit carriage return to initiate the filter.

G by itself means go to the end of the file

ma means set mark a to this line. (marks a-z exist)

'a means goto mark a.