# 数据库切换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
~~~
