import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Date;
import java.util.logging.Level;
import java.util.logging.Logger;
import com.cosmos.cuwap.service.ServException;
public class OracleConnectionManager extends ConnectionManager{
Logger log = Logger.getLogger(OracleConnectionManager.class.getName());
public Connection getConnection() {
Connection con =null;
String DBURL_WAP = "jdbc:oracle:thin:@192.168.0.4:1521:db";
String USER_WAPRESCUHQ = "system";
String PWD_WAPRESCUHQ = "admin";
try {
if (con == null) {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(DBURL_WAP, USER_WAPRESCUHQ, PWD_WAPRESCUHQ);
}
}catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
log.log(Level.FINE,"Get sql Connection at "+new Date());
return con;
}
}
近日在使用jdk15.0的jdbc程序连接oracle时,发现getconnection()号费时间很长。原来和jdk版本有关,换作jdk1.4或者jdk1.5.6以上版本,则速度很快;
同时还有其他的方法:增加如下代码到你的代码块中
import java.net.ProxySelector;
.
.
ProxySelector.setDefault(null);这样屏蔽了jre1.5中关于代理服务器的选择,采用直接连接的方式
参考: