# 數據庫切換Oracle/SqlServer/Postgresql
### Oracle數據
#### 1.添加oracle驅動，修改pom.xml
~~~
<!-- oracle驅動 -->
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>
</dependency>
~~~
#### 2.修改數據庫連接
~~~
修改druid配置
validationQuery: SELECT 1 FROM DUAL
driver-class-name: oracle.jdbc.OracleDriver
url: jdbc:oracle:thin:@192.168.1.200:1521:ORCL
username: jeecgboot
password: jeecgboot
~~~
### SQL server數據
#### 1.添加SQL server驅動，修改pom.xml
~~~
<!-- sqlserver-->
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0</version>
<scope>runtime</scope>
</dependency>
~~~
#### 2.修改數據庫連接
~~~
修改druid配置
validationQuery: SELECT 1
filters: stat,slf4j
driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
url: jdbc:sqlserver://192.168.1.200:1433;SelectMethod=cursor;DatabaseName=jeecg-boot
username: sa
password: SA
修改JPA加上database-platform參數
jpa:
open-in-view: false
database-platform: org.hibernate.dialect.SQLServerDialect
~~~
#### 3.sqlserver下定時任務報錯處理
~~~
報錯信息org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: sql injection violation, syntax error: syntax error, not support option : UPDATE, pos 86, line 1, column 80, token UPDATE
~~~
修改配置如下：將selectWithLockSQL: SELECT\* FROM {0}LOCKS UPDLOCK WHERE LOCK\_NAME = ?配置在jobStore下
~~~
quartz:
.....省略其他配置.....
properties:
org:
quartz:
jobStore:
selectWithLockSQL: SELECT* FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ?
~~~
#### 3.sqlserver下啟動后，如果控制臺一直滾動如下圖信息
可修改配置文件
~~~
web-stat-filter:
enabled:false
~~~
### postgresql數據庫
#### 1.添加postgresql驅動，修改pom.xml
(根據不同版本的數據庫引入對應版本的驅動，下載地址：[https://jdbc.postgresql.org/download.html](https://jdbc.postgresql.org/download.html))
~~~
<!-- postgresql-->
<dependency>
<groupId>postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.2.5</version>
</dependency>
~~~
#### 2.修改數據庫連接
~~~
增加spring下的配置
spring:
#postgresql 報錯問題
jpa:
properties:
hibernate:
temp:
use_jdbc_metadata_defaults: false
修改druid配置
validationQuery: SELECT 1
url: jdbc:postgresql://localhost:5432/postgres
username: postgres
password: root
driver-class-name: org.postgresql.Driver
~~~
