Oracle
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@hostname:port:SID
String url = "jdbc:oracle:thin:@localhost:1521:ORA8";
Class.forName("oracle.jdbc.driver.OracleDriver“);
mssql
com.jk.jdbc.Driver
jdbc:jk://hostname:port/database=db_name
String url="jdbc:jk://localhost:1433/database=CRM";
Class.forName("com.jk.jdbc.Driver“);
mysql
orj.gjt.mm.mysql.Driver
jdbc:mysql://db_url:port/db_name
String url = "jdbc:mysql://localhost:3306/CRM";
Class.forName("orj.gjt.mm.mysql.Driver“);
sybase
com.sybase.jdbc2.jdbc.SybDriver
jdbc:sybase:Tds:db_url:port/db_name
String url = "jdbc:sybase:Tds:localhost:3344/CRM";
Class.forName("com.sybase.jdbc.jdbc.SybDriver“);
db2
COM.ibm.db2.jdbc.app.DB2Driver
jdbc:db2://172.58.654.356:port/db_name
String url = "jdbc:db2://localhost:9010/CRM";
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver“);
postgresql
7.0 version : org.postgresql.Driver
6.5 version : postgresql.Driver
jdbc:postgresql:db_name
jdbc:postgresql://host/db_name
jdbc:postgresql://host:port/db_name
String url = "jdbc:postgresql://localhost:5432/CRM";
Class.forName("org.postgresql.Driver“); -> version 7.0
Class.forName("postgresql.Driver“); -> version 6.5
informix
com.informix.jdbc.IfxDriver
jdbc:informix-sqli://hostname:port/db_name:INFORMIXSERVER=server_name:user=user_name:password=user_pwd
String url = "jdbc:informix-sqli://localhost:2020/CRMl:INFORMIXSERVER=mydb:user=sys:password=pass";
Class.forName("com.informix.jdbc.IfxDriver“);
odbc brigde
sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc:source-name
String url = "jdbc:odbc:CRM";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver“);
teradata
com.ncr.teradata.TeraDriver
jdbc:teradata://host:port/gateway/tmode=default
'DB' 카테고리의 다른 글
Fedora Core 5에서 오라클 10g Release 2 설치 (0) | 2006.06.30 |
---|---|
[펌] Oracle, MS-SQL, Informix의 SQL문 비교 (0) | 2005.12.20 |
[펌] sybase 설치 (0) | 2005.12.17 |