2011년 8월 2일 화요일

JDBC connection strings


/*JDBC Drivers from Microsoft MSSQL Server - jTds*/
url = "jdbc:jtds:sqlserver://host:port/dbname";
driver = "net.sourceforge.jtds.jdbc.Driver";

/*JDBC Drivers from Microsoft MSSQL 2000 */
url = "jdbc:microsoft:sqlserver://host:port";
driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

/* MySQL With MM JDBC */
jdbc driver and url
driver = "org.gjt.mm.mysql.Driver";
url = "jdbc:mysql://localhost/dbname";

/*Sybase jconnect2.jar */
url = "jdbc:sybase:Tds:host:port";
driver = "com.sybase.jdbc2.SybDriver";

/*Oracle JDBC Thin Driver classes12.zip */
url = "jdbc:oracle:thin:@host:port:sid";
driver = "oracle.jdbc.driver.OracleDriver";

/*Oracle OCI Driver classes12.zip*/
url = "jdbc:oracle:thin:@host:port:sid";
driver = "oracle.jdbc.driver.OracleDriver";

/* Oracle 에서 Service Name 을 사용하는 경우 */
jdbc:oracle:thin:@//host_name:port_number/service_name
jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename

/* OpenBase OpenBaseJDBC.jar (download from www.openbase.com) */
url = "jdbcpenbase://host/database";
driver = "com.openbase.jdbc.ObDriver";

/* MySQL Connector/J from MySql (www.mysql.com)*/
url = "jdbc:mysql://host/database";
driver = "com.mysql.jdbc.Driver";

/*JSQLConnect from JDBC Drivers from Microsoft MSSQL 2000*/
url = "jdbc:microsoft:sqlserver://host:port";
driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

/*DB2 Universal JDBC Driver from IBM
jdbc classes: db2java.zip */
url = "jdbc:db2:host";
driver = "COM.ibm.db2.jdbc.app.DB2Driver";

/*DB2 Universal JDBC Driver from IBM type4
jdbc classes: db2jcc.jar*/
driver = "com.ibm.db2.jcc.DB2Driver"
url = "jdbc:db2://{host}:50000/{database name}"

/*DB2 Universal JDBC Driver from IBM
jdbc classes: db2java.zip */
url = "jdbc:db2://{host}:{port}/{database name}";
driver = "COM.ibm.db2.jdbc.net.DB2Driver";

/*OpenBase5.1 jdbc driver for neusoft
jdbc class: openBASE.jar*/
url = "jdbc:OpenBASE:database"
url = "jdbc:OpenBASE://host/database"
url = "jdbc:OpenBASE://host:port/database"
url = "jdbc:OpenBASE://host:port/database;user=username;password=pwd"
driver = "com.neusoft.OpenBASE.Driver"

댓글 없음:

댓글 쓰기