Elegant coding

Tools for making the vedio demo

2010-02-15T15:26:00.001-05:00

1. CamStudio - Free Streaming Video Software

2. Subtitle Workshop - The most complete, efficient and convenient freeware subtitle editing tool.

3. AutoGK - THE tool for XviD / DivX conversion

4. WinAVI Vedio Converter - A complete solution for video-file converting

Some tools to speeding up the productivity

2010-02-06T22:02:00.001-05:00

1. Powerpro - A windows tool to imitate the key typing with a keyboard shortcut.

http://powerpro.webeddie.com/

2. AutoFill forms - A Firefox Add-on that enables you to fill out web forms with a keyboard shortcut.

3. Ubiquity - A Firefox Add-on that lets you give commands to Firefox by entering command words into a special input box.

sqlplus tip

2009-07-16T10:03:00.001-04:00

1. DEFINE_EDITOR=vi - define the vi editor
2. EDIT - edit the sql statement in current buffer with using vi editor
3. save file <filename> - save the sql statement in current buffer to a file
4. get file <filename> - load the sql statement from file to current buffer
5. / - execute the sql statement in current buffer

Some tools

2009-07-15T14:01:00.006-04:00

Ganglia - a tools to monitor the system performance

http://ganglia.info/

Hudson - A tools to perform the build and automation functional test

http://hudson.com/

nmon - a tools to monitor the Linux performance

http://blog.csdn.net/chinalinuxzend/archive/2009/06/03/4238526.aspx

Selenium - a tool to do the web automation test

http://seleniumhq.org/

Some sql tips

2009-07-09T14:55:00.001-04:00

sequence and streams

CREATE SEQUENCE some_sequence
START WITH -1
INCREMENT BY -100

Convert the delimited string to list

select (column_value).getstringval()
from xmltable('"a","b","c"');

Recreate capture process

2009-06-29T15:35:00.001-04:00

select * from dba_queue_tables

BEGIN

dbms_capture_adm.drop_capture(capture_name          => 'RSA_STREAMS_CAPTURE',
                                drop_unused_rule_sets => TRUE);

END;

BEGIN
dbms_streams_adm.add_schema_rules(queue_name         => 'RSA_STREAMS_CAPTURE_Q',
                                    streams_type       => 'CAPTURE',
                                    streams_name       => 'RSA_STREAMS_CAPTURE',
                                    schema_name        => 'RSA_REP',
                                    include_dml        => TRUE,
                                    include_ddl        => FALSE,
                                    include_tagged_lcr => TRUE,
                                    inclusion_rule     => TRUE);

END;

list Opatch on non-default folder

2009-06-29T11:20:00.001-04:00

/opatch lsinventory -invPtrloc /export/home/qeuser/AuthMgr/db/oraInst.loc

Using RMAN to deregister the missing archived log files

2009-06-26T21:30:00.001-04:00

rman

connect target sys/<>
crosscheck archivelog all
delete expired archivelog all

My first GAE java application

2009-04-16T20:29:00.001-04:00

Here is the site http://test-java.appspot.com/

I developed it with using GWT and JPA which are two very popular technology.

Google provides a Eclipse PlugIn for GAE, that allows to debug the web application include both server and client side.

Debug java application

2009-02-17T14:29:00.001-05:00

export _JAVA_OPTIONS="-Dlax.debug.level=3 -Dlax.debug.all=true"
export LAX_DEBUG=true

The issue with using 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE'

2009-01-25T23:27:00.001-05:00

There are some issues with recover control files in RESETLOGS mode after executing 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE',

According to instruction, we need to register log files with using the following comamnd

ALTER DATABASE REGISTER LOGFILE ''

But sometimes the following error occurred

ORA-00604: error occurred at recursive SQL level" error on "ALTER DATABASE REGISTER LOGFILE '/<path>/1_234_636797930.dbf'

"

And the work around is using the following command instead

ALTER DATABASE REGISTER PHYSICAL LOGFILE

Linux renew ip command

2008-12-03T23:09:00.001-05:00

The -r flag explicitly
releases the current lease, and once the lease has been released, the
client exits. For example, open terminal and type the command:

$ sudo dhclient -r

Now obtain fresh IP:

$ sudo dhclient

There is no need to restart network service. Above command should
work with any Linux distro such as RHEL, Fedora, CentOS, Ubuntu and
others. On a related note you can also try out the following commands:

# ifdown eth0 # ifup eth0 # /etc/init.d/network restart

OR

# /etc/init.d/networking restart

Some tech books read recently

2008-09-09T09:03:00.003-04:00

Troubleshooting Oracle Performance

Very comprehensive.

Effective Java Second Edition

Provide some simple and nice programming tips

Scrum and XP from the Trenches

Introductory book

Ask Tom 2007

Too many contents

The web security tools

2008-08-28T15:48:00.000-04:00

netcat - a featured networking utility which reads and writes data across
network connections, using the TCP/IP protocol.

http://netcat.sourceforge.net/

nmap - a free and open source (license) utility for network exploration or
security auditing

http://nmap.org/

paros - a web proxy
for people who need to evaluate the security of their web
applications

http://www.parosproxy.org/index.shtml

Develop the web application running on google app engine

2008-07-30T02:15:00.002-04:00

My Example

http://yyang-hhong.appspot.com/

Required libraries

1. simplejson
setup.py install
2. prototype javascript library

How to view PDF file in windows mobile

2008-07-27T16:16:00.003-04:00

Most of PDF files are non-tagged files which text cannot be wrapped automatically, but you can use Adobe Acrobat to convert them to tagged file, and here is the instruction.

Guide to Creating Accessible PDF Files with Adobe Acrobat 5

Setup the automation test in windows with using CYGWIN

2008-07-18T23:48:00.010-04:00

Some required libraries:

1. openssh

http://www.netadmintools.com/art516.html
2. apache http d
3. sendmail - ssmtp, mutt
4. cron
5. cygrunsrv
6. vim

Tips:
1. For launching the ANT windows version, use dos2unix to convert the file $ANT_HOME/bin/ant

2. use ' od -c more ' to check if the file contains invisible characters

3. use tr to remove the invalid character, such as DOS escape character

echo `p4 counter $BRANCH_COUNTER_NAME` > $UNIX_TEMP_HOME/output-$BRANCH_COUNTER_NAME
DAS_COUNTER=`tr -d '\r' < $UNIX_TEMP_HOME/output-$BRANCH_COUNTER_NAME` 4. start and stop Apache httpd /usr/sbin/httpd.exe kill -TEAM 'cat /var/run/httpd.pid' 5. install cron and view logs cron-config /usr/bin/cronevents.exe 6. solve the cron error like 'can't switch user context' change the owner for all of files used by cron 7. ssh client can not access the windows network drive, but Cygwin can. the reason is because sshd service is running as LOCAL SYSTEM ACCOUNT.

8. cron job cannot access the existing windows network drive, but you can mount it at the beginning of the cron scripts, for instance

net use l: //test_machine/folder /user:test_user test_password

9. Cygwin Doesn't Register All Environment Variables When Using SSH, and here is a solution

http://smithii.com/node/44

Some good tools for Windows Mobile

2008-07-18T00:16:00.003-04:00

I think the best reader for Windows Mobile is IE since it can display the html content with one column layout so user don’t have to move the content horizontally.

I have tried a couple of other reader such as Adobe reader, Text Reader, but unfortunately both
of them don’t support one column layout very well.

And there are a couple of tools that could convert the documents to html doc.

PDF2HTML - convert PDF to html

CHMUNPACKER - convert CHM to html

posting blog with using scribeFire

2008-07-18T00:04:00.002-04:00

cool firefox addon!

Danny jumped to M$

2006-04-17T18:06:00.000-04:00

Now M$ got three of best borland's chief architect .

A interest query

2006-04-06T17:01:00.001-04:00

we have a table items which miss some price for some weeks

Week	Item	Price
1	1	8
2	1	null
3	1	null
4	1	7
1	2	6
2	2	3
3	2	null
1	3	2
2	3	null
3	3	4
4	3	2
5	3	null

we want to have a query to replace the missed price with last available price

SELECT i_item,
i_week,
i_price,
SUM(i_price) over(PARTITION BY new_price) new_price2
FROM (

SELECT i.item AS i_item,
i.week AS i_week,
i.price AS i_price,
SUM(i.price) over(ORDER BY i.item, i.week) new_price
FROM items i)
ORDER BY 1,
2

adopts dbms_rls to restrict the table access

2006-01-23T20:04:00.000-05:00

oracle provides a powerful feature that allows developer to audit the table access with user_customized function, here is the sample

create or replace function GEORGEY_SECURITY_FUNCTION return boolean is
Result boolean;
begin
raise_application_error(-20101, 'illegal access');

return(Result);
end GEORGEY_SECURITY_FUNCTION;

BEGIN

dbms_rls.add_policy(object_schema => 'GEORGEY',
object_name => 'PEOPLE',
policy_name => 'GEORGEY_POLICY',
function_schema => 'GEORGEY',
policy_function => 'GEORGEY_SECURITY_FUNCTION',
statement_types => 'SELECT,UPDATE,INSERT,DELETE',
update_check => TRUE,
enable => TRUE,
static_policy => FALSE);

END;

java.net: Sprinkle Some AJAX Magic in Your Struts Web Application

2005-11-23T00:04:00.000-05:00

Visual Studio:Microsoft dev tools roadmap

2005-11-09T18:04:00.000-05:00

bobbyvandersluis.com | Ten good practices for writing JavaScript in 2005

2005-10-12T10:47:00.000-04:00

WWW SQL Designer

2005-10-11T11:12:00.000-04:00

meebo.com

2005-10-10T22:53:00.000-04:00

Ajax for Java developers: Java object serialization for Ajax

2005-10-07T11:00:00.000-04:00

MSDN .NET Framework Developer Center: The LINQ Project

2005-09-21T22:20:00.000-04:00

TheServerSide.NET - 10 Ways to Make Your Code More Testable

2005-09-17T20:29:00.000-04:00

TheServerSide.NET - 10 Ways to Make Your Code More Testable

frogware.com: custom .NET and Delphi programming

2005-09-17T20:26:00.000-04:00

frogware.com: custom .NET and Delphi programming

Windows Workflow Foundation

2005-09-17T20:04:00.000-04:00

Raible's Wiki: AppFuseQuickStart

2005-09-13T09:16:00.000-04:00

Raible's Wiki: AppFuseQuickStart

Home - Confluence

2005-09-12T15:12:00.000-04:00

Home - Confluence

WebHostingTalk - Web Hosting Forum

2005-09-09T23:34:00.000-04:00

WebHostingTalk - Web Hosting Forum

Setup the transaction in spring

2005-09-06T15:31:00.000-04:00

Setup the transaction in spring

� Introducing Spring JDBC - frequently the best introduction of Spring in an organization

2005-09-06T14:33:00.000-04:00

� Introducing Spring JDBC - frequently the best introduction of Spring in an organization

del.icio.us direc.tor: Delivering A High-Performance AJAX Web Service Broker :: Johnvey

2005-09-05T00:22:00.000-04:00

del.icio.us direc.tor: Delivering A High-Performance AJAX Web Service Broker :: Johnvey

clone object in dotnet

2005-09-03T11:24:00.000-04:00

private static void TestClone()
{
Person p1 = new Person();
p1.Age = 26;
p1.UserName = "yyanghhong";

Person p2 = (Person)CloneObjectEx(p1);
p2.UserName = "unruledboy";

Console.WriteLine(p1.UserName);
Console.WriteLine(p2.UserName);
}

public static Person CloneObject(Person ObjectInstance)
{
BinaryFormatter bFormatter = new BinaryFormatter();
MemoryStream stream = new MemoryStream();
bFormatter.Serialize(stream, ObjectInstance);
stream.Seek(0, SeekOrigin.Begin);
Person newObject = (Person)bFormatter.Deserialize(stream);
return newObject;
}

public static object CloneObjectEx(object ObjectInstance)
{
BinaryFormatter bFormatter = new BinaryFormatter();
MemoryStream stream = new MemoryStream();
bFormatter.Serialize(stream, ObjectInstance);
stream.Seek(0, SeekOrigin.Begin);
return bFormatter.Deserialize(stream);
}

[Serializable]
public class Person
{
private int age;
private string userName;

public Person()
{
}

public int Age
{
get{return age;}
set{age = value;}
}
public string UserName
{
get{return userName;}
set{userName = value;}
}
}

Google Code

2005-09-03T10:45:00.000-04:00

Google Code

Google AJAXSLT

2005-09-02T21:14:00.000-04:00

Google AJAXSLT

design-nation.blog/en: An example of the Extension Objects pattern ( the java version )

2005-08-31T13:18:00.000-04:00

Use AOP in permission management (chinese)

2005-08-27T15:19:00.000-04:00

Use AOP in permission management

The Code Project - How to Test Private and Protected methods in .NET - C# Programming

2005-08-27T15:06:00.000-04:00

The Code Project - How to Test Private and Protected methods in .NET - C# Programming

DBAzine.com: Trees in SQL: Nested Sets and Materialized Path

2005-08-27T15:01:00.000-04:00

TheServerSide.com - Building Custom JSF UI Components

2005-08-23T15:40:00.000-04:00

Finding warez using Google | The days start here

2005-08-23T13:21:00.000-04:00

interesting article

Ajax.NET - The free library for .NET (C#)

2005-08-21T22:32:00.000-04:00

Ajax.NET - The free library for .NET (C#)

Undocumented Keywords in C#

2005-08-21T22:22:00.000-04:00

http://www.cnblogs.com/flier/archive/2004/07/08/22405.aspx

High-performance XML (V): Increase performance on message-based web services by avoiding XmlDocument creation when using XmlSerializer

2005-06-06T14:45:00.000-04:00

High-performance XML (V): Increase performance on message-based web services by avoiding XmlDocument creation when using XmlSerializer

File: README

2005-05-31T11:34:00.000-04:00

Action Pack in ruby on rails

Rico Mariani's Performance Tidbits : How To Do A Good Performance Investigation

2005-05-26T10:51:00.000-04:00

Rico Mariani's Performance Tidbits : How To Do A Good Performance Investigation

Service Station: Contract-First Service Development -- MSDN Magazine, May 2005

2005-05-25T14:03:00.001-04:00

Service Station: Contract-First Service Development -- MSDN Magazine, May 2005

Cutting Edge: Collections and Data Binding -- MSDN Magazine, May 2005

2005-05-25T14:03:00.000-04:00

Cutting Edge: Collections and Data Binding -- MSDN Magazine, May 2005

InternalsVisibleTo in c#2.0

2005-04-21T08:05:00.000-04:00

It is a very useful attribute, especially good for unit test. but it will lead to some security issue, it is better to adopt strong name or add conditional constants to restrict it.

Team Room

2005-04-19T13:16:00.000-04:00

XP Team Room

Useful Developer Tools - Confluence

2005-04-07T23:21:00.000-04:00

Useful Developer Tools for Dotnet developer

Castle Active Record

2005-04-07T09:23:00.000-04:00

Castle Active Record

this OR mapping framework is based on nhibernate, but it doen't require XML mapping file. it use attributes instead

The Code Project - Castle's DynamicProxy for .NET - C# Programming

2005-04-07T09:09:00.000-04:00

The Code Project - Castle's DynamicProxy for .NET - C# Programming

Feature comparison between HA-JDBC and C-JDBC

2005-03-28T23:37:00.000-05:00

Feature comparison between HA-JDBC and C-JDBC

A cheap method to implement database cluster(s) with multiple JVMs.

How the Runtime Locates Assemblies

2005-03-25T11:24:00.000-05:00

How the Runtime Locates Assemblies

Design for Performance vs. Tune for performance

2005-03-25T08:28:00.000-05:00

Design for Performance vs. Tune for performance

There are some good points inside this article, I like using agile methods to deal with performance tuning, it requires a detailed unit testing case, and an agile way to amend the code, such as adopting AOP methods to put some business rules and logic into configuation file for ignoring re-compiling.

Microsoft HowTo's QuickStarts Tutorial

2005-03-24T15:40:00.000-05:00

Microsoft HowTo's QuickStarts Tutorial

Apartments and Pumping in the CLR

2005-03-22T15:33:00.000-05:00

Apartments and Pumping in the CLR

Responding to Richard Grimes article on .NET

2005-03-16T23:52:00.000-05:00

Responding to Richard Grimes article on .NET

AOP Fun with JavaScript

2005-03-16T23:16:00.000-05:00

AOP everywhere, Javascript, PHP

TheServerSide.com - Velocity: A template engine OR A Rule engine OR Both?

2005-03-16T21:36:00.000-05:00

TheServerSide.com - Velocity: A template engine OR A Rule engine OR Both?

Software Factory Elevator Story

2005-03-16T11:23:00.000-05:00

Software Factory Elevator Story

AskTom "what kind of analyze is best"

2005-03-16T10:52:00.000-05:00

AskTom "what kind of analyze is best"

Mainsoft, Visual MainWin for the J2EE platform

2005-03-15T08:28:00.000-05:00

Mainsoft, Visual MainWin for the J2EE platform
Visual MainWin brings the C# and Visual Basic .NET programming languages to the Java platform, enabling more than 2.5 million Microsoft-skilled developers to quickly and efficiently develop J2EE Web applications and Web services. it sounds too good to be true.

XenoCode 2005

2005-03-14T09:16:00.000-05:00

XenoCode 2005
A good dotnet obfuscation tools, it supports a very nice feature of taking several assemblies and obfuscating them into one single assembly

ASP.NET QuickStart Tutorial

2005-03-12T20:06:00.000-05:00

ASP.NET QuickStart Tutorial

why Dotnet guy step down?

2005-03-09T12:33:00.000-05:00

Richard is stepping down from his post of commenting on all things .NET.

The Code Project - Dynamic/Transparent Proxy using DynamicProxy.NET - .NET

2005-03-07T16:19:00.000-05:00

The Code Project - Dynamic/Transparent Proxy using DynamicProxy.NET - .NET

Open letter to the Borland community regarding our eclipse.org announcement

2005-03-03T10:33:00.000-05:00

Open letter to the Borland community regarding our eclipse.org announcement

Using distributed transactions in .Net 1.x without deriving from ServicedComponent

2005-02-14T00:59:00.000-05:00

Using distributed transactions in .Net 1.x without deriving from ServicedComponent

Seattle Weekly: News: Microsoft's Sacred Cash Cow by Jeff Reifman

2005-02-14T00:41:00.000-05:00

Seattle Weekly: News: Microsoft's Sacred Cash Cow by Jeff Reifman

.NET Architecture Center: Choosing the Right Presentation Layer Architecture

2005-02-14T00:05:00.000-05:00

.NET Architecture Center: Choosing the Right Presentation Layer Architecture

MSDN .NET Framework Developer Center:

2005-02-14T00:04:00.000-05:00

Designing .NET Class Libraries: Member Types

EIF vs log4net

2005-02-13T23:54:00.000-05:00

EIF vs log4net
I love Log4net

Yet Another 2005 Prediction List

2004-12-30T13:06:00.000-05:00

Flex overview

2004-12-26T20:09:00.000-05:00

From OOP to Service-Oriented - Do you get it yet?

2004-12-26T19:57:00.000-05:00

developerWorks : Blogs

2004-12-13T11:36:00.000-05:00

Microsoft and Domain Specific Languages

M$ just issued the concept of software factory and Domain Specific Languages that will be a big impact to some existed design language such as UML, the author of this article is one of 3 founder of UML & Rose, he said that he is quite disappointed with it.

2004-11-30T13:58:00.000-05:00

systemwebmail.com
good site to introduce the webmail in .net framework

2004-11-28T14:58:00.000-05:00

Some delphi guys complain that there are no class reference in java and .net, such as

type
BaseClass = class constructor Create; virtual;
...
end;

BaseClassRef = class of BaseClass

DerivedClass1 = class (BaseClass )

DerivedClass2 = class (BaseClass )

RegisterClass(DerivedClass1);
RegisterClass(DerivedClass2);
...
var
AClassRef : BaseClassRef ;
begin

//the class name can be stored in a configuration profile
AClassRef := BaseClassRef(FindClass('DerivedClass1'));
...
end;

Now, we could do the similar thing with a java IOC framework PicoContainer.

Interface BaseIntf

class DerivedClass1 implements BaseIntf

class DerivedClass2 implements BaseIntf

public void () {
MutablePicoContainer pico = createPicoContainer(null);
pico.registerComponentImplementation("DerivedClass1",DerivedClass1.class);
pico.registerComponentImplementation("DerivedClass2",DerivedClass2.class);
...

//the class name can be stored in a configuration profile
BaseIntf t = (BaseIntf) pico.getComponentInstance("DerivedClass2");
assertNotNull(t);
}

PicoContainer has .net portion too.

2004-11-23T20:30:00.000-05:00

ASP.NET: 10 Tips for Writing High-Performance Web Applications -- MSDN Magazine, January 2005

2004-11-23T15:56:00.000-05:00

MyGeneration - Home

A very good open source code generation tools for DotNet

2004-11-21T23:20:00.000-05:00

a good chinese article about hibernate and spring

2004-11-19T09:46:00.000-05:00

ODP.NET Tip of the Month

2004-11-16T19:58:00.000-05:00

Spring.NET - Application Framework

http://www.springframework.net/doc/reference/index.html

This release contains a lightweight container with IoC / Dependency Injection functionality comparable to that found in the Java based Spring framework. Highlights include

Constructor and Setter based Dependency Injection
Factory method creation
Inheritance of object definitions
Support for .NET application configuration files
Event wiring
Autowiring of collaborators
Singleton/Prototype creation modes

2004-11-12T23:49:00.000-05:00

pinvoke.net: the interop wiki!
It is a site that attempts to address the difficulty of calling Win32 or other unmanaged APIs in managed code

2004-11-11T22:48:00.000-05:00

use IOCP in thread

use IOCP in socket

IOCP is most efficient method in Win32 thread and Socket programming, but it requires much more work.

2004-11-11T22:02:00.000-05:00

Contexts in .NET: Decouple Components by Injecting Custom Services into Your Object's Interception Chain -- MSDN Magazine, March 2003

Aspect-Oriented Programming Enables Better Code Encapsulation and Reuse

ContextBoundObject is a nice way to implement AOP in DotNet, but it is a little expensive.

2004-11-11T19:26:00.000-05:00

DHTML Menu 4 (WebFX)
version 3 allowed menus to cover windowed controls,
version 4 can be displayed outside the physical boundaries of the browser window.

2004-11-11T13:42:00.000-05:00

MyXaml - Home
a Open source XAML framework, it is based on Winform.

2004-11-10T22:33:00.000-05:00

Debugging Memory Problems

Performance Counters for ASP.NET

2004-11-08T23:17:00.000-05:00

URLDownloadToCacheFile

A very useful Windows platform API, it Downloads data into the Internet cache and returns the file name of the cache location for retrieving the bits. it is widely used by auto-upgrade of rich client application.

2004-11-08T13:03:00.000-05:00

Manageability - Open Source Workflow Engines Written in Java

2004-11-07T20:26:00.000-05:00

ActiveWidgets :: dhtml grid, javascript tables, .net datagrid, asp controls, php widgets
This controls set includes a scrollable javascript grid that looks like win 32 grid, it could be used in open source project for free, but not in commercial project.