Oracle Lite dmagent managing olite.key

While dmagent running, it may hold a copy of the olite.key in the memory. So if you change the olite.key in the file system level, it may not be picked up during next action.
Also, the dmagent has the ability to download the new olite.key as it needs, but you may see the username/password challenge window, if you are sure the username/password is correct, just simply click OK, let it try with the new olite.key downloaded by the dmagent. Surprise, it succeeded!

Creating platform specific apps for .Net development

Creating platform specific apps

Most of the language compilers (like C#) now offer a /platform switch. By using this switch, developers can create binaries targeted for a specific platform type or binaries that are platform agnostic. There are four types of binaries that are emitted

· anycpu – platform agnostic

· x86 – 32-bit platform specific

· x64 – x64 platform specific

· itanium – IA platform specific

Please refer to Moving from 32-bit to 64-bit application development on .NET Framework.

How to view the corflags(ILONLY, 32BitRequired etc.) of a PE image?
corflags.exe Core32.dll

bash shortcuts

Here is a list of bash shortcuts, credit to this blog.
alt-f -- move forward one word
alt-b -- move backwards one word
ctrl-a -- takes you to the begining of the command you are currently typing.
ctrl-b -- move backwards one character
ctrl-c -- kills the current command or process.
ctrl-d -- kills the shell.
ctrl-e -- takes you to the end of the command you are currently typing in.
ctrl-f -- move forward one character
ctrl-h -- deletes one letter at a time from the command you are typing in.
ctrl-l -- clear screen
ctrl-r -- does a search in the previously given commands so that you don't have to repeat long command.
ctrl-u -- clears the typing before the hotkey.
ctrl-z -- puts the currently running process in background
esc-b -- takes you back by one word while typing a command.
esc-p -- like ctrl-r lets you search through the previously given commands.
esc-. -- gives the last command you typed.

Another good reference.
Here "2T" means Press TAB twice

$ 2T - All available commands(common)
$ (string)2T - All available commands starting with (string)
$ /2T - Entire directory structure including Hidden one
$ 2T - Only Sub Dirs inside including Hidden one
$ *2T - Only Sub Dirs inside without Hidden one
$ ~2T - All Present Users on system from "/etc/passwd"
$ $2T - All Sys variables
$ @2T - Entries from "/etc/hosts"
$ =2T - Output like ls or dir

Regex back references

When use Intellij to search/replace by using Regex, you need to notice that the back reference is $n rather than \n.
Refer to Intellij Help on search/repalce.
Refer to here.

Replace File Explorer with XPlorer 2

Need a tabbed file explorer?
Try Xplorer 2 out.
Please refer to here.
Aslo: need tabbed console? here you are.

This attribute does not support request time values when using JSTL

When I tried to upgrade our jstl library from 1.0 to 1.1, I got the following error:
This attribute does not support request time values
The solution is

• include JSTL 1.1 by changing the taglib-URIs in include.jsp from
  <%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" >
  <%@ taglib prefix="fmt" uri="http://java.sun.com/jstl/fmt">
  to
  <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core">
  <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt">
  

Does JSTL forEach apply to array?

The answer is yes. Please see here.

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