JDBC连接别机器上sql server很慢30秒
lkkjx 2005-05-16 07:14:26 我用JDBC写的程序连接自己自己机器上的数据库很快,而连接别的机器上的数据库很慢,在连接过程就要30秒。一但连接上后执行SELECT操作又很快。不知道大家有见过这样的情况没。
数据库是SQL SERVER2000 打了SP3,JDK是1.4。2,TOMCAT 5
import java.util.ResourceBundle;
public class config {
public String DBdriver;
public String DBname;
public String DBuser;
public String DBpwd;
public String DBurl;
private String DBLibName;
public config() {
DBdriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
//读取数据库设置文件
ResourceBundle readIni = ResourceBundle.getBundle("DB");
DBname = readIni.getString("DBip");
DBuser = readIni.getString("user");
DBpwd = readIni.getString("pass");
DBLibName = readIni.getString("DBname");
DBurl = "jdbc:microsoft:sqlserver://" + DBname + ":1433;DatabaseName=" + DBLibName;
}
}
public ResultSet ExeQuery(String s)
{
try
{
conn = DriverManager.getConnection(DBurl,DBuser,DBpwd);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE ,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(s);
}
catch(SQLException sqlexception)
{
System.err.println("aq.executeQuery:" + sqlexception.getMessage());
}
return rs;
}