连接sql可以尝试的连接方式

连接sqlserver可以尝试的连接方式
SOURCE_ASSETS_JDBC_URL=jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=dbname
SOURCE_ASSETS_USERNAME=
SOURCE_ASSETS_PASSWORD=
驱动程序名称：com.microsoft.jdbc.sqlserver.SQLServerDriver


SOURCE_DIGITAL_JDBC_URL=jdbc:jtds:sqlserver://127.0.0.1:1433/dbname
SOURCE_DIGITAL_USERNAME=sa
SOURCE_DIGITAL_PASSWORD=
驱动程序名称：net.sourceforge.jtds.jdbc.Driver

参考：http://www.blogjava.net/guming123416/articles/28002.html
https://www.cnblogs.com/wang3680/p/5616088.html

连接oracle可以尝试的连接方式
select * from v$version;
或select banner from sys.v_$version

   12 可以尝试的jar 

<!-- https://mvnrepository.com/artifact/com.oracle/ojdbc6 -->
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>12.1.0.1-atlassian-hosted</version>
<scope>test</scope>
</dependency>

   11 可以尝试的jar

<!-- https://mvnrepository.com/artifact/com.oracle/ojdbc6 -->
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.4.0-atlassian-hosted</version>
<scope>test</scope>
</dependency>