常連

### 前提
OracleDBを接続したいのですが、環境設定がうまくいきません


**前提条件**
OS：Windows
DB：Oracle Database 21c Express Oracle
開発環境：Eclipse 2022 Full Edition Java
Oracle JDBC driver：ojdbc11.jar
どれも最新版を使用しています。

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2884987/5a9b3296-7f2e-2e64-ce6d-27499b61ab36.png)
タイプはGradleです。


![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2884987/0671c1b7-e3a3-6d67-79d0-860351078086.png)
どれが必要か曖昧なため、DB関係ありそうな
・Spring Data JPA
・Spring Data JDBC
を追加しました。

### 実現したいこと

Springを用いてOracleDBからデータを取得し、コンソール画面上に表示したいです。
- [ ] application.propertiesの設定
- [ ] build.gradleの設定
- [ ] エンティティ(Sample.java)の設定
- [ ] レポジトリ(SampleCrudRepository.java)の設定

### 発生している問題・エラーメッセージ

```
Exception in thread "restartedMain" java.lang.reflect.InvocationTargetException
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)
Caused by: org.springframework.data.relational.core.conversion.DbActionExecutionException: Failed to execute DbAction.UpdateRoot(entity=Sample(id=4, name=Kato, gender=0, age=23))
	at org.springframework.data.jdbc.core.AggregateChangeExecutor.execute(AggregateChangeExecutor.java:95)
	at org.springframework.data.jdbc.core.AggregateChangeExecutor.lambda$execute$0(AggregateChangeExecutor.java:52)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at org.springframework.data.relational.core.conversion.DefaultAggregateChange.forEachAction(DefaultAggregateChange.java:127)
	at org.springframework.data.jdbc.core.AggregateChangeExecutor.execute(AggregateChangeExecutor.java:52)
	at org.springframework.data.jdbc.core.JdbcAggregateTemplate.store(JdbcAggregateTemplate.java:360)
	at org.springframework.data.jdbc.core.JdbcAggregateTemplate.save(JdbcAggregateTemplate.java:161)
	at org.springframework.data.jdbc.repository.support.SimpleJdbcRepository.save(SimpleJdbcRepository.java:75)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker$RepositoryFragmentMethodInvoker.lambda$new$0(RepositoryMethodInvoker.java:289)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker.doInvoke(RepositoryMethodInvoker.java:137)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker.invoke(RepositoryMethodInvoker.java:121)
	at org.springframework.data.repository.core.support.RepositoryComposition$RepositoryFragments.invoke(RepositoryComposition.java:530)
	at org.springframework.data.repository.core.support.RepositoryComposition.invoke(RepositoryComposition.java:286)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$ImplementationMethodExecutionInterceptor.invoke(RepositoryFactorySupport.java:640)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:164)
	at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:139)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
	at com.sun.proxy.$Proxy81.save(Unknown Source)
	at com.example.demo.MySpringDataJdbcSampleApplication.executeInsert(MySpringDataJdbcSampleApplication.java:29)
	at com.example.demo.MySpringDataJdbcSampleApplication.execute(MySpringDataJdbcSampleApplication.java:22)
	at com.example.demo.MySpringDataJdbcSampleApplication.main(MySpringDataJdbcSampleApplication.java:15)
	... 5 more
Caused by: org.springframework.dao.IncorrectUpdateSemanticsDataAccessException: Failed to update entity [Sample(id=4, name=Kato, gender=0, age=23)]. Id [4] not found in database.
	at org.springframework.data.jdbc.core.JdbcAggregateChangeExecutionContext.updateWithoutVersion(JdbcAggregateChangeExecutionContext.java:316)
	at org.springframework.data.jdbc.core.JdbcAggregateChangeExecutionContext.executeUpdateRoot(JdbcAggregateChangeExecutionContext.java:109)
	at org.springframework.data.jdbc.core.AggregateChangeExecutor.execute(AggregateChangeExecutor.java:72)
	... 39 more
```

### 該当のソースコード

```application.properties
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:XE
spring.datasource.username=system 
spring.datasource.password=5931
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
```
```build.gradle
dependencies {
	implementation 'org.springframework.boot:spring-boot-starter-data-jdbc'
	implementation 'org.springframework.boot:spring-boot-starter-thymeleaf'
	implementation 'org.springframework.boot:spring-boot-starter-web'
	compileOnly 'org.projectlombok:lombok'
	developmentOnly 'org.springframework.boot:spring-boot-devtools'
	runtimeOnly 'com.oracle.database.jdbc:ojdbc8'
	annotationProcessor 'org.projectlombok:lombok'
	testImplementation 'org.springframework.boot:spring-boot-starter-test'
　　implementation 'org.springframework.boot:spring-boot-starter-data-jpa'
	implementation files('lib/ojdbc11.jar')
```

```Sample.java
package com.example.demo.entity;

import org.springframework.data.annotation.Id;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Sample {
	@Id
	private Integer id;
	private String name;
	private Integer gender;
	private Integer age;
}
```

```SampleCrudRepository.java
package com.example.demo.reporitory;

import org.springframework.data.repository.CrudRepository;

import com.example.demo.entity.Sample;

public interface SampleCrudRepository extends CrudRepository<Sample, Integer> {

}
```

```MySpringDataJdbcSampleApplication.java
package com.example.demo;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

import com.example.demo.entity.Sample;
import com.example.demo.reporitory.SampleCrudRepository;

@SpringBootApplication
public class MySpringDataJdbcSampleApplication {

	public static void main(String[] args) {
		SpringApplication.run(MySpringDataJdbcSampleApplication.class, args)
		.getBean(MySpringDataJdbcSampleApplication.class).execute();
	}
	
	@Autowired
	SampleCrudRepository repository;
	
	private void execute() {
		executeInsert();
		executeSelect();
	}
	
	private void executeInsert() {
		Sample sample = new Sample(4, "Kato", 0, 23);
		sample = repository.save(sample);
		System.out.println(sample);
	}
	
	private void executeSelect() {
		Iterable<Sample> samples = repository.findAll();
		for (Sample sample : samples) {
			System.out.println(sample);
		}
	}

}
```

### 試したこと
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2884987/d985b9cc-0c54-e4c7-38f7-ab7f39fa407d.png)
今回作成したプロジェクトのパッケージエクスプローラー

[こちらのサイト](https://qiita.com/ishibe-m/items/70e3f5340bd9fa7e81ec)を参考に自分でプロジェクトを作成しました。本来であればlibフォルダは存在しませんでしたが、自分で追加しました。

警告には”oracle.jdbc.driver.OracleDriver was not found, trying direct instantiation.”と表示されているので、application.propertiesやbulid.gradleのどこかが間違えていると思うのですがわかりません。

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2884987/a4300abd-1ff1-520a-8608-b4b4b750030f.png)
他にもプロジェクトを右クリックし、プロパティ＞Javaのビルドパス＞ライブラリー＞クラスパス＞外部JARの追加でojdbc11.jarを追加しようとしましたがうまくいきませんでした。



質問編集履歴