JDBC 접속시 파라미터 값 설정.

다양한 DB를 다루게 되네.. 

JDBC 접속시. 

붉은 부분만 수정해서 사용하면 된다. 

- 오라클

jdbc.driverClassName.oracle=oracle.jdbc.OracleDriver

jdbc.url.oracle=jdbc:oracle:thin:@IP:PORT(1521):SID명

jdbc.username.oracle=userid

jdbc.password.oracle=userps

- HSQL DB

jdbc.driverClassName.hsqldb=org.hsqldb.jdbcDriver

jdbc.url.hsqldb=jdbc:hsqldb:C:/dev/tools/db(생성시 위치)

jdbc.username.hsqldb=userid

jdbc.password.hsqldb=userps

- MSSQL

jdbc.driverClassName.mssql=com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc.url.mssql=jdbc:sqlserver://IP:PORT(1433);databaseName=DB명;

jdbc.username.mssql=userid

jdbc.password.mssql=userps

- DB2

jdbc.driverClassName=com.ibm.as400.access.AS400JDBCDriver

jdbc.url=jdbc:as400:IP;prompt=false

jdbc.username=userid

jdbc.password=userps