Just Logger

2014年1月11日星期六

bind /tmp to /dev/shm on Ubuntu

After upgrading my PC to 16G of memory, I thing I can move something to memory instead of keeping them on disk.
Chome is my daily used software, and yes, chrome keep lots of caches. To help speed up chrome, I decide to move chrome's cache to memory for testing.
Here are the steps:

<< 閱讀更多 >>

2012年9月7日星期五

讀取 Clob 資料

在工作上終於遇到了資料表欄位型態是Clob的狀況，在網路上找到的方法不外乎就是以Stream的方式讀出在這裡將方法記錄下來


private String clubToString(Clob data) {

    StringBuilder sb = new StringBuilder();

    try {
        Reader reader = data.getCharacterStream();
        BufferedReader br = new BufferedReader(reader);
        String str = br.readLine();
        while (str != null) {
            sb.append(str);
            str = br.readLine();
         }
    } catch (Exception e) {
        logger.error(e.getMessage(), e);
    } finally {
        // 關閉Stream
        if (br != null) {
            br.close();
        }
    }

    if (sb.length() > 0) {
        sb.setLength(sb.length() - 1);
    }

    return sb.toString();
}

<< 閱讀更多 >>