JDBC [JDBC] URL 사용법 모음

[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.