使用druid内置sql,用avatica驱动连接时,返回404
[code]import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
public class Main {
public static void main(String[] args) {
System.out.println("Hello World!");
String url = "jdbc:avatica:remote:url=http://localhost:8082/druid/v2/sql/avatica/";
Properties connectionProperties = new Properties();
try(Connection connection = DriverManager.getConnection(url,connectionProperties)){
try(ResultSet resultSet =
connection.createStatement()
.executeQuery("SELECT COUNT (*) FROM jinfeng_three_1")) {
while (resultSet.next()){
System.out.println("hello");
}
} catch (SQLException e) {
e.printStackTrace();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}[/code][code]
我把上面的localhost换成了服务器的ip,通过其他方法可以正常访问服务器,我导入的jar包有
[/code][code]avatica-1.10.0.jar
[/code]
没有找到相关结果
已邀请:
1 个回复
空心菜 - 心向阳光,茁壮成长