| sitelink1 | http://www.ibm.com/developerworks/kr/for...amp;cat=20 |
|---|---|
| sitelink3 | http://1 |
| sitelink4 | http://ko |
| sitelink6 | http://sitelink1 |
[JDBC] URL 사용법 모음
게시글 시간: 2006/04/12 07:17:00 오후
긴급하게 이런글 찾고 싶을 때가 있습니다.
그때 긴요하게 쓸 수 있을 거 같아서 올립니다.
/* 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";
/* 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";
/*JDBC Drivers from Microsoft MSSQL 2000 */
url = "jdbc:microsoft:sqlserver://host:port";
driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
/*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"
( Nov 18 2005, 01:07:47 AM GMT-08:00 ) Permalink Comments [0]
Sunday August 14, 2005
Test Statement for database
In some case, we will want to check database connection is really ok, below sql statement maybe used.
*for MySQL use: select 1
*for PostgreSQL use: select now().
*for Apache Derby use: values 1.
*for HSQL use: call now().
*for SAP DB (MySQL MaxDB) use: select count(*) from versions.
*for Oracle use: select * from dual.
*for Firebird use: select * from rdb$types.
*for InstantDB use: set date format "yyyy/mm/dd".
*for Interbase use: select * from rdb$types.
*for Microsoft SQL server 2000 use: select 1.
