spring-ucp-prop (oracle-samples#207)

nsundara · web-flow · commit 4a677b8cf012 · 2022-06-01T09:54:00.000-07:00
* Update application.properties

* Update pom.xml

* Update application.properties

* Update application.properties
diff --git a/java/SpringBootApp/pom.xml b/java/SpringBootApp/pom.xml
@@ -11,7 +11,7 @@
 	<parent>
 		<groupId>org.springframework.boot</groupId>
 		<artifactId>spring-boot-starter-parent</artifactId>
-		<version>2.2.6.RELEASE</version>
+		<version>2.7.0</version>
 	</parent>
 	<properties>
 		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
@@ -60,4 +60,4 @@
 			</plugin>
 		</plugins>
 	</build>
-</project>
+</project>
diff --git a/java/SpringBootApp/src/main/resources/application.properties b/java/SpringBootApp/src/main/resources/application.properties
@@ -5,12 +5,15 @@ spring.datasource.username=<your-db-user>
 spring.datasource.password=<your-db-password>
 
 # Properties for using Universal Connection Pool (UCP)
-# Note: These properties require JDBC version 21.0.0.0
+# Note: These properties require Spring Boot version greater than 2.4.0
 spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
-spring.datasource.type=oracle.ucp.jdbc.UCPDataSource
-spring.datasource.ucp.connection-factory-class-name=oracle.jdbc.replay.OracleDataSourceImpl
-spring.datasource.ucp.sql-for-validate-connection=select * from dual
-spring.datasource.ucp.connection-pool-name=connectionPoolName1
-spring.datasource.ucp.initial-pool-size=15
-spring.datasource.ucp.min-pool-size=10
-spring.datasource.ucp.max-pool-size=30
+spring.datasource.type=oracle.ucp.jdbc.PoolDataSource
+# If you are using Replay datasource 
+#spring.datasource.oracleucp.connection-factory-class-name=oracle.jdbc.replay.OracleDataSourceImpl
+# Use this if you are not using Replay datasource 
+spring.datasource.oracleucp.connection-factory-class-name=oracle.jdbc.pool.OracleDataSource
+spring.datasource.oracleucp.sql-for-validate-connection=select * from dual
+spring.datasource.oracleucp.connection-pool-name=connectionPoolName1
+spring.datasource.oracleucp.initial-pool-size=15
+spring.datasource.oracleucp.min-pool-size=10
+spring.datasource.oracleucp.max-pool-size=30
