Java/Tip & Tech2009. 3. 6. 15:45

jTDS Driver (MSSQL과 Sysbase를 지원하는 JDBC Driver) 다운받기

db_driver=net.sourceforge.jtds.jdbc.Driver

db_url=jdbc:jtds:sqlserver://{IP}:{Port}/{DB}


MSSQL JDBC Driver 다운받기

db_driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
db_url=jdbc:microsoft:sqlserver://{IP}:{Port};DatabaseName={DB}


MySQL JDBC Driver 다운받기
db_driver=com.mysql.jdbc.Driver

db_url=jdbc:mysql://{IP}:{Port}/{DB}?autoReconnect=true&useUnicode=true&characterEncoding=euc-kr



ORACLE JDBC Driver 다운받기

db_driver=oracle.jdbc.driver.OracleDriver

db_url=jdbc:oracle:thin:@{IP}:{Port}:{SID}



PostgreSQL JDBC Driver 다운받기

db_driver=org.postgresql.Driver

db_url=jdbc:postgresql://{IP}:{Port}/{DB}


SQLite JDBC Driver 다운받기

db_driver=org.sqlite.JDBC

db_url=jdbc:sqlite:{File}

ex1) jdbc:sqlite:C:/work/mydatabase.db

ex2) jdbc:sqlite:/home/leo/work/mydatabase.db

ex3) jdbc:sqlite:memory:

Posted by Huikyun