albert's blog: February 2020

2020/02/29

2020/02/28

2020/02/10

[Docker] 如何將預先準備好的 SQL 檔案，於啟動時匯入 Oracle Docker

1. 確認 Docker 所 mount 的 directory

2. 將準備好的 SQL file(s) 放到特定目錄下

3. 指定 volume，將 sql 所存放的路徑 (i.e. /Users/guojunyou/Documents/docker/local-initdb) 對應到 /etc/entrypoint-initdb.d

docker run -d --shm-size=2g -p 8080:8080 -p 1521:1521 \
-e NLS_LANG="TRADITIONAL CHINESE_TAIWAN.AL32UTF8" \
-v /Users/guojunyou/Documents/docker/local-initdb:/etc/entrypoint-initdb.d \
42dda6eba3ea

Reference
[1] https://hub.docker.com/r/orangehrm/oracle-xe-11g

2020/02/09

[Docker] 如何解決 Oracle Docker 匯入資料繁體中文亂碼問題

Problem
我有準備好 create table 與 insert data 的語法在指定目錄，並用以下指令啟動 docker:

docker run -d --shm-size=1g -p 8080:8080 -p 1521:1521 \
-v /Users/guojunyou/Documents/docker/local-initdb:/etc/entrypoint-initdb.d \
42dda6eba3ea

並成功啟動 Oracle docker

guojunyoude-iMac:~ guojunyou$ docker logs 4445b2acf933 --details
 Starting Oracle Net Listener.
 Starting Oracle Database 11g Express Edition instance.

 Database init...

 /start.sh: running /etc/entrypoint-initdb.d/data.sql

 Table created.

 1 row created.

 1 row created.

 1 row created.

 1 row created.

 End init.
 Oracle started successfully!

發現所 insert 的資料都是亂碼

How-To
這是因為編碼所導致的問題，在啟動指令增加一個參數
-e NLS_LANG="TRADITIONAL CHINESE_TAIWAN.AL32UTF8" 即可解決亂碼問題

docker run -d --shm-size=1g -p 8080:8080 -p 1521:1521 \
-e NLS_LANG="TRADITIONAL CHINESE_TAIWAN.AL32UTF8" \
-v /Users/guojunyou/Documents/docker/local-initdb:/etc/entrypoint-initdb.d \
42dda6eba3ea

2020/02/08

[Docker] Error response from daemon: Get https://registry-1.docker.io/v2/: net/http: request canceled while waiting for connection

Problem
As I tried to pull a docker image, I got the following error message:

F:\git
λ docker pull orangehrm/oracle-xe-11g
Using default tag: latest
Error response from daemon: Get https://registry-1.docker.io/v2/: net/http: 
request canceled while waiting for connection (Client.Timeout exceeded while awaiting headers)

How-To
Configure proxy and restart docker

Pull again

F:\git
λ docker pull orangehrm/oracle-xe-11g
Using default tag: latest
latest: Pulling from orangehrm/oracle-xe-11g
cb56c90f0b30: Pull complete
0acc551e5716: Pull complete
8956dcd35143: Pull complete
908242721214: Pull complete
b44ff14dd3bb: Pull complete
81ac3d025953: Pull complete
b555aeaf1117: Pull complete
e1896669ff82: Pull complete
9437119349eb: Pull complete
96e36910991c: Pull complete
2de589c896ac: Pull complete
c5510f7fcb03: Pull complete
c09e52e19f4b: Pull complete
abbfadca26af: Pull complete
c14464a9caeb: Pull complete
4468bbe36672: Pull complete
85cfa88ee1f2: Pull complete
d4831108a661: Pull complete
0821dd9b7524: Pull complete
b19f8225db0a: Pull complete
3001b1e31fbc: Pull complete
585b27c5a8cb: Pull complete
4977c21ef050: Pull complete
acf12f209883: Pull complete
51a0fc043bdd: Pull complete
47759cd1519f: Pull complete
Digest: sha256:b56c95bb59dfef4ee8d373713209105dedb52f09d56c82f94edb29f1fac3b60c
Status: Downloaded newer image for orangehrm/oracle-xe-11g:latest
docker.io/orangehrm/oracle-xe-11g:latest

2020/02/07

2020/02/06

[Docker] error during connect: Get http://%2F%2F.%2Fpipe%2Fdocker_engine/v1.40/version:

Problem
When I try to get my docker version, I get the error message as bellows:

F:\git\doodle\cheers2019 (master -> origin)
λ docker version
Client: Docker Engine - Community
 Version:           19.03.5
 API version:       1.40
 Go version:        go1.12.12
 Git commit:        633a0ea
 Built:             Wed Nov 13 07:22:37 2019
 OS/Arch:           windows/amd64
 Experimental:      false
error during connect: Get http://%2F%2F.%2Fpipe%2Fdocker_engine/v1.40/version: open //./pipe/docker_engine: The system cannot find the file specified.
 In the default daemon configuration on Windows, the docker client must be run elevated to connect. This error may also indicate that the docker daemon is not running.

How-To
Start up docker

Check again:

F:\git\doodle\cheers2019 (master -> origin)                     
λ docker version                                                
Client: Docker Engine - Community                               
 Version:           19.03.5                                     
 API version:       1.40                                        
 Go version:        go1.12.12                                   
 Git commit:        633a0ea                                     
 Built:             Wed Nov 13 07:22:37 2019                    
 OS/Arch:           windows/amd64                               
 Experimental:      false                                       
                                                                
Server: Docker Engine - Community                               
 Engine:                                                        
  Version:          19.03.5                                     
  API version:      1.40 (minimum version 1.12)                 
  Go version:       go1.12.12                                   
  Git commit:       633a0ea                                     
  Built:            Wed Nov 13 07:29:19 2019                    
  OS/Arch:          linux/amd64                                 
  Experimental:     false                                       
 containerd:                                                    
  Version:          v1.2.10                                     
  GitCommit:        b34a5c8af56e510852c35414db4c1f4fa6172339    
 runc:                                                          
  Version:          1.0.0-rc8+dev                               
  GitCommit:        3e425f80a8c931f88e6d94a8c831b9d5aa481657    
 docker-init:                                                   
  Version:          0.18.0                                      
  GitCommit:        fec3683

2020/02/05

[Intellij IDEA] How to build project automatically

By default, Intellij IDEA doesn’t compile classes automatically.

But, you can enable the auto compile feature by following steps :
File => Settings => Build, Execution, Deployment => Compiler => Checked "Build project automatically"

2020/02/04

[Java] [Freemarker] Generate Text file from FTL - example 2

Requirement
I would like generate text file as bellows:

FreeMarker Template example: Hello World!

        ===================(Page:0001)
        ======  County List   ======
        ========================
        1. 台灣
        2. Japan
        3. The Netherlands


        ===================(Page:0002)
        ======  County List   ======
        ========================
        4. United Kingdom
        5. France
        6. Canada


        ===================(Page:0003)
        ======  County List   ======
        ========================
        7. United States
        8. Italy

------------------------------
Number of Record(s): 0000000008
Print date: 19 Nov 19

FTL file

<#-- 設定 locale，讓日期印出來是英文
     https://freemarker.apache.org/docs/ref_directive_setting.html  -->
<#setting locale = "en_US">

<#-- 宣告變數用來儲存總筆數與頁數
     https://freemarker.apache.org/docs/ref_directive_assign.html -->
<#assign total = 0>
<#assign page = 1>

<#-- 取得現在日期 -->
<#assign dateTime = .now>
<#assign date = dateTime?date>

FreeMarker Template example: ${message}

<#list countries as country>
    <#-- 一頁三筆資料 -->
    <#if total % 3 == 0>
        <#-- 第二頁開始才在表頭增加兩行空白 -->
        <#if page gt 1>


        </#if>
        <#-- 將 page number 格式化 -->
        ===================(Page:${page?string["0000"]})
        ======  County List   ======
        ========================
        <#assign page = page + 1>
    </#if>
        ${country_index + 1}. ${country}
        <#assign total = total + 1>
</#list>

------------------------------
Number of Record(s): ${total?left_pad(10, "0")}
<#-- https://freemarker.apache.org/docs/ref_builtins_date.html -->
Print date: ${date?string["dd MMM yy"]}

Test Case

package com.test.batch;

import com.test.batch.exception.FtlException;
import freemarker.template.Configuration;
import freemarker.template.Template;
import freemarker.template.TemplateException;
import lombok.Builder;
import lombok.Getter;
import lombok.extern.slf4j.Slf4j;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.Writer;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@RunWith(SpringRunner.class)
@SpringBootTest
@Slf4j
public class FtlTest {

    private Configuration cfg;

    @Before
    public void init() {
        cfg = new Configuration();
        // 設定到 classpath 讀取 ftl file
        cfg.setClassForTemplateLoading(this.getClass(), "/");
    }
    
    @Test
    public void testCountriesFtl() {
        try (Writer file = new FileWriter(new File("C:/ftl_countries.txt"));) {
            Template template = cfg.getTemplate("ftl/countries.ftl");

            Map<String, Object> data = new HashMap<>();
            data.put("message", "Hello World!");

            List<String> countries = new ArrayList<String>();
            countries.add("台灣");
            countries.add("Japan");
            countries.add("The Netherlands");
            countries.add("United Kingdom");
            countries.add("France");
            countries.add("Canada");
            countries.add("United States");
            countries.add("Italy");

            data.put("countries", countries);

            template.process(data, file);
        } catch (IOException | TemplateException e) {
            throw new FtlException("fail to generate file from ftl file : " + e.getMessage(), e);
        }
    }

}

2020/02/03

[Java] [Freemarker] Generate Text file from FTL - example 1

Requirement
I would like to generate text file as bellows:

分行代碼  貸款代碼   客戶代碼  流水號
808      12345678   0000001   111                           
303      87654321   0000002   222                           
123      45678912   0000003   333                           
-------------------------------------------------
Number of Record(s): 0000000003

FTL File

<#assign total = 0>
<#if rows??>
分行代碼  貸款代碼   客戶代碼  流水號
<#list rows as row>
<#-- https://freemarker.apache.org/docs/ref_builtins_string.html#ref_builtin_right_pad -->
${row.branchId?right_pad(16)}${row.custLoanNumber?right_pad(11)}${row.custId?right_pad(10)}${row.ext1?right_pad(30)}
<#assign total = total + 1>
</#list>
<#else>
No Data Found!
</#if>
<#-- https://freemarker.apache.org/docs/ref_builtins_string.html#ref_builtin_left_pad -->
-------------------------------------------------
Number of Record(s): ${total?left_pad(10, "0")}