spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@//192.168.4.9:1521/orcl.example.com
spring.datasource.username=www
spring.datasource.password=123123
spring.jpa.database-platform=org.hibernate.dialect.Oracle10gDialect

spring.jpa.show-sql=true
#spring.jpa.hibernate.ddl-auto=update
spring.jpa.hibernate.ddl-auto=create-drop
			
		

其他配置

		
spring.datasource.connection-test-query="SELECT 1 FROM DUAL"
spring.datasource.test-while-idle=true
spring.datasource.test-on-borrow=true
		
		

Oracle RAC

		
jdbc:oracle:thin@(DESCRIPTION=
(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=racnode1) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=racnode2) (PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=service_name)))

jdbc:oracle:thin:@(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=125.22.42.68)(PORT=1521))
(LOAD_BALANCE=on)
(FAILOVER=ON)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=service_name)
(FAILOVER_MODE=(TYPE=SESSION)(METHOD=BASIC))
)
)