오라클

맥북

docker login

docker search oracle -xe-11g

docker pull jaspeen/oracle-xe-11g

docker run --name oracle -d -p 8080:8080 -p 1521:1521 jaspeen/oracle-xe-11g

docker exec -it oracle sqlplus

system

oracle

SELECT * FROM all_users;

CREATE USER SCOTT IDENTIFIED BY TIGER;

GRANT CONNECT, resource to SCOTT;

the account is locked

sqlplus /nolog

ALTER USER 계정이름 ACCOUNT UNLOCK;

Spring Framework <-> Oracle

1. jdbc 저수준 코드를 사용하는 방법(프로젝트에 jdbc 드라이버 등록)

2. Spring Framework 지원 jdbc 라이브러리 사용

3. 2 + ORM Framework(MyBatis)

4. JPA(Java Persistence API)