db별 jdbc url 및 jdbc driverclass 작성 방법

db별 jdbc url 및 jdbc driverclass 작성 방법

 

 

Oracle

Oracle jdbc url

 

Oracle jdbc driverClass

oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@IP:1521:dbname

내 pom.xml 파일에 작성한 예시 

<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@localhost:1521:XE" />

 

 

Maria Db

 Maria jdbc url

Maria jdbc driverClass 

org.mariadb.jdbc.Driver
jdbc:mariadb://IP:3306/DBNAME?characterEncoding=utf8&autoReconnect=true

 

 

 

mysql

Mysql jdbc url 

Mysql jdbc driverClass 

 

com.mysql.jdbc.Driver
jdbc:mysql://IP:3306/DBNAME?characterEncoding=utf8&autoReconnect=true

 

 

mysql-connector-java 버전 6.**

com.mysql.cj.jdbc.Driver
jdbc:mysql://IP:3306/DBNAME?characterEncoding=utf8&autoReconnect=true&serverTimezone=KST

 

 

 

 

cubrid

cubrid  jdbc url 

cubrid  jdbc driverClass 

 

cubrid.jdbc.driver.CUBRIDDriver
jdbc:cubrid:IP:33000:DBNAME:::

 

DB2

DB2 jdbc url 

DB2 jdbc driverClass 

 

com.ibm.db2.jcc.DB2Driver
jdbc:db2://IP:50000/DBNAME

 

 

Tibero

Tibero jdbc url

Tibero driverClass

 

com.tmax.tibero.jdbc.TbDriver
jdbc:tibero:thin:@IP:8629:DBNAME

 

 

 

 

Mssql

Mssql jdbc url 

Mssql jdbc driverClass 

 

com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://IP:1433;DatabaseName=DBNAME