Posted on | In

引入依赖

1
2
3
4
5
<dependency>
    <groupId>org.jooq</groupId>
    <artifactId>jooq</artifactId>
    <version>3.11.11</version>
</dependency>

生成CREATE语句

1
2
3
4
5
6
7
8
9
System.out.println(
                DSL.using(SQLDialect.MYSQL_8_0).createTable("user")
                        .column("id", SQLDataType.BIGINT.precision(20))
                        .column("name", SQLDataType.VARCHAR.precision(20))
                        .constraints(
                                constraint("PK_MY_TABLE").primaryKey("id")
                        )
                        .getSQL()
        );

注

要使用Oracle等大多数方言需要购买商用版

Posted on | In

Debian 8 Set TimeZone +8

1
2
echo "Asia/Shanghai" > /etc/timezone
dpkg-reconfigure -f noninteractive tzdata

Debian 9 Set TimeZone +8

ln -fs /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
dpkg-reconfigure -f noninteractive tzdata

在Dockerfile中配置时区(Debian8)

1
2
RUN echo "Asia/Shanghai" > /etc/timezone
RUN dpkg-reconfigure -f noninteractive tzdata

在MySQL JDBC 8中设置时区

1
serverTimezone=GMT%2B8

REF

CHANGING THE TIMEZONE IN DEBIAN 9 (STRETCH)
Docker 中如何设置 container 的时区
JDBC连接数据库 mysql serverTimezone useSSL 时差

Posted on | Edited on | In

环境

  • 15-inch Mid 2015 MacBookPro
  • macOS 10.14
  • IDEA 2019.1.2
  • IdeaVim

问题及解决方案

在调整了macOS屏幕缩放后，IdeaVim jk有延迟感，很卡.

安装Idea Plugin JB SDK Bintray Downloader, 重启Idea后按 Shit+Cmd+A

输入Get JB SDK from Bintay

为Idea下载最新版JDK, b后面数据越大越新.

下载了jbsdk11b125_osx_x64.tar.gz后，按install ，重启后即可.

如果在下载过程中提示JDK mx内存不足请设置成2048

或者

使用brew cask install Resolutionator将显示调整为非Retina

Tips

Shit+CMD+A Find Action 仅在主界面时可按.

  • Get JB SDK 为下载idea JDK
  • Switch Boot JDK 可切换启动JDK

参见

Selecting the JDK version the IDE will run under
在OS X上使用4K显示器时，IDE速度非常慢

Posted on | In

SpringTest中正常， SPringApplication中不正常, 用的同一个配置
Mybatis plus 3.1.1

1
2
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression 'ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere'. Cause: org.apache.ibatis.ognl.OgnlException: sqlSegment [com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Your property named "XXXXXXX" cannot find the corresponding database column name!]
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77) ~[mybatis-spring-2.0.1.jar:2.0.1]

Posted on | In

docker maven images

1
docker pull 3-jdk-8
[link](https://hub.docker.com/_/maven)

mvn package 当前目录

1
2
3
4
docker run -it --rm --name my-maven-project \
    -v "$(pwd)":/usr/src/mymaven \
    -w /usr/src/mymaven maven:3-jdk-8 \
    mvn clean package

mvn package 当前目录,并使用本地/data/m2目录的maven配置

1
2
3
4
5
docker run -it --rm --name maven-project-xxx \
    -v /data/m2:/root/.m2 \
    -v "$(pwd)":/usr/src/mvnp \
    -w /usr/src/mvnp maven:3-jdk-8 \
    mvn clean package

使用非root运行

1
docker run -v ~/.m2:/var/maven/.m2 -ti --rm -u 1000 -e MAVEN_CONFIG=/var/maven/.m2 maven mvn -Duser.home=/var/maven archetype:generate

Posted on | In

FeignClient使用相同名字时会提示重名并无法启动,可以通过添加contextId进行区分两个client

1
2
3
4
5
@FeignClient(contextId = "a", name = "User", configuration = FeignClientsConfiguration.class)
...

@FeignClient(contextId = "b", name = "User", configuration = FeignClientsConfiguration.class)
...

error

1
2
3
4
5
6
The bean FeignClientSpecification', defined in null, could not be registered. 
A bean with that name has already been defined in null and overriding is disabled.

Caused by: org.springframework.beans.factory.support.BeanDefinitionOverrideException: 
Invalid bean definition with name xxxx.FeignClientSpecification' defined in null: 
Cannot register bean definition [Generic bean: class [org.springframework.cloud.openfeign.FeignClientSpecificatio...

Posted on | In

将mydir压缩成 hello.7z

7za a hello.7z mydir

将mydir压缩成 hello.7z 并加密

7za a -p hello.7z mydir

Test压缩包

7za t hello.7z

设置压缩等级

7za a hello.7z mydir -mx=0

0为不压缩，最高为9,默认为5

Posted on | In

tmux 2.9开始将不再支持-bg风格配置,将会由

1
2
3
set -g mode-bg yellow
set -g mode-fg red
set -g mode-attr blink,underline

改为

1
set -g mode-style fg=yellow,bg=red,blink,underline

ref

Posted on | In

macOS

1
2
3
4
5
brew install xz
xz -d youfile.xz

unxz < file.tar.xz > file.tar
xz -dc < file.tar.xz > file.tar

Ubuntu

1
2
3
4
5
6
sudo apt install xz-utils
tar xf archive.tar.xz
tar xf archive.tar.gz
tar xf archive.tar

tar cfJ <archive.tar.xz> <files>
1
tar -xJf file.pkg.tar.xz

The -J is the flag that specifically deals with .xz files.

Posted on | In

环境

  • FreeBSD 11.1
  • OpenJDK

install

sudo pkg install openjdk

mount files

sudo mount -t fdescfs fdesc /dev/fd
sudo mount -t procfs proc /proc

auto mount file

sudo vi /etc/fstab

Insert the following mount information into the file:

1
2
fdesc   /dev/fd     fdescfs     rw  0   0
proc    /proc       procfs      rw  0   0

Save and exit.

参考