다양한 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
태그 : jdbc
덧글