ksh0165 / ReactStudy

업무에 필요한 내용 기록
http://github.com/ksh0165/works.git
0 stars 0 forks source link

h2 database #340

Open ksh0165 opened 1 year ago

ksh0165 commented 1 year ago

docker run -it -d -p 722:22 -p 8082:8082 -p 9092:9092 --name h2 jizuzquiza/h2database:1.0 "java" "-Dh2.bindAddress=0.0.0.0" "-jar" "h2-1.4.197.jar" "-webAllowOthers" "-tcpAllowOthers" "-properties" "/opt/h2/data"

ksh0165 commented 1 year ago

http://localhost:8082/

create table users( id number(5) primary key, username varchar2(30), password varchar2(100), email varchar2(30) );

insert into users (id,username, password, email) values (1,'guest','guest123','guest@gmail.com');


spring.jpa.open-in-view=false spring.sql.init.mode=always

script 파일이 hibernate 초기화 이후 동작하게 하기 위한 옵션

spring.jpa.defer-datasource-initialization=true

spring.jpa.show-sql=true spring.datasource.url=jdbc:h2:tcp://localhost/~/../opt/h2/data/jbpm-runtime-db spring.datasource.driver-class-name=org.h2.Driver spring.datasource.username=sa spring.h2.console.enabled=true spring.jpa.hibernate.ddl-auto=none