MySQL Character Encoding Configuration

It's common practice that the MySQL configuration file, in *nix systems is located in /etc/mysql/my.cnf
in windows, which is located in %MYSQL_HOME%\my.ini

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

XWiki encoding

web.xml:

<filter>
<filter-name>Set Character Encoding</filter-name>
<filter-class>com.xpn.xwiki.web.SetCharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>


xwiki.cfg:

xwiki.encoding = UTF-8

XWiki: XWikiPreferences:
Default Language:en

用Windows Live Writer試試post

還不錯用耶

Tomcat 5.5中設定JNDI resource的方法

1. $TOMCAT_HOME/conf/server.xml:
<GlobalNamingResources>
...
<Resource name="bean/CalendarFactory"
type="java.util.GregorianCalendar"
auth="Container"
factory="org.apache.naming.factory.BeanFactory"/>
</GlobalNamingResources>

2. $TOMCAT_HOME/conf/context.xml
<Context>
...
<Resource name="jdbc/AboveeDB" auth="Container"
type="javax.sql.DataSource" username="pp50" password="pp50"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://robbibm:1433/pp50p2"
maxActive="8" maxIdle="4"/>
</Context>

3. $TOMCAT_HOME/conf/web.xml
</web-app>
...
<resource-env-ref>
<description>
Fake up a Factory for Calendar objects
</description>
<resource-env-ref-name>
bean/CalendarFactory
</resource-env-ref-name>
<resource-env-ref-type>
java.util.GregorianCalendar
</resource-env-ref-type>
</resource-env-ref>
</web-app>

4. JSP client程式片斷
<%
javax.naming.Context ctx = new javax.naming.InitialContext( );
java.util.Calendar calendar = (java.util.GregorianCalendar)
ctx.lookup("java:comp/env/bean/CalendarFactory");
out.println(calendar.getTime());
%>

note

eclipse font: Georgia 16, Microsoft Sans Serif 14
package: nimble, brisk

找出某特定class到底存在哪個jar檔裡

Linux:
find ./ -name "*.jar" |xargs -t -i jar -tvf {}|grep TheClass

Windows + Cygwin
for %f in (*.jar) do jar -tvf %f |grep TheClass

在fedora上安裝java 6

1. 自sun網站download jdk-6u3-linux-i586-rpm.bin
2. chmod 755 jdk-6u3-linux-i586-rpm.bin
3. su, 改用root登入
4. 執行./jdk-6u3-linux-i586-rpm.bin
5. 執行alternatives命令指示fedora改用Sun的JVM:
alternatives --install /usr/bin/java java /usr/java/jdk1.6.0_03/bin/java 100
alternatives --install /usr/bin/jar jar /usr/java/jdk1.6.0_03/bin/jar 100
alternatives --install /usr/bin/javac javac /usr/java/jdk1.6.0_03/bin/javac 100
其他jdk相關可執行檔也可以相同方式處理。
6.最後需要配置alternative去使用Sun的JVM做預設的JVM。執行以下命令：
/usr/sbin/alternatives --config java

7.有時執行java webstart時，會出現以下錯誤訊息：
java.lang.UnsatisfiedLinkError: /usr/java/jdk1.6.0_03/jre/lib/i386/libdeploy.so: libstdc++.so.5: cannot open shared object file: No such file or directory
執行yum install libstdc++.so.5就可以了。

8. 安裝jre及firefox jre plugin，參考以下網址：
http://java.com/zh_TW/download/help/5000010500.xml#rpm

9. 安裝完jre後，至/usr/lib/firefox-2.0.0.10/plugins執行以下命令：
ln -s /usr/java/jre1.6.0_03/plugin/i386/ns7/libjavaplugin_oji.so .
如此可讓firefox執行applet