Mysql UTF-8設定

LINUX底下修改 mysql 設定檔

指令:
vi /etc/mysql/my.cnf

修改以下

[client]
default-character-set=utf8

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci

Oracle SQL SYS_CONNECT_BY_PATH 合併多行字符串

select  temp.c1, substr(max(SYS_CONNECT_BY_PATH(c2,',')),2) as c_list
from (select c2, c1, ROW_NUMBER() OVER (PARTITION BY c2 ORDER BY c1) as rn
from table1
where c1 = 'A123456789'
order by c1) temp
START WITH temp.rn = 1
CONNECT BY temp.c1 = PRIOR temp.c1
and temp.rn -1 = PRIOR temp.rn
GROUP BY temp.c1
order by temp.c1;


參考:http://hsunya.wordpress.com/2010/10/13/oracle-sys_connect_by_path/

Eclipse 啟動時卡住問題

Eclipse在啟動時卡住 停在loading org.eclipse.debug.core

解決方法

刪除
.metadata\.plugins\org.eclipse.core.resources\.root\.markers.snap

不行在刪除

.metadata\.plugins\org.eclipse.core.resources\.projects\<project>\.markers.snap
如果還不行刪除 
.metadata\.plugins\org.eclipse.core.resources\.snap

Deploy Error : A composition unit with name already exists. Select a different application name

from: http://turanunes.wordpress.com/2011/09/21/deploy-error-a-composition-unit-with-name-already-exists-select-a-different-application-name/

When installing an application or performing other administrative actions in WebSphere Application Server version 7.x, the following error is received:
”A composition unit with name already exists. Select a different application name”
Resolving the Problem :
There are some temp file s on the Websphere server , you can delete them…
/opt/IBM/WebSphere/AppServer/profiles/Dmgr01/config/cells/(CellName)/blas/(AppName)
/opt/IBM/WebSphere/AppServer/profiles/Dmgr01/config/cells/(CellName)/cus/(AppName)
and also you can delete
/opt/IBM/WebSphere/AppServer/profiles/Dmgr01/wstemp/*.*
/opt/IBM/WebSphere/AppServer/profiles/Dmgr01/config/cells/isprodwas61Cell01/blas/(AppName)


window==>
C:\Program Files (x86)\IBM\SDP75\runtimes\base_v7\profiles\was70profile1\config\cells\lunayccleo-VAIONode01Cell\blas
C:\Program Files (x86)\IBM\SDP75\runtimes\base_v7\profiles\was70profile1\config\cells\lunayccleo-VAIONode01Cell\cus


C:\Program Files (x86)\IBM\SDP75\runtimes\base_v7\profiles\was70profile1\wstemp

Compass

http://blog.mukispace.com/compass-for-html-code-project/

Open multiple eclipse workspace in Mac

1. use command line to go to your eclipse folder
cd /Documents/eclipse

2. open eclipse as follow
./eclipse &

Eclipse configure reference project

when your web project in eclipse need to use classes from java project

then you need to set up your java project as  your reference project

1 configure project dependency

2.add require project