知乎专栏 |
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)) ) )