JDBC

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