에러 사진

2023/03/04 트러블 슈팅 사례

장소: STARDOM PC

파일 경로 F->javaedu10->project

                                                 설치 상태

1.Intellij Community Edition Download

2.Java 17se version download, 환경변수 설정 완료.

Java Archive Downloads - Java SE 17

3.SQL Developer 22.2.1 설치/javaedu10/project

Oracle SQL Developer Downloads

4.git bash 64bit for windows 설치

Git - Downloading Package

5.파일 경로 F->javaedu10->project에서 빈 곳 오른쪽 클릭 후

"git bash Here"  클릭

열려진 git bash 창에 

$ git clone https://github.com/sang105kr/demo1

입력 후 Enter(프로젝트 생성).

6.Oracle Database XE Downloads 다운로드, 이후 설치 시 비밀번호는 admin1234로 한다.

Oracle Database Express Edition (XE) 18c Downloads

7.javaedu10->project 경로의 Oracle developer 접속 후 새 접속 클릭

8.해당 계정 생성

Name:admin

사용자 이름:"sys as sysdba"

비밀번호:admin1234(Oracle Database XE Downloads 설치 시 설정했던 비밀번호)

이후 worksheet에

GRANT CONNECT, RESOURCE, DBA TO sys WITH ADMIN OPTION; 입력 후 F5 누르기(선택 사항, 안해도 해결 되었었다. 혹시 모르니 기입.)

9.intellij 환경 설정. 하단 참조

10.application.properties에 밑의 코드를 복사 붙여넣기 한다.

#server
server.port:9080

#Database
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@localhost:1521/xe
spring.datasource.username=sys as sysdba
spring.datasource.password=admin1234

이후 DemoApplication 실행 하면

2023-03-04T07:37:14.230+09:00 ERROR 1760 --- [  restartedMain] j.LocalContainerEntityManagerFactoryBean : Failed to initialize JPA EntityManagerFactory: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

2023-03-04T07:37:14.231+09:00  WARN 1760 --- [  restartedMain] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

2023-03-04T07:37:14.234+09:00  INFO 1760 --- [  restartedMain] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]

2023-03-04T07:37:14.244+09:00  INFO 1760 --- [  restartedMain] .s.b.a.l.ConditionEvaluationReportLogger : 

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.

2023-03-04T07:37:14.260+09:00 ERROR 1760 --- [  restartedMain] o.s.boot.SpringApplication               : Application run failed

이라고 Error 뜨던 것이

잘 실행 된 것을 확인 할 수가 있다.

구동 확인.

intellij 환경 설정

Help>Edit Custom VM Options..
≫ 인코딩 추가 설정
✓ -Dfile.encoding=UTF-8
✓ -Dconsole.encoding=UTF-8
IJ File Edit View Navigate Code Refactor Build Run Tools
mypc AppData Roaming JetBrains IdealC2022.1
C: Users
idea64.exe.vmoptions X
Commit Project
Pull Requests
^^^ ^>
<
produc 1
.gra
ide: 2
3
grac
out
sql
src
.giti
a.tx
buil
grad
grac
setti
> IIII Externa
>
Scratch
application.properties Xx
-Xmx2043m
Git Window Help product - C:WUsers#mypc#AF
idea64.exe.vm
Find Action...
Ctrl+Shift+A
-Dfile.encoding=UTF-8
-Dconsole.encoding=UTF-8
? Help
Learn IDE Features
What's New in IntelliJ IDEA
Getting Started
IntelliJ IDEA on YouTube
Keyboard Shortcuts PDF
Tip of the Day
My Productivity
Contact Support...
Submit a Bug Report...
Submit Feedback...
Show Log in Explorer
Collect Logs and Diagnostic Data
Delete Leftover IDE Directories...
Diagnostic Tools
Change Memory Settings
Edit Custom Properties...
Edit Custom VM Options...
Check for Updates...
Register Plugins...
About

+ Recent posts