使用Selenium连接到数据库时发生java未知主机异常
当我连接到客户端网络(使用VPN)时,我就能够成功地从数据库中获取数据。但是,如果我断开与客户端网络的连接,在本地运行相同的功能,那么我的错误率就会降低-
连接失败:SAP DBTech JDBC:无法连接到JDBC:sap://saphsg.XXXX.XX.com:30015[未知主机saphsg.XXXX.XXX.com:30015[null],-709]
下面是我正在使用的代码-
public static void dbConnection(String query) throws ClassNotFoundException {
Connection connection = null;
try {
Class.forName("com.sap.db.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:sap://saphsg.XXXX.XXX.com:30015?encrypt=true&validateCertificate=false", UserID, Password);
} catch (SQLException e) {
System.err.println("Connection Failed:" +e.getMessage());
}
if (connection != null) {
try {
System.out.println("Connection to HANA successful!");
Statement stmt = connection.createStatement();
ResultSet resultSet = stmt.executeQuery(query);
while (resultSet.next()){
String Name1 = resultSet.getString(1);
String Name2 = resultSet.getString(4);
String Name3 = resultSet.getString(5);
System. out.println(Name1+"----"+Name2+"----"+Name3);
}
} catch (SQLException e) {
System.err.println("Query failed!");
}
}
}
共 (0) 个答案