• MySql
• Oracle
• SQL Server
• Informix
• 참고 문헌

JDBC를 사용하여 Database 접속 정보를 정리 한다.

 

MySql

---

• jdbc.driverClassName

 

 com.mysql.jdbc.Driver
 org.gjt.mm.mysql.Driver

• jdbs.url

 

 jdbc:mysql://localhost:3306/databaseName?useUnicode=true&characterEncoding=EUC-KR
 jdbc:mysql://localhost/liferaydb?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false

 

Oracle

---

• jdbc.driverClassName

 

 oracle.jdbc.driver.OracleDriver

• jdbs.url

 

 jdbc:oracle:thin:@localhost:1521:demomail

 

SQL Server

---

• jdbc.driverClassName

 

 com.microsoft.jdbc.sqlserver.SQLServerDriver, MSSQL

• jdbs.url

 

 jdbc:microsoft:sqlserver://localhost:1433;databaseName=db;selectMethod=cursor;

 

Informix

---

• jdbc.driverClassName

 

 com.informix.jdbc.IfxDriver

• jdbs.url

 

 jdbc:informix-sqli://localhost:port/dbname:INFORMIXSERVER=dbservername

 

참고 문헌

---

 

분류: Database

---